Average Order Value Calculator: Formula & How to Use

This calculator works out your Average Order Value (AOV) — the mean amount each customer spends per order — from just two numbers: total revenue and number of orders. You enter those two figures, and you get the AOV instantly, plus a quick check on orders per customer if you also provide customer count. It’s the standard e-commerce metric that tells you whether customers are spending more or less over time.

Formula

The average order value is simply total revenue divided by the number of orders:

AOV = Total Revenue ÷ Number of Orders

• Total Revenue – the sum of all money brought in from sales over a period (in dollars, euros, etc.)
• Number of Orders – the count of individual purchase transactions in that same period
• AOV – the average revenue per order (same currency as revenue)

The optional orders-per-customer output is just orders divided by customers. It shows how many times the average person bought from you.

Worked Example

Using the default values: revenue = $10,000, orders = 200, customers = 150.

1. Divide revenue by orders: $10,000 ÷ 200 = $50.00
2. That’s the AOV: $50.00 per order.
3. For orders per customer: 200 ÷ 150 = 1.33 (rounded to 2 decimals).

So with $10,000 in sales across 200 orders, the average customer spent $50 each time they ordered, and on average each customer placed about 1.33 orders.

Why AOV Matters

AOV is a core health check for any business that sells online or in person. It tells you how much revenue you generate per transaction, which directly affects your profitability. If you can raise AOV without increasing customer acquisition costs, your bottom line improves. Marketers use it to decide how much they can spend on ads; product teams use it to plan bundles or free-shipping thresholds. It’s also a key input for forecasting revenue: if you know your typical order value and how many orders you expect, you can estimate sales.

Compare AOV across different periods (monthly, quarterly) or customer segments (new vs. returning) to spot trends. A rising AOV might mean customers are adding more items or choosing pricier options. A falling AOV could signal more discounting or a shift toward cheaper products.

How to Increase Average Order Value

Once you know your AOV, you can work on improving it. Common tactics include:

• Free shipping thresholds – offer free shipping over a certain amount to encourage larger baskets.
• Bundling – sell complementary products together at a slight discount.
• Upselling/cross-selling – recommend higher-end versions or add-ons at checkout.
• Volume discounts – give a percentage off when customers buy more units.
• Minimum order discounts – e.g., “spend $75, get 10% off.â€�

Each tactic aims to increase the numerator (revenue) without proportionally increasing the number of orders. Keep an eye on customer satisfaction though – pushing too hard can backfire.

Common Mistakes and Misconceptions

One frequent error is mixing up revenue with profit. AOV uses gross revenue, not profit. If you use net profit, you’ll get a misleadingly low number. Another mistake is including refunds or cancellations inconsistently. Decide whether to use gross or net revenue (after returns) and stick to it for all comparisons. Also, be careful with the time period – always specify it (e.g., “AOV for March�).

A common misconception is that AOV is the same as average transaction value. They are identical. Another is that a high AOV is always good. That’s not true if it comes from a few huge orders while most customers buy little. Look at the distribution, not just the average.

Finally, don’t confuse AOV with customer lifetime value (LTV). AOV is per order; LTV is total revenue from a customer over their entire relationship with you. LTV = AOV × purchase frequency × customer lifespan.

Limitations of the Metric

AOV gives you a single number, but it hides important details. It doesn’t tell you about order frequency, customer retention, or profit margins. Two businesses can have the same AOV but very different economics – one might have high margins and low frequency, the other low margins and high frequency. Also, AOV can be skewed by a few very large orders (e.g., B2B bulk purchases) or by heavy discounting. Always pair AOV with other metrics like conversion rate, repeat purchase rate, and gross margin.

For subscription businesses, AOV is less meaningful because revenue is recurring; they often use average revenue per account (ARPA) instead. For marketplaces, AOV might include fees or not, depending on how you define revenue.

How to Use the Calculator

Enter your total revenue and number of orders for the period you care about. The calculator instantly gives you the AOV. If you also enter the number of unique customers, it shows orders per customer. Use the same currency for revenue as you want for AOV. The result is rounded to two decimals, which is standard for money. You can use any time period – a day, a week, a month, a year – as long as revenue and orders cover the same period.

Frequently Asked Questions

What is a good average order value?

There’s no universal “good� number – it varies hugely by industry and business model. A luxury goods store might have an AOV of $500, while a fast-food restaurant might be $15. The best way to judge is to compare your AOV to your own historical data and to competitors in your niche if you can find public numbers.

How do I calculate AOV in Excel or Google Sheets?

Simply divide total revenue by total orders. If revenue is in cell A1 and orders in B1, type =A1/B1 in another cell. Format the result as currency. That’s it – no complex formula needed.

Should I include shipping fees in AOV?

It depends on what you want to measure. If you include shipping revenue (what customers pay for shipping) in your total revenue, then yes, it’s part of AOV. If you’re looking at product revenue only, exclude shipping. Be consistent across comparisons.

What is the difference between AOV and average basket size?

Average basket size refers to the number of items per order, not the monetary value. AOV is about money; basket size is about units. They often move together, but not always – if customers buy more items but cheaper ones, basket size goes up while AOV might stay flat.

Can AOV be negative?

No, not in normal use. Revenue and orders are non-negative, so AOV is zero or positive. A negative AOV would only happen if you used net revenue after heavy refunds that exceed sales, which isn’t standard.

How often should I track AOV?

Most businesses track it monthly or quarterly. Daily tracking can be noisy due to weekends or promotions. If you run frequent campaigns, track it per campaign to see which ones lift AOV.

Related

• Elo Probability Calculator: How to Use It
• EFW Percentile Calculator: Fetal Weight Explained
• Dutch Lipid Percentile Calculator Guide

in t | Total revenue | $ | 10000 | 0
in n | Number of orders | - | 200 | 0
in c | Number of customers | - | 150 | 0
out aov | Average order value | $ | t / n | 2
out opc | Orders per customer | - | n / c | 2