Find your average order value in seconds — the lever behind profitable ad spend and smarter marketing.
What is AOV? Average order value meaning
Average order value (AOV) is the average amount a customer spends in a single order. In ecommerce and digital marketing, AOV is one of the most useful numbers because it directly affects how much you can afford to pay for traffic — and how profitable each order is.
AOV formula: AOV = Total revenue ÷ Number of orders
If you did $24,000 in sales across 800 orders, your AOV is $24,000 ÷ 800 = $30.
AOV in digital marketing — why it's one of the first numbers marketers check
In paid media, AOV sets the ceiling on what you can bid. If your AOV is $30 and your gross margin is 40%, you have $12 of gross profit per order to cover ad spend, overhead, and still leave net profit. That's why raising AOV is the fastest way to make ad campaigns profitable without touching your ad budget or creative. In performance marketing, AOV is read alongside ROAS and CAC — if ROAS is weak, check whether AOV is the bottleneck before cutting spend or blaming the ads.
AOV calculator Excel — how to track in a spreadsheet
If you track AOV in Excel or Google Sheets, set up a simple table:
Month | Total Revenue | Orders | AOV
January | $24,000 | 800 | =B2/C2 → $30
The formula is =Total_Revenue / Orders in any spreadsheet. To calculate AOV across multiple months, sum revenue and orders separately first, then divide — don't average monthly AOVs, as that gives incorrect results when month-to-month order counts differ. For a quick check, use this calculator; for ongoing tracking, build the spreadsheet once and update monthly.
Why AOV matters more than it looks
Every paid channel has a cost per order. If your AOV is $30 and it costs you $25 to acquire an order, you're on thin ice. Raise AOV to $45 and the same $25 acquisition cost suddenly looks healthy. That's why growing AOV is often the fastest way to make previously unprofitable ad campaigns work — you're increasing revenue per order without spending a cent more on ads.
How to increase AOV
The proven levers: product bundles, volume discounts ("buy 2 get 10% off"), free-shipping thresholds set just above your current AOV, upsells and cross-sells at checkout, and order minimums for promotions. Track AOV monthly — small, steady increases compound into meaningfully better unit economics across your whole ad budget.
Frequently asked questions
How do you calculate average order value?
Divide total revenue by the number of orders over the same period. AOV formula: AOV = Total Revenue ÷ Number of Orders. For example, $24,000 in revenue from 800 orders is an AOV of $30. Use orders, not customers — a single customer can place multiple orders.
How do I calculate AOV in Excel?
Use the formula =Total_Revenue / Orders in any cell. For monthly tracking, set up columns for each month with total revenue in one row and order count in another, then apply the division formula across. To calculate AOV for the full year, sum all monthly revenues and all monthly orders first, then divide — do not average the monthly AOVs, as that skews the result when order volumes differ across months.
What is AOV in digital marketing?
In digital marketing and ecommerce, AOV (average order value) is a core metric that sets the ceiling on profitable ad spend. If AOV is $30 with a 40% margin, you get $12 gross profit per order — that's your maximum sustainable cost per acquisition before overhead. Marketers track AOV alongside [ROAS](/roas-calculator/) and [CAC](/cac-calculator/) because raising AOV through upsells, bundles, or pricing improves both metrics without changing ad spend.
What is a good AOV?
There is no universal benchmark; it depends entirely on what you sell. A good AOV is one that comfortably exceeds your cost to acquire an order. Focus on improving your own AOV over time rather than comparing it to unrelated stores.
How can I increase my average order value?
Use product bundles, volume discounts, free-shipping thresholds set just above your current AOV, and checkout upsells or cross-sells. These raise revenue per order without increasing ad spend.
What is the difference between AOV and revenue per customer?
AOV measures spend per order; revenue per customer measures spend per buyer across all their orders. A customer who orders three times contributes to one customer but three orders, so revenue per customer is usually higher than AOV.
Why does AOV matter for ROAS?
Higher AOV means each conversion generates more revenue for the same ad spend, which directly improves ROAS. Raising AOV through bundles, upsells, or free-shipping thresholds is often the fastest way to make ad campaigns profitable without increasing budget.
Should I use AOV or revenue per customer for planning?
Use AOV when optimizing checkout, pricing, and ad efficiency per conversion. Use revenue per customer when modeling retention, subscriptions, or repeat purchase behavior. Both matter, but they answer different questions.