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)
  • Sales attributed to search.
  • Example: SUM(total_sales)
• quantity_purchased (items)
  • Number of items purchased from search traffic.
  • Example: SUM(quantity_purchased)
• view_sessions (sessions)
  • Sessions where a product was viewed from search results.
  • 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 and SKU/barcode identifier-lane lookups, so this metric reflects searches that genuinely failed to find relevant products. 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
• 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

​

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.

​

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
SINCE -7d

FROM search_text
SHOW identifier_lane_misses
GROUP BY term
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

​

Next steps

• LayersQL syntax
• LayersQL functions
• Datasets overview