Low-engagement product recommendations

Shopify's diagnostic of products whose recommendations underperform — the latest daily snapshot of its trailing-30-day computation. Not re-windowable: Shopify computes this only for the recent past. Requires the read_reports scope.

8 fields — 6 dimensions, 2 metrics. Date clauses (SINCE, UNTIL, DURING) use snapshotDay.

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 low_engagement_product_recommendations
  SHOW product_recommendation_low_click_rate
  GROUP BY grain
  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
grain	string	dimension	The snapshot grain — only snapshot exists; the index holds the latest daily fetch only.
product_title	string	dimension	The recommended product, verbatim.
product_type	string	dimension	The product's type as Shopify reports it (a literal "None" when unset).
product_recommendation_low_click_rate	percent	metric	Shopify's pre-computed click rate for this product's recommendations over its trailing-30-day window. ⚠️ Not additive; stored as computed, never derived.
product_recommendation_performance_gap	percent	metric	How far this product's recommendation engagement falls below Shopify's internal store benchmark (negative fractions). ⚠️ Not additive; stored as computed.
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'.