Marketing & Advertising
Average Order Value Calculator
Calculate gross AOV, adjusted net order revenue, net AOV, and refund share for a selected reporting period. Use the gross-to-net reconciliation to compare storefront, payment, and accounting reports, then evaluate whether changes in basket value come from merchandise, shipping policy, discounts, returns, or a changing order mix.
Gross average order value-
Net order revenue-
Net average order value-
Refund share of revenue-
Decision view
Gross-to-net order value bridge
Gross-to-net order value bridgeOrder revenue is reconciled through refunds and shipping revenue before gross and net value per completed order are compared.
Exact scenario comparisonNumber of orders changes while all other entered assumptions remain constant.
| Number of orders | Gross average order value | Net order revenue | Net average order value | Refund share of revenue |
|---|
How to use Average Order Value Calculator
- Choose one reporting period and enter recognized order revenue, the matching completed-order count, refunds and credits, and shipping revenue collected from those same orders.
- Compare gross AOV with net AOV to see how refunds and shipping revenue change the value retained per completed order.
- Keep the same order-status, currency, tax, cancellation, and refund conventions when comparing channels or periods.
Calculator guide
Understanding Average Order Value Calculator
Average order value is meaningful only when revenue adjustments and order counts refer to the same transaction population. This calculator preserves gross merchandise revenue, refunds, shipping revenue, and completed orders as separate inputs so the reported AOV can be reconciled rather than treated as a platform black box.
Calculation method
How the calculation works
Divide gross and adjusted order revenue by order count, keeping refunds and shipping revenue visible in the reconciliation. Divide gross and adjusted order revenue by order count, keeping refunds and shipping revenue visible in the reconciliation.
Metric governance
Define the AOV numerator before using the trend
Different dashboards can all display a number called AOV while using different revenue conventions.
Publish the numerator definition beside every AOV dashboard so teams do not optimize incompatible versions of the metric.
Worked situations
Practical examples
- $420,000 of order revenue across 5,600 completed orders produces gross AOV of $75.00.
- After subtracting $18,000 of refunds and adding $12,500 of shipping revenue, adjusted net order revenue is $414,500 and net AOV is about $74.02.
- A higher AOV accompanied by a sharply higher refund rate may not represent better merchandising or stronger retained revenue.
Better inputs
Useful tips
- Exclude cancelled, test, fraudulent, and duplicate orders from both revenue and order count using the same rule.
- Decide whether tax, tips, duties, gift-card sales, and shipping belong in the numerator before comparing AOV with another report.
- Segment AOV by new versus returning customer, device, country, acquisition source, product family, and promotion to locate the actual driver.
Before relying on the result
Limitations and common mistakes
- AOV does not measure gross margin, acquisition cost, fulfillment cost, repeat purchasing, or customer lifetime value.
- Refund timing can cross reporting periods, causing current-period credits to relate to earlier-period orders.
- A single blended AOV can hide large changes in product mix, order frequency, discount depth, and customer composition.
Reference
Key terms
- Gross AOV
- Entered order revenue divided by the matching number of completed orders before the displayed refund and shipping adjustments.
- Net order revenue
- Entered order revenue less refunds and credits, plus entered shipping revenue.
- Net AOV
- Adjusted net order revenue divided by the same completed-order count.
- Refund share
- Entered refunds and credits divided by entered order revenue.
Important note
Calculated from the entered campaign values. Validate attribution, incrementality, lag, margin, and observed source data before making decisions.
Frequently asked questions
Should shipping revenue be included in AOV?
It depends on the decision. Include it for customer-paid order value and exclude it for merchandise-only AOV; use the same convention in every comparison.
Should refunded orders remain in the order count?
The numerator and denominator need one documented policy. A common net-revenue view retains completed orders and subtracts refunds, while a net-order view may remove fully refunded orders.
Why can AOV rise while revenue falls?
Order volume may decline more than value per remaining order increases. AOV should be reviewed with orders, conversion, revenue, margin, and customer mix.
Is higher AOV always better?
No. Heavy bundling or discounting can raise basket value while reducing margin, purchase frequency, conversion, or retention.