Overview

New Subscriptions refers to the total number of new subscriptions started in the reporting period.

📘

New Subscriptions = Number of New Subscriptions Started

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

Detailed Breakdown

The formula above is derived from the following components:

• New Subscriptions = sum(total_new_subscriptions) --> Subscription Metrics table

Insights and Actions

New Subscriptions help you understand how effectively your brand is driving new recurring revenue through subscription growth:

• Measure Acquisition Momentum: Track New Subscriptions over time to see how campaigns, promotions, or seasonal changes impact subscription growth.
• Differentiate Growth Sources: Compare New Subscriptions with Reactivated Subscribers to understand whether growth comes from new customers or returning ones.
• Monitor Subscription Health: Use New Subscriptions alongside Total Cancelled Subscriptions to assess net subscription gains or losses.

Related Metrics

• Total New Subscribers – Shows how many new customers signed up for subscriptions, providing context for user-level acquisition.
• Reactivated Subscribers – Indicates how many previously canceled customers rejoined, complementing new subscription growth.
• Total Cancelled Subscriptions – Reveals how many subscriptions ended during the same period, helping you gauge net growth.

Example Use

Prompt

How many new subscriptions were there yesterday?

Response

Query

SELECT
  SUM(smt.total_new_subscriptions) AS new_subscriptions
FROM
  subscription_metrics_table AS smt
WHERE
  smt.event_date = CURRENT_DATE()  - 1;