Choose a version:

search_queries

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

Anchor to Use casesUse cases

Query volume: Group search_queries by search_query to rank the most-searched terms.
Clicked queries: Filter search_result_was_clicked when counting queries that resulted in a click.
Click trend: Trend search_queries_with_clicks by week to see how often searches lead to a click over time.

Examples

ShopifyQL

View in adminView query results in the ShopifyQL editor

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

Examples

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

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

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
```
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
```
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
```
FROM search_queries
  SHOW search_queries, search_queries_with_clicks
  WITH PERCENT_CHANGE
  DURING last_month
  COMPARE TO previous_period
```
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
```
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
```

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 search_queries.

Anchor to search_queries search_queries: Number of search queries
Anchor to search_queries_with_clicks search_queries_with_clicks: Number of search queries in which the customer clicked on a search result

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 search_queries.

Anchor to day day: Day (timestamp) the data was recorded
Anchor to day_of_week day_of_week: The day of the week, with values Monday through Sunday.
Anchor to hour hour: Hour (timestamp) the data was recorded
Anchor to hour_of_day hour_of_day: The hour of the day, with values 0 through 23.
Anchor to minute minute: Minute (timestamp) the data was recorded
Anchor to month month: Month (timestamp) the data was recorded
Anchor to month_of_year month_of_year: The month of the year, with values 1 through 12.
Anchor to quarter quarter: Quarter (timestamp) the data was recorded
Anchor to search_query search_query: Search query made on your online store
Anchor to search_result_was_clicked search_result_was_clicked: Whether a search led to a click on one of its results, with values true and false.
Anchor to second second: Second (timestamp) the data was recorded
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 (timestamp) the data was recorded
Anchor to week_of_year week_of_year: The week of the year, with values 1 through 53.
Anchor to year year: Year (timestamp) the data was recorded
Anchor to shop_name shop_name: Name of your store

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.

QUARTER_TIMESTAMP

A date value representing the start of a fiscal quarter.

STRING

A sequence of characters representing text data.

BOOLEAN

A true or false value representing binary states.

SECOND_TIMESTAMP

A timestamp truncated to second precision.

IDENTITY

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

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.

Anchor to Related schemasRelated schemas

searches: Storewide search volume and intent for a higher-level view of search activity.
search_conversions: Search-driven funnel volume for tracking queries downstream to checkout.
global_searches: Catalog exposure from search requests outside your storefront.

Was this page helpful?