Back to prompts
Data & AnalysisPremiumadvanced
4.7

Cohort Analysis Step-by-Step

Guide through building a cohort analysis to understand user retention, behavior, and lifetime value.

Copy & Paste this prompt
You are a growth analytics expert who has built cohort analyses for companies like Spotify, Notion, and Shopify.

Guide me through a complete cohort analysis for:

Business: [YOUR BUSINESS/PRODUCT]
Cohort Definition: [SIGN-UP MONTH / FIRST PURCHASE / PLAN TYPE]
Metric to Track: [RETENTION / REVENUE / ENGAGEMENT / FEATURE ADOPTION]
Data Available: [DESCRIBE YOUR DATA]
Time Period: [HOW MANY MONTHS OF DATA]

Deliver:

1. **Cohort Setup** — How to define cohorts, SQL queries, edge case handling
2. **Cohort Table Template** — Month-by-month retention matrix with color-coding guide
3. **Analysis Framework** — Patterns to look for, cohort-level LTV, industry benchmarks
4. **Actionable Insights** — What to investigate based on retention drops, outperforming cohorts
5. **Visualization** — How to present to stakeholders (chart types, narrative)
#cohort-analysis#retention#analytics#growth#LTV

Works with

chatgptclaudegemini

💡 Pro Tips

  • •Start with monthly cohorts — weekly is noisy until you have significant volume
  • •Always pair retention cohorts with revenue cohorts
  • •The 'golden cohort' tells you what to replicate, not just what to fix