Choose a version:

global_searches

The global_searches schema 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.

Anchor to Use casesUse cases

Product visibility: Group global_search_requests by product_id to rank products by global-search exposure.
Request trend: Trend global_search_requests by month to see how global search demand moves over time.

Examples

ShopifyQL

View in adminView query results in the ShopifyQL editor

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

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
```
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
```
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
```
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
```
FROM global_searches
  SHOW global_search_requests
  WITH PERCENT_CHANGE
  DURING last_month
  COMPARE TO previous_period
```

Anchor to MetricsMetrics

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.

Anchor to global_search_requests global_search_requests: Number of unique global search requests

Anchor to DimensionsDimensions

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.

Anchor to day day: Day the global search occurred
Anchor to day_of_week day_of_week: Day of week the global search occurred
Anchor to hour hour: Hour the global search occurred
Anchor to hour_of_day hour_of_day: Hour of day the global search occurred
Anchor to minute minute: Minute the global search occurred
Anchor to month month: Month the global search occurred
Anchor to month_of_year month_of_year: Month of year the global search occurred
Anchor to product_id product_id: The unique Shopify identifier for the product connected to a global catalog search. Use product_id with product_title to show readable labels.
Anchor to product_variant_id product_variant_id: The unique Shopify identifier for the product variant connected to a global catalog search. Use product_variant_id with product_variant_title or product_variant_sku to show readable labels.
Anchor to quarter quarter: Quarter the global search occurred
Anchor to second second: Second the global search occurred
Anchor to shop_id shop_id: The unique Shopify identifier for your store. Use shop_id with shop_name to show readable store labels.
Anchor to week week: Week the global search occurred
Anchor to week_of_year week_of_year: Week of year the global search occurred
Anchor to year year: Year the global search occurred
Anchor to product_status product_status: The product's current publishing state, with values Active, Archived, Draft, Suspended, and Unlisted.
Anchor to product_title product_title: Display name of the product that your customers see
Anchor to product_type product_type: Type (category) that you've assigned to the product
Anchor to product_vendor product_vendor: Vendor of the product
Anchor to shop_name shop_name: Name of your store
Anchor to product_collection product_collection: Collection associated with the product
Anchor to product_collections product_collections <>: Set of collections associated with the product
Anchor to app_product_creation app_product_creation: The app that created the product, shown as an app name.
Anchor to product_tag product_tag: Tag associated with the product
Anchor to product_tags product_tags <>: Set of tags associated with the product
Anchor to product_variant_abc_grade product_variant_abc_grade: 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%.
Anchor to product_variant_sku product_variant_sku: SKU of the product variant
Anchor to product_variant_title product_variant_title: Display name of the product variant

DAY_TIMESTAMP

A date value truncated to day precision.

DAY_OF_WEEK

A day within a week, used for weekday-based grouping and filtering.

HOUR_TIMESTAMP

A timestamp truncated to hour precision.

HOUR_OF_DAY

An hour within a day, typically represented as an integer from 0 to 23.

MINUTE_TIMESTAMP

A timestamp truncated to minute precision.

MONTH_TIMESTAMP

A date value representing the start of a month.

MONTH_OF_YEAR

A month number within a year.

IDENTITY

A unique identifier for a Shopify resource such as a customer, product, or order.

QUARTER_TIMESTAMP

A date value representing the start of a fiscal quarter.

SECOND_TIMESTAMP

A timestamp truncated to second precision.

WEEK_TIMESTAMP

A date value representing the start of a week.

WEEK_OF_YEAR

A week number within a year.

YEAR_TIMESTAMP

A date value representing the start of a year.

STRING

A sequence of characters representing text data.

ARRAY

A list of values. The element type appears inside angle brackets, such as ARRAY<STRING>.

Anchor to Related schemasRelated schemas

searches: Storewide search volume when you want to see what shoppers look for inside your store.
search_queries: Query-level click outcomes inside your storefront.

Was this page helpful?