Choose a version:

subscriptions

The subscriptions schema captures subscription count snapshots. It's a source for active, added, and canceled subscription movement by interval.

Anchor to Use casesUse cases

Subscription base: Group active_subscriptions by month to show the subscription base over time.
Movement: Compare subscriptions_added and subscriptions_canceled for the same snapshot interval to see whether the subscription base is growing or churning.

Examples

ShopifyQL

View in adminView query results in the ShopifyQL editor

FROM subscriptions

SHOW active_subscriptions

TIMESERIES month WITH PERCENT_CHANGE

DURING this_year

COMPARE TO previous_year

ORDER BY month ASC

VISUALIZE active_subscriptions TYPE line

Examples

Description
Compare monthly `active_subscriptions` for this year with a year-over-year percent-change column. This example uses [`COMPARE TO previous_year`](/docs/api/shopifyql/latest/syntax/compare-to) to benchmark each month against the same month last year.
ShopifyQL
```
FROM subscriptions
  SHOW active_subscriptions
  TIMESERIES month WITH PERCENT_CHANGE
  DURING this_year
  COMPARE TO previous_year
  ORDER BY month ASC
VISUALIZE active_subscriptions TYPE line
```
Description
Compare [`subscriptions_added`](#subscriptionsmetric-propertydetail-subscriptionsadded) and `subscriptions_canceled` by quarter for the last eight quarters. This example uses a line chart to show subscription additions and cancellations over time.
ShopifyQL
```
FROM subscriptions
  SHOW subscriptions_added, subscriptions_canceled
  TIMESERIES quarter WITH TOTALS
  SINCE startOfQuarter(-7q) UNTIL today
  ORDER BY quarter ASC
VISUALIZE subscriptions_added, subscriptions_canceled TYPE line
```
Description
Break down `active_subscriptions` and `subscriptions_canceled` by `quarter` across this year. This example uses [`GROUP BY`](/docs/api/shopifyql/latest/syntax/group-by) to compare the active base with cancellations each quarter.
ShopifyQL
```
FROM subscriptions
  SHOW active_subscriptions, subscriptions_canceled
  GROUP BY quarter WITH TOTALS
  DURING this_year
  ORDER BY quarter ASC
VISUALIZE active_subscriptions TYPE line
```
Description
Break down `active_subscriptions` and `subscriptions_added` by `week` across last quarter. This example uses [`GROUP BY`](/docs/api/shopifyql/latest/syntax/group-by) to compare new additions with the active base each week.
ShopifyQL
```
FROM subscriptions
  SHOW active_subscriptions, subscriptions_added
  GROUP BY week WITH TOTALS
  DURING last_quarter
  ORDER BY week ASC
VISUALIZE active_subscriptions TYPE line
```

Anchor to MetricsMetrics

Counts and calculations that let you track key business indicators. Metrics show up as the columns when queried.

Metrics you can use when querying FROM subscriptions.

Anchor to active_subscriptions active_subscriptions: The active subscription count from the latest measurement in each period.
Anchor to subscriptions_added subscriptions_added: Number of subscriptions your customers added in the given period
Anchor to subscriptions_canceled subscriptions_canceled: Number of subscriptions your customers canceled in the given period

Anchor to DimensionsDimensions

Attributes of your data that let you look more granularly at aspects of the data. Group and filter by dimensions to shape the rows your query returns.

Dimensions you can use when querying FROM subscriptions.

Anchor to day day: The day your subscription summary applies to.
Anchor to month month: The month your subscription summary applies to.
Anchor to quarter quarter: A three-month calendar quarter, Q1 through Q4.
Anchor to shop_id shop_id: The unique Shopify identifier for your store. Use shop_id with shop_name to show readable store labels.
Anchor to week week: The week your subscription summary applies to.
Anchor to year year: The year your subscription summary applies to.
Anchor to shop_name shop_name: Name of your store

DAY_TIMESTAMP

A date value truncated to day precision.

MONTH_TIMESTAMP

A date value representing the start of a month.

QUARTER_TIMESTAMP

A date value representing the start of a fiscal quarter.

IDENTITY

A unique identifier for a Shopify resource such as a customer, product, or order.

WEEK_TIMESTAMP

A date value representing the start of a week.

YEAR_TIMESTAMP

A date value representing the start of a year.

STRING

A sequence of characters representing text data.

Anchor to Related schemasRelated schemas

fulfillments: Fulfillment events when you want to track recurring shipments tied to subscription orders.
sales: Sale-level data when you want to attribute revenue back to subscription orders.
customers: Customer-level data for lifetime value of subscribers and one-off buyers.

Was this page helpful?