Subscription Monthly Metrics Table (BETA)
subscription_monthly_metrics_table
The Subscription Monthly Metrics table provides a snapshot of monthly recurring revenue (MRR) trends and changes in subscriber activity over time for subscriptions managed through billing platforms (e.g. Stripe). Querying this table enables you to track how subscriber MRR evolves from month to month, compare current performance against past periods, and analyze subscription lifecycles across different account segments.
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 |
Account ID |
| string | The ID of the account that the subscription belongs to. |
Created Date |
| date | The date the subscription was created. |
End Date |
| date | The date the subscription ended. |
MRR Bucket |
| string | Classifies the type of change in monthly recurring revenue (MRR) for a subscription during the month. Possible values: |
Measures
Measures are numeric fields that can be aggregated and/or combined to calculate new metrics.
| Title | ID | Type | Description |
|---|---|---|---|
| Monthly Recurring Revenue | mrr | numeric | The monthly recurring revenue for the subscription. |
| Previous Monthly Recurring Revenue | previous_mrr | numeric | The previous month's recurring revenue for the subscription. |
Updated about 13 hours ago