Use case · Retention rate

Explain retention rate change by customer segment

Overall retention slipped. WaterfallBridge shows which segments actually churned more — and how much of the drop is just a changing customer mix.

The question

"Our blended retention rate fell this year. Is it that customers are genuinely churning more, or did we grow the segments that always retained worse? Which segment is the real problem?"

Why traditional methods struggle

Retention is retained ÷ eligible — a ratio that moves with both churn and the size of each segment.
Growth can lower blended retention even when no segment got worse, if you add more of a low-retention segment.
A new segment (e.g. a free tier) enters with different retention, distorting the average.
Cohort spreadsheets rarely separate real per-segment churn from segment-mix shift.

How WaterfallBridge breaks it down

Set the Result to Retention Rate, with SumY = Retained customers (numerator) and SumN = Eligible customers (denominator), broken down by the Key = Customer segment. With last year as baseline and this year as comparison, WaterfallBridge attributes the retention change to each segment and isolates the mix shift and the newly added segment.

Example input data

Illustrative figures. Free-tier is a new segment this year.

Segment	Period	Eligible (SumN)	Retained (SumY)	Retention
Enterprise	Baseline	200	184	92.0%
Enterprise	Comparison	220	198	90.0%
SMB	Baseline	500	425	85.0%
SMB	Comparison	650	520	80.0%
Free-tier new	Comparison	300	210	70.0%
Total	Baseline	700	609	87.0%
Total	Comparison	1,170	928	79.3%

The eligible base grew +470, but retention fell −7.7 pp (87.0% → 79.3%).

Example output: the retention bridge

Contribution of each segment to the −7.7 pp retention change (illustrative).

Driver	Contribution to retention	Effect
Baseline retention rate	87.0%	start
Enterprise — slight decline (92% → 90%)	−0.3 pp	down
SMB — real churn rise (85% → 80%)	−2.8 pp	down
Free-tier — added (low 70% retention)	−4.4 pp	down
Mix shift toward lower-retention segments	−0.2 pp	down
Comparison retention rate	79.3%	end

The conclusion

The headline −7.7 pp is mostly structural, not a company-wide collapse. Adding the Free-tier segment at 70% retention accounts for ~4.4 pp — expected dilution from a new low-commitment tier. The genuine red flag is SMB, where real retention fell from 85% to 80% (~2.8 pp). Enterprise is essentially stable. The action: separate Free-tier in reporting so it doesn't mask the core book, and prioritise an SMB churn intervention.

A falling blended rate is often a new-segment story. The bridge tells you what's dilution and what's real churn.

FAQ

How do I explain a retention rate change by customer segment?

Define retention rate as retained customers divided by eligible customers, set retained as SumY and eligible as SumN, and break it down by customer segment. WaterfallBridge attributes the blended retention change to each segment and separates real per-segment retention changes from the effect of a changing segment mix and any newly added segment.

Explain your own retention change

Try the demo with sample data, or ask an AI agent to analyze your file in one sentence.

Try with sample data → Ask AI to analyze your file →