--- title: global_searches description: >- Reference for the ShopifyQL `global_searches` 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/global_searches md: >- https://shopify.dev/docs/api/shopifyql/latest/schemas/sessions_and_behavior/global_searches.md api_name: shopifyql --- # global\_​searches The `global_searches` [schema](https://shopify.dev/docs/api/shopifyql/latest/schemas) captures search requests against the global catalog rather than only a shop's storefront search. It's a source for global search request volume tied to product and variant context. ### Use cases * **Product visibility**: Group [`global_search_requests`](#globalsearchesmetric-propertydetail-globalsearchrequests) by [`product_id`](#globalsearchesdimension-propertydetail-productid) to rank products by global-search exposure. * **Request trend**: Trend [`global_search_requests`](#globalsearchesmetric-propertydetail-globalsearchrequests) by month to see how global search demand moves over time. Examples ### Examples * #### ##### Description Show the 25 products with the most \`global\_search\_requests\` this year, each with its year-over-year change. This example uses \[\`COMPARE TO last\_year\`]\(/docs/api/shopifyql/latest/syntax/compare-to) with \[\`PERCENT\_CHANGE\`]\(/docs/api/shopifyql/latest/syntax/with#percent-change-columns). ##### ShopifyQL ```shopifyql FROM global_searches SHOW global_search_requests GROUP BY product_id WITH PERCENT_CHANGE DURING this_year COMPARE TO last_year ORDER BY global_search_requests DESC LIMIT 25 VISUALIZE global_search_requests TYPE horizontal_bar ``` * #### ##### Description Break down weekly \`global\_search\_requests\` by product variant through this quarter, stacked into one column per week. This example uses \[\`WITH GROUP\_TOTALS\`]\(/docs/api/shopifyql/latest/syntax/with#group-total-columns) to add a per-week total across variants beside the per-variant bands. ##### ShopifyQL ```shopifyql FROM global_searches SHOW global_search_requests GROUP BY product_variant_title, product_variant_sku WITH GROUP_TOTALS TIMESERIES week DURING this_quarter ORDER BY week ASC LIMIT 200 VISUALIZE global_search_requests TYPE stacked_bar ``` * #### ##### Description Track daily \`global\_search\_requests\` over the last 30 days. This example uses \[\`SINCE startOfDay(-30d) UNTIL today\`]\(/docs/api/shopifyql/latest/syntax/since-until-during) to bound the range to the last 30 days. ##### ShopifyQL ```shopifyql FROM global_searches SHOW global_search_requests TIMESERIES day WITH TOTALS SINCE startOfDay(-30d) UNTIL today ORDER BY day ASC VISUALIZE global_search_requests TYPE line ``` * #### ##### Description Compare \`global\_search\_requests\` 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 global_searches SHOW global_search_requests 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 global_searches`. * **global\_​search\_​requests** **INTEGER** Number of unique global search requests ### 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 global_searches`. * **day** **DAY\_TIMESTAMP** Day the global search occurred * **day\_​of\_​week** **DAY\_OF\_WEEK** Day of week the global search occurred * **hour** **HOUR\_TIMESTAMP** Hour the global search occurred * **hour\_​of\_​day** **HOUR\_OF\_DAY** Hour of day the global search occurred * **minute** **MINUTE\_TIMESTAMP** Minute the global search occurred * **month** **MONTH\_TIMESTAMP** Month the global search occurred * **month\_​of\_​year** **MONTH\_OF\_YEAR** Month of year the global search occurred * **product\_​id** **IDENTITY** The unique Shopify identifier for the product connected to a global catalog search. Use [`product_id`](#globalsearchesdimension-propertydetail-productid) with [`product_title`](#globalsearchesdimension-propertydetail-producttitle) to show readable labels. * **product\_​variant\_​id** **IDENTITY** The unique Shopify identifier for the product variant connected to a global catalog search. Use [`product_variant_id`](#globalsearchesdimension-propertydetail-productvariantid) with [`product_variant_title`](#globalsearchesdimension-propertydetail-productvarianttitle) or [`product_variant_sku`](#globalsearchesdimension-propertydetail-productvariantsku) to show readable labels. * **quarter** **QUARTER\_TIMESTAMP** Quarter the global search occurred * **second** **SECOND\_TIMESTAMP** Second the global search occurred * **shop\_​id** **IDENTITY** The unique Shopify identifier for your store. Use [`shop_id`](#globalsearchesdimension-propertydetail-shopid) with [`shop_name`](#globalsearchesdimension-propertydetail-shopname) to show readable store labels. * **week** **WEEK\_TIMESTAMP** Week the global search occurred * **week\_​of\_​year** **WEEK\_OF\_YEAR** Week of year the global search occurred * **year** **YEAR\_TIMESTAMP** Year the global search occurred * **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 * **product\_​variant\_​abc\_​grade** **STRING** The ABC grade assigned to the product variant based on its share of revenue. A-grade variants account for about 80% of revenue, B-grade for 15%, and C-grade for 5%. * **product\_​variant\_​sku** **STRING** SKU of the product variant * **product\_​variant\_​title** **STRING** Display name of the product variant ### 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 ``` ### IDENTITY A unique identifier for a Shopify resource such as a customer, product, or order. ```ts ``` ### QUARTER\_TIMESTAMP A date value representing the start of a fiscal quarter. ```ts ``` ### SECOND\_TIMESTAMP A timestamp truncated to second precision. ```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 ``` ### ARRAY A list of values. The element type appears inside angle brackets, such as ARRAY\. ```ts ``` *** ## Related schemas * [`searches`](https://shopify.dev/docs/api/shopifyql/latest/schemas/sessions_and_behavior/searches): Storewide search volume when you want to see what shoppers look for inside your store. * [`search_queries`](https://shopify.dev/docs/api/shopifyql/latest/schemas/sessions_and_behavior/search_queries): Query-level click outcomes inside your storefront. ***