Customer cohorts (monthly)

Customers grouped by the monthly period of their FIRST order, tracked across the periods since it — the data behind the cohort retention grid.

8 fields — 4 dimensions, 4 metrics. Date clauses (SINCE, UNTIL, DURING) use customerFirstOrderDate.

The live, authoritative list is always GET /v1/datasets — this page is regenerated from the same catalog, but the endpoint reflects exactly what is deployed.

Query it

FROM customer_cohorts_monthly
  SHOW customer_cohorts_monthly_customers
  GROUP BY customer_cohorts_monthly_periods_since_first_purchase
  SINCE -30d

See Querying with SoloQL for the language.

This dataset is queryable through SoloQL; it has no record-retrieval endpoint.

Fields

Field	Type	Role	Description
customer_cohorts_monthly_periods_since_first_purchase	number	dimension	How many whole monthly periods after the customer's first order this activity happened. 0 is the first period; -1 marks the first order itself, which feeds totals but is hidden from the grid.
customer_cohorts_monthly_customers	number	metric	Distinct customers from the cohort active in the period (order/product lines only).
customer_cohorts_monthly_orders	number	metric	Distinct orders placed by the cohort's customers in the period.
customer_cohorts_monthly_customers_in_cohort	number	metric	How many distinct customers make up the cohort — the retention denominator.
customer_cohorts_monthly_customer_retention_rate	number	metric	Share of the cohort active in the period: customers ÷ customers in cohort. Empty when the cohort has no customers — never a fabricated 0%.
store	string	dimension	The shop the record belongs to. Filter with WHERE store IN ('Shop name') or GROUP BY store.
store_id	string	dimension	The shop's raw identifier — what an export or the API reports. Same shops as Store, shown as ids.
store_domain	string	dimension	The shop's myshopify.com domain. Filter with WHERE store_domain = 'shop.myshopify.com'.