--- title: search_conversions description: >- Reference for the ShopifyQL `search_conversions` table. Every metric and dimension, paired with worked example queries. api_version: 2026-07 source_url: html: >- https://shopify.dev/docs/api/shopifyql/latest/schemas/sessions_and_behavior/search_conversions md: >- https://shopify.dev/docs/api/shopifyql/latest/schemas/sessions_and_behavior/search_conversions.md api_name: shopifyql --- # search\_​conversions The `search_conversions` [schema](https://shopify.dev/docs/api/shopifyql/latest/schemas) captures the online store search funnel in aggregate. It follows the path from sessions that search, to clicks, cart additions, and completed checkouts, along with the conversion rate at each step. ### Use cases * **Search funnel**: Show [`sessions_with_searches`](#searchconversionsmetric-propertydetail-sessionswithsearches), [`search_sessions_with_clicks`](#searchconversionsmetric-propertydetail-searchsessionswithclicks), and [`search_sessions_with_cart_additions`](#searchconversionsmetric-propertydetail-searchsessionswithcartadditions) to trace drop-off between searching and adding to cart. * **Conversion trend**: Trend [`search_conversion_rate`](#searchconversionsmetric-propertydetail-searchconversionrate) by month to see whether on-site search is converting better over time. * **Rate comparison**: Compare [`search_click_rate`](#searchconversionsmetric-propertydetail-searchclickrate) and [`search_added_to_cart_rate`](#searchconversionsmetric-propertydetail-searchaddedtocartrate) to see whether search clicks turn into cart additions. Examples ### Examples * #### ##### Description Show each stage of the search funnel, from \`sessions\_with\_searches\` through completed checkout, broken down by day of the week this quarter. This example uses \[\`WITH TOTALS\`]\(/docs/api/shopifyql/latest/syntax/with#total-columns) to add a whole-week total per step. ##### ShopifyQL ```shopifyql FROM search_conversions SHOW sessions_with_searches, search_sessions_with_clicks, search_sessions_with_cart_additions, search_sessions_that_completed_checkout GROUP BY day_of_week WITH TOTALS DURING this_quarter ORDER BY day_of_week ASC VISUALIZE sessions_with_searches TYPE list_with_dimension_values ``` * #### ##### Description Show \[\`search\_conversion\_rate\`]\(#searchconversionsmetric-propertydetail-searchconversionrate) by day of week and hour of day this quarter. This example uses \`TYPE heatmap\` to render the two-dimension grouping as a color-coded grid, so peak conversion windows stand out. ##### ShopifyQL ```shopifyql FROM search_conversions SHOW search_conversion_rate GROUP BY day_of_week, hour_of_day DURING this_quarter ORDER BY day_of_week ASC, hour_of_day ASC VISUALIZE search_conversion_rate TYPE heatmap ``` * #### ##### Description Track weekly \`search\_click\_rate\` and \`search\_added\_to\_cart\_rate\` across this quarter. This example uses \[\`WITH TOTALS\`]\(/docs/api/shopifyql/latest/syntax/with#total-columns) to add an overall quarter-to-date rate beside the weekly rows, because both metrics are rates. ##### ShopifyQL ```shopifyql FROM search_conversions SHOW search_click_rate, search_added_to_cart_rate TIMESERIES week WITH TOTALS DURING this_quarter ORDER BY week ASC VISUALIZE search_click_rate, search_added_to_cart_rate TYPE line ``` * #### ##### Description Compare \`search\_sessions\_with\_clicks\` 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 search_conversions SHOW search_sessions_with_clicks 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 search_conversions`. * **search\_​added\_​to\_​cart\_​rate** **PERCENT** Online store sessions with searches and items added to cart relative to all sessions with searches * **search\_​click\_​rate** **PERCENT** Online store sessions in which a customer clicked a search result relative to all sessions with searches * **search\_​conversion\_​rate** **PERCENT** Online store sessions with searches and a completed purchase relative to all sessions with searches * **search\_​sessions\_​that\_​completed\_​checkout** **INTEGER** Number of online store sessions in which a customer searched your site and also made a purchase * **search\_​sessions\_​with\_​cart\_​additions** **INTEGER** Number of online store sessions in which a customer searched your site and also added an item to the cart * **search\_​sessions\_​with\_​clicks** **INTEGER** Number of online store sessions in which a customer clicked on a search result * **sessions\_​with\_​searches** **INTEGER** Number of online store sessions with searches ### PERCENT A percentage value represented as a decimal, where 0.25 represents 25%. ```ts ``` ### INTEGER A whole number without decimal places, used for counts, quantities, and other discrete numeric values. ```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 search_conversions`. * **day** **DAY\_TIMESTAMP** Day (timestamp) the data was recorded * **day\_​of\_​week** **DAY\_OF\_WEEK** The day of week a search happened, with values Monday through Sunday. * **hour** **HOUR\_TIMESTAMP** Hour (timestamp) the data was recorded * **hour\_​of\_​day** **HOUR\_OF\_DAY** The hour of day a search happened, with values 0 through 23. * **minute** **MINUTE\_TIMESTAMP** Minute (timestamp) the data was recorded * **month** **MONTH\_TIMESTAMP** Month (timestamp) the data was recorded * **month\_​of\_​year** **MONTH\_OF\_YEAR** The month of year a search happened, with values 1 through 12. * **quarter** **QUARTER\_TIMESTAMP** Quarter (timestamp) the data was recorded * **second** **SECOND\_TIMESTAMP** Second (timestamp) the data was recorded * **shop\_​id** **IDENTITY** The unique Shopify identifier for your store. Use [`shop_id`](#searchconversionsdimension-propertydetail-shopid) with [`shop_name`](#searchconversionsdimension-propertydetail-shopname) to show readable store labels. * **week** **WEEK\_TIMESTAMP** Week (timestamp) the data was recorded * **week\_​of\_​year** **WEEK\_OF\_YEAR** The week of year a search happened, with values 1 through 53. * **year** **YEAR\_TIMESTAMP** Year (timestamp) the data was recorded * **shop\_​name** **STRING** Name of your store ### DAY\_TIMESTAMP A date value truncated to day precision. ```ts ``` ### DAY\_OF\_WEEK A day within a week, used for weekday-based grouping and filtering. ```ts ``` ### HOUR\_TIMESTAMP A timestamp truncated to hour precision. ```ts ``` ### HOUR\_OF\_DAY An hour within a day, typically represented as an integer from 0 to 23. ```ts ``` ### MINUTE\_TIMESTAMP A timestamp truncated to minute precision. ```ts ``` ### MONTH\_TIMESTAMP A date value representing the start of a month. ```ts ``` ### MONTH\_OF\_YEAR A month number within a year. ```ts ``` ### QUARTER\_TIMESTAMP A date value representing the start of a fiscal quarter. ```ts ``` ### SECOND\_TIMESTAMP A timestamp truncated to second precision. ```ts ``` ### IDENTITY A unique identifier for a Shopify resource such as a customer, product, or order. ```ts ``` ### WEEK\_TIMESTAMP A date value representing the start of a week. ```ts ``` ### WEEK\_OF\_YEAR A week number within a year. ```ts ``` ### YEAR\_TIMESTAMP A date value representing the start of a year. ```ts ``` ### STRING A sequence of characters representing text data. ```ts ``` *** ## Related schemas * [`searches`](https://shopify.dev/docs/api/shopifyql/latest/schemas/sessions_and_behavior/searches): Search volume and intent for what shoppers look for. * [`search_queries`](https://shopify.dev/docs/api/shopifyql/latest/schemas/sessions_and_behavior/search_queries): Query-level click outcomes for which terms drive engagement. * [`sessions`](https://shopify.dev/docs/api/shopifyql/latest/schemas/sessions_and_behavior/sessions): Storewide session data for a denominator beyond search-driven traffic. ***