Cohort analysis groups customers by a shared characteristic — typically their acquisition month — and tracks their behaviour over time. It reveals patterns in retention, spending, and engagement that are invisible in aggregate data, making it essential for understanding customer lifetime value and predicting churn.
In Depth
Cohort analysis is one of the most powerful analytical tools available to FP&A teams because it separates the effects of time from the effects of growth. Aggregate metrics can be misleading: overall retention might appear stable while individual cohorts are actually deteriorating, masked by a growing customer base.
The most common cohort is the acquisition cohort: customers grouped by the month they signed up. Tracking each cohort's retention rate over subsequent months produces a retention curve. Healthy businesses show retention curves that flatten — meaning churn decreases over time as remaining customers are increasingly engaged.
Revenue cohort analysis tracks MRR from each cohort over time. A cohort that starts at £10K MRR and grows to £15K over twelve months demonstrates positive net revenue retention. Comparing revenue cohorts across time periods reveals whether the business is improving — are recent cohorts performing better or worse than earlier ones?
FP&A teams use cohort analysis for several planning purposes. LTV estimation becomes more accurate when based on actual cohort retention curves rather than average churn rates. Forecasting benefits from understanding how cohort behaviour changes with tenure. Product investment decisions are informed by which features correlate with better cohort performance.
For UK SaaS companies, cohort analysis can also reveal seasonal effects — Q1 cohorts may behave differently from Q4 cohorts due to budget cycles — and the impact of pricing changes on subsequent cohort quality.
Real-World Example
A UK SaaS company analyses revenue cohorts and discovers that customers acquired in 2024 retain 92% of revenue after 12 months, compared to 85% for the 2023 cohort. Digging deeper, the FP&A team finds that the improvement correlates with a new onboarding programme launched in January 2024. The 7-percentage-point improvement in year-one retention increases estimated LTV by 35%, justifying further investment in customer onboarding.
Related Terms
Customer acquisition cost (CAC) is the total cost of acquiring a new customer, including all sales a...
Customer lifetime value (LTV or CLV) is the total revenue a company expects to earn from a customer ...
Churn rate measures the percentage of customers or revenue lost over a given period. Customer churn ...
Net revenue retention (NRR) measures the percentage of recurring revenue retained from existing cust...
Stop wrestling with spreadsheets. Grove FP gives your finance team a purpose-built platform for budgeting, forecasting, and financial modelling — designed for UK businesses.
FAQ