Wednesday, July 25, 2012

Abandoned Cart Reports

Every eCommerce solution needs to have a means by which the manager can view abandoned shopping carts to try and determine if there are any trends showing why the visitor didn't complete the purchase. Through use of this tool, one can eliminate bottlenecks and streamline the shopping experience, thus generating more sales and more revenue.

True to form, Volusion has an Abandoned/Live Carts report:



Also, true to form, it's practically worthless.

Why?

What information would one need to glean from an abandoned carts report? Maybe the products being purchased, or perhaps the point in the funnel at which each individual cart was abandoned. Could it be that the customer balked at the shipping costs, and left after determining that shipping was too high?

All of these factors should be able to be gleaned from an Abandoned Carts report.  But not Volusion.

Here are the items provided by an export (via CSV to Excel) of Volusion's Abandoned Carts report, with any appropriate comments in parenthesis:

cartid
customerid
phone_number
email_address
ipaddress
notes (which presumably would be any notes the customer entered into the cart before leaving)
lastmodified (date and time)
cartitemcount
recordcount (the number of records in the export)

Could anyone tell me how this information would be useful?  I suppose I could write to each individual customer who happened to log in (which would be the only email addresses captured, about one in twenty in our case) and ask them, "Why didn't you complete your order?"

You know how many would likely respond?  Maybe 2%.  By this definition, I would get back useful information on why the cart was abandoned by one in one thousand abandoned shopping carts.

A handy feature indeed. Let me get right to work on going through these reports, right after I finish doing something useful, such as flogging a dead horse.

2 comments:

  1. click the Enable Quick Edit link at the upper right corner of the abandoned carts table. This will open the Quick Edit Window in the bottom half of the page. If you click on a cart in the top part of the window, its details will be displayed below.
    Here, the information listed in the main Abandoned / Live Carts table is displayed along with a list of every product within the page - including product codes, option IDs, prices and quantities for each product. Clicking on the product code for each product listed here will redirect to the actual product listing in the Volusion Administration Page.
    In addition, in the Helpful Links section there are two buttons available:
    Storefront: Clicking this button will open the checkout page logged in as the customer, with the details of their abandoned cart displayed at the bottom.
    Phone Order Page: Clicking this button will open the Phone Order Page with the abandoned cart's contents loaded into the Order Summary Section.

    ReplyDelete
  2. Uh huh. And what was the title of this post again, Tom?

    Abandoned Cart REPORTS.

    R-E-P-O-R-T-S

    What in your response has anything to do with reports? The whole point of an Abandoned Carts report is to be able to export it to Excel and look for trends, not look through every G-D page individually. Sure, I guess I could look through each one individually, and then compile the report manually.

    I could also cut every blade of grass in my yard with a pair of barber shears.

    ReplyDelete