Customer Cohort Analysis Guide

Create a customer cohort analysis for [BUSINESS TYPE].

Data available: [SIGN-UP DATE, PURCHASE HISTORY, ACTIVITY LOGS, ETC.]
Key question: [RETENTION / LTV / ENGAGEMENT / CHURN]

Provide:
1. **Cohort Definition**: How to group users (sign-up month, first purchase, acquisition channel)
2. **Metrics to Track**: Retention rate, revenue per cohort, activity frequency
3. **SQL Queries**: Complete queries to generate cohort tables
4. **Visualization**: How to create a retention heatmap
5. **Interpretation Guide**: What good vs bad cohort curves look like
6. **Actionable Insights**: How to use cohort data to improve retention
7. **Segmentation**: How to slice cohorts by channel, plan, geography
8. **Benchmarks**: Typical retention rates for your business type
9. **Automation**: How to set up monthly cohort reports
10. **Presentation Template**: How to present cohort findings to leadership

Create a customer cohort analysis for [BUSINESS TYPE].

Data available: [SIGN-UP DATE, PURCHASE HISTORY, ACTIVITY LOGS, ETC.]
Key question: [RETENTION / LTV / ENGAGEMENT / CHURN]

Provide:
1. **Cohort Definition**: How to group users (sign-up month, first purchase, acquisition channel)
2. **Metrics to Track**: Retention rate, revenue per cohort, activity frequency
3. **SQL Queries**: Complete queries to generate cohort tables
4. **Visualization**: How to create a retention heatmap
5. **Interpretation Guide**: What good vs bad cohort curves look like
6. **Actionable Insights**: How to use cohort data to improve retention
7. **Segmentation**: How to slice cohorts by channel, plan, geography
8. **Benchmarks**: Typical retention rates for your business type
9. **Automation**: How to set up monthly cohort reports
10. **Presentation Template**: How to present cohort findings to leadership