Analyze customer and revenue churn

Direct answer

Report lost customers and lost recurring revenue separately, using the customers and revenue present at the start of the period. Gross revenue retention excludes expansion; net retention includes it. Compare signup cohorts and separate cancellations from subscriptions lost after payment recovery fails.

Why this question comes up

One large cancellation can outweigh many small ones. A single blended churn rate misses that difference and can hide whether newer signup cohorts are retaining better or worse.

Records to gather

• Subscription start, end, and change dates per customer
• MRR or ARR by customer by month
• Invoice and payment status for subscriptions with failed charges
• Cancellation reasons where captured
• Upgrades, downgrades, and pauses distinguished from cancellations
• Cohort assignment by signup month

Review workflow

1. Count beginning-of-period customers. Customer churn is customers from that group whose subscriptions end during the period, divided by the starting count. Do not add new signups to the denominator.
2. Measure lost recurring revenue. Divide starting-cohort MRR lost to cancellations and downgrades by starting MRR. Gross revenue retention is 100% minus that loss rate. Net retention also adds expansion from those starting customers; do not include new-customer revenue.
3. Compare cohorts. Group customers by signup month and compare retention at the same age. A blended rate can hide a change in newer cohorts.
4. State when churn occurs. A cancellation request, the end of a paid term, and an unsuccessful charge are different events. Use one rule consistently and disclose it.
5. Identify payment-related losses. A failed charge is not necessarily churn if payment is recovered. Once the subscription ends, count the loss but show it separately from voluntary cancellation.

What a useful answer should include

• Customer churn and revenue churn reported separately
• Gross and net revenue retention, both shown
• Cohort retention curves rather than a blended rate
• The churn event definition, stated
• Involuntary churn split out from voluntary
• Expansion revenue shown separately from retained revenue

Common failure modes

• Leading with net retention. Expansion from a few large accounts can hold it above 100% while the customer base erodes.
• Blending cohorts. Deterioration stays invisible until it is a year old.
• Treating every failed charge as churn. Check whether the payment was recovered and whether the subscription actually ended.
• Multiplying monthly churn by twelve. For a stable monthly rate and a fixed starting cohort, annual loss is 1 − (1 − monthly churn)^12, not twelve times the monthly rate.