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.Recommended tables
- Orders:
obt_orders - Order lines:
obt_order_lines
Suggested workflow
- Start with valid orders:
is_order_sm_valid = TRUE. - Use order lines to aggregate product performance:
- Orders containing product
- Net revenue attributed to product lines
- Quantity sold
- Add slices:
- Channel (
sm_channel) - New vs repeat customer
- Discounted vs non-discounted orders
- Channel (

