Analyze customer and revenue churn

Direct answer

For this review, explain logo churn, revenue churn, GRR, NRR, and cohort analysis with a first-90-days lens.

Why this question comes up

Teams know churn is bad but need to know where, when, and why customers drop. This guide turns that concern into a review that can be repeated with a defined period, consistent inputs, and a visible trail back to the records.

Records to gather

• Subscription start, end, and change dates per customer
• MRR or ARR by customer by month
• Cancellation reasons where captured
• Upgrades, downgrades, and pauses distinguished from cancellations
• Cohort assignment by signup month

Review workflow

1. Separate customer churn from revenue churn. Losing 10% of customers who represent 2% of revenue is a very different business problem from the reverse. Report both.
2. Distinguish gross from net revenue retention. Gross retention cannot exceed 100% and shows loss honestly. Net includes expansion and can sit above 100% while most customers are leaving.
3. Work in cohorts. A blended churn rate mixes a mature cohort with a new one and hides the trend. Cohort curves show whether churn is improving.
4. Define the churn event precisely. Cancellation date, end of paid term, and failed payment are three different moments. Pick one and apply it consistently.
5. Separate involuntary churn. Failed cards are a payments problem with a payments fix, not a product problem. Mixing them misdirects the response.

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.
• Counting failed payments as churn. It is recoverable, and it hides the real voluntary rate.
• Annualising a monthly rate naively. Monthly churn compounds; multiplying by twelve overstates annual loss.

Community context

The linked community posts show why people search for this topic and which parts create confusion in practice. They are anecdotal. Use the reference sources and your organization’s policies for accounting treatment, tax, compliance, and final decisions.