DataMimiDataMimi

What Is Cohort Retention?

Cohort retention groups customers by the period they joined and tracks what share remains active at each subsequent interval. Unlike an aggregate churn rate, it reveals whether newer customers are staying longer than older ones — or whether a product change made things worse for a specific month's sign-ups.

Upload your subscription or event export and get a cohort retention table — each sign-up month as a row, each time interval as a column — built automatically.

Drop your file in and ask a question — no account needed.

Upload your spreadsheet.xlsx .xls .csv — free to try, no account

Or start with

Do customers who activated within 3 days have higher 90-day retention than those who took longer?Which cohort month produced the best 6-month retention?Did the product change in March improve or hurt retention for subsequent cohorts?At what week does our retention curve flatten to a steady-state level?How does retention differ between customers acquired through paid versus organic channels?

What this export contains

Cohort Month
Week 0
Week 1
Week 2
Week 4
Week 8
Week 12
Week 26
Week 52
Customer Count
Active Count
Retention %

What usually goes wrong with it

  • Active status is set by billing events, not usage events

    An 'active' flag that updates based on subscription status keeps churned customers marked active until a cancellation event fires — which can happen weeks after they last used the product, inflating early-period figures.

    DataMimi DataMimi uses the last product event date rather than subscription status for the active flag, so the curves reflect genuine engagement rather than billing system timing.

  • Trial periods inflate Week 1 and Week 2 results

    Users who signed up for a 14-day trial all appear at Week 1 and Week 2 by definition — they haven't had the chance to churn yet. Including them makes early results look artificially high.

    DataMimi It detects trial-period rows and offers to exclude the first N days so the first comparable data point reflects post-trial behavior.

  • Small cohort sizes produce imprecise percentages

    A cohort of 8 customers at Week 52 with 3 active produces a 37.5% figure that appears precise but has a confidence interval wide enough to include both failure and success.

    DataMimi It flags cohort cells with fewer than a configurable minimum observations and marks them as statistically unreliable rather than reporting a precise percentage.

  • Day zero definition changes between cohort periods

    Some months use signup date as Day 0; a product change means later cohorts use activation date instead. The two definitions produce non-comparable curves even when placed on the same chart.

    DataMimi It detects the Day 0 definition change across cohort periods and segments the curves by their start definition so they're only compared within comparable groups.

Common questions

What is cohort retention?

It is the percentage of customers from a specific starting group who remain active at each subsequent time interval — Week 1, Month 3, Month 12. It shows how long customers stick around and whether newer cohorts are improving over older ones.

What is a good cohort retention rate?

For consumer apps, 20-30% at Day 30 is considered decent. For B2B SaaS, 80-90% at Month 12 is a healthy target. The right benchmark depends on the product category and pricing model.

What is the difference between cohort retention and churn rate?

Churn rate is an aggregate figure across all customers in a period. Cohort-based analysis shows how specific starting groups behave over time, revealing whether a product change improved or hurt retention for specific sign-up months.

How do I build a cohort retention table in a spreadsheet?

Group customers by their sign-up month. For each subsequent month, count what share of each group is still active. Each group is a row, each period is a column, and each cell is a percentage. DataMimi builds this from a subscription or event export automatically.

How much does DataMimi cost?

Free plan: $0/month, 40 credits, no credit card required. Lite: $9/month, 400 credits. Starter: $24/month, 1,500 credits, up to 3 simultaneous files. Pro: $59/month, 5,000 credits with rollover. Team: $199/month, 20,000 credits, 5 users.

Try it with your own file

DataMimi reads the file you actually have — merged cells, headers below row one, totals pasted at the bottom — and shows which rows and columns every number came from.

Ask about your file

More in Analysis methods