Excel template for cohort analyses in SaaS The idea is that y | 🦄 Startup News
Excel template for cohort analyses in SaaS
The idea is that you have to enter only a small amount of data and everything else is calculated automatically. Specifically, what you’ll have to type in (or import from a data source) is the basic cohort data: How many customers did you acquire in each month and how many of them were retained in each subsequent month. If you also want to see your churn on an MRR basis and get a sense for your CLTV, you’ll also have to enter the corresponding revenue numbers.
If you’re not sure how to read a cohort analysis, here’s a quick explanation — http://christophjanz.blogspot.com/2013/10/excel-template-for-cohort-analyses-in.html
