.png){kind=logo}
Cohort Analysis Framework
Build a cohort analysis framework to track user retention, revenue, or behaviour over time, with clear methodology, visualisation guidance, and insight narrative.
Data AnalystCo-PilotClaudeChatGPTGeminiHighUpdated Mar-26
572·
Prompt
I need to build a cohort analysis to understand trends over time.
Product or service:
Cohort definition:
Key metric to track:
Time window:
Data available:
Tooling:
Please produce:
1. A methodology document — how to define, calculate, and segment cohorts correctly
2. The SQL or pseudocode to build the cohort matrix from raw event or transaction data
3. A description of how to visualise the output — chart type, axes, colour encoding, and what patterns to look for
4. An interpretation guide — what good, bad, and improving retention looks like in the data
5. The 5 most common cohort analysis mistakes and how to avoid them
6. A narrative template I can use to present findings to a non-technical stakeholder
Ask me any questions that would help you tailor the methodology to our specific data and context.
Sign in to save the prompt