Search (text) dataset

• Label: Search (Text)
• Description: Text search analytics.
• Default group key: term

​

Metrics

• requests (requests)
  • Number of search requests.
  • Example: COUNT_DISTINCT(requests)
• results_count (results)
  • Results returned per search request.
  • Example: AVG(results_count)
• total_sales (USD)
  • Gross sales credited to search by blended attribution, which splits one order fractionally across every surface that contributed to it. Shown in the dashboard as Attributed Revenue (blended). Measures line-item price after line-item discounts, in the store’s own currency: before tax and shipping, and not reduced by refunds or cancellations.
  • Example: SUM(total_sales)
• quantity_purchased (items)
  • Number of items purchased from search traffic.
  • Example: SUM(quantity_purchased)
• view_sessions (sessions)
  • Distinct sessions in which a product was viewed from search results. Counts sessions, not views: one session that views five products counts once. Shown in the dashboard as Viewing Sessions.
  • Example: COUNT_DISTINCT(view_sessions)
• cart_sessions (sessions)
  • Sessions where a product from search results was added to cart.
• quantity_added_to_cart (items)
  • Items added to cart from search results.
• redirects (requests)
  • First-page search requests answered by a semantic redirect instead of results. Redirected requests are excluded from zero_results.
  • Example: COUNT_DISTINCT(redirects)
• redirect_rate (rate)
  • Share of first-page search requests answered by a redirect. Computed as redirects / requests.
  • Example: SHOW redirect_rate
• zero_results (requests)
  • First-page search requests that returned no results. Excludes redirected requests, SKU/barcode identifier-lane lookups, and requests where the shopper applied filters, so this metric reflects searches that genuinely failed to find relevant products. Filters injected by a request transform do not exclude a request. Track SKU/barcode lookups that matched nothing with identifier_lane_misses instead.
  • Example: SHOW zero_results
• zero_result_rate (rate)
  • Share of first-page search requests with no results. Computed as zero_results / requests.
  • Example: SHOW zero_result_rate
• transform_scoped_requests (requests)
  • First-page search requests constrained by filters injected by a request transform Add filter group action. Use this to see how much search traffic your transforms narrow.
  • Example: SHOW transform_scoped_requests
• transform_scoped_rate (rate)
  • Share of search requests constrained by transform filters. Computed as transform_scoped_requests / requests.
  • Example: SHOW transform_scoped_rate
• identifier_lane_lookups (requests)
  • First-page searches that query interpretation routed to the SKU/barcode identifier lane. Use this as the denominator when evaluating exact-code lookups.
  • Example: SHOW identifier_lane_lookups
• identifier_lane_misses (requests)
  • First-page SKU/barcode lookups that matched no product. The shopper typed an exact code that is not in the catalog. This is a catalog-coverage signal rather than a relevance failure, so these are tracked apart from zero_results.
  • Example: SHOW identifier_lane_misses
• identifier_lane_miss_rate (rate)
  • Share of SKU/barcode lookups that matched no product. Computed as identifier_lane_misses / identifier_lane_lookups.
  • Example: SHOW identifier_lane_miss_rate
• filtered_requests (requests)
  • Distinct search requests where the shopper applied at least one filter. Filters injected by a request transform do not count.
  • Example: COUNT_DISTINCT(filtered_requests)
• filter_usage_rate (rate)
  • Share of search requests with filters applied. Computed as filtered_requests / requests.
  • Example: SHOW filter_usage_rate
• filtered_zero_results (requests)
  • Filtered search requests that returned no products. Use this to find filter combinations that dead-end the shopper.
  • Example: COUNT_DISTINCT(filtered_zero_results)
• filtered_zero_result_rate (rate)
  • Share of filtered search requests with zero results. Computed as filtered_zero_results / filtered_requests.
  • Example: SHOW filtered_zero_result_rate
• ctr (rate)
  • Click-through rate: share of text search requests with at least one product click.
  • Example: SHOW ctr
• atc_rate (rate)
  • Add-to-cart rate: share of text search requests with at least one add to cart.
  • Example: SHOW atc_rate
• cvr (rate)
  • Conversion rate: share of clicked text search requests that produced an order.
  • Example: SHOW cvr
• purchase_rate (rate)
  • Share of text search requests that produced an order.
  • Example: SHOW purchase_rate
• aov (USD)
  • Average order value: blended revenue divided by blended order credit.
  • Example: SHOW aov
• rpi (USD)
  • Revenue per impression: blended revenue divided by engagement-covered text search requests.
  • Example: SHOW rpi
• hover_rate (rate)
  • Product hovers divided by product impressions.
  • Example: SHOW hover_rate
• touch_rate (rate)
  • Product touches divided by product impressions.
  • Example: SHOW touch_rate

​

Dimensions

• term: The search query string.
• query_type: Type of search query.
• language: Best-effort ISO language code inferred from the search query (for example, en, fr, pt-br). Empty when the query is too short or ambiguous to detect confidently, and only populated for text queries.
• num_results: Number of results returned.
• current_page: Current page index for paginated results (1-based).
• shopping_channel: The shopping channel (web or app).
• locale: Storefront locale code active for the request (e.g., en, fr, pt-br).
• currency: ISO 4217 currency code applied to the request (e.g., USD, EUR).
• session_returning: Session type — new or returning.
• customer_state: Whether the shopper is authenticated — signed_in or guest.
• customer_returning: Customer type — new or returning, based on prior order count.
• b2b_company: Shopify B2B company location identifier for the signed-in company account.
• billable: Whether this request is counted for billing.
• attribution_token: Token used to attribute downstream events/purchases.
• experiment_id: Experiment identifier.
• experiment_group: Experiment group/variant.
• device: Device category.
• os: Operating system.
• geo_country: Two-letter country code.
• geo_state: Up to three-letter province code.
• geo_city: City name as captured.
• marketing_source: UTM source.
• marketing_medium: UTM medium.
• marketing_campaign: UTM campaign.
• redirect_term: The matched term of the semantic redirect that answered the request. Only populated for redirected requests.
• filter_property: The shopper-applied filter property (for example, option.color, metafield.custom.material). Transform-injected filters are excluded.
• filter_operator: The operator used for the selection (in, notIn, eq, neq, range, geo, etc.).
• filter_value: The selected value. Populated for in, notIn, eq, and neq; NULL for range and geo operators, which emit one row per request without values.
• filter_name: Display-only merchant label for the filter property, resolved from the attribute’s nickname. Group by filter_property to populate this label.

​

Examples

FROM search_text
SHOW COUNT_DISTINCT(requests)
GROUP BY term
SINCE -7d

FROM search_text
SHOW SUM(total_sales)
GROUP BY geo_country
SINCE this_month

FROM search_text
SHOW zero_results
GROUP BY term
HAVING zero_results > 0
SINCE -7d

FROM search_text
SHOW identifier_lane_misses
GROUP BY term
HAVING identifier_lane_misses > 0
SINCE -30d

FROM search_text
SHOW COUNT_DISTINCT(requests)
GROUP BY language
SINCE -30d

FROM search_text
SHOW COUNT_DISTINCT(requests)
GROUP BY term
WHERE language = 'fr'
SINCE -30d

FROM search_text
SHOW COUNT_DISTINCT(redirects)
GROUP BY redirect_term
SINCE -30d

FROM search_text
SHOW redirect_rate
GROUP BY day
SINCE -30d

FROM search_text
SHOW COUNT_DISTINCT(filtered_requests)
GROUP BY filter_property
SINCE -30d

​

Next steps

• LayersQL syntax
• LayersQL functions
• Datasets overview