Product recommendation conversions

The product-recommendation funnel by day — sessions that saw a recommendation, and how many clicked one, added to cart and completed checkout, as Shopify measures it. Requires the read_reports scope; empty on stores that have not granted it.

11 fields — 4 dimensions, 7 metrics. Date clauses (SINCE, UNTIL, DURING) use day.

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 product_recommendation_conversions
  SHOW sessions_with_product_recommendations
  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	Which aggregation Shopify computed the row at. Only `day` exists today.
`sessions_with_product_recommendations`	number	metric	Online store sessions in which a product recommendation was shown. The denominator of all three rates below.
`product_recommendation_sessions_with_clicks`	number	metric	Sessions in which a recommended product was clicked.
`product_recommendation_sessions_with_cart_additions`	number	metric	Sessions in which a recommended product was added to the cart.
`product_recommendation_sessions_that_completed_checkout`	number	metric	Sessions with a recommendation that went on to complete checkout.
`product_recommendation_click_rate`	percent	metric	Share of recommendation sessions in which a recommended product was clicked. Blank on a day with no recommendation sessions — an unmeasured day, not a 0% one.
`product_recommendation_added_to_cart_rate`	percent	metric	Share of recommendation sessions that added a recommended product to the cart. Blank on a day with no recommendation sessions.
`product_recommendation_conversion_rate`	percent	metric	Share of recommendation sessions that completed checkout. Blank on a day with no recommendation sessions.
`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'.