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 (

