Kevin Hillstrom: MineThatData

Exploring How Customers Interact With Advertising, Products, Brands, and Channels, using Multichannel Forensics.

September 06, 2006

E-Commerce Productivity

An executive at an e-commerce pureplay asked me a question about how best to measure the productivity of his website. He mentioned that his business experienced a significant increase in traffic, year-over-year, but experienced a reduction in conversion rate, year-over-year.

One way to analyze the sales productivity of a website is to take the Internet Retailer Top 500, remove outliers and smaller companies (leaving 251 observations) and plot demand-per-visitor (y-axis) against average monthly traffic (x-axis).

The scatterplot indicates that there is a diminishing rate of returns. As traffic increases, the productivity of each individual visitor decreases.

The relationship can be modeled using a "power" function (the word "demand" is used in this post, however, the relationships actually depict net sales, not demand, FYI).
  • Demand per Visitor = 816.2 * (Monthly Visitors ^ - 0.3754)
Using the relationship, we can predict an average Demand per Visitor, given average monthly traffic volumes:
  • 100,000 Monthly Visitors yields $13.33 per visitor.
  • 250,000 Monthly Visitors yields $9.61 per visitor.
  • 500,000 Monthly Visitors yields $7.50 per visitor.
  • 1,000,000 Monthly Visitors yields $5.85 per visitor.
  • 5,000,000 Monthly Visitors yields $3.29 per visitor.
  • 10,000,000 Monthly Visitors yields $2.57 per visitor.
Clearly, as a "brand" increases traffic to the site, it attracts traffic that will spend incrementally less (be less likely to convert to a purchase). Like all things in life, there is a law of diminishing returns. It is possible that my executive friend was observing a trend that is perfectly fine (traffic increase, productivity decrease).

The equation can be used to evaluate your e-commerce productivity. If you have 500,000 monthly visitors, you can expect $7.50 per visitor. If your site has $10.00 per visitor, you may be doing better than average. If your site has $5.00 per visitor, you may be doing worse than average.

Ah, the magic that occurs when you mine that data!!

0 Comments:

Post a Comment

Links to this post:

Create a Link

<< Home