Mar 24, 2017

Actionable Data Analysis for Ecommerce Products

Managing an Ecommerce shop backed with proper transactional/warehouse database and a digital analytics collection platform (e.g. Google Analytics) means having access to lots and lots of data. The types of analysis you can do are uncountable. It depends of course on the business question you need to answer.

However, the unique added value of your analysis is very often  represented by how much actionable their results are for the business. In this post I am going to demonstrate a few examples of actionable analysis you can do with your ecommerce business data.

I will take some data from the Google Merchandise Site (there is a free GA demo account) and use Tableau to create the visualizations.

Products performance in the site

In this first example I am developing on some ideas suggested in this article by Tatvic. The question is: how can we measure performance of each products offered in the website?

One way to do it is by crossing two variables:
  • Pageviews: how many times a specific product page was viewed  >> this can be thought as a simple proxy variable to measure demand for that product  (people browse a product as they might be interested to buy it).
  • Transactions: how many times the same product was actually bought  >> here we are talking about sales (not only the product was viewed, but it was added to checkout and eventually purchased).
If you have the Enhanced Ecommerce module properly implemented in GA, you can find these data under Conversions>Ecommerce>Product Performance>Shopping Behavior tab. The variables we are interested in are called "Product Detail Views" and "Unique Purchases".

In the Tableau visualization below I've plotted data from the Google Merchandise Site for the month of February 2017. Each circle represents a single product and it's placed in the plot based on its views and transactions values.

pageviews vs transactions

There are over than 1,000 products in the plot which makes the visualization hard to understand. On top of that, as expected both variable distributions are right-skewed (most products are have few views and sales) which turn the visualization even more unclear (and not actionable). One way to cope with that is to convert our axis into logarithmic.

pageviews vs transactions logarithmic axis


Looks nicer. Still not actionable though.

Let say we want to identify the top segment of products that generate both a high number of views and transactions. Or better, lets generate 4 segments of products as follows:
  1. High Pageviews/High Sales
  2. High Pageviews/Low Sales
  3. Low Pageviews/High Sales
  4. Low Pageviews/Low Sales
In other words we would like to split the plot area into 4 quadrants. A very simple way to do it would be to just draw reference line in the middle of each axis.

A more solid approach instead would rely on statistics measures, which means considering the distribution of each variable. What we can do is calculate quartiles for each variable. Given a sequence of data points, the quartile divides the frequency distribution into 4 equal groups. So, for the pageviews variable for example:
  1. the 1st quartile (also called lower quartile) will contain the lowest 25% of products. 
  2. the 2nd quartile (up to the median) is the next lowest group. So it has 50% of the data below it.
  3. the 3rd (upper quartile) is the second highest and has 75% of products below it.
  4. Finally the 4rth is the point from which fall the top 25% of products.
After calculating and plotting quartiles for both variables, we should be able to obtain a similar visualization as below (if you are browsing from a mobile device you might not see it properly, please visit this Tableau Public page):



where:
  • The top-right quadrant includes the top 25% both in terms of sales and pageviews. It looks there is a high demand for these products (are the most viewed) and high sales are eventually generated. This is probably an ideal context for the business and a possible action could be increasing price of those products in order to improve margins.
  • In the bottom-right quadrant products are highly viewed/demanded though do not generate as much sales as the previous quadrant. It looks as we could improve the commercial offer in order to push more sales.
  • In the top-left quadrant it looks as products convert very well (GA has a metric called Buy to Detail Rate which should be high for these products) since they generate high sales with less pageviews than others. Perhaps some actions aimed at giving them more exposure within the website could produce even more sales.
  • Finally we should take some action on the bottom left products. The idea would be to gradually shift these products towards the top-right, or alternatively drop some of them.

Lastly, we can include additional dimensions to the visualization. Here I've added for each products their correspondent business category. The drop-down filter allows you selecting just one category. And the cool thing is that quartiles will be recalculated based on the distribution of that particular category. This means being able to do more granular analysis and meaningful comparisons based on a specific context.



Products sold vs stock

Lets apply the same logic above to solve another practical problem for any ecommerce business selling goods: do we have enough stock? Do we need to supply new stock to the warehouse or, we should better discount a particular product?

The final visualization would be the following (note that for the stock variable I've generated some random data myself since I've no access to real data):

sales vs stock

where:

  • the top-left quadrant contains products that generated high sales but are currently low of stock. Should we better buy more stock and make it available in the warehouse?
  • the bottom-right identify products with high availability of stock but low sales performance. In this case we might need to apply some discount to stimulate sales.


Conclusions: how to be actionable?

In this post I've presented only a few examples. Beyond the data and the technical aspects I followed to build the visualization (you could be more rigorous for sure),  I do think they all provide actionable results for the business and stakeholders can make decisions from that.

So, how can we make sure that results will be actionable? Below is a list of  of steps I recommend to consider in your data analysis task:
  1. Solve a practical problem for the business.
  2. Cross relevant variables.
  3. Provide a comparison/benchmark to give data a proper context.
  4. Make sure the results are ready to be used for people.
  5. Take advantage of visualizations to explain result and simplify interpretation for decision makers.
  6. Provide not only data but also words to describe insights. If you understood the business problem properly from the very beginning, you should be able to talk the same language used by final users of your analysis.

14 comments:

  1. It’s laborious to seek out educated individuals on this topic, but you sound like you know what you’re speaking about! Thanks digital marketing strategy

    ReplyDelete
  2. It is truly a nice and useful piece of information. I’m happy that you shared this helpful info with us. Please stay us up to date like this. Thanks for sharing.
    e commerce in singapore

    ReplyDelete
  3. Thank you for all your valuable effort on this site. Kate really likes managing research and it is obvious why. My spouse and i learn all relating to the compelling manner you present precious tricks through the web blog and foster contribution from people on the content and our favorite princess is truly understanding a great deal. Enjoy the remaining portion of the year. You're conducting a glorious job.
    advertising firms singapore

    ReplyDelete
  4. Yesterday, while I was at work, my cousin stole my iPad and tested to see if it can survive a twenty five foot drop, just so she can be a youtube sensation. My iPad is now destroyed and she has 83 views. I know this is entirely off topic but I had to share it with someone!
    search engine optimization tips singapore

    ReplyDelete
  5. Thanks, for sharing this informative post with us. I'll also read many other students related article from your blog. You can share this with student answering service with other students.

    ReplyDelete
  6. Hmm it seems like your website ate my first comment (it was extremely long) so I guess I'll just sum it up what I wrote and say, I'm thoroughly enjoying your blog. I as well am an aspiring blog blogger but I'm still new to the whole thing. Do you have any recommendations for inexperienced blog writers? I'd certainly appreciate it.
    Verz Design

    ReplyDelete
  7. Just desire to say your article is as astounding. The clarity in your put up is simply great and that i could suppose you are an expert on this subject. Fine together with your permission allow me to grasp your feed to stay updated with imminent post. Thank you one million and please continue the rewarding work. corporate secretarial services in Singapore

    ReplyDelete
  8. Hello just wanted to give you a quick heads up. The text in your post seem to be running off the screen in Ie. I'm not sure if this is a formatting issue or something to do with internet browser compatibility but I thought I'd post to let you know. The design and style look great though! Hope you get the issue solved soon. Thanks
    product marketing tips in Singapore

    ReplyDelete
  9. I am extremely impressed together with your writing skills and also with the structure to your weblog. Is this a paid subject matter or did you modify it yourself? Either way keep up the nice quality writing, it’s uncommon to see a nice weblog like this one these days..
    Singapore domains

    ReplyDelete
  10. Wonderful blog! I found it while searching on Yahoo News. Do you have any suggestions on how to get listed in Yahoo News? I've been trying for a while but I never seem to get there! Thanks
    Important SEO Ranking Factors

    ReplyDelete
  11. Do you mind if I quote a couple of your articles as long as I provide credit and sources back to your blog? My website is in the very same area of interest as yours and my visitors would really benefit from some of the information you provide here. Please let me know if this okay with you. Thank you!
    small business seo services

    ReplyDelete
  12. Hey There. I found your blog using msn. This is a very well written article. I’ll make sure to bookmark it and return to read more of your useful information. Thanks for the post. I will definitely comeback. Use strong passwords

    ReplyDelete
  13. More often than not I don't make remarks on sites,

    Cartly Electronics store

    ReplyDelete
  14. Howdy would you mind letting me know which hosting company you're utilizing? I've loaded your blog in 3 completely different internet browsers and I must say this blog loads a lot quicker then most. Can you suggest a good hosting provider at a fair price? Many thanks, I appreciate it! Skilled web designers and developers

    ReplyDelete