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.

Title	ID	Type	Description
Cancellation Comments	`cancellation_comments`	string	Additional comments given by the customer at the time of cancellation. Example values: `No longer interested`, `Ordered two by mistake`, `Just taking a break`
Cancellation Reason	`cancellation_reason`	string	The reason for cancellation of the subscription, provided by the customer. Example values: `Not the right fit`, `Issue with shipping`, `Other`
Subscription Created Date	`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`
Customer ID	`customer_id`	string	The unique ID for the customer associated with the subscription. Example value: `6784521634029`
Subscription Ended Date	`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`
Subscription First Order Date	`first_order_date`	date	The date when the first order within this subscription was placed. Example value: `2023-04-09`
Subscription First Order ID	`first_order_id`	string	The unique ID for the first order placed within this subscription. Example value: `5246165483756`
Orders	`orders`	record repeated	A collection of orders placed under this subscription.
Order ID	`orders.order_id`	string	The unique order ID for each order within the subscription. Example value: `5779061670114`
Order Date	`orders.event_date`	date	The date when each order within the subscription was placed. Example value: `2024-03-20`
Product ID	`product_id`	string	The unique ID for each product within the subscription. Example value: `7809254686953`
Subscription Status	`status`	string	The status of the subscription. Example values: `active`, `cancelled`, `expired`
Subscription ID	`subscription_id`	string	The unique ID for the subscription. Example value: `352106812`
Subscription Interval	`subscription_interval`	string	The time unit that defines how often the subscription renews. This indicates the frequency of fulfillment cycles for the subscription. Used in combination with the Subscription Interval Count to determine the exact frequency of fulfillment (e.g., a value of `week` with an interval count of `2` means the subscription renews every two weeks). Example values: `day`, `week`, `month`
Variant ID	`variant_id`	string	The unique ID for each variant within the subscription. Example value: `43151194915045`

Measures

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

Title	ID	Type	Description
Product Price	`price`	numeric	The price of each product in the subscription.
Product Quantity	`quantity`	numeric	The number of products included in the subscription.
Subscription Interval Count	`subscription_interval_count`	numeric	The number of intervals between each subscription renewal. Used in combination with the Subscription Interval to determine the exact frequency of fulfillment (e.g., a value of `2` with an interval of `week` means the subscription renews every two weeks). Example values: `1`, `2`, `4`

Title

Type

Description

Product Price

price

numeric

The price of each product in the subscription.

Product Quantity

quantity

numeric

The number of products included in the subscription.

Subscription Interval Count

subscription_interval_count

numeric

The number of intervals between each subscription renewal. Used in combination with the Subscription Interval to determine the exact frequency of fulfillment (e.g., a value of 2 with an interval of week means the subscription renews every two weeks).

Example values: 1, 2, 4