Choose a version:

search_conversions

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

Anchor to Use casesUse cases

Search funnel: Show sessions_with_searches, search_sessions_with_clicks, and search_sessions_with_cart_additions to trace drop-off between searching and adding to cart.
Conversion trend: Trend search_conversion_rate by month to see whether on-site search is converting better over time.
Rate comparison: Compare search_click_rate and search_added_to_cart_rate to see whether search clicks turn into cart additions.

Examples

ShopifyQL

View in adminView query results in the ShopifyQL editor

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

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

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
```
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
```
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
```
FROM search_conversions
  SHOW search_sessions_with_clicks
  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 search_conversions.

Anchor to search_added_to_cart_rate search_added_to_cart_rate: Online store sessions with searches and items added to cart relative to all sessions with searches
Anchor to search_click_rate search_click_rate: Online store sessions in which a customer clicked a search result relative to all sessions with searches
Anchor to search_conversion_rate search_conversion_rate: Online store sessions with searches and a completed purchase relative to all sessions with searches
Anchor to search_sessions_that_completed_checkout search_sessions_that_completed_checkout: Number of online store sessions in which a customer searched your site and also made a purchase
Anchor to search_sessions_with_cart_additions search_sessions_with_cart_additions: Number of online store sessions in which a customer searched your site and also added an item to the cart
Anchor to search_sessions_with_clicks search_sessions_with_clicks: Number of online store sessions in which a customer clicked on a search result
Anchor to sessions_with_searches sessions_with_searches: Number of online store sessions with searches

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

Anchor to day day: Day (timestamp) the data was recorded
Anchor to day_of_week day_of_week: The day of week a search happened, 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 day a search happened, 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 year a search happened, with values 1 through 12.
Anchor to quarter quarter: Quarter (timestamp) the data was recorded
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 year a search happened, 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.

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.

STRING

A sequence of characters representing text data.

Anchor to Related schemasRelated schemas

searches: Search volume and intent for what shoppers look for.
search_queries: Query-level click outcomes for which terms drive engagement.
sessions: Storewide session data for a denominator beyond search-driven traffic.

Was this page helpful?