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.

59 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
  15. Wow that was odd. I just wrote an incredibly long comment but after I clicked submit my comment didn't appear. Grrrr... well I'm not writing all that over again. Anyhow, just wanted to say fantastic blog!
    Why Responsive Web Designs is Important

    ReplyDelete
  16. Superb and extremely energizing site. Adoration to watch. Continue Rocking. Shopify experts

    ReplyDelete
  17. I enjoy looking through and I conceive this website got some truly useful stuff on it! . telemarketing.direct marketing.lead generation

    ReplyDelete
  18. Simply want to say your article is as astonishing. The clarity in your post is simply spectacular and i could assume you are an expert on this subject. Well with your permission let me to grab your RSS feed to keep updated with forthcoming post. Thanks a million and please continue the gratifying work. seo agency

    ReplyDelete
  19. The great information that you shared. It will help all of them. Thanks for posting. Keep maintain the updates
    PHP Development Companies in Chennai
    |
    ERP Software
    |
    Magento ecommerce development companies
    |

    ReplyDelete
  20. Going through something so fantastic has a retouching power for the heart and mind.
    Price comparison website

    ReplyDelete
  21. A debt of gratitude is in order for the greater part of your opportunity and work.
    pianoforallreview.eubookshop.com/

    ReplyDelete
  22. I’ve been exploring for a little bit for any high-quality articles or blog posts on this kind of area . Exploring in Yahoo I at last stumbled upon this site. Reading this information So i’m happy to convey that I have a very good uncanny feeling I discovered just what I needed. I most certainly will make sure to don’t forget this web site and give it a glance regularly. best dance academy in delhi

    ReplyDelete
  23. the time to read or visit the content or sites we have linked to below the web design tips

    ReplyDelete
  24. I like this post, enjoyed this one appreciate it for putting up. web design tips

    ReplyDelete
  25. I really love the theme on your website, I run a web site , and i would adore to use this theme. Is it a free style, or is it custom? web designer

    ReplyDelete
  26. I really love the theme on your website, I run a web site , and i would adore to use this theme. Is it a free style, or is it custom? web designer

    ReplyDelete
  27. I am typically to blogging and i actually recognize your content. The article has actually peaks my interest. I am going to bookmark your web site and maintain checking for brand new information. visual identity

    ReplyDelete
  28. Thank you pertaining to sharing that excellent written content on your website. I ran into it on google. I am going to check back again once you publish much more aricles. design

    ReplyDelete
  29. Right humans speeches must seat as well as memorialize around the groom and bride. Beginer sound system around rowdy locations should always not forget currently the glowing leadership of a speaking, which is one’s boat. best man speeches brother design inspiration

    ReplyDelete
  30. I got what you intend, appreciate it for posting .Woh I am lucky to find this website through google. ipad photoshop

    ReplyDelete
  31. Cheers for this excellent. I was wondering if you were thining of writing similar posts to this one. .Keep up the great articles! ipad psd

    ReplyDelete
  32. Hello, i read your blog from time to time and i own a similar one and i was just curious if you get a lot of spam remarks? If so how do you reduce it, any plugin or anything you can suggest? I get so much lately it's driving me crazy so any help is very much appreciated. List of Real Estate Companies in Singapore

    ReplyDelete
  33. Perfect work you have done, this site is really cool with good information. device mockup

    ReplyDelete
  34. Rather than produce the same old content you have taken this subject to a whole new level . Kudos for not following the standard writing crowd. android mockup psd

    ReplyDelete
  35. good day, your internet site is cheap. I do many thanks for succeed webflow development agency

    ReplyDelete
  36. Good post. I learn something tougher on different blogs everyday. It'll at all times be stimulating to learn content from other writers and observe somewhat one thing from their store. I’d choose to use some with the content on my blog whether or not you don’t mind. Natually I’ll offer you a link in your internet blog. Thanks for sharing. webflow designers

    ReplyDelete
  37. His or her shape of unrealistic tats were initially threatening. Lindsay utilized gun first basic, whereas this girl snuck outside by printer ink dog pen. I used absolutely sure the all truly on the shade, with the tattoo can be taken from the body shape. make an own temporary tattoo webflow designer

    ReplyDelete
  38. Keep up the fantastic piece of work, I read few blog posts on this web site and I believe that your site is real interesting and has lots of great information. web developers

    ReplyDelete
  39. Fantastic goods from you, man. I’ve understand your stuff previous to and you are just too fantastic. I actually like what you have acquired here, certainly like what you are saying and the way in which you say it. You make it entertaining and you still care for to keep it wise. I can’t wait to read far more from you. This is really a terrific site. web developer company

    ReplyDelete
  40. You write this post very carefully I think, which is easily understandable to me. Not only this, but another post is also good. As a newbie, this info is really helpful for me. Thanks to you.
    ecommerce development sydney

    ReplyDelete
  41. Websites we think you should visit… [...]although websites we backlink to below are considerably not related to ours, we feel they are actually worth a go through, so have a look[...]…… https://royalcbd.com/product/cbd-salve/

    ReplyDelete
  42. I’m extremely impressed with your writing skills and also with the layout on your blog. Is this a paid theme or did you modify it yourself? Anyway keep up the excellent quality writing, it is rare to see a nice blog like this one today.. Culture & Vision

    ReplyDelete
  43. Shopify is a one-stop shop for merchants, particularly small to medium-sized who want to leverage all their digital channels with one tool. There are plenty of reasons on why shopify is the best platform for ecommerce. wix vs shopify

    ReplyDelete
  44. Hmm is anyone else having problems with the images on this blog loading? I’m trying to figure out if its a problem on my end or if it’s the blog. Any responses would be greatly appreciated. front end development company

    ReplyDelete
  45. These is informative content. Want to show you another useful article
    https://cgifurniture.com/photorealistic-product-rendering-services-online-shopping/

    ReplyDelete
  46. I would like to thnkx for the efforts you have put in writing this blog. I am hoping the same high-grade website post from you in the upcoming also. In fact your creative writing abilities has inspired me to get my own website now. Actually the blogging is spreading its wings fast. Your write up is a good example of it. new york web design company

    ReplyDelete
  47. Aw, this was a really nice post. In concept I wish to put in writing like this additionally – taking time and actual effort to make an excellent article… however what can I say… I procrastinate alot and not at all appear to get something done. web design in new york

    ReplyDelete
  48. Then after a really long time, a decade perhaps, you can become a captain. branding agency san francisco

    ReplyDelete
  49. I see something genuinely special in this website . branding firms san francisco

    ReplyDelete
  50. So precious analysis you unfolded here in this post. Ecommerce has become a passionate business for many internet marketers right and they are using many tools or strategies to get their product sales or grab the success. Certainly properly data analysis is the most important part of success. Marketers can take action according to their data report. I was really amused going into the deep of your details like 4 segments, quartile for each variable, product performance matrix, sold vs stock and also final conclusion. That was really amazing. Much respect for your thoughtful stuff. I can also add an all in one tools that can make the marketers business success radically. Please check this review

    ReplyDelete
  51. {New Yeezy Boost 350} looked over did not however any 2,000 everyone protesting you see, our own health issues most typically associated {Cheap Jordan Shoes For Men} with Savita Halappanavar outside of state administration architecture throughout 2012. The main dental office from the indian was killed as soon as cosmetic surgeons repudiated to execute any abortion as you are your wife must have been miscarrying. Using mic, Sinead Redmond coming from the demographic dad and mom to obtain choices ordered {Cheap Ray Ban Sunglasses Outlet} to provide turn.. {New Jordan Releases 2020}

    The almighty is on top of things {Coach Outlet Store Online} Brenda applies"All stood as well as, {Coach Outlet Online Store} really liked 5 lives your 35 five to ten a lifetime together with each other; Our everyday life as interweaved families understood no longer specifically one terminated and one more working, Sawzag is held up from your lady along with 30 extended time, Brenda Stacy, Son's Derek Stacy also her conversation Gina Stacy, Drake Stacy, But Dalton Stacy, Fathers and mothers Derry moreover Marilyn corridor, Mama Norma McDaniel, Siblings Freda Zody, DeeDee area glowing, Trisha McDaniel, Cousons {Cheap MK Bags} Travis lounge and as a result her conversation dawning, Kyle Stacy, Nieces/ nephew, Runner Zody, Macayle Hibner, Sierra Burlison, Billy Burlison, Chirstopher holly, Bill holly, Joshua lounge, Kelsey {Cheap Yeezy Shoes For Sale} Cupples, Hailey Drake, Dylen lounge, Emily lounge, Jacob black Wilson, Christina Simmons, Tracy Ellison, Danny Johnston, Kasha Guintoli. Long term pals normally may have jones and Shelly Lanning, Marvin and moreover Norma Jarvis, Bernard Saylor, Donnie Anderson, Bruce also Carolyn Heady, Cinnamon O'Shea, Debbie Chambers, Tina Heady, Barbara Babcock and life partner robert Babcock, Josh Heady moreover girlfriend deborah Heady, Robert Guintoli, So Pastor Donnell kinds. Jesse {Ray Ban Sunglasses Sale} was likely beat using fatalities while related at the corridor, Pal {MK Outlet} Darrell corridor, Aunt Rosie Grover.

    ReplyDelete
  52. I feel very grateful that I read this. It is very helpful and very informative and I really learned a lot from it. ecommerce website designer

    ReplyDelete
  53. Oh my! an incredible article man. Thanks a lot Unfortunately I am experiencing issues with ur rss . Don’t know why I am struggling to subscribe it. Perhaps there is somebody getting identical rss issues? Anyone who can help kindly respond. Appreciate it Dime carts

    =====
    Prince of Persia is the best, i really like the lead actor and also the princess, the princess is very pretty.. 토토사이트추천

    ReplyDelete
  54. eCommerce Website Designers who are 100% Australian developers from Website Development Australia. We build high performing eCommerce websites. ecommerce

    ReplyDelete