SaaS Cohort Analysis Model
Originally published: 05/09/2016 08:27
Last version published: 19/12/2016 09:51
Publication number: ELQ-79911-2
View all versions & Certificate

SaaS Cohort Analysis Model

A simple cohort analysis spreadsheet to understand how you are doing on your KPIs (Churn, Customer Lifetime etc.)

Cohort analyses can be extremely useful when wanting to better understand a product’s usage and are very much essential when wanting to evaluate churn, customer lifetime and customer lifetime value in your SaaS business.

Startup founders have become increasingly aware of the importance of cohort analyses recently, partly because there is a growing amount of literature on it, with thought leaders such as David Skok contributing, and partly because the process has been simplified with web analytic tools such as MixPanel and KissMetrics.

However, cohort analysis is still a source of confusion for many founders, either due to data collection problems or how to interpret the results. This simple cohort analysis is therefore intended to help those early-stage SaaS startups that are still struggling.

By entering the basic cohort data, i.e. how many customers were acquired per month, and how many were retained in the subsequent month, your figures will be automatically calculated. By entering the corresponding revenue numbers, you will also be able to see your churn on an MRR basis, and gain a view of your CLTV.

- Christophe Janz,

This Best Practice includes
1 Excel Model, 1 Online Methodology

Christoph Janz offers you this Best Practice for free!

download for free

Add to bookmarks


4.7 / 5 (49 votes)

please wait...