A single churn rate hides the most important question in a subscription business: are newer customers sticking around better than older ones? A cohort retention table answers it. Each row is a group of customers who signed up in the same month, and each column shows how many of them are still active one, two, three or more months later. This tool builds the table from numbers you paste in, shades it as a heatmap, and works out the weighted average retention curve.
How it works
Each cell is the number still active in that month divided by the cohort's starting size. A cohort of 120 with 84 active after two months shows 70%. Reading across a row shows one cohort's decay; reading down a column compares cohorts at the same age.
The bottom row is the weighted average for each month, using only cohorts old enough to have reached it, weighted by their size. A simple average of percentages would let a small cohort of 10 customers count as much as one of 1,000.
Use customer counts for logo retention, or monthly recurring revenue for revenue retention. Revenue cohorts can go above 100% when upgrades and expansion outweigh cancellations, which is what strong net revenue retention looks like.
Look for the curve flattening. If retention drops fast early and then levels off, you have a core of customers who stay, and improving onboarding lifts every later month. If it keeps falling without levelling, the product isn't holding people long term.
A worked example
With the example data, 85.9% of customers are still active after month 1 and 71.3% after month 3, on a weighted average across cohorts. The newer cohorts retain better: the January cohort kept 80.0% after month 1, while July kept 89.1%, which suggests recent product or onboarding changes are working. The curve flattens after month 4, around 60% by month 6.
More examples
If a January cohort of 200 customers has 140 left after three months, month-3 retention is 70%. If the February cohort keeps 150 of 200 (75%), the newer cohort is retaining better.
Common mistakes
- Averaging cohort percentages without weighting by cohort size.
- Comparing cohorts over different lengths of time.
- Mixing customer counts and revenue in the same table.
- Reading the most recent cohorts before they have had time to mature.
Questions people ask
What is a cohort retention table?
A grid showing, for each group of customers who signed up in the same period, what share is still active after each following month. It shows whether retention is improving over time and when customers tend to leave.
How do you calculate cohort retention?
Divide the number of customers from a cohort still active in a given month by the number who started in that cohort, and multiply by 100. For revenue retention, use the cohort's MRR in each month divided by its starting MRR.
What is good retention for a SaaS product?
It depends heavily on the market. Products for large businesses usually retain far better than low-priced consumer or small-business tools. More useful than a benchmark is your own trend: newer cohorts should retain at least as well as older ones, and the curve should flatten rather than keep falling.
Should I track customers or revenue?
Both, if you can. Customer (logo) retention shows whether people stay. Revenue retention shows whether the ones who stay grow. A business can lose customers yet grow revenue from each cohort if expansion is strong.
Where do I get the data?
Your billing system or database: group customers by the month of their first payment, then count how many are still paying at each month end. Most billing tools can export this, and a spreadsheet pivot table gets it into the right shape to paste here.