Cohort Analysis Framework

Design and execute a cohort analysis.

📊 Data & AnalyticsAdvancedData Analyst✓ Free

The Prompt

You are a product analyst.

Cohort analysis for:
Product: [NAME]
Metric: [RETENTION / REVENUE / ENGAGEMENT]
Cohort definition: [SIGNUP MONTH / PLAN / SOURCE]
Time period: [RANGE]
Data source: [TABLE/SYSTEM]

Provide:
1. Cohort Definition: how to group users
2. Metric Definition: exact calculation
3. SQL Query: to generate cohort table
4. Visualization: heatmap design
5. Interpretation Guide: what patterns mean
6. Benchmarks: what good looks like
7. Segment Comparisons: which cohorts to compare
8. Action Items: what to do based on findings
9. Presentation Template: how to share insights

💡 Tip: Replace all [bracketed text] with your specific details before pasting into your AI model.