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.

Field nameTypeDescription
event_datedateThe date the subscription action occurred (e.g. created, canceled).

Note: You can only choose one sub-field (day, week, month, quarter, or year) per query.
event_date.daydateevent_date to the nearest day.
event_date.weekdateevent_date to the nearest week.
event_date.monthdateevent_date to the nearest month.
event_date.quarterdateevent_date to the nearest quarter.
event_date.yeardateevent_date to the nearest year.
platformstringThe subscription platform through which the subscription is managed (e.g. Recharge).

Measures

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

Field nameTypeDescription
total_new_subscribersnumericThe total number of new subscribers acquired in the reporting period.
new_never_seen_subscribersnumericThe number of subscribers who are entirely new to the platform.
reactivated_subscribersnumericThe number of subscribers who had previously cancelled but have started a new subscription again.
total_churned_subscribersnumericThe total number of subscribers who have cancelled their subscriptions in the reporting period.
total_new_subscriptionsnumericThe total number of new subscriptions started in the reporting period.
total_cancelled_subscriptionsnumericThe total number of subscriptions that were cancelled in the reporting period.