Boneyard Tools

Cohort Retention Calculator

Track how well each signup group sticks around over time. Enter the starting size of each cohort and how many users stay active each period to get a color-coded retention heatmap, a weighted average retention curve, and the matching churn curve.

How to use the cohort retention calculator

  1. Add a cohort for each signup group and name it, such as the month users joined.
  2. Set the starting size, then enter retained user counts per period as a comma separated list.
  3. Read the heatmap and the average retention row to spot where users drop off.

Examples

Two monthly cohorts

Jan: 100 start, 100, 80, 60. Feb: 200 start, 200, 100.
Jan retention 100%, 80%, 60%; period 1 weighted average 60%

A single cohort over three months

100 users, retained 100, 75, 50
Retention 100%, 75%, 50% and churn 0%, 25%, 50%

Frequently asked questions

What is cohort retention?

Cohort retention groups users by when they joined and tracks how many are still active in each later period. Period 0 is the group's starting size, so it reads 100 percent. A cohort that starts with 100 users and keeps 60 by period 2 has 60 percent retention there. Reading cohorts side by side shows whether newer groups stick around better than older ones.

How is the retention percentage calculated?

For each cohort, retention at a period is the users still active divided by the cohort's starting size, multiplied by 100. So 60 of an original 100 users is 60 percent. Because the denominator is always the starting size, every row begins at 100 percent and you can compare any later period directly against the start.

How is the average retention curve weighted?

The average curve weights each cohort by its starting size rather than treating every cohort equally, so a cohort of 1,000 users counts more than one of 10. Each period only averages over cohorts that are old enough to have data there, which stops a brand new cohort from distorting longer-horizon retention. The churn curve is simply 100 minus average retention at each period.

Can cohorts have different numbers of periods?

Yes. Older cohorts naturally have more periods of history than recent ones, so you can leave newer cohorts shorter. The heatmap leaves missing cells blank, and the average retention for a given period only includes cohorts that have actually reached it.

Can retention go above 100 percent?

It can if a cohort wins back lapsed users or reactivates dormant accounts, since retained users in a later period can exceed an earlier count. The calculator allows this so the numbers stay faithful to your data, and the matching churn value simply turns negative for that period.

Does this calculator send my cohort data anywhere?

No. Everything runs entirely in your browser, so your cohort names, user counts, and retention figures never leave your device or get stored on a server.

Related tools