Subscription Cancellation Reason Analysis Builder
Analyze subscription cancellation reasons by customer segment, plan, cohort, usage, timing, and revenue impact to prioritize retention fixes.
Prompt Template
You are a subscription analytics lead. Build a cancellation reason analysis plan for the subscription business below. Business type: [SaaS, membership, subscription box, streaming, education, fitness, marketplace, consumer app] Cancellation data fields: [customer ID, cancel date, plan, price, tenure, reason, free-text feedback, save offer, refund, reactivation] Customer segments: [new users, long-term customers, plan tier, acquisition channel, geography, company size, household type] Usage data: [login frequency, feature use, orders, content watched, support tickets, failed payments, onboarding completion] Reason collection method: [survey, support tag, cancellation flow, chat transcript, account manager notes, none] Time period: [date range] Revenue fields: [MRR, ARR, LTV, discount, refund amount, remaining contract value] Known data quality issues: [missing reason, multiple reasons, vague options, agent inconsistency, biased survey choices] Business questions: [why customers leave, which reasons cost most, which fixes to prioritize, which save offers work] Retention actions available: [pricing change, onboarding, pause plan, downgrade, product fix, customer success outreach, help content] Reporting audience: [executives, product, lifecycle marketing, support, customer success, finance] Privacy constraints: [PII minimization, sensitive health/financial data, customer quote approval] Produce: 1. Data cleaning plan for structured reasons and free-text feedback. 2. Cancellation reason taxonomy with parent categories and examples. 3. KPI definitions for logo churn, revenue churn, reason share, preventable churn, and save-rate. 4. Segment analysis by plan, tenure, acquisition channel, usage level, and support history. 5. Revenue impact table that separates high-volume reasons from high-dollar reasons. 6. Text analysis approach for open-ended cancellation comments. 7. Root-cause hypotheses that connect reasons to product, pricing, onboarding, support, or expectation gaps. 8. Dashboard layout for trend monitoring and executive review. 9. Prioritized retention experiments with expected impact, owner, effort, and measurement window. 10. Recommendations for improving the cancellation survey without increasing friction unfairly. Make the analysis decision-oriented, not just a pie chart of reasons.
Example Output
Reason Taxonomy
| Parent Reason | Examples | Action Owner |
|---|---|---|
| Price or budget | Too expensive, budget cut, discount ended | Pricing and lifecycle |
| Missing value | Did not use enough, feature gap, unclear ROI | Product and onboarding |
| Temporary need ended | Project complete, seasonal pause | Lifecycle marketing |
Initial Insight
Customers canceling in the first 45 days cite missing value 38% of the time, but long-tenure customers cite price 44% of the time. The first group needs onboarding fixes; the second group needs plan-fit and downgrade options.
Tips for Best Results
- 💡Do not trust raw cancellation reasons until you inspect missing values and vague options.
- 💡Segment by tenure; early cancellation and long-term cancellation often mean different things.
- 💡Compare reason count with revenue impact so a noisy low-value segment does not dominate priorities.
- 💡Use free-text quotes carefully and remove unnecessary personal details before sharing.
Related Prompts
Cohort Retention Analysis Explainer
Interpret your cohort retention data to understand user behavior, identify drop-off patterns, and improve retention strategies.
Revenue Forecasting Model Builder
Build a structured revenue forecast with multiple scenarios, key assumptions, and sensitivity analysis to predict and plan for future growth.
Feature Cannibalization Impact Analysis
Analyze whether a new product feature is stealing usage, revenue, or engagement from existing features and recommend product or packaging actions.