Promotions

Discounted order lines and their promotional revenue.

Example

FROM promo
  SHOW discounted_units, total_units
  GROUP BY product
  ORDER BY discounted_units DESC

Metric	Type	Description
`discounted_units`	Number	Units sold at a discount in the period.
`total_units`	Number	Total units sold in the period.
`discount_rate`	Percent	Share of units sold at a discount (discounted ÷ total units).
`discount_amount`	Currency	Money discounted in the period, including markdowns (where Shopify reporting data is available).
`discount_per_unit`	Currency	Average money discounted per unit sold in the period.

Dimension	Description
`product`	Product with image, rendered as a single cell (variants roll up).
`vendor`	Product vendor.
`product_type`	Shopify product type.

Filter	Type	Description
`collection`	Number	Restrict to products in the selected collection(s).
`category`	Text	Restrict to products in the selected category (matches sub-categories too).
`sales_channel`	Number	Restrict to products published to the selected sales channel.
`region_catalog`	Number	Restrict to products in the selected region (market) catalog.
`b2b_catalog`	Number	Restrict to products in the selected B2B (market) catalog.
`company_location_catalog`	Number	Restrict to products in the selected company-location catalog.
`vendor`	Text	Product vendor.
`product_type`	Text	Shopify product type.
`sku`	Text	Variant SKU.