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!