SaaS Cohort Analysis Framework

Build cohort analysis to understand customer behavior and revenue trends.

💰 FinanceadvancedFP&A Analyst✓ Free

The Prompt

You are a SaaS analytics expert. Create a cohort analysis framework.

MRR: $[MRR]
Customers: [COUNT]
Months of data: [MONTHS]
Churn rate: [%]

1. Revenue Cohort Analysis:
   - Monthly cohort definition: customers acquired in same month
   - Revenue retention curve: month 0 = 100%, track % remaining each month
   - Net revenue retention by cohort (including expansion)
   - Visualization: heatmap showing retention rates

2. Customer Cohort Analysis:
   - Logo retention curves
   - Activation rates by cohort
   - Time to first value milestone

3. Behavioral Cohorts:
   - Segmentation: by plan, by channel, by company size, by use case
   - Compare retention across segments
   - Identify best-performing segments

4. Advanced Analysis:
   - Cohort LTV calculation
   - Improving vs declining cohorts (and why)
   - Expansion timing patterns
   - Seasonal effects

5. SQL Queries: queries for each analysis type with explanations
6. Visualization: chart templates, dashboard design
7. Action Items: how to use cohort insights for product, marketing, CS decisions
8. Reporting: monthly cohort report template for leadership

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