{"id":8811,"date":"2020-11-02T07:30:36","date_gmt":"2020-11-02T07:30:36","guid":{"rendered":"https:\/\/www.revuze.it\/?p=8811"},"modified":"2020-11-02T07:30:36","modified_gmt":"2020-11-02T07:30:36","slug":"data-cleanup-guide","status":"publish","type":"post","link":"https:\/\/www.revuze.it\/blog\/data-cleanup-guide\/","title":{"rendered":"Sentiment Analysis of Reviews \u2013 Data Cleanup Guide (2021)"},"content":{"rendered":"<p>IBM recently estimated that the cost of bad data to the US economy is <a href=\"https:\/\/hbr.org\/2016\/09\/bad-data-costs-the-u-s-3-trillion-per-year\" target=\"_blank\" rel=\"noopener\">$3.1 trillion<\/a>!!!! Imagine that\u2026when thinking about eCommerce ratings and reviews, it may sound simple to analyze them (what could possibly go wrong\u2026) \u2013 but there\u2019s actually a lot of moving parts behind the scenes so what you get in terms of insights and analytics is worthwhile.<\/p>\n<p>Keep in mind that <strong>2.4B <\/strong>internet users post reviews globally (Which is <strong>52% <\/strong>of <a href=\"https:\/\/www.statista.com\/statistics\/617136\/digital-population-worldwide\" target=\"_blank\" rel=\"noopener\">global internet users<\/a>) \u2013 that\u2019s a lot of reviews for you.<\/p>\n<p>We\u2019ll give you a short data cleanup guide so you can start right after you are done with this article.<\/p>\n<p>&nbsp;<\/p>\n<h2><strong>A quick reminder on why ratings and reviews matter<\/strong><\/h2>\n<p>eCommerce <a href=\"https:\/\/www.revuze.it\/blog\/product-review\/\">ratings and reviews are the richest sources of information<\/a> about products, services, and the purchase process. <strong>Real buyers<\/strong> who bought a product\/service provide feedback as to:<\/p>\n<ul>\n<li>What they purchased<\/li>\n<li>How easy it was to buy<\/li>\n<li>Availability in stock<\/li>\n<li>Customer service post-purchase<\/li>\n<\/ul>\n<p>When analyzing topics and sentiment per the above, one can gain an infinite array of feedback towards areas such as:<\/p>\n<ul>\n<li>Product\/service optimization<\/li>\n<li>Marketing<\/li>\n<li>eCommerce<\/li>\n<li>Customer service<\/li>\n<li>Competition<\/li>\n<\/ul>\n<p>As reviews are publicly available on brand websites as well as marketplaces, analyzing a wide range of these sources can provide an industry-wide perspective of brands (new and existing), products, and consumer wants and trends. This is typically done in the context of one industry \u2013 for example, jeans or shampoos.<\/p>\n<h2><strong>The promise of an industry-wide catalog <\/strong><\/h2>\n<p>When collecting reviews from multiple eCommerce sources there\u2019s the opportunity to build an industry-wide perspective. The key though is in the organization. To make an effective analysis you need to associate each review with a product, associate the product with the brand, and this way you gain an industry catalog with<\/p>\n<ul>\n<li>All brands (industry level summary of topics and sentiments)<\/li>\n<li>All product per brand (Brand level summary of topics and sentiment<\/li>\n<li>Product level analysis (What customers like or dislike about a product, the purchase experience, or the customer service)<\/li>\n<\/ul>\n<p>Being able to view an industry this way is very different in terms of insights vs just summarizing the reviews per industry (no brands or no products involved). Imagine the difference between knowing 87% of consumers love Brand X Feature Y vs knowing that out of the 20 different products that Brand X makes product number 18 has only 50% sentiment towards Feature Y.<\/p>\n<h2><strong>What you need to know about cleaning up reviews<\/strong><\/h2>\n<p>Because the ideal way to go is to organize an industry level catalog, cleaning up the data needs to take place on several levels:<\/p>\n<ul>\n<li>Review level<\/li>\n<li>Product level<\/li>\n<li>Brand level<\/li>\n<\/ul>\n<h3>Examples for <strong>review level<\/strong> cleanliness challenges:<\/h3>\n<ul>\n<li>A review may not include text, but only include star rating<\/li>\n<li>Reviews may include grammar and spelling mistakes<\/li>\n<li>Due to their concise form, each sentence may cover multiple topics (\u201cLoved the product except for the design and price\u201d)<\/li>\n<li>Some marketplaces mix languages to increase reviews number per product (English + Spanish + Chinese)<\/li>\n<li>Some marketplaces mix reviews across similar products (Same model jeans with different colors, shampoo with 500ml package with the same shampoo with 250ml package)<\/li>\n<li>A review may be fake<\/li>\n<li>A review may be part of a promotion (AKA incentivized review)<\/li>\n<li>Reviews may be syndicated between websites, meaning the same review will be collected and analyzed multiple times from several websites<\/li>\n<\/ul>\n<h3>Examples for <strong>product level<\/strong> cleanliness challenges (Mostly related to consolidating reviews from multiple sources\/websites):<\/h3>\n<ul>\n<li>The same product may be listed under a different name in different marketplaces, which means you will not be able to associate the right reviews with the right product across websites<\/li>\n<li>Different websites may place the same product under different product hierarchy which again may impact the ability to associate the 2 products together<\/li>\n<li>Some marketplaces promote related products (You\u2019re looking to buy a laptop so here\u2019s an offer for a carrying case) and when collecting reviews about one industry (laptops) you may collect reviews of \u201crecommended products\u201d in the process (carrying cases in our example)<\/li>\n<\/ul>\n<h3>Examples for <strong>brand level<\/strong> cleanliness challenges (Similar to product level challenges):<\/h3>\n<ul>\n<li>The same brand may be spelled differently in different marketplaces or even under different online stores within a marketplace, which means you will not be able to associate the right reviews with the right brand<\/li>\n<\/ul>\n<h2><strong>Conclusion<\/strong><\/h2>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-8813 size-full alignnone\" src=\"https:\/\/revuzeblog.wpengine.com\/wp-content\/uploads\/2020\/11\/conclusion.png\" alt=\"\" width=\"1296\" height=\"628\" srcset=\"https:\/\/www.revuze.it\/blog\/wp-content\/uploads\/sites\/2\/2020\/11\/conclusion.png 1296w, https:\/\/www.revuze.it\/blog\/wp-content\/uploads\/sites\/2\/2020\/11\/conclusion-300x145.png 300w, https:\/\/www.revuze.it\/blog\/wp-content\/uploads\/sites\/2\/2020\/11\/conclusion-1024x496.png 1024w, https:\/\/www.revuze.it\/blog\/wp-content\/uploads\/sites\/2\/2020\/11\/conclusion-768x372.png 768w\" sizes=\"(max-width: 1296px) 100vw, 1296px\" \/><\/p>\n<p>Ratings and reviews offer a huge untapped potential to directly connect with the top of mind of customers in your industry, without them knowing you are even taking a look\u2026it\u2019s basically like listening to the world largest panel, covering you and your competitors on any number of business topics \u2013 product, purchase, and service.<\/p>\n<p>To maximize your value from this you need to organize these opinions in a way that reflects product and brand relationship and clean it up so insights are reliable. Once you do you will be able to benefit from an almost unlimited range of insights for a flat fee \u2013<\/p>\n<ul>\n<li>Positioning<\/li>\n<li>New product launch<\/li>\n<li>Trends and wish lists\/innovation<\/li>\n<li>CSAT<\/li>\n<li>Competitive intelligence<\/li>\n<li>Brand analysis<\/li>\n<li>etc\u2026<\/li>\n<\/ul>\n<p>This is a worthy exercise to have, and the ROI is enormous. Just make sure to stay the course, not to save time or effort on data clean up and data organization in products\/brands, otherwise what you get is just a list of topics and sentiments, without the eCommerce roots of product-specific feedback<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Data Cleanup Guide: Sentiment Analysis of Reviews \u2013 The Data Cleanup Guide (2021)<\/p>\n","protected":false},"author":17,"featured_media":8812,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"inline_featured_image":false,"footnotes":""},"categories":[1],"tags":[],"acf":[],"_links":{"self":[{"href":"https:\/\/www.revuze.it\/blog\/wp-json\/wp\/v2\/posts\/8811"}],"collection":[{"href":"https:\/\/www.revuze.it\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.revuze.it\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.revuze.it\/blog\/wp-json\/wp\/v2\/users\/17"}],"replies":[{"embeddable":true,"href":"https:\/\/www.revuze.it\/blog\/wp-json\/wp\/v2\/comments?post=8811"}],"version-history":[{"count":0,"href":"https:\/\/www.revuze.it\/blog\/wp-json\/wp\/v2\/posts\/8811\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.revuze.it\/blog\/wp-json\/wp\/v2\/media\/8812"}],"wp:attachment":[{"href":"https:\/\/www.revuze.it\/blog\/wp-json\/wp\/v2\/media?parent=8811"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.revuze.it\/blog\/wp-json\/wp\/v2\/categories?post=8811"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.revuze.it\/blog\/wp-json\/wp\/v2\/tags?post=8811"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}