Subscriptions Table

The Subscriptions table stores individual subscription records with lifecycle details. One row per subscription line item; subscriptions with multiple products produce multiple rows. Includes status, billing interval, cancellation data, and linked order info.

📋
Table Guide
What You Can Answer With This Table

What is the distribution of subscription statuses and cancellation reasons? — group by status, cancellation_reason

Which products and variants have the most subscriptions? — group by product_id or variant_id

Before You Query

This table is not time-series. No event_date filter is needed.

Key Relationships

Table Join Key Use This Join To
Orders first_order_id to order_id Analyze subscription signups by first-order products, discounts, and fulfillment
Customers customer_id Segment subscription behavior by customer attributes and lifetime metrics

When to Use a Different Table

Use Subscription Metrics table when you need daily subscription performance, such as new subscriptions, churn rates, or revenue trends. The Subscriptions table is for individual subscription records.

View the full Triple Whale Data Ontology →

Table	Join Key	Use This Join To
Orders	`first_order_id` to `order_id`	Analyze subscription signups by first-order products, discounts, and fulfillment
Customers	`customer_id`	Segment subscription behavior by customer attributes and lifetime metrics

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`
Product ID	`product_id`	string	The unique ID for each product within the subscription. Example value: `7809254686953`
Shop ID	`shop_id`	string	The unique ID of the shop (often corresponds to the shop domain). Can be used to group or filter data by shop in multi-store reports. Example values: `example-US.myshopify.com`, `example-EU.myshopify.com`
Shop Name	`shop_name`	string	The name of the shop. Can be used to group or filter data by shop in multi-store reports. Example values: `example-US`, `example-EU`
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

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`

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

Updated 14 days ago