Completed-order revenue, aggregated daily by customer segment and country. "Revenue-eligible" excludes orders in cancelled or refunded status — the same definition Finance uses for the monthly GMV report. AOV is exposed as a formula measure so callers don't recompute it from a multi-bucket window (sum-of-averages bias).
- highRecomputing AOV from a multi-bucket result
`avg_order_value` is a formula measure (sum(revenue) / sum(paid_orders_count)) — correct under any GROUP BY. Dividing two already-aggregated columns client-side yields a different number when the buckets have unequal sizes.
- highTreating `unique_customers_daily` as distinct over a window
It is a SUM of per-day distinct counts — a customer who orders on three days contributes 3. For true distinct-over-window, use the `customer_health` metric's `customers_count` measure.
- mediumMixing `orders_count` with `revenue` filters
`orders_count` includes cancelled + refunded; `revenue` and `paid_orders_count` exclude them. Picking the wrong pair inflates conversion / AOV ratios.
- “What was revenue last month, broken down by segment?”
- “Top 5 countries by revenue this quarter, vs last year.”
- “AOV trend for enterprise customers over the last 8 weeks.”
- customer_health
Per-customer snapshot — answers "who drove the revenue number" and gives a true distinct customer count.
- support_volume
Cost-side counterpart. Use together when answering "are sales coming with extra support load?"
- product_reviews
Quality leading indicator — drift here often precedes revenue softness.
- dashboardRevenue dashboard (Metabase)
- runbookRevenue definition runbook
- Finance GMV report (monthly close)last verified · 2026-04-30drift · 0.40%