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.
| Field name | Type | Description | Source |
|---|---|---|---|
event_date | date | The 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. | Recharge |
event_date.day | date | event_date to the nearest day. | Recharge |
event_date.week | date | event_date to the nearest week. | Recharge |
event_date.month | date | event_date to the nearest month. | Recharge |
event_date.quarter | date | event_date to the nearest quarter. | Recharge |
event_date.year | date | event_date to the nearest year. | Recharge |
platform | string | The subscription platform through which the subscription is managed (e.g. Recharge). | Recharge |
Measures
Measures are numeric fields that can be aggregated and/or combined to calculate new metrics.
| Field name | Type | Description | Source |
|---|---|---|---|
total_new_subscribers | numeric | The total number of new subscribers acquired in the reporting period. | Recharge |
new_never_seen_subscribers | numeric | The number of subscribers who are entirely new to the platform. | Recharge |
reactivated_subscribers | numeric | The number of subscribers who had previously cancelled but have started a new subscription again. | Recharge |
total_churned_subscribers | numeric | The total number of subscribers who have cancelled their subscriptions in the reporting period. | Recharge |
total_new_subscriptions | numeric | The total number of new subscriptions started in the reporting period. | Recharge |
total_cancelled_subscriptions | numeric | The total number of subscriptions that were cancelled in the reporting period. | Recharge |