product_recommendation_conversions

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

  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

  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

  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

  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