--- title: search_queries description: >- Reference for the ShopifyQL `search_queries` 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/search_queries md: >- https://shopify.dev/docs/api/shopifyql/latest/schemas/sessions_and_behavior/search_queries.md api_name: shopifyql --- # search\_​queries The `search_queries` [schema](https://shopify.dev/docs/api/shopifyql/latest/schemas) captures online store search with one row per search term. Use it to report how often terms are searched and how often they get a click, rather than for broader funnel analysis. ### Use cases * **Query volume**: Group [`search_queries`](#searchqueriesmetric-propertydetail-searchqueries) by [`search_query`](#searchqueriesdimension-propertydetail-searchquery) to rank the most-searched terms. * **Clicked queries**: Filter [`search_result_was_clicked`](#searchqueriesdimension-propertydetail-searchresultwasclicked) when counting queries that resulted in a click. * **Click trend**: Trend [`search_queries_with_clicks`](#searchqueriesmetric-propertydetail-searchquerieswithclicks) by week to see how often searches lead to a click over time. ### Examples * #### Rank the top 50 queries by click vs. no-click ##### Description Show the 50 most-run \`search\_queries\` last month, split by whether the result was clicked. This example uses \[\`HAVING\`]\(/docs/api/shopifyql/latest/syntax/having) \`search\_queries > 10\` to drop long-tail queries from the ranking. ##### ShopifyQL ```shopifyql FROM search_queries SHOW search_queries, search_queries_with_clicks GROUP BY search_query, search_result_was_clicked WITH TOTALS, GROUP_TOTALS HAVING search_queries > 10 DURING last_month ORDER BY search_queries DESC LIMIT 50 VISUALIZE search_queries TYPE list_with_dimension_values ``` * #### Find when shoppers search the most this month ##### Description Break down \`search\_queries\` and clicked queries by hour of day this month. This example uses \[\`WITH TOTALS\`]\(/docs/api/shopifyql/latest/syntax/with#total-columns) to add the total across all hours. ##### ShopifyQL ```shopifyql FROM search_queries SHOW search_queries, search_queries_with_clicks GROUP BY hour_of_day WITH TOTALS DURING this_month ORDER BY hour_of_day ASC VISUALIZE search_queries TYPE grouped_bar ``` * #### Compare search queries and clicked queries to the previous month ##### Description Compare \`search\_queries\` and \`search\_queries\_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_queries SHOW search_queries, search_queries_with_clicks WITH PERCENT_CHANGE DURING last_month COMPARE TO previous_period ``` * #### Track weekly clicked search queries this quarter ##### Description Track weekly \`search\_queries\_with\_clicks\` 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 search_queries SHOW search_queries_with_clicks TIMESERIES week WITH TOTALS DURING this_quarter ORDER BY week ASC VISUALIZE search_queries_with_clicks TYPE 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 search_queries`. * **search\_​queries** **INTEGER** Number of search queries * **search\_​queries\_​with\_​clicks** **INTEGER** Number of search queries in which the customer clicked on a search result ### 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 search_queries`. * **day** **DAY\_TIMESTAMP** Day (timestamp) the data was recorded * **day\_​of\_​week** **DAY\_OF\_WEEK** The day of the week, with values Monday through Sunday. * **hour** **HOUR\_TIMESTAMP** Hour (timestamp) the data was recorded * **hour\_​of\_​day** **HOUR\_OF\_DAY** The hour of the day, 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 the year, with values 1 through 12. * **quarter** **QUARTER\_TIMESTAMP** Quarter (timestamp) the data was recorded * **search\_​query** **STRING** Search query made on your online store * **search\_​result\_​was\_​clicked** **BOOLEAN** Whether a search led to a click on one of its results, with values `true` and `false`. * **second** **SECOND\_TIMESTAMP** Second (timestamp) the data was recorded * **shop\_​id** **IDENTITY** The unique Shopify identifier for your store. Use [`shop_id`](#searchqueriesdimension-propertydetail-shopid) with [`shop_name`](#searchqueriesdimension-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 the year, with values 1 through 53. * **year** **YEAR\_TIMESTAMP** Year (timestamp) the data was recorded * **shop\_​name** **STRING** Name of your store ### 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 ``` ### MINUTE\_TIMESTAMP Date and time with seconds removed ```ts ``` ### MONTH\_TIMESTAMP Date for the start of a month ```ts ``` ### MONTH\_OF\_YEAR Month number within a year ```ts ``` ### QUARTER\_TIMESTAMP Date for the start of a fiscal quarter ```ts ``` ### STRING Text made of letters, numbers, or symbols ```ts ``` ### BOOLEAN Value that is either true or false ```ts ``` ### SECOND\_TIMESTAMP Date and time with fractions of a second removed ```ts ``` ### IDENTITY Unique identifier for a Shopify resource such as a customer or order ```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 ``` *** ## Related schemas * [`searches`](https://shopify.dev/docs/api/shopifyql/latest/schemas/sessions_and_behavior/searches): Storewide search volume and intent for a higher-level view of search activity. * [`search_conversions`](https://shopify.dev/docs/api/shopifyql/latest/schemas/sessions_and_behavior/search_conversions): Search-driven funnel volume for tracking queries downstream to checkout. * [`global_searches`](https://shopify.dev/docs/api/shopifyql/latest/schemas/sessions_and_behavior/global_searches): Catalog exposure from search requests outside your storefront. ***