New vs Cancelled Subscriptions
This dashboard compares new subscription acquisitions against cancellations to reveal your net subscriber growth, cancellation patterns, and potential warning signs.
URL: /analytics/new-vs-cancelled-subscriptions
Access: Owner, Administrator, Pricing Strategist, Finance Manager
Overall Metrics
| KPI | Description | Formula |
|---|---|---|
| Total New Subscriptions | Count of new subscriptions created in the period | Sum of new subscriptions |
| Total Cancelled Subscriptions | Count of subscriptions cancelled in the period | Sum of cancellations |
| Net Change | Difference between new and cancelled | New − Cancelled |
| Net Change % (YoY) | Year-over-year net growth rate | ((Current Year Net − Previous Year Net) / Previous Year Net) × 100 |
| Avg New / Month | Average monthly new subscriptions | Total New / Number of Months |
| Avg Cancelled / Month | Average monthly cancellations | Total Cancelled / Number of Months |
| Growth Rate | Net growth as a percentage of total base | Net Change / Total Active Subscriptions × 100 |
| Churn Impact | Revenue impact of cancellations | Sum of MRR from cancelled subscriptions |
Charts
Monthly New vs Cancelled (Mixed Column + Line Chart)
| Property | Detail |
|---|---|
| Chart Type | Mixed — columns for new/cancelled, line for net change |
| X-Axis | Month |
| Y-Axis (left) | Subscription count (columns) |
| Y-Axis (right) | Net change (line) |
| Series | New Subscriptions (green column), Cancelled (red column), Net Change (blue line) |
| Purpose | Visualize whether you’re growing or shrinking each month. The line crossing below zero signals net subscriber loss. |
| Who uses it | Executives monitoring business trajectory; marketing teams correlating campaigns with acquisition spikes |
Plan Breakdown (Bar Chart)
| Property | Detail |
|---|---|
| Chart Type | Grouped bar chart |
| X-Axis | Rate plan name |
| Series | New (green), Cancelled (red), Net Change (blue) |
| Purpose | Identify which plans are gaining or losing subscribers. A plan with high cancellations relative to new sign-ups may need attention. |
| Who uses it | Product managers evaluating plan health; pricing strategists considering plan restructuring |
Cancellation Reasons (Donut Chart)
| Property | Detail |
|---|---|
| Chart Type | Donut chart with center label showing total cancellations |
| Data | Cancellation reason and count with percentage |
| Typical Reasons | Too expensive, Switched to competitor, No longer needed, Missing features, Poor support |
| Purpose | Understand why customers leave. Actionable insights: if “Too expensive” dominates, consider a lower-tier plan; if “Missing features” leads, feed into product roadmap. |
| Who uses it | Product teams prioritizing feature development; CS teams designing save offers |
Critical Period Alert
The dashboard automatically detects critical periods where cancellations exceed new subscriptions for consecutive months. When detected:
- An alert banner appears with the affected months
- The message highlights the severity and suggests investigation
- Helps teams react before a temporary dip becomes a sustained trend