Skip to content
Built in Lahore, PakistanHow we check the math
mathbehind

SaaS Cohort Retention Table Generator

Paste monthly signups and active customers to see a cohort retention heatmap, weighted averages by month, and export it as CSV.

By Muhammad Ahmad, Software EngineerLinkedIn

Label, starting customers, then customers still active after month 1, 2, 3 and so on. Paste straight from a spreadsheet or separate with commas. Your data stays in your browser.

Average customers retained after month 3

71%

After month 1
86%
After month 3
71%
After month 6
60%
Cohorts
8

Averages are weighted by cohort size and use only cohorts old enough to have reached that month.

Retention by signup cohort and month since signup
CohortStartM1M2M3M4M5M6M7
Jan 202612080%70%66%63%60%58%57%
Feb 202614082%72%68%64%62%61%
Mar 202616584%75%71%68%66%
Apr 202615086%78%74%71%
May 202618087%79%76%
Jun 202621088%81%
Jul 202623089%
Aug 2026260
Weighted average86%77%71%67%63%60%57%
Darker cells mean more customers retained.

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.