Skip to main content
  • Label: Search (Similar)
  • Description: Similar item search analytics.
  • Default group key: product_id

​
Metrics

  • requests (requests)
    • Number of similar search requests.
    • Example: COUNT_DISTINCT(requests)
  • results_count (results)
    • Results returned per search request.
    • Example: AVG(results_count)
  • total_sales (USD)
    • Sales attributed to similar search.
    • Example: SUM(total_sales)
  • quantity_purchased (items)
    • Number of items purchased from similar search traffic.
    • Example: SUM(quantity_purchased)
  • view_sessions (sessions)
    • Sessions where a product was viewed from similar search results.
  • cart_sessions (sessions)
    • Sessions where a product from similar search results was added to cart.
  • quantity_added_to_cart (items)
    • Items added to cart from similar search results.

​
Dimensions

  • product_id: Product ID used as the similar search anchor.
  • query_type: Type of search query.
  • num_results: Number of results returned.
  • 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

Similar search requests by product (last 7 days) 
FROM search_similar
SHOW COUNT_DISTINCT(requests)
GROUP BY product_id
SINCE -7d
Similar search revenue by country (this month) 
FROM search_similar
SHOW SUM(total_sales)
GROUP BY geo_country
SINCE this_month

​
Next steps