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_dateis 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 |
| date | The date the subscription event occurred. Based on the time zone of the shop at the time of the subscription event. |
Event Day |
| date | The day on which the event occurred. Derived from |
Event Week |
| date | The Sunday of the week during which the event occurred. Derived from |
Event Month |
| date | The month during which the event occurred. Derived from |
Event Quarter |
| date | The first month of the quarter during which the event occurred. Derived from |
Event Year |
| date | The year during which the event occurred. Derived from |
Subscription Platform |
| string | The subscription platform through which the subscription is managed. Example values: |
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 2 months ago