--- title: low_engagement_product_recommendations description: >- Reference for the ShopifyQL `low_engagement_product_recommendations` 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/low_engagement_product_recommendations md: >- https://shopify.dev/docs/api/shopifyql/latest/schemas/sessions_and_behavior/low_engagement_product_recommendations.md api_name: shopifyql --- # low\_​engagement\_​product\_​recommendations The `low_engagement_product_recommendations` [schema](https://shopify.dev/docs/api/shopifyql/latest/schemas) captures products whose recommendations get clicked less than the rest. It surfaces the recommendations performing below the store's recent average. ### Use cases * **Low-click products**: Group [`product_recommendation_low_click_rate`](#lowengagementproductrecommendationsmetric-propertydetail-productrecommendationlowclickrate) by [`product_id`](#lowengagementproductrecommendationsdimension-propertydetail-productid) to find the products whose recommendations rarely get clicked. * **Performance gap**: Use [`product_recommendation_performance_gap`](#lowengagementproductrecommendationsmetric-propertydetail-productrecommendationperformancegap) to show the difference from the store's 30-day average click rate. Examples ### Examples * #### ##### Description Find the 50 products whose click rate falls furthest below your store's 30-day average, each shown next to its click rate. This example sorts by \[\`product\_recommendation\_performance\_gap\`]\(#lowengagementproductrecommendationsmetric-propertydetail-productrecommendationperformancegap) ascending, so the largest gaps land at the top. ##### ShopifyQL ```shopifyql FROM low_engagement_product_recommendations SHOW product_recommendation_performance_gap, product_recommendation_low_click_rate GROUP BY product_id ORDER BY product_recommendation_performance_gap ASC LIMIT 50 VISUALIZE product_recommendation_performance_gap TYPE horizontal_bar ``` * #### ##### Description Show the 100 products with the lowest \`product\_recommendation\_low\_click\_rate\`, with each performance gap. This example uses \[\`HAVING\`]\(/docs/api/shopifyql/latest/syntax/having) \`product\_recommendation\_low\_click\_rate < 0.2\` to keep only products clicked less than a fifth of the time. ##### ShopifyQL ```shopifyql FROM low_engagement_product_recommendations SHOW product_recommendation_low_click_rate, product_recommendation_performance_gap GROUP BY product_id HAVING product_recommendation_low_click_rate < 0.2 ORDER BY product_recommendation_low_click_rate ASC LIMIT 100 VISUALIZE product_recommendation_low_click_rate TYPE list ``` * #### ##### Description List \`product\_recommendation\_low\_click\_rate\` and \`product\_recommendation\_performance\_gap\` for recommendations last month. This example uses \[\`HAVING\`]\(/docs/api/shopifyql/latest/syntax/having) \`product\_recommendation\_low\_click\_rate < 0.2\` to keep only recommendations with a click rate below 20%. ##### ShopifyQL ```shopifyql FROM low_engagement_product_recommendations SHOW product_recommendation_low_click_rate, product_recommendation_performance_gap HAVING product_recommendation_low_click_rate < 0.2 DURING last_month ORDER BY product_recommendation_low_click_rate ASC VISUALIZE product_recommendation_low_click_rate TYPE list ``` * #### ##### Description Compare \`product\_recommendation\_performance\_gap\` last month against the month before. This example uses \[\`COMPARE TO previous\_period\`]\(/docs/api/shopifyql/latest/syntax/compare-to) to benchmark your date range against the equal-length period right before it. ##### ShopifyQL ```shopifyql FROM low_engagement_product_recommendations SHOW product_recommendation_performance_gap WITH PERCENT_CHANGE DURING last_month COMPARE TO previous_period ``` *** ## 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 low_engagement_product_recommendations`. * **product\_​recommendation\_​low\_​click\_​rate** **PERCENT** Online store sessions in which a customer clicked on a product recommendation relative to all sessions with product recommendations * **product\_​recommendation\_​performance\_​gap** **PERCENT** Positive values mean this recommendation's click rate is above your store's 30-day average, and negative values mean it's below that average. ### PERCENT A percentage value represented as a decimal, where 0.25 represents 25%. ```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 low_engagement_product_recommendations`. * **product\_​id** **IDENTITY** Shopify identifier for the product * **shop\_​id** **IDENTITY** The unique Shopify identifier for your store. Use [`shop_id`](#lowengagementproductrecommendationsdimension-propertydetail-shopid) with [`shop_name`](#lowengagementproductrecommendationsdimension-propertydetail-shopname) to show readable store labels. * **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 ### IDENTITY Unique identifier for a Shopify resource such as a customer or order ```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 * [`product_recommendation_conversions`](https://shopify.dev/docs/api/shopifyql/latest/schemas/sessions_and_behavior/product_recommendation_conversions): Conversion-side recommendation data for which products do convert. ***