Cohort analysis

Cohort analysis is a method that allows you to track the behavior of subsets of customers that share common characteristics – referred to as cohorts – over time. In the digital world, marketers and founders use it to monitor user retention over time or compute the lifetime value (LTV) of a product.

This template employs cohorts to help you compute your customers' retention and churn rate, starting from a simple list of sales.

• List your users' purchases in the 'Sales data' table
• The spreadsheet will automatically build cohorts and track how they evolve.