Churn Analysis Template
Sales & Revenue Operations
Quick Answer
Enter your churn data including churned customers, ARR lost, and reasons for churn. Paste into Claude or ChatGPT. Get root cause analysis, at-risk segment identification, and prioritized retention actions.
What You Get
A churn analysis covering gross and net churn calculation, churn by segment and cohort, root cause identification from churn reasons, at-risk customer identification framework, and specific retention actions prioritized by revenue impact.
Who Is This For
Customer success leaders analyzing churn drivers, SaaS CFOs presenting churn analysis to investors and boards, and founders trying to understand why customers are leaving.
About This Template
Churn is the silent killer of SaaS growth. A 2 percent monthly churn rate means you lose 22 percent of your revenue annually and must replace it just to stay flat. Understanding why customers churn — and which customers are at risk — is the foundation of an effective retention strategy. This template guides customer success and finance teams through entering their churn data, then uses AI to identify patterns, root causes, and the highest-leverage retention actions.
Fill In Your Details
Your company name
e.g. Q2 2026 or trailing 12 months
e.g. 9400000
e.g. 720000 in churned ARR
e.g. 18 customers churned
e.g. Product fit issues 6 customers, budget cuts 4 customers, competitor 3 customers, no onboarding completion 3 customers, unknown 2 customers
e.g. SMB under $500 MRR: 12 customers, Mid-market $500-2000 MRR: 5 customers, Enterprise over $2000 MRR: 1 customer
e.g. 8 churned in months 1-3, 6 churned at annual renewal, 4 churned months 4-11
Gather these details then use them to fill in the prompt below.
AI Prompts
Generate churn analysis
Paste this prompt into Claude or ChatGPT with your churn data filled in.
You are a customer success analyst conducting a churn analysis. Using the data below, produce a comprehensive churn analysis with actionable retention recommendations. Company: [company_name] Period: [analysis_period] Opening ARR: [opening_arr] Churned ARR: [churned_arr] Churned customers: [churned_customers] Churn reasons: [churn_reasons] Churned segments: [churned_segments] Churn timing: [churn_timing] Produce: 1. Churn Metrics — gross ARR churn rate, gross logo churn rate, average ARR per churned customer 2. Churn by Segment Analysis — which segment has the highest churn rate and revenue impact 3. Root Cause Analysis — group churn reasons into addressable categories and rank by revenue impact 4. Churn Timing Patterns — identify when in the customer lifecycle churn is most likely 5. At-Risk Customer Profile — describe the characteristics of customers most likely to churn 6. Retention Actions — specific actions for each root cause ranked by potential ARR saved 7. Churn Reduction Target — if top 2 root causes are addressed what churn rate is achievable Calculate: gross ARR churn rate equals churned ARR divided by opening ARR.
Sample Output
This is an example of what AI produces when you use this template.
Root Cause Analysis
Churn reasons ranked by ARR impact: 1. No onboarding completion (3 customers, $180K ARR lost): customers who never fully implemented the product churned at month 3. This is entirely preventable — these customers paid for something they never used. Revenue at risk from current pipeline with similar onboarding patterns: estimated $240K. 2. Product fit issues (6 customers, $210K ARR lost): concentrated in the SMB segment under $500 MRR. These customers likely bought for use cases the product does not fully support. Root cause is sales qualification — reps are closing accounts that are not good fits. 3. Budget cuts (4 customers, $195K ARR lost): largely uncontrollable but timing suggests Q1 budget cycles. Mitigation: annual prepay incentives reduce exposure to budget cut churn by locking in revenue.
Retention Actions
Action 1 — Onboarding completion program (addresses $180K ARR churn, highest ROI): implement a mandatory 30-day onboarding success milestone. Assign a CSM to every new account for the first 60 days with a weekly check-in. Trigger an automated intervention if a customer has not completed 3 core actions within 14 days of signing. Expected impact: reduce early churn from 8 customers to 2-3, saving $120K-$150K in ARR annually. Action 2 — SMB qualification tightening (addresses $210K ARR churn): add 2 qualification questions to the sales process that screen for use cases showing high SMB churn correlation. Reps should not advance deals where these patterns are present. Expected impact: 30 percent reduction in SMB churn, saving $63K in ARR annually at the cost of 15 percent fewer SMB closes.