Skip to main content
  • Label: Search (Text)
  • Description: Text search analytics.
  • Default group key: term
When you group search text metrics by term, query variants are automatically consolidated into a single canonical form. This includes:
  • Spelling and plural variations — searches for “charm”, “charms”, and “charmed” are grouped together under one entry.
  • Autocomplete prefixes — keystroke-by-keystroke terms that users type before reaching their final query (for example, “cro”, “cros”, and “cross”) are rolled up into the longest matching term.
When both apply, prefixes resolve through the cluster mapping. For instance, if “cross” maps to the canonical term “cross necklace”, then “cro” and “cros” are also attributed to “cross necklace”.After consolidation, results are re-sorted so the highest-volume terms appear first. This gives you a clearer picture of true search demand without noise from partial keystrokes, spelling variations, or plural forms.

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

​
Dimensions

  • term: The search query string.
  • query_type: Type of search query.
  • num_results: Number of results returned.
  • current_page: Current page index for paginated results (1-based).
  • shopping_channel: The shopping channel (e.g., online_store).
  • 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.

​
Examples

Search requests by term (last 7 days) 
FROM search_text
SHOW COUNT_DISTINCT(requests)
GROUP BY term
SINCE -7d
Search revenue by country (this month) 
FROM search_text
SHOW SUM(total_sales)
GROUP BY geo_country
SINCE this_month
Top search terms with zero results 
FROM search_text
SHOW COUNT_DISTINCT(requests)
GROUP BY term
WHERE num_results = 0
SINCE -7d

​
Next steps