Data Driven Ecommerce Case Study

Data-driven E-commerce case study: cohorts and segmentation

Disclaimer: Unfortunately, the e-commerce sector is a really tough competitive market, so I could only write this case study by replacing the name of the company, product and numbers with something similar.

The Hiking Backpack E-commerce Store (if a company with that name does exist, apologies, I am not thinking of them, this is just a fictional example) began to analyze their data. They were curious about: Ecommerce Cohorts Analysis

  • Who is the best target group for them?
  • What kind of product to offer to whom and when?
  • Having answered these two questions, how can they reach the highest Revenue and higher Visitor-to-PremiumCustomer % in the long term?

The first thing they saw was that the sales performance fluctuates throughout the year.

This can be for a number of reasons of course, but knowing the circumstances we first thought that this is due to the nature of the product.

To validate our suspicions, we looked at the 2013 vs. 2014 Revenue Chart on a monthly breakdown. The two years show a similar trend (we only see a small growth). We see the same for 2012 and 2011 as well.

Data Driven Ecommerce Case Study 1

As can be expected, we did a number of User interviews and Usability tests, and checked some obvious analysis based on different hypotheses. Most of these didn’t give us any exciting results — but one of the segmentations had an interesting outcome.

We segmented the Revenue on the below chart based on Payment types. We can see that there was a constant change in 2014 on whether the „simple” First Payments (so the first purchases of the customers) or the Repeat Purchase (when a previous customer purchased again) brought in more Revenue.

Data Driven Ecommerce Case Study 2

It jumps out that the Revenue generated by new customers drops in autumn, but returning customers cover this gap.

In light of this, we created a Cohort analysis for those who made their first Payment in the shop in 2014. We looked at exactly how much was spent and when as a Repeat Purchase. We found this:

Data Driven Ecommerce Case Study 3

The customers from 2014 brought the best Revenue from a Repeat Purchase at the end of the summer and beginning of autumn. In fact, we also know that customers from February, March, April and May are really strong and spend a lot 4–5 months after they make their first purchase (so July, August, September and October).

From this, two obvious reports followed.

One is to take a look at the same metrics, but through many years. (This also showed that the February-May customers spend a lot as a Repeat Purchase. So again: this is a hiking backpack e-commerce business. It is clear that it was these customers who took hiking seriously and planned their trips ahead and with that their trip equipment, too. The rest shopped on an ad-hoc basis in the summer, or gave the backpack as a gift — typically around the Christmas period.)

The other research was about finding out the exact products that people purchase as a Repeat Purchase. This was a much simpler story. In short  —  The Hiking Backpack E-commerce Store was able to find a well-targetable Customer Group and also what to sell them and when.

The autumn campaign of 2015 was thus approached with a brand new strategy.

Instead of aiming at new customers, the current ones were targeted in these 3 months. This had its results.

Data Driven Ecommerce Case Study 4

This is just a short e-commerce case study but you can find more of these – along with the most commonly used data terms for online businesses – in the Practical Data Dictionary. It’s fully free and you can find it here:http://data36.com/datadictionary/

This article was kindly contributed by Tomi Mester.

3 Kicsi

Tomi Mester is a data analyst and researcher. He worked for iZettle, Prezi and several smaller companies as an analyst/consultant. He’s the author of the Data36 blog where he writes weekly posts and tutorials about data science, AB-testing, online research and data coding. He’s an O’Reilly author and presenter at TEDxYouth, Barcelona E-commerce Summit and Stockholm Analyticsdagarna. More info about Tomi: here and here (linkedin).

 

About the author

Dimira is the Words Pixie of Metrilo. A daydreamer and a coffee junkie. Can’t live when a comma is misplaced. A dog lover with a geeky sense of humor.

Become a data-powered marketing hero

Learn to use the power of data and turn it into sales. If you want to grow your ecommerce business with data-driven decisions, subscribe for our email newsletter and you’ll be the first to get our content + exclusive examples you can’t read anywhere else.

Oops! Invalid email.

We promise, no spam.

Awesome!

Thank you for subscribing!
See you soon :-)

New blog posts