Using the Abandoned Carts Report in Magento
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%.1 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.2 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
The report display will show you the following:
- Customer Name
- Number of Items
- Quantity of Items
- 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
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/
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?
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.
Good share Amy, I was looking for this guide and figured out the issue for fixing it with Sugar CRM, also, I am fixing issues to reduce cart abandonment, https://www.cloudways.com/blog/reduce-cart-abandonment/ , This is another helpful guide.