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:
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.
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.
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:
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.
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.
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).
Metrilo’s mission is to help you build your ecommerce brand and win your place in the customer’s heart. We share what we learn from our daily work with product innovators and founders here. Subscribe to our weekly newsletter to get the freshest lessons and conquer your niche.