Metric 01 · orders ⨝ order_items
Total Revenue
Delivered orders only · excludes cancelled & refunded
$0
—
delivered orders0
avg line value$0
peak day—
Metric 02 · AVG(order_total)
Avg Order Value
$0
—
median$0
largest order$0
Rollups · same filtered scope
Volume & Health
Delivered orders
0
—New customers
0
—Units sold
0
—Refund rate
0%
—Series · date_trunc(month)
Revenue & Order Volume
Metric 05 · GROUP BY category
Category Performance
Metric 03 · ORDER BY units_sold DESC LIMIT 5
Top 5 Best-Sellers
Ranked by quantity sold in range
Metric 04 · window SUM() OVER ()
Customer Growth
New sign-ups per bucket with running cumulative total
Scope control · WHERE status filter audit
Order Status Mix
Only status = 'delivered' contributes to revenue metrics above
Detail · top 25 orders by gross value
Order Ledger
Console · executed statements this run
Query Log & Schema
Referenced schema