Cohort Analysis Calculator

About the Cohort Analysis Calculator

Cohort analysis groups customers by their acquisition period (typically the month of first purchase) and tracks what percentage remain active in each subsequent period. It is the gold standard for measuring retention trends because it controls for growth — unlike blended retention metrics that mix new and old customers.

A cohort retention table is read left to right: Period 0 is always 100% (the cohort itself), Period 1 shows what percentage came back the next period, and so on. Healthy businesses show a flattening curve — the customers who survive the first few periods tend to stick around for a long time.

This calculator lets you enter cohort size and active users for up to 6 periods, computing retention percentages and visualizing the decay curve. Use it to compare cohorts, evaluate whether retention is improving over time, and model the long-term value of different customer groups.

When This Page Helps

Blended retention metrics can look stable while individual cohorts are deteriorating if you keep acquiring more customers. Cohort analysis reveals the true retention story and lets you compare before-and-after cohorts for changes like onboarding, loyalty, or merchandising updates.

How to Use the Inputs

1. Enter the size of a customer cohort (e.g., customers acquired in January).
2. Enter the number of active customers from that cohort in Period 1, 2, 3, etc.
3. The calculator shows the retention percentage for each period.
4. Compare across cohorts to see if retention is improving.
5. Use the retention curve to model CLV by cohort.

Example Calculation

Tips & Best Practices

• Look for the "flattening point" in your cohort curve — this tells you when customers become loyal.
• Compare cohorts before and after major changes (new product, loyalty program, UX overhaul).
• Monthly cohorts are standard. For fast-moving businesses, weekly cohorts can provide earlier insights.
• The first 30–60 days after acquisition have the steepest retention drop for most businesses.
• Cohort analysis is significantly more insightful than blended retention metrics.
• Model CLV per cohort by multiplying retention percentages by AOV through each period.

Why Cohort Analysis Is the Gold Standard

Warren Buffett once said the most important thing is to see what's happening underneath the surface. Cohort analysis does exactly that for customer retention. A business growing at 30% per year might have declining cohort retention that will eventually catch up with it. The cohort table reveals this truth.

Interpreting the Retention Curve

The first-month drop is always the steepest because many first-time buyers are one-time experimenters. By month 3–4, you see your "core" retention rate — the percentage of buyers who become genuine repeat customers. This core rate is your true retention baseline.

Using Cohorts to Measure Experiments

Launching a new onboarding email sequence? Compare the retention curves of the pre-launch cohort vs. the post-launch cohort at the same maturity. This is the cleanest way to measure the impact of retention programs without confounding factors.

Frequently Asked Questions

• What defines a "cohort" in e-commerce?

  A cohort is typically all customers who made their first purchase in the same month. You can also create cohorts based on acquisition channel, product category, or campaign to compare specific groups.

• What does "Period 0" mean?

  Period 0 is the cohort itself at 100%. Period 1 is the next time window (e.g., the next month). The retention percentage in each period shows what fraction of the original cohort was still active.

• What does a healthy cohort curve look like?

  A healthy curve drops steeply initially (many first-time buyers do not return) then flattens. If 15–25% of a cohort remains active after 6 months with minimal further drop-off, those are loyal customers who will likely stay for years.

• How many periods should I track?

  Track at least 6–12 months for non-subscription e-commerce. The value is in seeing whether the curve flattens. If it does not flatten and keeps declining, you have a fundamental retention/product problem.

• How is cohort analysis different from overall retention rate?

  Overall retention blends all customers together, masking cohort-specific trends. Cohort analysis isolates each group, letting you see whether newer cohorts retain better or worse than older ones. It is far more actionable for evaluating changes.

• Can I do cohort analysis in Google Analytics?

  GA4 has a built-in cohort exploration report. It is useful for quick analysis. For deeper cohort analysis with revenue and margin data, most teams export data to a spreadsheet or BI tool for custom analysis.