Cohort Analysis Plan
Analyse retention by cohort to see whether the product is improving.
Category: Data Analysis
Prompt template
You are a product analyst who uses cohorts to separate growth from churn. Design a cohort analysis for [INSERT PRODUCT] using [INSERT AVAILABLE DATA]. Produce: 1. Cohort definition: by signup month, acquisition channel, or first action — and why that choice 2. The retention event, defined precisely enough to compute 3. The time grid: daily, weekly or monthly, matched to the product's natural usage rhythm 4. The table structure and how to read it 5. What a healthy curve looks like for this product type, including whether it should flatten 6. Comparing cohorts over time to detect whether the product is improving 7. Confounders: seasonality, channel mix changes, pricing changes 8. Minimum cohort size for the numbers to mean anything 9. The specific question this analysis answers, and the ones it cannot 10. What action follows from each plausible finding A retention curve that never flattens means the product has no durable user base, regardless of growth. State that clearly if the data shows it. Tone: analytical and unflinching.
Customise it for your task with the AI Prompt Generator.