Products dataset

This page outlines the definition, type, and utility of each ShopifyQL column including numeric values, aggregates, and dimensional attributes.

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

Name Type Definition
view_sessions number The sessions where the product was viewed
cart_sessions number The sessions where the product was added to cart
checkout_sessions number The sessions where the product reached checkout
purchase_sessions number The sessions where the product was purchased
view_and_cart_sessions number The sessions where the product was viewed and added to cart
view_cart_and_checkout_sessions number The sessions where the product was viewed, added to cart, and reached checkout
view_cart_checkout_and_purchase_sessions number The sessions where the product was viewed, added to cart, reached checkout, and purchased
checkout_and_purchase_sessions number The sessions where the product reached checkout and was purchased
view_and_purchase_sessions number The sessions where the product was viewed and purchased
quantity_added_to_cart number The number of items added to the cart from online store sessions
quantity_purchased number The number of items purchased from online store sessions
gross_sales price The value of sales before factoring in discounts, returns, shipping, or taxes
ordered_product_quantity number The number of items ordered
returned_product_quantity number The number of items returned
net_product_quantity number The items ordered, less the number of items returned
discounts price The amount taken off a product's regular price
returns price The value of returned products
net_sales price The value of sales after factoring in discounts and returns, but before taxes
taxes price The total amount of taxes charged
product_price price The price the product sold for before discounts
product_price_after_discounts price The price the product sold for after discounts

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.

Name Type Definition
view_to_cart_rate rate The ratio of sessions added to cart after viewing
Formula: SUM(view_and_cart_sessions)/SUM(view_sessions)
view_and_cart_to_checkout_rate rate The ratio of sessions which reached checkout after viewing and adding to cart
Formula: SUM(view_cart_and_checkout_sessions)/SUM(view_and_cart_sessions))
view_cart_checkout_to_purchase_rate rate The ratio of sessions purchased after viewing, adding to cart and reaching checkout
Formula: SUM(view_cart_checkout_and_purchase_sessions)/SUM(view_cart_and_checkout_sessions)
checkout_to_purchase_rate rate The ratio of sessions purchased after reaching checkout
Formula: SUM(checkout_and_purchase_sessions)/SUM(checkout_sessions)
view_to_purchase_rate rate The ratio of sessions purchased after viewing
Formula: SUM(view_and_purchase_sessions)/SUM(view_sessions)
Name Type Definition
product_title string The name of a product
product_type string The label describing the nature of the product
product_id number The product identifier used in Shopify