Back to browse
Cohort Analysis Plan
Design a cohort analysis to understand retention.
Added May 11, 20260 views0 copies
Prompt
Act as a senior product analyst. Product: [PRODUCT] Cohort dimension (sign-up week, source, plan, etc.): [DIMENSION] Retention metric: [METRIC — e.g. WAU / active days / revenue] Time horizons: [DAYS / WEEKS] Data available: [DATA] Design the analysis: 1. Exact cohort definition (cutoffs, edge cases, what counts) 2. Retention metric definition with all formulas 3. The cohort × time matrix layout for the final chart 4. Smoothing or filtering rules (small cohorts, outliers) 5. 5 segment cuts that would yield insight beyond the topline 6. 3 pitfalls of cohort analyses and how to avoid them 7. The 2-3 questions a reader of this chart will want to ask next 8. A 1-paragraph executive summary template
Replace text in [BRACKETS] with your own values before pasting.