Average Order Value: Calculator and Decision Tree for Ecommerce
Higher AOV is not a win when contribution margin, conversion, returns, or repeat purchase deteriorate.



Average order value calculator
Average order value
$40.00
$48,000 realized revenue across 1,200 eligible orders.
This calculator runs in your browser and sends no inputs anywhere. Keep cohort rules and revenue treatment consistent when comparing periods.
Average order value (AOV) is revenue divided by orders, but it is comparable only when revenue, refunds, tax, shipping, discounts, and order status use the same definitions.
Table of Contents
- What is the AOV formula?
- Which revenue and order fields should you include?
- When is higher AOV actually worse?
- Which lever should you test?
- How should you monitor AOV?
- Sources
- FAQ
What is the AOV formula?
The formula is:
Average order value = revenue ÷ number of orders
Example: a store records $48,000 in qualifying revenue from 1,200 qualifying orders:
$48,000 ÷ 1,200 = $40 AOV
That means the average completed order produced $40 under your chosen revenue definition. It does not mean every customer spent $40, and it does not show whether the store is profitable.
Calculate AOV consistently:
- Choose a fixed period, such as a month or quarter.
- Define revenue as gross sales, net sales, or recognized revenue.
- Decide whether tax and shipping are included.
- State how discounts, refunds, returns, and cancellations are treated.
- Count only matching orders.
- Divide matching revenue by matching orders.
Suppose a store has $60,000 in gross merchandise sales, $6,000 in discounts, $3,000 in refunds, and $1,000 in cancelled orders. If it uses net merchandise revenue and excludes cancelled orders, the numerator is $50,000. With 1,250 completed orders, AOV is $40.
Never compare that figure with a prior month calculated from gross sales and all created orders; the difference may reflect measurement rather than customer behavior.
A higher AOV can still be worse. One hundred orders produce $5,000 in revenue at a 55% contribution margin, or $2,750. A bundle changes the result to 80 orders at $75, raising revenue to $6,000 and AOV from $50 to $75. But deeper discounts, extra fulfillment costs, and a lower-margin mix reduce contribution margin to 40%, or $2,400. AOV rises 50% while contribution margin falls $350. The bundle is worthwhile only if it also improves repeat purchase, acquisition cost, or inventory economics.
Which revenue and order fields should you include?
Write the definition before using AOV for decisions. These rules are a practical starting point.
| Field | Rule | Why it matters |
|---|---|---|
| Revenue basis | Choose gross or net consistently | Gross can overstate realized sales |
| Product discounts | Subtract discounts for realized spend | A $100 cart with $20 off yields $80 |
| Taxes | Usually exclude | Taxes collected are not merchandise revenue |
| Customer shipping | Include or exclude consistently | It can raise AOV without raising product value |
| Shipping cost | Track separately | Customer-paid shipping is not profit |
| Refunds/returns | Subtract for realized AOV | Pre-refund AOV can hide weak performance |
| Cancellations | Exclude from revenue and orders | They are not completed purchases |
| Partial refunds | Subtract refunded amounts | They change realized order value |
| Order count | Count matching paid or completed orders | Do not mix placed, fulfilled, and completed orders |
| Currency | Document conversion rules | Exchange rates distort comparisons |
| Reporting window | Use identical dates | Promotions and returns are timing-sensitive |
Keep two metrics for operational reporting. Booked AOV uses purchase-time revenue and orders for merchandising and checkout analysis. Realized AOV subtracts refunds, cancellations, and other adjustments to show collected value. Neither replaces contribution margin per order.
Separate subscriptions, one-time products, services, and wholesale orders before calculating a blended average. A mix shift can move the number without changing behavior. See SellerTrove’s pricing category.
When is higher AOV actually worse?
High average order value is not automatically better. The goal is profitable customer value, not the biggest checkout total.
Check contribution margin first. Subtract variable costs such as product cost, payment processing, picking and packing, shipping subsidies, commissions, and promotion costs. A bundle can raise revenue while reducing contribution dollars.
Check conversion rate next. A “free shipping over $100” threshold may lift AOV among completed purchases but discourage shoppers with $70 baskets. If conversion falls sharply, added basket value may not offset lost orders.
Check discount dependence. AOV may rise because customers respond to 25%-off bundles while the business buys revenue at an unacceptable cost. Compare incremental contribution margin, not sales alone. The discount break-even calculator can help estimate the extra volume required.
Check returns and refunds by product, bundle, customer segment, and acquisition source. A high-value order with a high return rate can produce attractive booked AOV but poor realized AOV.
Check repeat purchase. A larger first order can create overbuying, buyer’s remorse, or a delayed next purchase, especially for consumables and replenishment products.
Use this rule: lifting AOV while margin, conversion, or repeat purchase falls is not a win.
Evaluate revenue per order, contribution margin per order, conversion rate, and repeat purchase rate together.
Which lever should you test?
Use the decision tree below to select one focused test.
-
Complementary products already sell together: Test bundles or “complete the set” recommendations. Protect margin and track attach rate, discount cost, fulfillment cost, and contribution margin.
-
Carts cluster near a threshold: Test free shipping or a gift above current AOV, with a relevant add-on. Track conversion, threshold attainment, shipping cost, and profit per visitor.
-
Customers buy one core product: Test relevant product-page, cart, or post-purchase cross-sells. Post-purchase offers can protect initial conversion.
-
Customers choose cheaper options: Improve hierarchy, comparison content, demonstrations, and defaults before discounting.
-
First orders are healthy but later orders are weak: Test replenishment reminders, education, lifecycle email, loyalty, and recommendations. See email marketing strategy.
-
Low AOV comes from bargain-only traffic: Review targeting, landing pages, offer structure, and channel cohorts instead of forcing bundles.
Use competitive pricing strategy guidance to check whether your price architecture supports the basket behavior you want.
How should you monitor AOV?
Report AOV by new versus returning customer, acquisition channel, device, geography, product category, promotion exposure, and subscription status rather than relying on one store-wide number.
Use cohorts to compare customers acquired in the same week or month. Track first-order AOV, 30-day revenue, repeat purchase rate, refunds, and contribution margin so a temporary promotion does not appear to be a durable improvement.
Pair the average with median order value and the full order-value distribution. A few wholesale-sized orders can raise the average while most shoppers spend much less.
A practical dashboard includes:
- Booked and realized AOV
- Orders and conversion rate
- Gross and net revenue
- Contribution margin per order
- Discount rate
- Refund and return rate
- Items per order
- Bundle or cross-sell attach rate
- Repeat purchase rate
- Revenue and margin by cohort
Ecommerce reports and analytics platforms provide order data, but the business must define the metric. There is no universal good AOV; the right level depends on category, price point, traffic source, shipping model, margins, purchase frequency, and customer expectations.
Use SellerTrove’s Stack Builder to organize reporting systems, and the SellerTrove report to turn measurements into decisions. The best target supports profitable acquisition, a strong customer experience, and repeat demand.
Sources
FAQ
Is AOV the same as customer lifetime value?
No. AOV measures one order. Customer lifetime value estimates total customer value across purchases, usually considering retention, margin, and sometimes acquisition cost. Higher AOV can support higher lifetime value, but oversized or irrelevant orders may reduce repeat purchase.
Should refunds be included in AOV?
Use two versions when refunds matter. Booked AOV includes original order value and evaluates checkout behavior. Realized AOV subtracts refunds and cancellations and reflects collected revenue. Label both clearly and do not compare one with the other.
What is a good AOV?
There is no universal benchmark. A good AOV supports contribution margin, fulfillment, acquisition, and service costs while preserving conversion and repeat purchase. Compare it with your own history, segments, and unit economics.
How can I raise AOV without discounting?
Recommend complementary products, create useful bundles at full or near-full price, offer premium versions, add quantity options, improve merchandising, and use post-purchase cross-sells. The test succeeds only when contribution margin and customer experience improve with order value.
We track pricing and new tools across the whole catalog. Get an email when prices move or a better tool launches.