Email Marketing Cohort Analysis Framework

Create an email marketing cohort analysis framework for [COMPANY NAME] with [NUMBER] subscribers.

**1) Cohort Definitions:**

**By Signup Date:**
- Monthly cohorts (subscribers who joined in January, February, etc.)
- Track engagement over 12 months

**By Acquisition Source:**
- Organic, paid ads, referral, content download, event
- Compare engagement and revenue by source

**By First Purchase:**
- First-time buyers by month
- Track repeat purchase rate over time

**2) Metrics to Track by Cohort:**
- Email open rate over time (Month 1, Month 2, etc.)
- Click rate over time
- Purchase rate over time
- Revenue per subscriber over time
- Unsubscribe rate over time

**3) Cohort Analysis Table:**
| Cohort | Month 1 | Month 2 | Month 3 | Month 6 | Month 12 |
|--------|---------|---------|---------|---------|----------|
| Jan 2024 | [X]% | [X]% | [X]% | [X]% | [X]% |
| Feb 2024 | [X]% | [X]% | [X]% | [X]% | [X]% |

**4) Insights to Extract:**
- Which cohorts have the highest lifetime value?
- Which acquisition sources produce the most engaged subscribers?
- Is engagement declining over time for all cohorts?
- Are newer cohorts more or less engaged than older ones?

**5) Actionable Recommendations:**
- Improve onboarding for low-performing cohorts
- Replicate successful acquisition channels
- Re-engagement strategy for aging cohorts
- Content optimization based on cohort preferences

**6) Visualization:**
- Heat map of engagement by cohort and month
- Line chart of retention curves
- Revenue by cohort over time

Include a cohort analysis spreadsheet template and a visualization guide.