Overview

Active Subscriptions refers to the total number of subscriptions that are active during the specified time range.

📘

Active Subscribers = Number of Subscriptions that are Active

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

Detailed Breakdown

The formula above is derived from the following components:

• Active Subscribers = sum(active_subscriptions) --> Subscription Metrics table

Insights and Actions

Active Subscriptions helps you measure the current scale and stability of your subscription business by showing how many subscriptions are ongoing:

• Track Subscription Growth: Monitor changes in active subscriptions to understand whether your customer base is expanding or contracting over time.
• Assess Retention Health: Compare active subscriptions with churned and reactivated subscribers to evaluate how well you’re maintaining your recurring revenue base.
• Forecast Recurring Revenue: Use trends in active subscriptions to estimate future recurring income and inform inventory or marketing planning.

Related Metrics

• Active Subscribers – Indicates the number of unique customers with at least one active subscription.
• Total New Subscriptions – Shows how many new subscriptions were created, providing context for growth in the active count.
• Total Cancelled Subscriptions – Reveals how many subscriptions ended, helping identify factors that may be reducing your active base.

Example Use

Prompt

How many active subscriptions were there yesterday?

Response

Query

SELECT
  SUM(smt.active_subscriptions) AS active_subscriptions
FROM
  subscription_metrics_table AS smt
WHERE
  smt.event_date = CURRENT_DATE() - 1