• Skip to primary navigation
  • Skip to main content

Metrical

  • Solution
  • Resources
  • About
  • Contact
  • Show Search
Hide Search

A Simple and Easy Way to Calculate Cart Abandonment

Metrical · April 13, 2018 · Article

by Aurangzeb Agha


In today’s world, data rules all. Though you can sometimes have too much of it, the better you can leverage it, the better you can position yourself to succeed. In the world of e-commerce, there are some key data points that every retailer must know at all times:

  • Your online conversion rate
  • The number of unique visitors that come to your e-commerce site daily/weekly
  • Your daily number of orders and revenue.

These are the obvious ones and are pretty easy to track and calculate.

Another very important metric that all e-commerce decision makers must constantly keep their eye on is cart abandonment rate (CAR). As you probably already know, the average online cart abandonment rate is 70% (and by some measures, even as high as 78%). Knowing your online store’s specific cart abandonment rate allows you to better understand both how much money your shoppers could be spending and how to address their abandoning behavior.


Surprisingly, many retailers we speak with don’t actually know their cart abandonment rates and tend to assume it is around the industry average. In most cases, we’ve found that’s not the case! But have no fear! We’ve developed a very simple and easy to use calculator that you can use to determine your store’s cart abandonment rate.

Here is how it works:

1. Download a copy of our complimentary Cart Abandonment Rate Revenue Calculator by clicking here—it’s a Google Sheet. A new page will open in your browser that looks like this:



2. Go to File -> Download As -> Microsoft Excel if you’d like to edit the file to plug in your own numbers

Alternatively, if you don’t mind working in Google Sheets, just make a copy of this worksheet:



3. Once you have your own copy, plug in your numbers from last month in the three green boxes:

  • Your Average Order Value (AOV)
  • The number of times people pressed “Add to Cart” for products on your site and
  • The number of Purchases (or orders)

In the spreadsheet, we’ve entered:

  1. Average Order Value (AOV) = $100
  2. “Add to Cart” = 200
  3. Purchases / Orders = $300
Cart abandonment calculation step 3



4. Plugging in these three numbers calculates our approximate revenue for last month and your cart abandonment rate (CAR). You can see from cell F7 that our revenue for last month was $30k and from cell H7 that our cart abandonment rate was a high 88.9%!

Cart abandonment calculation step 4



5. Now comes the fun part! In cell H9, we can start playing around with what happens to our revenue if we reduce the cart abandonment rate. In this example, we’ve plugged 1.5% into cell H9:

Cart abandonment calculation step 5a

What manipulating cell H9 (CAR Reduction) shows us is how even a minor reduction in CAR can impact our revenue.

In this example—assuming the same number of people Add to Cart—reducing our CAR of 88.9% by 1.5% (cell H9) to 87.4% (cell H13) increases our purchases from 300 to 341 (cell D13) and our revenue to $34,050 (cell F13):

Cart abandonment calculation step 5b

These are huge impacts to revenue! With 41 additional purchases, we’d see $4,050 more in revenue. That’s a 13.5% increase!

Cart abandonment calculation step 5c

Can you imagine how much more revenue you would see if you reduced your cart abandonment rate by 3%, 5% or 7%! Just plug in the numbers and see for yourself!

If you would like to learn more about how to calculate your cart abandonment rate—and more importantly—reduce it and increase your conversion rate and revenue, then please drop us a note. Metrical use artificial intelligence (AI) to detect cart abandonment before it happens and gives you creative ways of turning your shoppers into buyers before they leave your site. We are more than happy to help!

You might also be interested

Black Friday Sale

AI Powered Ecommerce Gives Retailers a Profit Boost

AI powered ecommerce can increase profits because it gives customers the best experience. The digital shopping journey is mapped out in real-time, predicting what and when the shopper needs to see.

Read More →

What is Metrical, Really? (Part 2)

Our intelligent messaging platform can easily augment existing platforms (e.g. Shopify, Salesforce, Magento, or a bespoke system) to provide an engaging and seamless digital experience for arriving shoppers.

Read More →

Smart targeting and real-time customer engagement give you the edge you need.

Navigate Our Site

  • Solution
  • Resources
  • About
  • Contact

Get in Touch

    [email protected]

    © 2023 Metrical, Inc. All rights reserved.

    We are using cookies to give you the best experience on our website.

    You can find out more about which cookies we are using or switch them off in settings.

    Powered by  GDPR Cookie Compliance
    Privacy Overview

    This website uses cookies so that we can provide you with the best user experience possible. Cookie information is stored in your browser and performs functions such as recognising you when you return to our website and helping our team to understand which sections of the website you find most interesting and useful.

    Strictly Necessary Cookies

    Strictly Necessary Cookie should be enabled at all times so that we can save your preferences for cookie settings.

    If you disable this cookie, we will not be able to save your preferences. This means that every time you visit this website you will need to enable or disable cookies again.