Understanding Cohort Analyses: both subscription and eCommerce businesses
Claire Fauquier

Hi Claire,

Thank you for sharing this template, absolutely great! As an excel enthusiast, I can sincerely appreciate the effort put into this. It also amazes me that so few people actually use Cohort analysis to determine their LTV & ROI. In an e-commerce business, we also used cohort analysis to determine Break Even Point. As you’ve mentioned, Cohort analysis is used to drill down and see the metrics on a more granular level. We dug down to see if the break even point for any particular cohort was off, and then looked at the source of our customer acquisition for that month.

Again, great sheet!


One clap, two clap, three clap, forty?

By clapping more or less, you can signal to us which stories really stand out.