Search queries

Storefront search queries by day with whether a result was clicked, as Shopify records them. Distinct from the Searches dataset — Shopify counts the two differently. Requires the read_reports scope; empty on stores that have not granted it.

7 fields — 6 dimensions, 1 metrics. Date clauses (SINCE, UNTIL, DURING) use day.

The live, authoritative list is always GET /v1/datasets — this page is regenerated from the same catalog, but the endpoint reflects exactly what is deployed.

Query it

FROM search_queries
  SHOW search_queries
  GROUP BY grain
  SINCE -30d

See Querying with SoloQL for the language.

This dataset is queryable through SoloQL; it has no record-retrieval endpoint.

Fields

Field	Type	Role	Description
grain	string	dimension	Which aggregation the row was fetched at. Only day_query exists today.
search_query	string	dimension	The raw text a visitor typed into the storefront search box, verbatim.
search_result_was_clicked	boolean	dimension	Whether a result of this query was clicked.
search_queries	number	metric	Number of search queries as Shopify counts them on this dataset — NOT the same measure as the Searches dataset's searches. Additive; proven by re-aggregation.
store	string	dimension	The shop the record belongs to. Filter with WHERE store IN ('Shop name') or GROUP BY store.
store_id	string	dimension	The shop's raw identifier — what an export or the API reports. Same shops as Store, shown as ids.
store_domain	string	dimension	The shop's myshopify.com domain. Filter with WHERE store_domain = 'shop.myshopify.com'.