spyc.ai

Free tool

Cohort Retention Analyzer

Paste a cohort table as CSV to get a retention percentage grid and a size-weighted average retention curve.

How it works

What is the Cohort Retention Analyzer?

The Cohort Retention Analyzer is a free tool that turns a pasted cohort table into retention percentages. Give it one row per cohort with the cohort name, its starting size and the number still active in each later period. It returns a shaded percentage grid, a size-weighted average retention curve and the steepest drop.

How to use the Cohort Retention Analyzer

  1. Export or type your cohort table as CSV: cohort name, starting size, then retained counts per period.
  2. Paste it into the box, with or without a header row.
  3. Read the retention grid and the average retention curve underneath.
  4. Copy the grid to paste into a spreadsheet.

What is cohort retention analysis?

Cohort retention analysis groups customers by when they started, usually the month they signed up, and tracks what share of each group is still active one period later, two periods later and so on. Each group is a cohort.

It answers questions a single churn rate cannot: whether customers leave early or late, whether the curve flattens, and whether newer cohorts retain better than older ones.

How do I format the cohort table?

One cohort per line, values separated by commas, tabs or semicolons. The first value is the cohort name, the second is its starting size, and the rest are the counts still active in period 1, period 2 and onward. For example: Jan,1000,600,450,400.

A header row is optional; if the second cell of the first line is not a number the tool treats that line as headings and uses them as column labels. Newer cohorts can have fewer columns. Write numbers without thousands separators, since a comma starts a new column.

How do I read a retention grid?

Each cell is retained customers divided by the cohort's starting size, and darker cells mean higher retention. Read across a row to follow one cohort over time. Read down a column to compare cohorts at the same age, which shows whether retention is improving.

The grid is a triangle because recent cohorts have not lived long enough to fill the later columns.

How is the average retention curve calculated?

For each period the tool adds up the retained customers across every cohort that has reached that period and divides by those cohorts' combined starting size. That is a size-weighted average, so a cohort of 1,200 counts for more than a cohort of 900.

Later periods rest on fewer cohorts and are less reliable. The last column in the sample comes from a single cohort. The tool also names the step where the average falls furthest.

What does a healthy retention curve look like?

The shape matters more than any single number. A curve that drops and then flattens means a stable core of customers stays; a curve that keeps falling toward zero means every cohort eventually leaves, and growth depends entirely on replacing them.

The steepest drop is usually in the first period, which points at onboarding. To turn retention into a single rate use the Churn Rate Calculator, and to see what it does to customer value use the CAC and LTV Calculator. For revenue instead of customer counts, see the NRR and GRR Calculator.

Questions

Can I paste revenue instead of customer counts?
Yes. Use starting revenue as the size and retained revenue per period. Cells can then exceed 100% when a cohort expands, and the tool flags that so you can confirm it is intended.
Should the table include period 0?
No. The starting size is period 0, which is 100% by definition. The first retained column is the first period after that.
What happens to rows the tool cannot read?
A row whose size is missing, zero or not a number is skipped and named under the grid. A row stops at its first blank or non-numeric cell.
Is the average weighted?
Yes, by cohort size. It is total retained divided by total starting size for the cohorts that have data in that period.
Is the Cohort Retention Analyzer free?
Yes, with a free spyc.ai account. It runs in your browser, so nothing you type is sent to a server.

Marketing Calculators

More in Marketing Calculators

ROAS Calculator

Work out return on ad spend from revenue and spend, plus break-even ROAS and profit from your gross margin.

Calculate ROAS

CAC and LTV Calculator

Get CAC, lifetime value, the LTV:CAC ratio and payback from spend, new customers, ARPU, margin and churn.

Calculate LTV:CAC

Churn Rate Calculator

Measure customer and revenue churn for a month, quarter or year, with compounded monthly and annual rates.

Calculate churn

Ready when you are

Before your next buyer asks AI about you, ask AI about yourself

One check, four engines, about twenty seconds. We show you the answers before we ask for anything.