search_
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, andsearch_sessions_with_cart_additionsto trace drop-off between searching and adding to cart. - Conversion trend: Trend
search_conversion_rateby month to see whether on-site search is converting better over time. - Rate comparison: Compare
search_click_rateandsearch_added_to_cart_rateto see whether search clicks turn into cart additions.
ShopifyQL
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_valuesDescription
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 heatmapDescription
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 lineDescription
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 .
- Anchor to search_added_to_cart_ratesearch_
added_ to_ cart_ ratesearch_ added_ to_ cart_ rate PERCENTPERCENT Online store sessions with searches and items added to cart relative to all sessions with searches
- Anchor to search_click_ratesearch_
click_ ratesearch_ click_ rate PERCENTPERCENT Online store sessions in which a customer clicked a search result relative to all sessions with searches
- Anchor to search_conversion_ratesearch_
conversion_ ratesearch_ conversion_ rate PERCENTPERCENT Online store sessions with searches and a completed purchase relative to all sessions with searches
- Anchor to search_sessions_that_completed_checkoutsearch_
sessions_ that_ completed_ checkoutsearch_ sessions_ that_ completed_ checkout INTEGERINTEGER Number of online store sessions in which a customer searched your site and also made a purchase
- Anchor to search_sessions_with_cart_additionssearch_
sessions_ with_ cart_ additionssearch_ sessions_ with_ cart_ additions INTEGERINTEGER 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_clickssearch_
sessions_ with_ clickssearch_ sessions_ with_ clicks INTEGERINTEGER Number of online store sessions in which a customer clicked on a search result
- Anchor to sessions_with_searchessessions_
with_ searchessessions_ with_ searches INTEGERINTEGER Number of online store sessions with searches
PERCENT
A percentage value represented as a decimal, where 0.25 represents 25%.
INTEGER
A whole number without decimal places, used for counts, quantities, and other discrete numeric values.
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 .
- Anchor to daydaydayDAY_TIMESTAMPDAY_TIMESTAMP
Day (timestamp) the data was recorded
- Anchor to day_of_weekday_
of_ weekday_ of_ week DAY_OF_WEEKDAY_OF_WEEK The day of week a search happened, with values Monday through Sunday.
- Anchor to hourhourhourHOUR_TIMESTAMPHOUR_TIMESTAMP
Hour (timestamp) the data was recorded
- Anchor to hour_of_dayhour_
of_ dayhour_ of_ day HOUR_OF_DAYHOUR_OF_DAY The hour of day a search happened, with values 0 through 23.
- Anchor to minuteminuteminuteMINUTE_TIMESTAMPMINUTE_TIMESTAMP
Minute (timestamp) the data was recorded
- Anchor to monthmonthmonthMONTH_TIMESTAMPMONTH_TIMESTAMP
Month (timestamp) the data was recorded
- Anchor to month_of_yearmonth_
of_ yearmonth_ of_ year MONTH_OF_YEARMONTH_OF_YEAR The month of year a search happened, with values 1 through 12.
- Anchor to quarterquarterquarterQUARTER_TIMESTAMPQUARTER_TIMESTAMP
Quarter (timestamp) the data was recorded
- Anchor to secondsecondsecondSECOND_TIMESTAMPSECOND_TIMESTAMP
Second (timestamp) the data was recorded
- Anchor to shop_idshop_
idshop_ id IDENTITYIDENTITY - Anchor to weekweekweekWEEK_TIMESTAMPWEEK_TIMESTAMP
Week (timestamp) the data was recorded
- Anchor to week_of_yearweek_
of_ yearweek_ of_ year WEEK_OF_YEARWEEK_OF_YEAR The week of year a search happened, with values 1 through 53.
- Anchor to yearyearyearYEAR_TIMESTAMPYEAR_TIMESTAMP
Year (timestamp) the data was recorded
- Anchor to shop_nameshop_
nameshop_ name STRINGSTRING 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.
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.