Subscriptions

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