AiPromptss
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.