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, www.christophjanz.blogspot.com
This business tool includes
1 Excel Model, 1 Online Methodology
Christoph Janz offers you this business tool for free!
download for free
Add to bookmarks
- Gaurav Sandhya(last updated: 28/05/2018 10:05)
- K Vijay Kumar(last updated: 25/05/2018 18:53)
- Mohammed Halaseh(last updated: 12/03/2018 12:52)
- Paul Lee(last updated: 17/01/2018 19:52)
- Alfonso Cioffi(last updated: 31/12/2017 14:14)
- Pablo Garrido(last updated: 16/11/2017 08:03)
- Mamadou Dr. Bass(last updated: 29/09/2017 09:43)
People using this tool also downloaded
Analyze SaaS Bookings + Automated KPI DashboardThis model allows you to gain a deep understanding of how your SaaS bookings have performed over time.customerssaasmetricsdashboardchurnmrrkpibookingsbillingskey metric reporting786 remove_red_eye$189.00by Adam Jernigan
SaaS Revenue Waterfall Excel Chart TemplateA SaaS Excel Model to help you forecast revenue waterfall in simple, automated charts.revenuewaterfallsaassoftware as a servicemrrarrrevenue forecast218 remove_red_eye
SaaS Metrics 2.0 DashboardA dashboard to help founders manage their SaaS businesskey performance indicatorsstartupsventure capitalsaasmetricsdashboardmrracvmonthly recurring revenueannual contract value3,908 remove_red_eye
SaaS Metrics DashboardA simple KPI sheet for early-stage SaaS startups with a low-touch sales model.startupsventure capitalsaaskpismetricsdashboardsoftware as a service4,525 remove_red_eye
Simple SaaS cash flow analysisIllustrates the SaaS P&L/Cash Flow trough highlighting the importance of growth management for better profits.analysiskey performance indicatorscash flowstartupssaaschurneconomicsacquisition costscustomer value604 remove_red_eye
SaaS Revenue Forecasting ModelFull-packed revenue forecasting model to help SaaS founders take better decisions with key indicators.key performance indicatorssalesrevenuesforecastingstartupssaasassumptionssoftware as a servicerecurring revenue1,032 remove_red_eyefreeby Noah Barr
Customer Acquisition Costs (CAC) ExplainedIn this short video, learn how to calculate and apply the Customer Acquisition Cost (CAC) formula.financestartupssaassoftware as a servicecaccustomer acquisition costs15 remove_red_eye
Enterprise SaaS and SME/Consumer Fundraising Excel ModelFor large, complex SaaS companies with enterprise, consumer and SME customers looking to fundraise.modelinvestorsstartupsventure capitalsaastemplateexcelenterprisefundraise289 remove_red_eye$299.00by Alexander Jarvis
SaaS Excel Financial Plan TemplateA SaaS financial plan that allows you to create your own financial forecast. Suitable for startups and SMB's.financial modelstartupssaasfinancial planexcelfinancial forecastsmbsoftware as a startup563 remove_red_eye
Sample Chart of Accounts in SaaSAn excel file showing a sample chart of accounts for a SaaS business.balance sheetincome statementssaassoftware as a serviceaccountssaas accountscoachart of accounts67 remove_red_eye
Any questions on SaaS Cohort Analysis Model?
The user community and author are here to help. Go ahead!