Cohort Analysis for SaaS: Tracking Revenue Retention

What Is Cohort Analysis and Why It Matters

Cohort analysis groups customers by acquisition month and tracks their behavior over time. January cohort: 50 customers acquired in January. You track how many are still paying in February, March, April, etc. July cohort: 75 customers acquired in July. By December, how many are still paying? Cohort analysis reveals whether retention is improving (newer cohorts retain better) or declining (older cohorts retained better).

This is critical for SaaS because revenue growth depends on both new customer acquisition and existing customer retention. If newer cohorts are retaining worse than older cohorts, your business is degrading. You're acquiring more customers but they're leaving faster. This is unsustainable. Conversely, if newer cohorts retain better, your product improvements are working.

Building a Cohort Retention Table

Create a table with cohorts down rows (January, February, March, etc.) and months after acquisition across columns (Month 0, Month 1, Month 2, etc.). Each cell shows the percentage of that cohort still active. January cohort: Month 0 = 100%, Month 1 = 95%, Month 2 = 92%, Month 3 = 89%, Month 12 = 60%. This shows 60% annual retention for January cohort.

In reality, you'll want to track revenue retention, not just customer count retention. A revenue cohort table tracks revenue, not customers. January cohort generated $50K revenue in Month 0 (month of acquisition). In Month 1, that same cohort generated $47K revenue (95% retention, also factoring in any expansion or contraction). By Month 12, $30K revenue (60% of original). This is more useful than customer count because revenue expansion is captured.

Interpreting Cohort Tables: Healthy vs Unhealthy Patterns

Healthy cohort analysis: (1) Month-0-to-Month-1 retention is 85-95% (normal that some customers churn in first month), (2) Retention stabilizes by Month 2-3 (you hit 70-80% and stay there), (3) Newer cohorts have similar or better retention than older cohorts (you're improving or at least not degrading).

Unhealthy patterns: (1) Month-0-to-Month-1 churn is 20%+ (onboarding problems), (2) Retention keeps declining through Month 6+ (customers gradually leave, indicating product issues), (3) Newer cohorts have worse retention than older cohorts (your product is getting worse or you're acquiring lower-quality customers).

Using Cohort Analysis to Diagnose Problems

If you see Month-0-to-Month-1 churn of 20%, you have onboarding problems. Many customers sign up but don't actually use your product. Fix: improve onboarding, have customer success follow up with new customers, provide better training. By improving onboarding, Month 1 retention should jump from 80% to 90%.

If Month 6+ retention is declining (from 85% Month 2 to 75% Month 3 to 60% Month 6), you have product stickiness problems. Customers try the product, find it useful initially, but eventually realize it's not truly solving their problems. Fix: improve product, add features they're requesting, or focus on customer segments where your product is genuinely sticky.

Cohort Expansion and Net Revenue Retention

A cohort that starts at $50K revenue and ends at $55K revenue at Month 6 has both retention and expansion. This is net revenue retention > 100%, which is exceptional. It means existing customers are staying AND increasing spend. This is the dream for SaaS: compounding revenue from existing customers.

Track cohort expansion separately from retention. Retention = (revenue month N / revenue month 0). Expansion = additional revenue from upsells, upgrades, increased usage. If January cohort started at $50K revenue, had $43K in Month 6 (86% retention), but upsells added $5K (expansion), final Month 6 revenue is $48K, or 96% net revenue retention. The expansion is critical to the story.

Predicting Revenue From Cohort Analysis

Once you have 6+ months of cohort history, you can forecast revenue. Your January cohort contributes revenue each month even years later. If January cohort will contribute $25K in Month 36, and February cohort will contribute $28K in Month 36, etc., sum all cohort contributions to get total Month 36 revenue.

This is far more accurate than "we'll grow 10% monthly" because it's based on actual cohort behavior. If January cohort's Month-to-Month retention is declining from Month 6 onward (going from 65% to 55% to 40%), your forecast will reflect that decline. This forces you to fix retention if you want to hit revenue targets.

Segmented Cohort Analysis: Different Products or Customer Types

Run cohort analysis separately for different customer segments. Enterprise cohort retention vs SMB cohort retention might be very different. Enterprise might have 90% annual retention; SMB might have 60%. This tells you to focus on enterprise expansion (they're sticky) or fix SMB retention (they're leaky).

Similarly, if you acquired cohorts via different channels (paid ads vs organic), track retention by channel. Organic customers might retain better (they were searching for your solution). Paid ad customers might churn more (they clicked an ad but weren't really looking for you). This drives CAC and pricing decisions.

Communicating Cohort Analysis to Investors

A cohort retention chart is one of the most powerful charts you can show investors. It tells the story of your product-market fit. If your chart shows improving retention over time (January cohort 60% annual retention, June cohort 70%, December cohort 80%), investors see a company where the product is getting better and customers are stickier. If retention is flat or declining, it signals problems.

Include a cohort table in your monthly investor updates. Show the most recent 12 months of cohorts and their retention to date. The shape of the curve—how steep is the drop in Month 1-2, how much does it stabilize—tells investors about your product quality and customer fit. A company with steep initial churn but stable later retention (normal) is different from a company with gradually declining retention (product issues).