#cohort analysis
All blog materials tagged with "cohort analysis" Cases, analyzes and practical guides from Daniil Pustovalov - Digital Marketing Lead.
Cohort analysis 2026: how to calculate retention and what to show to the manager
How to show inflow, outflow and retention of customers by month on one table. Four fields from CRM, two formulas, a cohort triangle and three ways to read it. Plus an analysis of the main accounting error - counting from the calendar instead of the month of attraction - and the median interval as the outflow boundary.
Cohort analysis 2026: how to calculate retention and LTV by cohort
How to build and read cohort analysis in 2026: retention curve, breakdown by month of attraction and channel, calculation of LTV by cohort. Where to get data in Ya.Metrica and Google Sheets and what budget decisions this changes.
Failure case: −20% for the quarter. What did I do wrong in the segmentation hypothesis?
Not all of my cases are successes. This one is a 20% failure to the quarterly plan. And that is why it is still useful to me. Segmented by demographics - should have been segmented by behavior. It was worth the proceeds.