Subscription Metrics Table

subscription_metrics_table

The Subscription Metrics table offers a comprehensive view of subscriber activities and subscription changes over time. Querying this table reveals patterns in new sign-ups, churn rates, and subscription modifications, essential for understanding the health and growth of subscription-based aspects of your business.

📘
Note
event_date is a required field for queries on this table.

Dimensions

Dimensions are immutable properties that can be used for grouping data.

Title	ID	Type	Description
Event Date	`event_date`	date	The date the subscription event occurred. Based on the shop time zone at the moment of the event (or the user time zone, if no sales platform is connected).
Event Day	`event_date.day`	date	The day on which the event occurred. Derived from `event_date`.
Event Week	`event_date.week`	date	The Sunday of the week during which the event occurred. Derived from `event_date`.
Event Month	`event_date.month`	date	The month during which the event occurred. Derived from `event_date`.
Event Quarter	`event_date.quarter`	date	The first month of the quarter during which the event occurred. Derived from `event_date`.
Event Year	`event_date.year`	date	The year during which the event occurred. Derived from `event_date`.
Subscription Platform	`platform`	string	The subscription platform through which the subscription is managed. Example values: `recharge`, `stripe`

Measures

Measures are numeric fields that can be aggregated and/or combined to calculate new metrics.

Title	ID	Type	Description
Active Subscribers	`active_subscribers`	numeric	The number of subscribers with an active subscription.
Active Subscriptions	`active_subscriptions`	numeric	The total number of active subscriptions, including multiple subscriptions per user if applicable.
New Never-Seen Subscribers	`new_never_seen_subscribers`	numeric	The number of subscribers who are entirely new (never seen before) to the platform.
Reactivated Subscribers	`reactivated_subscribers`	numeric	The number of subscribers who had previously cancelled but have started a new subscription again.
Total Cancelled Subscriptions	`total_cancelled_subscriptions`	numeric	The total number of subscriptions that were cancelled in the reporting period.
Total Churned Subscribers	`total_churned_subscribers`	numeric	The total number of subscribers who have cancelled their subscriptions in the reporting period.
Total New Subscribers	`total_new_subscribers`	numeric	The total number of new subscribers acquired in the reporting period.
Total New Subscriptions	`total_new_subscriptions`	numeric	The total number of new subscriptions started in the reporting period.

Updated 18 days ago