Skip to main content
Use this guide to find which products drive the most conversions and revenue, and how that changes by channel or acquisition source.

In the dashboard

Open the Product Performance module for orders and revenue by product, variant, and SKU over time. Set the date range and channel filters at the top of the page first. Funnel-stage conversion (views to add-to-cart to purchase) is not in the dashboard; use the warehouse recipe below.

Suggested workflow

  1. Start with valid orders: is_order_sm_valid = TRUE.
  2. Use order lines to aggregate product performance:
    • Orders containing product
    • Net revenue attributed to product lines
    • Quantity sold
  3. Add slices:
    • Channel (sm_channel)
    • New vs repeat customer
    • Discounted vs non-discounted orders
Tip: If you’re looking for funnel-stage conversion (views → add to cart → purchase), you’ll want funnel events tables instead of order lines.