SaaS Cohort Analysis: Track Retention Over Time

Cohort analysis is a method of grouping customers by a shared characteristic — most commonly their signup date — and tracking their behavior over time. Instead of looking at all customers as a single pool, you analyze each cohort separately to understand how retention changes as customers age.

For example, all customers who signed up in January form the “January cohort.” You then track what percentage of that cohort is still active after 1 month, 2 months, 3 months, and so on.

Cohort analysis answers questions that aggregate metrics cannot:

• Is our retention improving over time, or are newer customers churning faster?
• At what point after signup do we lose the most customers?
• Did a specific product change or pricing update affect retention for the cohorts that experienced it?
• Are customers from certain acquisition channels retaining better than others?

Without cohort analysis, a growing customer base can mask a deteriorating retention rate. New signups replace churned users, and the aggregate active user count looks stable even as individual customer retention worsens.

Consider a SaaS company that reports a 5% monthly churn rate. This single number hides critical dynamics:

• Is the 5% churn concentrated among new customers (first-month drop-off) or distributed evenly across all tenures?
• Is the churn rate improving or worsening compared to previous months?
• Did a recent product change affect retention for new signups differently than existing users?

Point-in-time metrics blend all customers together, making it impossible to distinguish between these scenarios. Cohort analysis separates them.

For example, you might discover that:

• Month-1 churn is 15% (new customers who never activate)
• Month-2 through Month-6 churn averages 3% per month
• After Month 6, churn drops to under 1% per month

This tells you a completely different story than “5% monthly churn.” It reveals that your biggest opportunity is improving first-month activation, and that customers who survive the first six months are highly loyal. You would never see this pattern in aggregate metrics alone.

A retention cohort table is a matrix where each row represents a cohort (grouped by signup month) and each column represents a time period after signup. The cells contain the percentage of the original cohort that is still active.

Here is how to build one:

1. Define your cohorts: Group customers by their signup month (or week, for faster-moving products).
2. Define “active”: Decide what counts as active. For subscription SaaS, this is usually “has an active subscription.” For usage-based products, you might define it as “logged in at least once this month.”
3. Calculate retention for each period: For each cohort, count how many customers are still active in month 0, month 1, month 2, etc. Divide by the original cohort size.

The resulting table might look like this (simplified):

Month 0 is always 100% because every customer starts as active. The table is triangular because newer cohorts have not yet aged enough to fill later columns.

Cohort tables reveal patterns that drive strategic decisions. Here is what to look for:

Improving cohorts (reading down a column): If the Month-3 retention is 65% for January, 70% for February, and 75% for March, your product or onboarding is getting better over time. This is the most encouraging pattern you can see.

Worsening cohorts: If newer cohorts show lower retention at the same age, something is degrading — product quality, customer fit, or onboarding effectiveness.

Early drop-off (reading across a row): A sharp decline between Month 0 and Month 1 indicates activation problems. Customers are signing up but not finding value quickly enough.

Flattening curves: As you read across a row, retention should eventually flatten. The point where the curve flattens is your “natural retention rate.” Customers who survive past this point tend to stay for a long time.

Seasonal patterns: Some cohorts may behave differently due to seasonal factors (holiday signups, new-year budgets, back-to-school). Look for consistent seasonal effects across years.

The most actionable insight from cohort analysis is identifying where in the customer lifecycle you lose the most people, so you can focus retention efforts on that specific stage.

Customer cohort analysis tracks the count of retained customers. Revenue cohort analysis tracks the dollar value retained (or expanded) from each cohort. These can tell very different stories.

Consider a scenario where customer retention is 80% after 12 months, but the remaining customers have upgraded their plans. Revenue retention might be 95% or even over 100% (if expansion revenue exceeds churned revenue).

Revenue cohorts are calculated the same way as customer cohorts, but instead of counting customers, you sum the MRR for each cohort at each time period:

Why track both:

• Customer cohorts show your raw retention and product stickiness
• Revenue cohorts show the economic impact of churn plus expansion
• Revenue cohorts above 100% at later periods mean you have strong expansion (negative net revenue churn within the cohort)
• A divergence between the two — customer retention declining but revenue retention stable — means you are losing small accounts and retaining or growing large ones

For board reporting and investor communication, revenue cohorts are typically more relevant. For product decisions, customer cohorts provide clearer signal.

You can build cohort analysis with varying levels of sophistication:

Spreadsheets (beginner): Export your customer data with signup dates and current status. Use pivot tables to create the cohort matrix. This works for small datasets but becomes unwieldy beyond a few thousand customers.

SQL queries (intermediate): Write queries against your production database or data warehouse. The basic approach is to join your customers table (for cohort assignment) with a subscription status table (for retention tracking) and group by cohort period and age.

A simplified SQL structure:

Analytics platforms (advanced): Tools like Amplitude, Mixpanel, ChartMogul, or Baremetrics offer built-in cohort analysis features with visualization, filtering, and segmentation capabilities.

Regardless of the tool, the key is to make cohort analysis a regular part of your reporting cadence. Review cohort tables monthly to catch trends early. Segment by acquisition channel, plan tier, or geography for deeper insights.