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
`subscription_id`	string	The unique ID for the subscription. Example value: `352106812`
`customer_id`	string	The unique ID for the customer associated with the subscription. Example value: `6784521634029`
`subscription_interval`	string	The frequency at which the subscription renews. Example values: `month`, `day`, `week`
`subscription_status`	string	The current status of the subscription. Example values: `active`, `cancelled`, `expired`
`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`
`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`
`first_order_id`	string	The unique ID for the first order placed within this subscription. Example value: `5246165483756`
`first_order_date`	date	The date when the first order within this subscription was placed. Example value: `2023-04-09`
`product_id`	string	The unique ID for each product within the subscription. Example value: `7809254686953`
`variant_id`	string	The unique ID for each variant within the subscription. Example value: `43151194915045`
`cancellation_reason`	string	The reason for cancellation of the subscription, provided by the customer.
`cancellation_comments`	string	Additional comments given by the customer at the time of cancellation.
`orders`	record repeated	A collection of orders placed under this subscription.
`orders.order_id`	string	The unique order ID for each order within the subscription. Example value: `5779061670114`
`orders.event_date`	date	The date when each order within the subscription was placed. Example value: `2024-03-20`

Measures

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

Name	Type	Description
`subscription_interval_count`	numeric	The total number of subscription intervals that have occurred while the subscription was active.
`price`	numeric	The price of the subscription.
`quantity`	numeric	The number of products included in the subscription.