Back to prompts
Data AnalysisChatGPTClaude

Customer Churn Analysis Prompt

Analyze customer churn patterns to identify at-risk segments, root causes, and retention interventions.

Prompt Template

You are a customer analytics expert. Help me analyze churn for the following business:

Business type: [SaaS / e-commerce / subscription]
Churn definition: [e.g., cancelled subscription, no purchase in 90 days]
Available data: [describe what data you have — usage, payment, support tickets, demographics]
Current churn rate: [%]
Time period: [date range to analyze]
Key hypothesis: [why you think customers are churning]

[PASTE DATA SAMPLE OR DESCRIBE COHORTS]

Analyze:
1. Churn rate by segment (plan, cohort, geography, etc.)
2. Leading behavioral indicators of churn
3. Time-to-churn distribution — when do most customers leave?
4. Revenue impact of current churn
5. Top 3 root cause hypotheses
6. Retention playbook — specific interventions ranked by expected impact

Example Output

Churn Analysis: Flowdesk SaaS — Q1 2026

Churn by Segment

| Segment | Churn Rate | Note |

|---------|-----------|------|

| Free → Paid (< 30 days) | 31% | Highest risk: haven't found value yet |

| Starter plan | 14% | 2× higher than Pro — price sensitivity |

| Pro plan | 6.8% | Healthy range for B2B SaaS |

| Customers with 2+ integrations | 2.1% | Deeply embedded, rarely leave |

Behavioral Leading Indicators (appear 7-14 days before cancel)

- Login frequency drops below 1×/week (87% churn correlation)

- Last feature used: billing page (62% churn within 30 days)

- Support ticket tagged 'confusion' in last 30 days (+3× churn risk)

Time-to-Churn

40% of churned customers cancel within the first 30 days — classic onboarding failure pattern.

Retention Playbook

1. **[Highest impact] Day-7 health check email** for users who haven't completed setup

2. **In-app nudge** when login drops to < 1×/week

3. **Proactive success call** for new Starter plan customers at day 14

4. **Exit survey** on all cancellations — currently dark on cancellation reasons

Tips for Best Results

  • 💡The most dangerous churn signal is silence — customers who stop engaging before they cancel are the easiest to save
  • 💡Distinguish voluntary churn (cancellation) from involuntary (failed payment) — they need different interventions
  • 💡Focus retention efforts on the first 30 days — 40% of churn typically happens in this window

Try it with