top of page
2 days ago
2 min read

Is SaaS expansion hiding churn in our smaller accounts?

By Trayan Hristov · Founder, Thrivelia · 19 November 2026

If net revenue retention is above 100%, the customers you started with now generate more recurring revenue in aggregate. It doesn’t tell you how many customers you lost, which plan they were on, or how dependent growth is on your biggest account.

Freeze the opening book

List each paying account and its recurring monthly value at the start of the interval. Track churn, contraction and expansion for those same accounts. Exclude new logos from both retention ratios. Agree on how to handle reactivation, currency changes, usage-based billing, credits and one-off services. If usage swings heavily, publish a consistent baseline or a separate usage bridge.

Gross revenue retention equals opening recurring revenue less churn and contraction, divided by opening revenue. Net revenue retention adds expansion from the opening cohort before dividing. Logo retention counts the accounts still paying. A customer downsizing seats stays in logo retention while lowering both revenue measures.

Read the three numbers on the same page

Imagine 100 opening accounts worth £100,000 MRR. Ten cancel, removing £8,000. Others contract by £4,000, while two large accounts expand by £18,000. Gross retention is 88%. Net retention is 106%. Logo retention is 90% if all 90 remaining accounts still pay. New sales could have been brilliant or terrible and these three calculations would be unchanged.

Break the bridge down by opening plan, account size and tenure. Assign the segment at the start. Moving an account to enterprise after its expansion and then using the new segment to explain performance distorts the analysis. Report the share of expansion from the largest account so the forecast shows its concentration.

Decide whether to invest in activation or expansion

If churn clusters among small accounts that never completed the core action, investigate onboarding and acquisition fit. If mature customers use the product heavily and then contract, look at packaging, seat utilisation and procurement. Ask whether a large expansion reflects sustained usage or an annual commitment that may reverse at renewal.

For a lifecycle test, randomise or phase changes by account. Track renewal and contribution after support cost as well as product activity. The Sintra case illustrates why a one-time product purchase and an ongoing software relationship need different journeys. The fictional revenue bridge above is a finance model, separate from that case.

Ask ChatGPT or Claude about your own numbers

Reconcile opening MRR, churn, contraction and expansion for the same accounts. Calculate GRR, NRR and logo retention by opening plan. How dependent is the result on the two largest expansions?

Related reading

 
 
 

Comments


bottom of page