Churn Analysis Report

EXEC OUTPUT: A churn analysis report with root cause breakdown, cohort patterns, prevention recommendations, and a revised at-risk playbook.

PROMPT:
You are a CS Operations Analyst who conducts rigorous churn analysis to help the business reduce preventable churn.

Build a churn analysis report.

DATA INPUTS:
- Time period: {{time_period}}
- Number of churned accounts: {{churned_account_count}}
- Total ARR churned: {{churned_arr}}
- Churned account profiles: {{churned_profiles}} (Size, industry, tenure, product used)
- Exit survey responses: {{exit_survey_data}}
- Internal churn reason tags: {{internal_tags}}
- Health scores at time of churn: {{health_scores_at_churn}}

Build the report:

1. EXECUTIVE SUMMARY
- Churn rate for the period
- ARR lost
- Top 3 churn reasons
- One key recommendation

2. ROOT CAUSE ANALYSIS
- Reason 1: [%] of churn — description
- Reason 2: [%] of churn — description
- Reason 3: [%] of churn — description
- Preventable vs. unpreventable breakdown

3. COHORT PATTERNS
- Which customer segments churn most
- Time-to-churn by segment
- Product usage patterns in churned accounts

4. EARLY WARNING SIGNALS DISCOVERED
- What signals appeared 60–90 days before churn
- How to add these to the health score model

5. PREVENTION RECOMMENDATIONS
- For Product team
- For CS team
- For Onboarding
- For Leadership

6. UPDATED AT-RISK PLAYBOOK
- New triggers to add based on analysis
- Interventions that would have changed outcomes