The Subscriptions table holds details about customer subscriptions, such as subscription IDs, intervals, status, creation times, and related orders. Querying this table can unearth trends in subscription behaviors, help track customer commitment over time, and aid in understanding the stability of recurring revenue.
Dimensions
Dimensions are immutable properties that can be used for grouping data.
Name | Type | Description | Source |
---|---|---|---|
subscription_id | string | The unique ID for the subscription. Example value: 352106812 | Recharge |
customer_id | string | The unique ID for the customer associated with the subscription. Example value: 6784521634029 | Shopify, Amazon |
subscription_interval | string | The frequency at which the subscription renews. Example values: month , day , week | Recharge |
subscription_status | string | The current status of the subscription. Example values: active , cancelled , expired | Recharge |
created_at | timestamp | The time when the subscription was created. Formatted according to the ISO 8601 international standard. Example value: 2022-06-15T19:26:30.000Z | Recharge |
ended_at | timestamp | The time when the subscription was canceled or expired. Formatted according to the ISO 8601 international standard . Example value: 2023-07-11T19:21:30.000Z | Recharge |
first_order_id | string | The unique ID for the first order placed within this subscription. Example value: 5246165483756 | Recharge |
first_order_date | date | The date when the first order within this subscription was placed. Example value: 2023-04-09 | Recharge |
product_id | string | The unique ID for each product within the subscription. Example value: 7809254686953 | Shopify, Amazon |
variant_id | string | The unique ID for each variant within the subscription. Example value: 43151194915045 | Shopify, Amazon |
cancellation_reason | string | The reason for cancellation of the subscription, provided by the customer. | Recharge |
cancellation_comments | string | Additional comments given by the customer at the time of cancellation. | Recharge |
orders | record repeated | A collection of orders placed under this subscription. | Shopify, Amazon |
orders.order_id | string | The unique order ID for each order within the subscription. Example value: 5779061670114 | Shopify, Amazon |
orders.event_date | date | The date when each order within the subscription was placed. Example value: 2024-03-20 | Shopify, Amazon |
Measures
Measures are numeric fields that can be aggregated and/or combined to calculate new metrics.
Name | Type | Description | Source |
---|---|---|---|
subscription_interval_count | numeric | The total number of subscription intervals that have occurred while the subscription was active. | Recharge |
price | numeric | The price of the subscription. | Recharge |
quantity | numeric | The number of products included in the subscription. | Recharge |