Business Thoughts by Allegro

  • Home
    Home This is where you can find all the blog posts throughout the site.
  • Categories
    Categories Displays a list of categories from this blog.
  • Tags
    Tags Displays a list of tags that have been used in the blog.
  • Bloggers
    Bloggers Search for your favorite blogger from this site.
  • Team Blogs
    Team Blogs Find your favorite team blogs here.
  • Login
    Login Login form

Using the Abandoned Carts Report in Magento

Posted by on in eCommerce
  • Font size: Larger Smaller
  • Hits: 18074
  • 2 Comments
  • Subscribe to this entry
  • Print

Abandoned cart

 

When you are running an e-commerce store, inevitably you will experience shopping cart abandonment - customer adds items to their cart but leaves your site before checking out.  In fact, the average shopping cart abandonment rate is 68.63%.There are a number of reasons for this phenomenon. Customers experience unexpected costs at checkout, the checkout process is too complicated, found a better price elsewhere, etc. No matter what the reason, they all equal the same thing - lost sales.  The good news is that you can use the abandoned carts report to identify the customers in question and try to win them back!

Where do I find this gem of a report, you ask?

Log in to your Magento admin.  Click on Reports->Shopping Cart->Abandoned Carts

Abandoned cart report screenshot

The report display will show you the following:

  • Customer Name
  • Email
  • Number of Items
  • Quantity of Items
  • Subtotal
  • Applied Coupon
  • Created At
  • Updated At
  • IP Address

 

In this example you can see that "Bob Smith"  has abandoned his cart.  If we now visit Bob's Customer record, we will see exactly what was in it when he left the site.

Click Customers->"Customer Name"->Shopping Cart

 Abandoned cart report screenshot 2

 

 

Now, what to do with all of this new found data?

There are few ways to approach your abandoned cart data.

1. Analyze the amount of abandoned carts your site is experiencing then take a look at where you can make improvements.  Is the checkout process lengthy or complicated?  Should you offer a wish list for convenient "saving" of items the customer is interested in?  Is your site optimized for mobile devices?

2. Seize the opportunity to "remind" the customer that they have left something behind. Many successful online businesses use remarketing campaigns to bring the customer back to their cart and encourage the completion of the sale.  Often times the emails will include an incentive in the form of a coupon or free shipping.

3. Use the product data to learn about trends in popularity.  Are there certain products that are consistently left in carts?  Are certain products most likely to be part of a completed sale following an abandoned cart email?

 

Noggin nugget: Studies show that in 2015, $4tr of merchandise was left in abandoned online shopping carts - the largest amount of cart abandonment ever seen!3

 

 

1- Baymard Institiute, http://baymard.com/lists/cart-abandonment-rate 

2- Statista, http://www.statista.com/statistics/232285/reasons-for-online-shopping-cart-abandonment/

3- Supply Chain Brain, http://www.supplychainbrain.com/content/general-scm/quality-metrics/single-article-page/article/despite-record-e-commerce-sales-69-percent-of-online-shopping-carts-abandoned/

A 1998 graduate of VCU's School of the Arts, Amy Gray began her career at The Martin Agency as a broadcast buyer. She handled negotiation, purchase and monitoring of advertising space on behalf of such clients as Alltel and Nick at Nite. After starting a family, Amy decided to stay home with her young children and take a break from full-time work. Six years ago she returned to the world of business as Marketing Manager for Allegro. Amy is responsible for web marketing, social media marketing strategy, email campaigns and public relations. Amy is certified as a Pre-Sales Engineer and Sales Executive for SugarCRM.

Comments

  • Guest
    Andy Wednesday, 02 November 2016

    I have a question - does the updated at column refers to when the abandoned cart was updated or o when the client's profile was updated?

  • Amy Gray
    Amy Gray Thursday, 03 November 2016

    Hi Andy! Good question. The "Updated At" column refers to the last time the customer edited their cart. Let's say they begin to checkout and then spend an hour or so shopping around the site. They add other items to their cart or change options in their cart, these events will trigger the "updated at" time stamp.

Leave your comment

Guest Tuesday, 21 November 2017