Retention, Churn & Lifetime Value

Your churn rate is averaging away the truth

A single churn number on a dashboard is one of the most reassuring metrics a business can own, and one of the least informative. It can hold perfectly steady while retention quietly deteriorates underneath it, because an average is exactly the right tool for hiding a change in the mix.

Commonsent Analytics · Retention, Churn & Lifetime Value · 11 min read

The short version: churn is not one number, it is a curve, and the curve belongs to a cohort. Customers who joined this month behave nothing like customers who joined two years ago, and blending them into one rate produces a figure that describes neither. The fix is one table, buildable from data your billing system already holds, and it changes what you see about your business more than almost any other single analysis.

Here is the scene where this usually surfaces. A subscription business, or a repeat-purchase business, reports monthly churn of around 4 percent, and has for a year. Stable. Fine. Meanwhile revenue growth keeps flattening, and nobody can quite say why, because the two headline numbers, new customers acquired and churn rate, both look healthy. The instinct is to push harder on acquisition. The actual problem, visible the moment anyone draws the cohort table, is that customers acquired recently are leaving almost twice as fast as customers acquired two years ago, and the blended rate has been averaging the difference away the whole time.

Why one number cannot describe leaving

Churn has a shape, and the shape is remarkably consistent across business models. Customers do not leave at a steady rate through their life. They leave mostly at the start. The first days decide whether the product got used at all, the first renewal or reorder decides whether it earned a habit, and past that point, leaving gets rarer with every month of tenure. Plot survival against age and you get a cliff, then a slope, then a long flattening tail.

% still active 100 50 0 month 0 month 3 month 12 month 24 the cliff: onboarding and first value the tail: your actual business
The shape of retention in almost every repeat-revenue business: a steep early cliff, then a tail that flattens with tenure.

Two things follow from the shape. First, "monthly churn" for a customer depends enormously on how old that customer is. A month-one customer might have a 15 percent chance of leaving this month; a month-twenty customer might have a 1 percent chance. Second, and this is the trap, your blended churn rate is therefore mostly a statement about your customer mix, not about your retention. A business acquiring fast has lots of young, fragile customers, so its blended rate runs high even if it retains beautifully at every age. A business that stopped growing has an aging, loyal base, so its blended rate looks great even as it slowly dies. The single number is not measuring what everyone assumes it measures.

A blended churn rate is mostly a statement about your customer mix, not about your retention.

How growth hides a retention problem

The mix effect gets dangerous in one specific and very common configuration: acquisition is growing, and new-customer quality is falling. Maybe the newer marketing channels bring weaker-fit customers, a pattern we dissected in more leads, less revenue. Maybe onboarding degraded as volume grew. Either way, each new cohort retains a little worse than the one before. What does the blended rate do? Almost nothing. The fast-growing base keeps the mix young, the mix keeps the average in a familiar range, and the dashboard stays green.

Worked example, simplified on purpose

A business with 2,000 long-tenured customers churning at 1.5% a month starts acquiring 300 new customers a month whose early churn is 12% a month, worsening to 15% over the year.

Start of year: blended churn = mostly old base = ~2.9%
End of year: new-customer churn up 25%, but the base is now younger and larger, blended churn = ~3.1%
The dashboard sees a rounding error. The cohort table sees a quarter of future revenue gone missing.

Illustrative arithmetic, not a client's data. The point survives any specific numbers: when mix shifts, the blended rate and the truth can move independently, and usually do.

Then acquisition slows, as it eventually does, and the mask slips. The young, leaky cohorts stop being refilled, the mix ages into the damage, and the blended churn rate jumps. Leadership experiences this as a sudden retention crisis. It is not sudden. It is somewhere between six and eighteen months old, and it was visible the entire time in a table nobody had drawn.

The cohort table: one view that cannot be fooled

The fix costs an afternoon. Group customers by the month they started. For each group, track the share still active one month later, two months later, three, and so on. Lay it out with cohorts as rows and age as columns. That is the whole method. What makes it powerful is that it separates the two questions a blended rate smears together: how does retention change with customer age (read along a row), and is retention getting better or worse for equivalent customers (read down a column).

CohortMonth 1Month 3Month 6Month 12
Jan 202588%74%66%58%
Apr 202587%72%63%54%
Jul 202584%68%58%
Oct 202581%63%
Jan 202678%

Read down the month-1 column of this illustrative table: 88, 87, 84, 81, 78. Every cohort is starting worse than the one before it, a straight ten-point slide in a year, and this is the single most important fact about this business. No blended rate would have shown it this early, because the deterioration lives entirely in young cohorts that are a small share of the current base. The column view is the early warning system. The row view, meanwhile, tells you where the money should go: if the big losses happen between month 0 and month 3, the fix lives in onboarding and first value, not in renewal discounts at month 11.

% still active month 0 month 6 month 12 2024 cohorts 2025 cohorts 2026 cohorts each vintage settles lower than the last
Successive cohorts as curves. The blended rate averages these three lines into one flattering number; the cohort view shows the slide.

Cut it again: cohorts by source

Once the cohort table exists, one more cut multiplies its value: split cohorts by acquisition channel. Retention is not evenly distributed across the ways customers find you, and the differences are routinely enormous. Customers who arrived through a referral or organic search often retain at multiples of customers who arrived through a discount-led prospecting campaign, because the channel selects for intent and fit before you ever see the customer.

This is where retention analysis quietly becomes acquisition analysis. If channel A's customers are worth 30 months and channel B's are worth 7, then a cost-per-acquisition comparison between them is meaningless on its own, and every budget decision made on blended CPA is misallocating money. The honest way to compare channels is by what a customer from each is actually worth over their observed life, which is precisely the arithmetic we walk through in LTV you can actually defend. And if a channel's cohorts churn fast and early, that is not a retention problem for the success team. It is a targeting problem for marketing, wearing a retention costume.

Three honest mechanics

Three details keep the analysis truthful, and all three are places we see it quietly go wrong.

Define "active" deliberately. Subscription businesses get churn dates from cancellations, but repeat-purchase businesses have to choose a definition: a customer is churned if they have not bought within some window. Set that window from your own inter-purchase data, the gap that, once exceeded, few customers ever return from, not from a default. Too short a window manufactures churn that is not real; too long hides churn that is.

Separate customer churn from revenue churn. Losing three tiny accounts and keeping one large one is a very different event from the reverse, and a count-based rate treats them identically. Track both: what share of customers stay, and what share of revenue stays. When the two diverge, the divergence itself is the finding, it tells you which end of your customer base is leaving.

Use the median lifetime, not the mean. The long tail of very loyal customers drags the mean lifetime far above what a typical customer does. The median, the age by which half a cohort has gone, describes reality. The mean flatters it, and anything built on the flattering version, pricing, payback rules, LTV, inherits the flattery.

What to do with what the table shows

The cohort table is a diagnostic, and diagnostics earn their keep by directing treatment. The pattern of the deterioration tells you where to look. Starting retention (month 1) falling cohort over cohort points upstream: channel mix, expectation-setting, onboarding. Mid-curve steepening (months 2 to 6) points at value delivery: the product or service is not building the habit it used to. Tail erosion in long-tenured customers is rarer and more serious: something changed for your best customers, pricing, quality, competition, and it deserves direct conversation with the customers themselves, not just analysis.

And because every intervention you launch will be aimed at a moving target, measure the fix the same way you found the problem: did the cohorts that received the new onboarding retain better than the cohorts that did not, at the same age? That comparison, cohort against cohort with everything else held as still as possible, is the retention version of the discipline we apply to ad spend in incrementality over attribution. The blended rate will not tell you whether your fix worked. The next three columns of the table will. Which is the whole story of this piece: stop asking what your churn rate is, and start asking what your newest cohort's curve looks like against the one before it. That question has an answer a business can act on.

Common questions

What is a good churn rate?

No universal benchmark survives contact with the differences between business models, price points, and customer mixes. The question with an actionable answer is directional: are your newest cohorts retaining better or worse than last year's cohorts at the same age? Improving vintage over vintage is health at almost any absolute level. Deteriorating vintages are a problem even when the blended number looks fine.

Why does my churn rate look stable while growth is flat?

Because a blended rate mixes old, loyal customers with new, fragile ones, and steady acquisition keeps refilling the fragile end. That holds the average in place even while new-customer retention worsens. When acquisition slows, the mask slips and the blended rate jumps, but the deterioration started months earlier. A cohort table shows it in the first column, almost immediately.

How do I calculate churn by cohort?

Group customers by start month. For each group, compute the share still active at age 1 month, 2 months, and so on, and lay the groups out as rows with age as columns. Reading down a column compares cohorts at equal age, which is the comparison that detects deterioration early. The inputs, start date and end or last-activity date per customer, already exist in your billing system or CRM.

Want your cohort table built and read?

We build the cohort and channel retention views from your billing and CRM data, show you where the curve is losing customers, and put a revenue figure on fixing the leak that matters most.

Book a 30-min call →