Schedule your FREE growth strategy session

If your website generates over $15k per month, let’s chat. We’ll discuss your goals and figure out how we can help your business get to its next stage of revenue and growth. (Others charge for this level of consultation.)

Fix your GMC Suspension

We’ve gotten Merchant Center suspensions lifted for our clients with a 100% success rate. We know what we’re doing here.

Client feedback

Mac Steer
Mac SteerSims Direct Owner
Read More
“Almost $4 million in revenue from basically nothing.”
Matt Childs
Matt ChildsWine Stash
Read More
“[They] helped us to more than 10x our conversions while decreasing the amount we're spending on Adwords almost every day.”
Ellen McCaleb
Ellen McCalebHeadwaters Studio
Read More
"My conversion rate went from like 1.83 to over 9%."
Pat Langley
Pat LangleyVaikobi
Read More
“We've been using them for just over a year now and we've had incredible success. We've grown our online business 145% and achieved a ROAS of 4.9. Fantastic return on investment!”
Kristabel
KristabelVerso
Read More
"Our ROI's went from 88% to 275%, which is huge."

Over 1.4 million views and growing fast on YouTube

We’re proud to be helping thousands of ecommerce business owners by giving the most digestible, battle-tested advice to be found online about succeeding with Google Ads.

Be sure to follow our channel to stay in the loop.

pexels-karolina-grabowska-5632403

How to Calculate AOV (Average Order Value) for Your Ecommerce Store

This post is going to explain what Average Order Value (AOV) is, how to calculate AOV, and what you can do to improve it.

Ecommerce store owners, big and small, are constantly trying to improve their sales figures and run stores that have impressive profit margins. To do this, they focus their attention on the data. When you’re running ads you’ll be focusing on engagement and conversion rates, but beyond this – when you’ve actually got customers to your ecommerce store – you’ll be focusing on metrics like Average Order Value.

What is Average Order Value?

Average Order Value (AOV) is how much, on average, a customer spends when they place an order on your store. This value can represent all of the orders that have been placed, orders that were placed in specific countries, or a single category of products.

But why is this metric important? Because it’s another indicator of your store’s performance. The higher your AOV, the more profit your store is generating.

Let’s say your customer AOV is $30 but you spend roughly $15 to acquire a customer. You can increase your AOV to $40, but that $15 doesn’t change – you’re investing the same whilst getting customers to spend more.

Think of it like this: you’re already spending that amount to get them to your store, why not put in the effort to convince them to spend more while they’re there?

How to Calculate AOV?

Average Order Value Calculation

To calculate the average order value, you’ll need your total revenue and number of orders. Divide revenue with the number of orders and you get your average order value.

average order value formula

 

Have those numbers ready? Let’s calculate your AOV with the calculator below. Input your revenue and number of orders and the calculator will work out the average order value.

Average Order Value Calculator

Calculating AOV with Shopify

If you have a relatively new Shopify store or don’t have a lot of orders, working out the AOV is as simple as adding up all the order totals and dividing that value by the number of orders. However, if you’ve had hundreds of orders, the method below is a much easier way to calculate AOV.


Step #1Start by signing into your Shopify dashboard and navigating to the Orders section.

Step #2Click the Export button and choose to export All orders, and make sure you choose to export as Plain CSV file.

Step #3 Press Export orders and Shopify will send you an email to download the CSV file containing all the order data. Shopify will take longer to process large volumes of order data so you may have to wait longer than a few minutes to receive the file.
Step #4Once you’ve downloaded the CSV file, create a new Google Sheets document.
Step #5Open the CSV file in Excel (or any spreadsheet program) and press CTRL + A to select it all then press CTRL + C to copy it. Right-click in the A1 cell of the Google sheet and select Paste special > Paste values only.

Step #6Click the box at the top-left of the sheet to select all the data, and click Data > Create a filter. This will enable you to sort the data based on the different variables.

Step #7 Create a new sheet by clicking the at the bottom-left of the page.

Step #8In any cell, enter the formula =average(Sheet1!L:L). In this case, the sheet with all of the Shopify data is called Sheet1 and the column containing the order totals is column L; edit the formula based on your own sheets.

Doing this will calculate the AOV for all of your store’s orders. If you want to calculate AOV for specific products or for orders within a specific date range, copy those orders into a separate spreadsheet and use the same AOV formula we used above.

How to Increase Your Average Order Value

So you’ve worked out your AOV, but what if the value you got was underwhelming? Most store owners are continuously working to increase average order value and here are some of the ways that you can do so.

1. Free Shipping Threshold

We usually recommend that all store owners offer free shipping anyway, but if you’re struggling to get a higher AOV then having a free shipping threshold can help. If your AOV is sitting at $35, set your free shipping threshold at $50. This will encourage customers to add to their orders so that they’re able to take advantage of this benefit.

What’s important here is that you do the math and make sure that this change remains profitable for your store. Since you’re going to be covering the shipping costs, your profit margin is going to shift and you need to determine how exactly free shipping will impact your profits.

2. Discounts Over Spend Threshold

Another threshold that can help increase AOV is to give customers a discount if they buy in a bulk or if their order total exceeds a set amount.

You can do the exact same thing as you would with the free shipping threshold: set the discount threshold a good amount more than your AOV and make sure that offering a discount doesn’t reduce your profits too much.

3. Bundle Deals

Bundle deals are perfect for improving customer AOV because it puts the notion in the customer’s mind that they could save some money by adding another product to their order. You don’t necessarily have to add a discount to bundle deals (simply advertising products in a bundle can be enough to make customers consider purchasing them), but this can entice more customers to purchase it.

4. Gift Cards

Gift cards are great for a couple of reasons. Not only does it encourage customers to place more expensive orders, but it gives them a reason to return to your store in the future (or if they give the gift card away, that brings you a new customer).

So if they place a $200 order, you could give them a $40 gift card. Getting the gift card amount right is important. If it’s too low then the customer won’t care as much, but if it’s too high you’ll lose money. Generally, around 20% of the threshold is a good amount for this strategy.

5. Cross Sells and Upsells

These are a bit different compared to the other ways but are nonetheless effective for boosting your average order value, and they are cross selling and upselling.

Cross selling is when you sell a product that is similar to the one the customer is viewing, but it’s more expensive. You can do this by showing the more expensive option in a related products box on the product page or the checkout page, giving customers the option to upgrade their order.

Upselling is when you sell a product in addition to the one the customer is viewing. If you’re selling printers, for example, then it would be useful to upsell ink cartridges alongside them.

6. Free Gifts

And the last thing you can try is to offer a free gift when a customer spends over a certain threshold. The fact is, people love getting things for free and this can be enough to persuade customers to pay a little extra to receive the free gift.

This doesn’t have to be something that’s crazy expensive, but it should be enough that it can act as an incentive and persuade customers to reach that order price threshold.

Conclusion

That sums up everything you need to know about average order values in e-commerce and what you can do to improve yours. The great thing about this metric is that you don’t have to increase your advertising budget to achieve better results. With the right strategy and with the help of the tips we’ve provided above, you can increase your store’s profits without overhauling your marketing campaigns.

Want to get more Ecommerce tips and tutorials just like this? Subscribe to my YouTube Channel and learn more about growing your Ecommerce store remotely.

Share this article:

Generic selectors
Exact matches only
Search in title
Search in content
Post Type Selectors
page
post

'How To Write Successful
Google Ads'

Google Ad Ebook Cover
    We are committed to protecting your privacy, as described in our Privacy policy.
    Sam single blog pages

    I hope you enjoy reading this article.

    If you want us to help you scale up your ecommerce business, book a free strategy call.

    Subscribe to Our Newsletter to Improve Your eCommerce Digital Marketing!

    Thank you for your interest in our newsletters. We will send you only the most important news and updates. No spam, we promise.

    We are committed to protecting your privacy, as described in our Privacy policy.

    What’s your goal today?

    1. Hire us to grow your ecommerce store

    We’ve generated millions for our clients, using the methods we’ve developed over years with a singular focus on Google Ads for ecommerce. To discover how we can help grow your business:

    Claim your FREE website strategy session with one of our renowned experts.

    2. Learn & develop your ecommerce skills

    Watch our highly regarded YouTube channel, followed by over 23,000 store owners and ecommerce learners from around the world.

    You can also subscribe to our weekly email newsletter to get real-world tested growth and optimization strategies, as well as notifications on anything you may need to know as an ecommerce store owner.

    Browse our blog, written and structured to be the best resource in the world for anyone starting and growing their online store. It includes strategy guides, setup instructions, checklists, and tools.

    Explore our KeyCompendium, which is a comprehensive wiki of digital marketing terms. Many readers have commented on the usefulness of this content.

    3. Join our team

    If you want to join our team—or discover why our team members love working with KeyCommerce—then see our “Careers” page.

    4. Contact us

    We help ecommerce store owners around the world, so get in touch!