Collections dataset

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.

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

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

⌘I