Skip to main content
  • Label: Collections
  • Description: Analytics for collection browsing and conversions.
  • Default group key: collection_handle

​
Metrics

  • requests (requests)
    • Number of collection browse requests.
    • Example: COUNT_DISTINCT(requests)
  • total_sales (USD)
    • Sales attributed to collection browsing.
    • Example: SUM(total_sales)
  • quantity_purchased (items)
    • Number of items purchased from collection browsing.
    • Example: SUM(quantity_purchased)
  • view_sessions (sessions)
    • Sessions where a collection page was viewed.
  • cart_sessions (sessions)
    • Sessions where items from a collection browse were added to cart.
  • quantity_added_to_cart (items)
    • Items added to cart from collection browsing.

​
Dimensions

  • collection_handle: The collection handle.
  • collection_title: Resolved collection title.
  • collection_id: Resolved collection ID.
  • sort_order_id: The sort order ID used for the collection.
  • sort_order: The sort order applied.
  • rule_id: The merchandising rule applied.
  • applied_filters: Serialized applied filters on the browse request.
  • shopping_channel: The shopping channel (e.g., online_store).
  • attribution_token: Token used to attribute downstream events/purchases.
  • 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.
  • device: Device category.
  • os: Operating system.

​
Examples

Collection impressions by handle (last 7 days) 
FROM collections
SHOW COUNT_DISTINCT(requests)
GROUP BY collection_handle
SINCE -7d
Collection revenue by sort order (this month) 
FROM collections
SHOW SUM(total_sales)
GROUP BY sort_order_id
SINCE this_month
Collection performance by merchandising rule 
FROM collections
SHOW COUNT_DISTINCT(requests), SUM(total_sales)
GROUP BY rule_id
SINCE -7d

​
Next steps