Products dataset

Each row of this dataset represents either a sale or a session associated with a product in a 15 minute span, per currency. Sales events will have the currency code populated, but session events will have NULL currency, so sales data and sessions data are aggregated to distinct rows. As such, each row represents a 15 minute rollup of either sessions data or sales data. Further, sales data is also aggregated at the currency grain, so there might be multiple sales rows per 15 minute span if there are sales in multiple currencies during that span.

Since sales and sessions exist on different rows in the underlying dataset, filtering on one will remove all rows belonging to the other. For example, the following query will result in sum(gross_sales) = 0 because all sale lines will be removed by the WHERE view_sessions > 0 filter.

• view_purchase_sessions: The count of sessions with a product page view and purchase
• view_cart_checkout_purchase_sessions: The count of sessions with a product page view, cart addition, checkout started and purchase

view_cart_checkout_purchase_sessions can be zero when view_purchase_sessions isn't zero, if the cart addition or the checkout being started wasn't captured by the session. This can happen because some stores don’t have carts. Similarly, some stores don’t have product pages, so the first step in their conversion funnels is always zero.

Numeric values are the base numbers in the dataset. They’re typically aggregated using ShopifyQL functions like sum.

Aggregates are predefined calculations of numeric values, to replicate metrics that are available throughout Shopify. Aggregates can be grouped or filtered by any of the dimensional attributes.