Excel template for cohort analyses in SaaS
[Note: This post first appeared as a guest post on Andrew Chen's blog . Andrew is a writer and entrepreneur and has written a large number of must-read essays on topics such as viral marketing, growth hacking and monetization . He was kind enough to publish my post on his blog, and I am republishing it here.] If you’re a long-time reader of my blog (or if you know me personally) you’ll know that cohort analyses are one of my favorite tools for getting a deeper understanding of a product’s usage. Cohort analyses are also essential if you operate a SaaS business and want to know how you’re doing in terms of churn, customer lifetime and customer lifetime value. I’ve blogged about it before and have included “Ignore your cohorts” in my “9 Worst Practices in SaaS Metrics” slides. My feeling is that over the last 12 months the awareness for the importance of cohort analyses has grown among startup founders. One reason may be that thought leaders like David Skok have been writing about...