In the dashboard
Open the Product Performance module. It reports at the line-item level (product, variant, SKU) and shows how specific products and product types perform over time. Set the date range and channel filters at the top of the page first. The rest of this page covers the same analysis in the warehouse.Recommended tables
- Order lines:
obt_order_lines - Orders (for filtering/segmentation):
obt_orders
Suggested workflow
- Filter to valid orders (
is_order_sm_valid = TRUE). - Aggregate by product (and optionally variant) to compute:
- Orders containing product
- Quantity sold
- Net revenue
- Add slices:
- Channel (
sm_channel) - New vs repeat
- Discount codes
- Channel (

