--- title: product_recommendation_conversions description: >- Reference for the ShopifyQL `product_recommendation_conversions` schema. Every metric and dimension, paired with worked example queries. api_version: 2026-10 source_url: html: >- https://shopify.dev/docs/api/shopifyql/latest/schemas/sessions_and_behavior/product_recommendation_conversions md: >- https://shopify.dev/docs/api/shopifyql/latest/schemas/sessions_and_behavior/product_recommendation_conversions.md api_name: shopifyql --- # product\_​recommendation\_​conversions The `product_recommendation_conversions` [schema](https://shopify.dev/docs/api/shopifyql/latest/schemas) captures the funnel from a shopper seeing a product recommendation through clicking, adding to cart, and checking out. It has one row per product, so recommendation performance is comparable product by product. ### Use cases * **Recommendation funnel**: Show [`sessions_with_product_recommendations`](#productrecommendationconversionsmetric-propertydetail-sessionswithproductrecommendations), [`product_recommendation_sessions_with_clicks`](#productrecommendationconversionsmetric-propertydetail-productrecommendationsessionswithclicks), and [`product_recommendation_sessions_with_cart_additions`](#productrecommendationconversionsmetric-propertydetail-productrecommendationsessionswithcartadditions) to trace drop-off between seeing a recommendation and adding to cart. * **Conversion by product**: Group [`product_recommendation_conversion_rate`](#productrecommendationconversionsmetric-propertydetail-productrecommendationconversionrate) by [`product_id`](#productrecommendationconversionsdimension-propertydetail-productid) to rank products by conversion from recommendations. * **Rate comparison**: Compare [`product_recommendation_click_rate`](#productrecommendationconversionsmetric-propertydetail-productrecommendationclickrate) with [`product_recommendation_added_to_cart_rate`](#productrecommendationconversionsmetric-propertydetail-productrecommendationaddedtocartrate) to see whether clicks on recommendations turn into cart additions. Examples ### Examples * #### ##### Description Rank the top 50 products by \`product\_recommendation\_conversion\_rate\` this quarter, with click and add-to-cart rates. This example uses \[\`HAVING\`]\(/docs/api/shopifyql/latest/syntax/having) \`sessions\_with\_product\_recommendations > 100\` to drop low-traffic products from the ranking. ##### ShopifyQL ```shopifyql FROM product_recommendation_conversions SHOW sessions_with_product_recommendations, product_recommendation_sessions_with_clicks, product_recommendation_click_rate, product_recommendation_conversion_rate, product_recommendation_added_to_cart_rate GROUP BY product_id HAVING sessions_with_product_recommendations > 100 DURING this_quarter ORDER BY product_recommendation_conversion_rate DESC LIMIT 50 VISUALIZE product_recommendation_conversion_rate TYPE horizontal_bar ``` * #### ##### Description Track the recommendation funnel week by week this quarter, from sessions through \`product\_recommendation\_conversion\_rate\`. This example pairs \[\`PERCENT\_CHANGE\`]\(/docs/api/shopifyql/latest/syntax/with#percent-change-columns) with \[\`COMPARE TO previous\_period\`]\(/docs/api/shopifyql/latest/syntax/compare-to) to add a column measuring each week against the quarter before. ##### ShopifyQL ```shopifyql FROM product_recommendation_conversions SHOW sessions_with_product_recommendations, product_recommendation_click_rate, product_recommendation_added_to_cart_rate, product_recommendation_conversion_rate TIMESERIES week WITH TOTALS, PERCENT_CHANGE DURING this_quarter COMPARE TO previous_period ORDER BY week ASC ``` * #### ##### Description Track weekly product-recommendation sessions that added to cart and those that completed checkout across this quarter. This example uses \[\`WITH TOTALS\`]\(/docs/api/shopifyql/latest/syntax/with#total-columns) to add a quarter-to-date total beside the weekly rows. ##### ShopifyQL ```shopifyql FROM product_recommendation_conversions SHOW product_recommendation_sessions_with_cart_additions, product_recommendation_sessions_that_completed_checkout TIMESERIES week WITH TOTALS DURING this_quarter ORDER BY week ASC VISUALIZE product_recommendation_sessions_that_completed_checkout TYPE line ``` * #### ##### Description Track weekly \`sessions\_with\_product\_recommendations\` by \`product\_id\` across last month. This example uses \[\`GROUP\_TOTALS\`]\(/docs/api/shopifyql/latest/syntax/with#group-total-columns) to add a per-week total across products beside the per-product bands, with \`LIMIT 50\` capping the returned rows. ##### ShopifyQL ```shopifyql FROM product_recommendation_conversions SHOW sessions_with_product_recommendations GROUP BY product_id WITH TOTALS, GROUP_TOTALS TIMESERIES week DURING last_month ORDER BY week ASC LIMIT 50 VISUALIZE sessions_with_product_recommendations TYPE stacked_bar ``` *** ## Metrics 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 product_recommendation_conversions`. * **product\_​recommendation\_​added\_​to\_​cart\_​rate** **PERCENT** A session contributes at most one count to the rate, even when multiple recommended items are added to the cart. * **product\_​recommendation\_​click\_​rate** **PERCENT** A session contributes at most one count to the rate, even when multiple recommendations are clicked. * **product\_​recommendation\_​conversion\_​rate** **PERCENT** A session contributes at most one count to the rate, even when multiple recommended items are purchased. * **product\_​recommendation\_​sessions\_​that\_​completed\_​checkout** **INTEGER** Number of online store sessions in which a customer clicked on a product recommendation and purchased that recommended item * **product\_​recommendation\_​sessions\_​with\_​cart\_​additions** **INTEGER** Number of online store sessions in which a customer clicked on a product recommendation and added that recommended item to their cart * **product\_​recommendation\_​sessions\_​with\_​clicks** **INTEGER** Number of online store sessions in which a customer clicked on a product recommendation * **sessions\_​with\_​product\_​recommendations** **INTEGER** Number of online store sessions in which a customer was shown a product recommendation ### PERCENT A percentage value represented as a decimal, where 0.25 represents 25%. ```ts ``` ### INTEGER Whole number without decimal places, used for counts and quantities ```ts ``` *** ## Dimensions 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 product_recommendation_conversions`. * **day** **DAY\_TIMESTAMP** Use this field to view product recommendation conversions by day. * **day\_​of\_​week** **DAY\_OF\_WEEK** Use this field to view product recommendation conversions by day of the week, with values Monday through Sunday. * **hour** **HOUR\_TIMESTAMP** Use this field to view product recommendation conversions by hour. * **hour\_​of\_​day** **HOUR\_OF\_DAY** Use this field to view product recommendation conversions by hour of the day, with values 0 through 23. * **month** **MONTH\_TIMESTAMP** Use this field to view product recommendation conversions by month. * **month\_​of\_​year** **MONTH\_OF\_YEAR** Use this field to view product recommendation conversions by month of the year, with values 1 through 12. * **product\_​id** **IDENTITY** Use [`product_id`](#productrecommendationconversionsdimension-propertydetail-productid) with [`product_title`](#productrecommendationconversionsdimension-propertydetail-producttitle) to show readable product labels. * **quarter** **QUARTER\_TIMESTAMP** Use this field to view product recommendation conversions by quarter. * **shop\_​id** **IDENTITY** The unique Shopify identifier for your store. Use [`shop_id`](#productrecommendationconversionsdimension-propertydetail-shopid) with [`shop_name`](#productrecommendationconversionsdimension-propertydetail-shopname) to show readable store labels. * **week** **WEEK\_TIMESTAMP** Use this field to view product recommendation conversions by week. * **week\_​of\_​year** **WEEK\_OF\_YEAR** Use this field to view product recommendation conversions by week of the year, with values 1 through 53. * **year** **YEAR\_TIMESTAMP** Use this field to view product recommendation conversions by year. * **product\_​status** **STRING** The product's current publishing state, with values Active, Archived, Draft, Suspended, and Unlisted. * **product\_​title** **STRING** Display name of the product that your customers see * **product\_​type** **STRING** Type (category) that you've assigned to the product * **product\_​vendor** **STRING** Vendor of the product * **shop\_​name** **STRING** Name of your store * **product\_​collection** **STRING** Collection associated with the product * **product\_​collections** **ARRAY\** Set of collections associated with the product * **app\_​product\_​creation** **STRING** The app that created the product, shown as an app name. * **product\_​tag** **STRING** Tag associated with the product * **product\_​tags** **ARRAY\** Set of tags associated with the product ### DAY\_TIMESTAMP Date with the time of day removed ```ts ``` ### DAY\_OF\_WEEK Day of the week, used to group or filter data by weekday ```ts ``` ### HOUR\_TIMESTAMP Date and time with minutes and seconds removed ```ts ``` ### HOUR\_OF\_DAY Hour of the day, shown as a whole number from 0 to 23 ```ts ``` ### MONTH\_TIMESTAMP Date for the start of a month ```ts ``` ### MONTH\_OF\_YEAR Month number within a year ```ts ``` ### IDENTITY Unique identifier for a Shopify resource such as a customer or order ```ts ``` ### QUARTER\_TIMESTAMP Date for the start of a fiscal quarter ```ts ``` ### WEEK\_TIMESTAMP Date for the start of a week ```ts ``` ### WEEK\_OF\_YEAR Week number within a year ```ts ``` ### YEAR\_TIMESTAMP Date for the start of a year ```ts ``` ### STRING Text made of letters, numbers, or symbols ```ts ``` ### ARRAY A list of values. The element type appears inside angle brackets, such as ARRAY\. ```ts ``` *** ## Related schemas * [`low_engagement_product_recommendations`](https://shopify.dev/docs/api/shopifyql/latest/schemas/sessions_and_behavior/low_engagement_product_recommendations): Recommendation products performing below the store average, to pair with these converters. ***