Sales dataset

• Label: Sales
• Description: Order-level metrics from the purchases table.
• Default group key: transaction_id

​

Metrics

• total_sales (USD)
  • Sales after discounts and before taxes/returns.
  • Example: SUM(total_sales)
• quantity_purchased (items)
  • Number of items purchased.
  • Example: SUM(quantity_purchased)
• orders (orders)
  • Unique orders (transaction_id).
  • Example: COUNT_DISTINCT(orders)
• line_items (items)
  • Unique line items purchased.
  • Example: COUNT_DISTINCT(line_items)
• customers (customers)
  • Unique customers who purchased.
  • Example: COUNT_DISTINCT(customers)

​

Dimensions

• transaction_id: Shopify order ID.
• line_item_id: Shopify line item ID.
• product_id: Shopify product ID.
• variant_id: Shopify variant ID.
• customer_id: Shopify customer ID.
• session_id: Session identifier derived from the order.
• geo_country: Country from the shipping address.
• geo_state: State or province from the shipping address.
• geo_city: City from the shipping address.
• shopping_channel: Channel of purchase (web, app, or retail). Resolves to retail whenever the order has a retail_location_id; otherwise reports the raw channel from the originating request.
• retail_location_id: Retail location ID for the purchase. NULL on non-retail orders. Use retail_location_id IS NULL to exclude retail orders, or filter by a specific ID to scope to one store.
• locale: Storefront locale code active on the originating request (e.g., en, fr, pt-br).
• currency: ISO 4217 currency code of the originating request (e.g., USD, EUR).
• session_returning: Session type at the time of the originating request — new or returning.
• customer_state: Whether the shopper was authenticated at purchase — 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.
• marketing_source: UTM source.
• marketing_medium: UTM medium.
• marketing_campaign: UTM campaign.
• device: Device category derived from User-Agent.
• browser: Browser family from User-Agent.

​

Examples

FROM sales
SHOW SUM(total_sales)
GROUP BY geo_country
SINCE -30d

FROM sales
SHOW COUNT_DISTINCT(orders)
GROUP BY marketing_source
SINCE this_month

FROM sales
SHOW COUNT_DISTINCT(customers)
GROUP BY shopping_channel
SINCE past_90_days

FROM sales
SHOW COUNT_DISTINCT(orders)
WHERE shopping_channel = 'retail'
SINCE -7d

FROM sales
SHOW COUNT_DISTINCT(orders)
WHERE shopping_channel != 'retail'
SINCE -7d

​

Next steps

• LayersQL syntax
• LayersQL functions
• Datasets overview