MetricKPI Compass StandardApprovedInternal
Average Order Value
Average revenue generated per completed order.
Unit
currency_per_order
Aggregation
ratio
Definition
Average revenue generated per completed order.
Formula
Revenue / Orders
Assumed fields: {{numerator_expression}}{{denominator_expression}}{{numerator_measure}}{{denominator_measure}}
Return blank or null when the denominator is zero. Confirm filters, grain, and inclusion rules before production use. Tableau, Looker (LookML), and Datorama templates are generated from the canonical formula — confirm field references before production use.
Standard reference formula for Average Order Value.
Sources
No sources recorded yet.