Churn Analysis Template for Product Analytics

What This Template Is For

Every SaaS business loses customers. The question is whether you understand why and whether you are doing anything systematic about it. Most teams track churn rate as a single number, but a single number tells you almost nothing. A 5% monthly churn rate where 80% of churners never activated is a fundamentally different problem than 5% churn where long-tenured power users are leaving for a competitor.

This template helps you move from tracking churn as a number to understanding churn as a system: categorize churn reasons into a taxonomy, design exit surveys that generate actionable data, analyze churn patterns by cohort and segment, build a save playbook for at-risk accounts, and design winback campaigns for customers who have already left. It is designed for B2B SaaS but the framework applies to any recurring-revenue product.

The churn rate glossary entry covers the different calculation methods (logo vs revenue, monthly vs annual). The Product Analytics Handbook covers cohort analysis methodology in depth. For modeling the financial impact of churn improvements, the LTV/CAC Calculator shows how even small churn reductions compound into significant lifetime value increases.

How to Use This Template

1. Build your churn reason taxonomy. Start with the categories below and customize them for your product.
2. Design or update your exit survey. Every churning customer should see a short survey. This is your primary qualitative data source.
3. Pull churn data by cohort and segment for the last 6-12 months. Look for patterns that the aggregate number hides.
4. Analyze your exit survey data. Map each response to your taxonomy. Calculate the percentage of churn attributable to each category.
5. Classify each churn reason as preventable, partially preventable, or unpreventable. Focus your effort on preventable churn.
6. Build a save playbook for each preventable churn reason.
7. Design winback campaigns for recently churned customers, segmented by reason.

The Template

Churn Baseline

Churn Reason Taxonomy

Exit Survey Design

When to show. During the cancellation flow, after the user clicks "Cancel Subscription" but before the cancellation is confirmed.

Survey structure.

Design rules.

• ☐ Survey is 5 questions or fewer (completion drops sharply after 5)
• ☐ First question maps directly to your churn taxonomy
• ☐ Survey appears in the cancellation flow, not in a separate email
• ☐ Open text field is optional, not required
• ☐ Survey data flows into CRM or analytics automatically (not a separate spreadsheet)
• ☐ Survey completion rate target: 60%+ of cancellations

Churn Cohort Analysis

By signup month (logo retention).

By segment (churn rate by group).

Save Playbook

For each preventable churn reason, define the intervention.

Winback Campaigns

Filled Example: B2B Design Tool Churn Analysis

Churn Baseline

Exit Survey Results (Last 90 Days, n=198)

Save Playbook Results (Q1 2026)

Key Takeaways

• Build a churn reason taxonomy and categorize every churn event. A single churn rate number tells you almost nothing
• Classify each reason as preventable, partially preventable, or unpreventable. Focus 80% of effort on preventable churn
• Exit surveys during the cancellation flow are your primary data source. Target 60%+ completion rate
• Segment churn by cohort, plan, activation status, and tenure. The patterns will be different for each group
• Build save playbooks for each preventable churn reason with specific triggers, interventions, owners, and success metrics

About This Template

Created by: Tim Adair

Last Updated: 3/4/2026

Version: 1.0.0

License: Free for personal and commercial use