Overview

Cancelled Subscriptions refers to the total number of subscriptions cancelled in the reporting period.

📘

Cancelled Subscriptions = Number of Subscriptions Cancelled

The calculation is based on data from the Subscription Metrics table.

Detailed Breakdown

The formula above is derived from the following components:

• Cancelled Subscriptions = sum(total_cancelled_subscriptions) --> Subscription Metrics table

Insights and Actions

Cancelled Subscriptions provides visibility into customer churn, helping you understand why and when subscribers choose to leave:

• Track Cancellation Patterns: Monitor cancellations over time to identify external factors like seasonality, product cycles, or campaign fatigue that affect churn.
• Compare Growth vs. Loss: Review cancellations alongside new and reactivated subscriptions to determine whether your subscriber base is growing or shrinking.
• Pinpoint Problem Areas: Analyze cancellations by subscription platform or product line to uncover opportunities to improve retention and reduce churn.

Related Metrics

• Total Churned Subscribers – Measures how many subscribers ended their subscriptions, giving a broader churn context.
• Reactivated Subscribers – Shows how many canceled customers rejoined, helping assess win-back effectiveness.
• Total New Subscriptions – Indicates how many new subscriptions started, allowing you to compare new growth against cancellations.

Example Use

Prompt

How many subscriptions were cancelled yesterday?

Response

Query

SELECT
  SUM(smt.total_cancelled_subscriptions) AS total_cancelled_subscriptions
FROM
  subscription_metrics_table AS smt
where
  event_date = DATE_SUB(current_date(), INTERVAL 1 DAY)