Revenue Leakage Detection — SaaS Analytics Dashboard

Total Leakage Detected

$847,500

12.4% vs Q3

Revenue Recovered

$523,200

34.7% vs Q3

Accounts at Risk

142

8 new this week

Recovery Rate

61.7%

+5.2pp vs Q3

Leakage vs Recovery Trend

Monthly comparison across leakage categories

6 Months

$848K

$636K

$424K

$212K

$0

Aug

Sep

Oct

Nov

Dec

Jan

Leakage

Recovered

Leakage by Category

4 Types

$847.5K

TOTAL

Pricing Drift35%

Silent Downgrades22%

Billing Errors20%

Feature Underuse23%

Recovery Pipeline

Active

Identified & Queued$312K

Outreach Initiated$218K

Negotiation Phase$147K

Revenue Recovered$523K

Top At-Risk Accounts

Actionable

Account	ARR	Leakage Type	Amount	Status	Impact
NovaTech Solutions	$186K	Pricing Drift	$42,300	Escalated	High
Meridian Data Co.	$124K	Silent Downgrade	$28,750	In Review	High
Apex Cloud Inc.	$97K	Billing Error	$18,200	Queued	Med
Vantage Analytics	$210K	Feature Underuse	$15,600	Monitoring	Low
BluePeak Systems	$78K	Pricing Drift	$12,400	Outreach	Med

Recovery Overview

Q4 FY25

Net Revenue Impact

$1.37M

Annual projected savings

Accounts Recovered

89

Out of 142 flagged

Avg. Recovery Time

14 days

Down from 23 days

Churn Prevented

31

Enterprise accounts saved

Accounts Identified

142

8 new this week

Outreach Initiated

98

69% conversion

In Negotiation

54

+12 vs last month

Recovered

31

61.7% win rate

Leakage Funnel by Type

Stage conversion for each leakage category

Oct FY25

Pricing Drift — Identified$296K · 50 accounts

→ Outreach Sent$231K · 36 accounts (72%)

→ Recovered$166K · 26 accounts (52%)

Feature Underuse — Identified$195K · 43 accounts

→ Outreach Sent$131K · 29 accounts (67%)

→ Recovered$58K · 13 accounts (30%)

Billing Errors — Identified$169K · 28 accounts

→ Corrected$159K · 26 accounts (94%)

Stage Drop-off Rate

By Type

Pricing Drift → Recovery52%

Silent Downgrade → Recovery58%

Billing Error → Recovery94%

Feature Underuse → Recovery30%

Avg Time per Stage

Days

Detection → Outreach3.2d

Outreach → Negotiation6.8d

Negotiation → Closed4.1d

Avg Total Time14.0d

Cohorts Tracked

6

Aug–Jan

Avg Leakage Onset

4.2 mo

After contract start

Worst Cohort

Nov

38% leakage rate

Best Recovery

Dec

64.0% recovery rate

Cohort Leakage Heatmap

% of ARR leaked per cohort over time

6 Cohorts

Cohort	Mo 1	Mo 2	Mo 3	Mo 4	Mo 5	Mo 6	Total
Aug	1.2%	3.8%	6.1%	9.4%	11.2%	13.8%	13.8%
Sep	0.9%	4.2%	7.3%	10.8%	13.1%	15.6%	15.6%
Oct	1.4%	5.1%	8.4%	12.3%	14.9%	18.2%	18.2%
Nov	2.1%	6.8%	11.2%	15.4%	19.1%	22.7%	22.7%
Dec	0.8%	3.2%	5.9%	8.6%	10.4%	—	10.4%
Jan	1.1%	4.4%	7.8%	—	—	—	7.8%

Leakage by Contract Age

Months

0–3 months2.1%

4–6 months7.4%

7–12 months12.8%

12+ months15.3%

Cohort Recovery Rate

%

Aug cohort

52%

Sep cohort

56%

Oct cohort

62%

Nov cohort

46%

Dec cohort

64%

Jan cohort

38%

Healthy Accounts

68%

Score ≥ 70

At-Risk Accounts

24%

Score 35–69

Critical Accounts

8%

Score < 35

Avg Health Score

67.4

+3.1 vs last month

Account Health Scorecards

Adoption score · Login freq · Feature usage · API utilisation

Top 8 Accounts

Account	Health Score	Logins/mo	Feature Use	API Use	Trend	Status
Vantage Analytics	84	42	91%	78%	↑	Healthy
DataCore Systems	79	38	84%	71%	↑	Healthy
NovaTech Solutions	52	19	58%	44%	↓	At Risk
Meridian Data Co.	48	14	51%	39%	↓	At Risk
CloudNest Co.	61	24	67%	52%	→	At Risk
BluePeak Systems	29	6	31%	18%	↓	Critical
Apex Cloud Inc.	33	9	37%	22%	↓	Critical
SkyBridge Corp.	72	31	77%	63%	↑	Healthy

Score Distribution

All Accounts

70–100 Healthy68 accounts

35–69 At Risk24 accounts

0–34 Critical8 accounts

Churn Probability

6-month forecast

Score < 35 → Churn risk4.2×

Score 35–69 → Churn risk1.8×

Score ≥ 70 → Churn risk0.3×

Grandfathered Accounts

50

35% of leakage

Avg Price Gap

23%

Below list price

Promo Rates Expired

18

Never updated

Annual Drift Value

$296K

Recoverable

Price Gap Analysis by Account

Contracted MRR vs current list price — sorted by annual leakage

Top Accounts

Account	Plan	Contracted MRR	List Price	Gap %	Annual Leakage	On Promo Since
NovaTech Solutions	Enterprise	$8,200	$11,750	-30%	$42,600	Mar 2023
Vantage Analytics	Enterprise	$14,100	$17,500	-19%	$40,800	Jan 2023
DataCore Systems	Pro	$3,400	$4,800	-29%	$16,800	Jul 2023
BluePeak Systems	Pro	$2,800	$3,900	-28%	$13,200	Oct 2023
ClearPath Inc.	Growth	$1,650	$2,100	-21%	$5,400	Apr 2024

Drift by Plan Tier

Breakdown

Enterprise (>$10K MRR)$168K

Pro ($2K–$10K MRR)$94K

Growth (<$2K MRR)$34K

Recommended Actions

Prioritised

Immediate (>30% gap)

Schedule renewal call — 8 accounts · $83K

Next 60 days (15–30% gap)

Proactive outreach — 22 accounts · $142K

Quarterly review (10–15% gap)

Include in next QBR — 20 accounts · $71K

Playbooks Active

4

All types covered

Best Win Rate

94%

Billing errors

Avg Outreach to Close

14d

Down from 23d

Revenue at Playbook

$523K

Recovered this period

Recovery Playbooks by Leakage Type

Step-by-step action plan · win rate · avg recovery value

💰 Pricing Drift PlaybookWin rate: 72% · Avg recovery: $5,920/account

Step 1 (Day 0): Auto-flag account — contracted MRR >10% below list price
Step 2 (Day 3): CSM receives alert with price gap report & renewal date
Step 3 (Day 7): CSM initiates value-demonstration call, prepares upgrade proposal
Step 4 (Day 14): Send formal pricing adjustment with 60-day notice
Step 5 (Day 60): New rate activates at next billing cycle

📉 Silent Downgrade PlaybookWin rate: 58% · Avg recovery: $4,100/account

Step 1 (Day 0): Downgrade event triggers immediate CRM workflow
Step 2 (Day 1): CSM outreach within 24 hours — no-pressure check-in
Step 3 (Day 5): Root cause call — identify budget, satisfaction, or usage issues
Step 4 (Day 10): Tailored re-engagement: training, executive sponsor, or discount bridge

🧾 Billing Error PlaybookWin rate: 94% · Avg recovery: $6,500/account

Step 1 (Day 0): Monthly reconciliation script flags invoice vs entitlement mismatch
Step 2 (Day 1): Finance team verifies — issue corrected in billing system
Step 3 (Day 2): Customer notified with explanation + goodwill credit if >$500 error
Step 4 (Day 3): Corrected invoice issued — new MRR takes effect immediately

Playbook Performance

Win Rate

Billing Error94%

Pricing Drift72%

Silent Downgrade58%

Feature Underuse45%

Next Actions Queue

Today

Escalated — call today3 accounts

Outreach due this week11 accounts

QBR prep needed7 accounts

Closed this week5 accounts

Root Causes Identified

7

Across all types

Top Cause

Stale Contracts

43% of all leakage

Preventable Leakage

76%

With process changes

Process Gaps Found

4

In CS workflow

Root Cause Breakdown

Primary driver behind each leakage category — impact & fix

Stale promotional contracts never renegotiated$296K

23% of enterprise accounts are still on rates from 2+ years ago. No automated process existed to flag contracts for renewal review when prices changed. Fix: automated 60-day renewal alert when contracted rate drifts >10% below list.

No CSM alert on downgrade events$186K

67% of silent downgrades happened at renewal with zero CSM contact in the prior 90 days. Downgrades were logged in billing but never surfaced to the success team. Fix: CRM workflow triggers CSM task within 24h of any plan reduction event.

Add-ons provisioned but never billed$169K

43% of billing errors were services switched on in the product backend with no corresponding invoice update. Provisioning and billing systems were not integrated. Fix: monthly reconciliation script matching provisioned services to active invoice line items.

No proactive engagement for low-adoption accounts$195K

Accounts with adoption scores below 35 were invisible until they requested a downgrade or cancelled. No health scoring existed before this project. Fix: weekly adoption scorecards in CRM; intervention triggered below score of 35.

Cause → Impact

% of leakage

Stale contracts43%

No downgrade alerting22%

Billing/provisioning gap20%

No adoption monitoring15%

Fixes Implemented

Status

Pricing drift alertsLive

Downgrade workflowLive

Billing reconciliationLive

Adoption scorecardsIn Progress