Templates · 2026-07-12 · 7 min read
Written and reviewed by Project Financial Advisor · FCA · CGMA · ACMA — Chartered Accountant
Cohort and Retention Analysis for SaaS and Subscriptions
How to read a cohort retention table, the difference between logo and net revenue retention, and why NRR above 100% drives subscription valuations.
Cohort and retention analysis groups customers by when they joined and tracks how many stay over time. For any subscription or repeat-purchase business, it is the most honest measure of product-market fit: headline growth can hide a leaky bucket, but a cohort table cannot. Here is how to read it, the metrics that matter, and why net revenue retention is the number investors care about most.
Reading a cohort table
A cohort table puts acquisition months down the side and elapsed months across the top; each cell shows the share of that cohort still active. Reading across a row shows how a single cohort decays; reading down a column compares cohorts at the same age, which reveals whether retention is improving as the product matures.
| Cohort | Month 0 | Month 1 | Month 3 | Month 6 | Month 12 |
|---|---|---|---|---|---|
| January | 100% | 92% | 85% | 79% | 72% |
| February | 100% | 90% | 83% | 77% | - |
| March | 100% | 93% | 87% | 82% | - |
Logo retention vs revenue retention
Logo (or customer) retention counts how many customers stay. Revenue retention counts how much revenue stays — and it can exceed 100% when existing customers expand (upgrades, seat growth) faster than others churn. Net revenue retention (NRR) above 100% means the business grows from its existing base alone, before adding a single new customer. It is the single strongest signal of a durable subscription business.
Why retention drives valuation
Retention compounds. A business retaining 90% of revenue a year keeps a customer roughly ten years on average; one retaining 70% keeps them barely three. That difference flows directly into lifetime value, CAC payback and the multiple the business commands. Improving retention is almost always cheaper than acquiring new customers, and it is where the best subscription businesses focus.
Common mistakes
Averaging all customers together (which hides that newer cohorts may retain worse), measuring retention only by logo when revenue is what pays the bills, and ignoring the time lag — a cohort's true retention only emerges over many months. Always segment, always track revenue, and give cohorts time to mature.
Model retention-driven revenue
EasyFinancialModels lets you drive recurring revenue with growth-and-churn assumptions and see the effect on cash flow and valuation. Build a financial model free for up to 3 years and test how a few points of retention change your runway and your worth.
→ Build your financial modeling model free with the Financial Model tool
More Financial Modeling guides
How to Build a Financial Model in Excel · Quarterly Financial Model: When to Use Quarterly Forecasts Instead of Annual Models · Industry Financial Model Templates: How to Choose the Right Revenue Drivers · How to Build a Startup Financial Model for Investors · The Three-Statement Financial Model Explained
About the author
Every model is built and reviewed by the project's Financial Advisor — a Fellow Chartered Accountant (FCA), Chartered Global Management Accountant (CGMA) and Associate Chartered Management Accountant (ACMA) with around two decades of corporate finance, audit and accounting experience, designing investor-grade financial models across industries. Full credentials and background are available on LinkedIn. More about the author →
← All guides · WACC calculator · DCF calculator · IRR calculator · Inside the 15-sheet model