Blog

  • AI-Driven Mapping of Retail Taxonomies- Part 2

    AI-Driven Mapping of Retail Taxonomies- Part 2

    Mapping product taxonomies using Deep Learning

    In Part 1 we discussed the importance of Retail taxonomy and the applications of mapping retail taxonomies in Assortment Analytics, building Knowledge Graph, etc. Here, we will discuss how we approached the problem of mapping retail taxonomies across sources.

    We solved this problem by classifying every retail product to a standard DataWeave defined taxonomy so that products from different websites could be brought at the same level. Once these products are at the same level, mapping taxonomies becomes straightforward.

    We’ve built an AI-based solution that uses state-of-the-art algorithms to predict the correct DataWeave Taxonomy for a product from its textual information like Title, Taxonomy and Description. Our model predicts a standard 4 level (L1-L2-L3-L4) taxonomy for any given product. These Levels denote Category, Sub Category, Parent Product Type and Product Type respectively.

    Approach

    Conventional methods for taxonomy prediction are typically based on machine learning classification algorithms. Here, we need to provide textual data and the classifier will predict the entire taxonomy as a class.

    We used the classification approach as a baseline, but found a few inherent flaws in this:

    • A Classification model cannot understand the semantic relation between input text and output hierarchy. Which means, it cannot understand if there’s any relation between the textual input and the text present in the taxonomy. For a classifier, the output class is just a label encoded value
    • Since the taxonomy is a tree and each leaf node uniquely defines a path from the root to leaf, the classification algorithms effectively output an existing root-to-leaf path. However, it cannot predict new relationships in the tree structure
    • Let’s say, our training set has only the records for “Clothing, Shoes & Jewelry > Men > Clothing > Shorts” and  “Clothing, Shoes & Jewelry > Baby > Shoes > Boots”, Example:

    {‘title’: “Russell Athletic Men’s Cotton Baseline Short with Pockets – Black – XXX-Large”, 

    ‘dw_taxonomy’: “ Clothing, Shoes & Jewelry > Men > Clothing > Shorts”},

    {‘title’:” Surprise by Stride Rite Baby Boys Branly Faux-Leather Ankle Boots(Infant/Toddler) – Brown -”,

    ’dw_taxonomy:” Clothing, Shoes & Jewelry > Baby > Shoes > Boots”}

    Now, if a product with Title “Burt’s Bees Baby Baby Boys’ Terry Short” comes for prediction, then the classifier will never be able to predict the correct taxonomy. Although, it would have seen the data points of Shorts and Baby.

    E-commerce product taxonomy has a very long tail, i.e. there’s a huge imbalance in counts of data per taxonomy. Classification algorithms do not perform well for very long tail problems.

    Encoder-Decoder with Attention for Taxonomy Classification

    What is Encoder-Decoder?

    Encoder-Decoder is a classical Deep Learning architecture where there are two Deep Neural Nets, an Encoder and a Decoder linked with each other to generate desired outputs.

    The objective of an Encoder is to encode the required information from the input data and store it in a feature vector. In case of text input, the encoder is mostly an RNN or Transformer based architecture and for image input, it is mostly a CNN-based architecture. Once the encoded feature vector is created, the Decoder uses it to produce the required output. The Encoder and Decoder can be interfaced by another layer which is called Attention. The Role of Attention mechanism is to train the model to selectively focus on useful parts of the input data and hence, learn the alignment between them. This helps the model to cope effectively with long input sentences (when dealing with text) or complex portions of images (when input is an image).

    Instead of classification-based approaches, we use an Encoder-Decoder architecture and map the problem of taxonomy classification to the task of machine translation (MT) AKA, Seq2Seq. An MT system takes the text in one language as input and outputs its translation as a sequence of words in another language. In our case, the input maps to the textual description of a product, and the output maps to the sequence of categories and sub-categories in our taxonomy (e.g., Clothing, Shoes & Jewelry > Baby > Shoes > Boots). By framing taxonomy classification as an MT problem, we overcome a lot of limitations present in classical classification approaches.

    • This architecture has the capability to predict a taxonomy that is not even present in the training data.
      • Talking about the example we discussed earlier where a traditional classification model was not able to predict the taxonomy for “Baby Boys knit terry shorts – cat & jack gray 12 m”, this Encoder-decoder model easily predicts the correct taxonomy as “ Clothing, Shoes & Jewelry > Baby > Clothing > Shorts”
    • We achieved a much higher accuracy because the model understands the semantic relationship between the input and output text, as well as giving attention to the most relevant parts in the input, when generating the output
    Fig. Attention visualization for product title “South of France lavender fields Bar Soap”. It can be seen from the image that the attention weights of “soap” word is very high when predicting the output at different time-steps.

    We used pre-trained fasttext word embeddings to vectorize textual input, pass on to the GRU-RNN based encoder which processes the input sequentially, and generates the final encoded vector. The Decoder which is also a GRU-RNN takes this encoded input and generates the output sequentially. Along with the encoded vector, there is also an attention vector which is passed to the Decoder for the output at every time-step.

    We trained both the Classification model (Baseline) and the Encoder-Decoder model for the Fashion category and the Beauty & Personal Care category. 

    For Fashion, we trained the model with 170,000 data points and validated it on a 30k set. For Beauty Category, we trained the model on 88k data points and validated it on a 20k set. We were able to achieve 92% Seq2Seq accuracy in 1,240 classes for the Fashion category and 96% Seq2Seq accuracy in 343 classes for the Beauty Category, using the Encoder-Decoder approach.

    Summary and the Way Forward

    Since we moved to this approach, we have seen drastic improvements in the accuracy of our Assortment Intelligence accounts. But the road doesn’t end here. There are several challenges to be tackled and worked upon. We’re planning on making this process language agnostic by using cross-lingual embeddings, merging models from different categories and also using product Image to complement the text-based model with visual input via a Multi-Modal approach.

    References

    Don’t Classify, Translate: Multi-Level E-Commerce Product Categorization Via Machine Translation by Maggie Yundi Li, Stanley Kok and Liling Tan

    SIGIR eCom’18 Data Challenge is organized by Rakuten Institute of Technology Boston (RIT-Boston)

    Massive Exploration of Neural Machine Translation Architectures by Denny Britz, Anna Goldie, Minh-Thang, and Luong Quoc Le

  • Mapping eCommerce Product Taxonomy with AI Pt. 1

    Mapping eCommerce Product Taxonomy with AI Pt. 1

    Product Taxonomy and its importance in retail

    Every product on a retail website is categorized in such a way that it denotes where the product belongs in the entire catalog. Generally, these categorizations follow a hierarchy that puts the product under some Category, Subcategory and Product Type (Ex. Clothing, Shoes & Jewelry > Men > Clothing > Shirts). We call this hierarchical eCommerce product categorization as Product Taxonomy. Categorizing products in a logical manner – in a way a shopper would find intuitive, helps in navigation when he or she is browsing an e-commerce website. 

    In addition, with a good category organization, a product lends itself for better searchability (for search engines) on e-commerce websites. Search engines work by looking up query terms in an index which points to products which contain those terms. Matches in various fields are ranked differently in relevance.

    For instance, a term that matches a word in the title, indicates greater relevance compared to one which matches the description. Additionally, terms that are exclusive to certain products, signal greater selectivity and hence contribute more to ranking. In light of this, the choice of words in fields indicating a product’s category affects the relevance of search results for a user query. This improves discoverability and as relevant results show up, it in turn improves the user experience. A good product taxonomy contributes to increased sales by helping shoppers find relevant products while browsing or searching. 

    Retail websites organize products into a taxonomy which they deem intuitive for their users, and fits the organization of their business units. Different retail websites could thus have taxonomies varying significantly from each other. Since we deal with millions of products across hundreds of websites on a daily basis, we often have to work with various taxonomies for the same product coming from different websites. 

    We are required to align these to a common standard taxonomy for our analyses. Standard taxonomies like Global Product Classification (GPC) taxonomies and Google Product taxonomies offer a standard way of representing a product. However, none of these taxonomies are complete and generic. Hence, we at DataWeave have come up with our own Standard Taxonomies for each category in e-commerce, which are generic enough to represent products on websites across different geographies.

    Having a standard taxonomy for each retail product is important for our Data Orchestration pipeline. A Standard Taxonomy helps in enriching the DataWeave Retail Knowledge Graph at scale.

    DataWeave’s Retail Knowledge Graph

    The information about products on most of the retail websites is unstructured and broken. We process this unstructured data, derive structured information from it and store it in a connected format in our Knowledge Graph. The Knowledge Graph is used in downstream applications like Attribute Tagging, Content Analysis, etc. The Knowledge Graph follows a standard hierarchy of 4 levels  (L1 > L2 > L3 > L4) for all the retail products.

    Mapping eCommerce retail taxonomies is not only a requirement for the Knowledge Graph, but has some direct business applications as well:

    Assortment Analytics

    • Mapping competitors’ products to their own taxonomies help retailers understand the exact gap in their assortment, regardless of how competitors are categorizing their products
    • Let’s say a retailer is interested in knowing the assortment of a product type, Scented Candles in their competitor’s catalog. Now, the retailer might have categorized it as Home & Kitchen > Home Decor > Scented Candle but the same product type could have been categorized as Fragrance > Home > Candles on a competitor’s website. Here, having an efficient and scalable mechanism to map product taxonomies provides accurate assortment analytics which retailers look for. Example:

    Health & Household > Health Care > Alternative Medicine > Aromatherapy > Candles

    Fragrance > Candles & Home Scents > Candles

    Automated Catalog Suggestion

    It is also used in Catalog Suggestion as a Service, where for any product we suggest the appropriate taxonomy it should follow on the website for a better browsing experience.

    Stay tuned to Part-2 to know how we are solving the  problem of mapping various retail taxonomies.

    Click here to know more about assortment analytics

  • Black Friday Prices Tempt Health & Beauty Shoppers

    Black Friday Prices Tempt Health & Beauty Shoppers

    Black Friday looked downright sultry with desirable discounts on health and beauty products.

    This year, health and beauty sales faced the threat of declining demand, as the pandemic keeps many consumers cooped up at home and in-store product testers no longer allowed. Yet consumers’ enduring desire to look and feel their best means this category will remain resilient. (Plus, we want to look smokin’ hot on Zoom.)

    That’s why we were curious to know how retail rivals, ranging from discounters to department stores, are battling it out to become bodacious beauty destinations to win the hearts, wallets and fake lashes of online shoppers.

    To calculate which retailers’ prices offered the broadest and most generous discounts, we examined health and beauty products’ pricing at Amazon, JC Penney, Macy’s, Neiman Marcus, Overstock, Nordstrom, Target and Walmart. We compared the pre-sale period (November 24-26) to the holiday sales period (Black Friday on November 27 through Cyber Monday on November 30) for a glimpse of retailers’ pricing strategies in this fiercely competitive category.

    BlackFriday_Health_Beauty_img1

    To gain insights into retailers’ competitive pricing strategies, we tracked three scenarios: whether prices decreased, increased or remained the same during the last week of November 2020. The vast majority of health and beauty products (91.0%) maintained the same prices during the pre-sale and sales periods. An astounding 99.7% of Target’s health and beauty prices stayed the same during the period.

    Amazon had the highest proportion of health and beauty products that offered a price decrease (18.1%), particularly on men’s fragrance, women’s fragrance and men’s hair care. Offering discounts on more items hints that Amazon wants to attract more health and beauty consumers, including men, by making more items affordable. Target offered the lowest proportion of health and beauty products with price decreases (0.8%).

    Amazon also had the greatest proportion of health and beauty products with a price increase (7.0%) with 15.3% of men’s fragrance earning a price hike.

    BlackFriday_Health_Beauty_img2

    On Black Friday, among health and beauty products with price decreases, Target gave the most generous average discount (37.6% vs. 7.2% for Overstock). However, Target’s discounts applied to only 12 products compared to 798 for Overstock.

    Common types of health and beauty products with the highest average discount on Black Friday have included face makeup, men’s fragrance, men’s hair care, and shampoo and conditioner.

    Among health and beauty products with price increases on Black Friday, Nordstrom had the highest average price hike (43.8% on one women’s fragrance) and Walmart offered the lowest (10.3% on 250 products).

    These findings suggest that Target was willing to create aggressive loss leaders in this category and Amazon wanted to boost health and beauty sales among male shoppers.

    Black Friday vs. Cyber Monday

    BlackFriday_Health_Beauty_img3

    This year, most retailers offered more additional discounts on health and beauty products on Cyber Monday than on Black Friday, possibly to prioritize clearing out their inventory before year-end. JC Penney and Macy’s were the exception. Overall, the top product types that received additional discounts included shave and hair removal, women’s fragrance and face makeup.

    On Cyber Monday, Amazon offered additional discounts on the greatest proportion of health and beauty products (21.1% vs. 2.1% for Target). Amazon focused on men’s hair care, shampoo and conditioner and face makeup.

    BlackFriday_Health_Beauty_img4

    Half the retailers (Amazon, JC Penney, Nordstrom and Overstock) offered deeper additional discounts on health & beauty on Cyber Monday than Black Friday, possibly to clear out their inventory before the end of the year. Cyber Monday discounts ranged from 35.0% for Nordstrom to 7.8% for Overstock.

    Meanwhile, both Neiman Marcus and Walmart offered the same levels of discounts on both Black Friday and Cyber Monday.

    Overall, the types of health and beauty products with the deepest discounts on both Black Friday and Cyber Monday were shampoo and conditioner, men’s hair care and face makeup.

    Additional discounts across products by “premiumness” level

    For almost all the retailers, the percentage of health and beauty products with additional discounts was higher on Cyber Monday than on Black Friday. Overstock had the highest proportion (20.2%), slightly more than Amazon (20.0%).

    JC Penney had a higher percentage of products with additional discounts on Black Friday. Neiman Marcus had the same percentage of products on both sales days.

    All the retailers except JC Penney and  Neiman Marcus allocated the greatest percentage of their additional discounts to health and beauty products at the high level of premium. The retailers may have wanted to appeal to upscale shoppers and make high premium goods more accessible to a broader audience of consumers.

    Half of the retailers (JC Penney, Nordstrom, Target and Walmart) offered deeper discounts on Black Friday than Cyber Monday.

    Target offered the most generous discounts on Black Friday with an average additional discount of 39.7%, which ranged from 50.1% on moderately premium health and beauty products to 28.6% for products at a high premium level. Target appeared to make more beauty items, including high premium items, affordable to more consumers to stay competitive as a beauty destination.

    Conversely, Amazon, Overstock and Macy’s were more generous with additional discounts on Cyber Monday. Among the high premium level of health and beauty products on Cyber Monday, Macy’s offered the deepest discounts (31.3%), edging out department store rival JC Penney (30.4%) in competing for upscale shoppers.

    Health & Beauty’s Ravishing Holiday Prices

    This year’s Black Friday and Cyber Monday pricing strategies showed retailers’ attempts to stand out, expand their market reach to stay competitive. Appealing to a broader audience included spanning upscale and value tiers, and wooing more male online shoppers to grow their top line and boost loyalty in an intense category amid a pandemic.

    Stay tuned for more Black Friday and Cyber Monday 2020 analysis to discover how retailers strategically price their products to win in leading e-commerce categories.


  • Who Won Black Friday’s Electronics Price War?

    Who Won Black Friday’s Electronics Price War?

    Electronics have never been hotter.

    This year’s COVID-19 pandemic created a seismic shift towards tech, directly affecting retailers’ Black Friday and Cyber Monday pricing strategies for electronics. Prime Day 2020’s new fall date also inevitably influenced pricing and purchasing patterns. If consumers pampered themselves with a 75-inch TV in October, what are the odds they’re in the market for another big-screen TV in late November?

    Consumer electronics are perennial holiday bestsellers because they make gift-giving easy, whether we buy them for others or for personal indulgence. Continuous innovation also means a comparatively shorter product lifecycle, making electronics an exciting, progressive retail category.

    To determine which retailers’ pricing strategies offered the most generous discounts on electronic products, we examined electronics pricing at Amazon, Best Buy, Overstock, Target and Walmart. We compared during the pre-sale period (November 24-26) to the holiday sales period (Black Friday on November 27 through Cyber Monday on November 30) for a glimpse of retailers’ pricing strategies to stay competitive in 2020.

    For competitive pricing insights, we tracked three scenarios before and during 2020’s traditional holiday sales season: whether prices decreased, increased or remained the same. Most strikingly, the overwhelming majority of electronics products (89.8%) maintained the same prices during the pre-sale and sales periods. For instance, Target kept a whopping 98.0% of its electronics prices the same during the period.

    Amazon had the greatest proportion of electronics products that offered a price decrease (11.7%), particularly on laptops, mobiles and wearable technology. These results also suggest Amazon wants to reach more consumers by making more electronics affordable with discounts. Target offered the lowest proportion of electronics with price decreases (2.5%).

    Overstock had the greatest proportion of electronics products that offered a price increase (10.7%) with 30.3% of TVs increasing in price. Best Buy offered the lowest proportion of electronics with price increases (1.2%).

    Among electronics products with price decreases on Black Friday, Best Buy offered the highest average discount (16.6%) and Amazon offered the lowest (10.2%). Among all the retailers, the types of electronics with the highest average discount included tablets, headphones, laptops and TVs.

    Among electronics products with price increases on Black Friday, Best Buy had the highest average price hike (30.2%) and Amazon offered the lowest (9.8%). That said, Best Buy increased the price of one laptop by 73.1% whereas Amazon increased the price of 44 laptops by an average of 4.2%.

    These findings show that Best Buy aggressively protected its market share in this competitive category by offering the most generous discounts.

    Black Friday vs. Cyber Monday

    Without exception, the retailers offered more additional discounts across the electronics category on Cyber Monday than on Black Friday. Retailers may have wanted to clear out their inventory to make room for new, innovative products in their assortments.

    Amazon had the greatest proportion of electronics with additional discounts on Cyber Monday (15.7%, which is more than double the 7.3% each for Overstock and Target). Amazon’s additional discounts focused on mobiles, laptops and wearable technology.

    Overall, the greatest proportion of additional discounts on electronics on Cyber Monday focused on laptops, desktops and USB flash drives.

    While most retailers offered deeper discounts on electronics on Cyber Monday than Black Friday, Overstock was the sole exception.

    On Cyber Monday, Target offered the most generous average additional discounts (19.6% vs. 10.2% for Amazon); however, Target’s discounts applied to 260 electronics products compared to 924 for Amazon.

    Overall, the types of electronics with the deepest discounts on Cyber Monday on electronics were USB flash drives, tablets and headphones.

    Additional discounts across products by “premiumness” level

    When we examine electronics’ additional discounts according to the products’ premium level, several patterns stand out.

    Most apparent is that every retailer offered a higher proportion of additional discounts on Cyber Monday compared to Black Friday, ranging from 15.9% for Amazon to 6.4% for Best Buy.

    With only one exception, Amazon offered the greatest proportion of additional discounts across all premium levels. Only Target offered a slightly higher proportion among low premium electronics (11.9% vs. 11.3% for Amazon). This approach could help Amazon make more electronics products more affordable to more consumers and boost its reach in this competitive category.

    Among electronic items at the high premium level, Amazon was most aggressive in allocating additional discounts (21.0% vs. 5.4% for Target), which could help the e-commerce giant earn top-of-mind status among affluent shoppers in the market for big-ticket electronics.

    Most retailers (Amazon, Best Buy and Walmart) offered deeper discounts on Cyber Monday than Black Friday. By contrast, Overstock and Target were more generous on Black Friday.

    Interestingly, Target’s average additional discount on Cyber Monday (18.8%) was still more generous than those of the other retailers.

    Among moderately premium items, Target’s average additional discount was 22.3%, more than double Amazon’s 10.3%. Target may have tried to make mid-market electronics more affordable to its core audience of value-seeking shoppers.

    Additional discounts across products by “popularity” level

    A review of retailers’ additional discounts by electronics’ popularity level reveals that most retailers allocated a bigger proportion of discounts on Cyber Monday than on Black Friday. Overstock was the exception. Again, clearing out 2020 inventory before year-end likely influenced retailers’ pricing strategies.

    Overall, on Cyber Monday retailers showed a direct relationship between additional discounts and electronics’ popularity levels. For instance, Amazon offered additional discounts on 21.7% of highly popular electronics and 15.3% on moderately popular electronics. Since Amazon strives to be “The Everything Store,” it makes sense to make more products more appealing and affordable to more consumers. Meanwhile, Target offered nearly double the proportion of additional discounts of less popular electronics than discount rival Walmart (12.5% vs. 6.7%) to tempt value-seekers with deals.

    Most retailers (Amazon, Best Buy, Target and Walmart) offered deeper discounts on Cyber Monday than Black Friday. Overstock was more generous on Black Friday.

    On Cyber Monday, Target’s average additional discount (21.8%) was the most generous of all the retailers, nearly double that of Amazon (11.1%). However, Target’s discounts applied to 259 electronics products. vs. 903 for Amazon.

    Both Amazon and Overstock gave their most generous discounts to less-popular electronics, possibly to clear out their inventory to make room for more popular or higher-margin items.

    Black Friday & Cyber Monday 2020 Electronics Pricing Strategies

    This year, the pandemic jolted consumers to focus on digital technology to stay connected to work, school and retail, which heightened demand for electronics.

    In response, retailers’ 2020 pricing strategies for Black Friday and Cyber Monday suggest a desire to extend their reach beyond their core audience to maximize their brand appeal and steal rivals’ market share.

    The Cyber Monday findings, in particular, suggest retailers decluttered their assortments to make space for the latest and highest-margin tech gadgets in time for Christmas.

    Click here for more Black Friday and Cyber Monday 2020 analysis for greater clarity on the evolving pricing positions of retail rivals across top e-commerce categories.


  • Black Friday Furniture Prices Inspire Home Makeovers

    Black Friday Furniture Prices Inspire Home Makeovers

    As most of us stay home for the holidays this year, retailers hope we’ll invest in our nest.

    The global pandemic ignited sales in the red-hot home furniture category, as our domestic comfort, functionality and aesthetics suddenly became urgent priorities in 2020. Now we’re investing more in domestic leisure, organizing and redecorating as our consumption habits shift.

    That’s why we wanted to know how retailers adapted their Black Friday and Cyber Monday furniture pricing strategies to meet consumers’ needs. For instance, did retailers give the best deals on low-commitment furniture like area rugs or on big-ticket items like dining room sets?

    To pinpoint which retailers offered the greatest proportion of discounts and the deepest discounts, we reviewed furniture at Amazon, Home Depot, JC Penney, Overstock, Target, Walmart and Wayfair. We compared the pre-sale period (November 24-26) to the holiday sales period (Black Friday on November 27 through Cyber Monday on November 30) to monitor retailers’ furniture pricing moves.

    Top product types by additional discount

    BlackFriday_homefurnishings

    To review retailers’ holiday pricing strategies in the furniture category, we tracked three scenarios: whether prices decreased, increased or remained the same during the last week of November 2020.

    The proportion of furniture items that maintained the same prices during the pre-sale and sales periods ranged widely, from 91.6% for Home Depot to only 22.6% for Wayfair.

    That’s because Wayfair had by far the highest proportion of furniture with a price decrease (77.2% on 4254 products vs. 7.1% on 342 products for Home Depot). Since Wayfair specializes in home décor, it makes sense for the retailer to aggressively distribute discounts across its furniture assortment.

    Among all retailers, the top types of furniture with discounts included bookcases, entertainment units, sofas and storage and cabinets. These findings suggest we are investing in domestic leisure, relaxation and organization.

    BlackFriday_homefurnishings_saleanalysis

    On Black Friday, JC Penney offered the most generous average discount (21.3% vs. 4.6% for Wayfair). This means that although Wayfair spread discounts across its furniture subcategories, the actual discounts were lower than rivals’.

    Types of furniture with the highest average discount on Black Friday at JC Penney included storage and cabinets, bookcases and rugs. These products tend to be affordable additions to our homes compared to bigger investments like a dining room set.

    Black Friday Vs. Cyber Monday

    CyberMonday_homefurnishings

    On Cyber Monday, Target offered additional discounts on the greatest proportion of furniture (27.4% vs. 7.8% for JC Penney). These findings suggest Target really wants to be a convenient option for shoppers, including their home furnishing needs.

    Among all retailers, the top types of discounted furniture included rugs, beds and entertainment units.

    Most retailers offered deeper additional discounts on furniture on Cyber Monday than Black Friday, possibly to maximize sales before the end of the year. Cyber Monday discounts for furniture ranged from 20.9% for JC Penney to 4.9% for Wayfair. Among all retailers, the top types of furniture that received discounts on Cyber Monday were rugs, storage and cabinets and dining table sets, which show that redecorating and organizing were in style this holiday season.

    Additional discounts across product “premiumness” levels

    BlackFridayVsCyberMonday_homefurnishings

    Nearly all retailers had a higher proportion of furniture with additional discounts on Cyber Monday than on Black Friday. Wayfair had the highest proportion (79.2% for both Cyber Monday and Black Friday vs. 9.3 for Home Depot). Wayfair’s use of discounts across all premium levels on both major sales days shows the retailer wants to extend its brand reach, own this category and earn top-of-mind status across diverse furniture shoppers at all price points.

    Only JC Penney had a higher percentage of furniture with additional discounts on Black Friday.

    Every retailer offered deeper discounts on Cyber Monday than Black Friday, likely to clear out 2020 merchandise.

    On Cyber Monday, JC Penney offered the most generous furniture discounts, with an average additional discount of 38.0%, which ranged from 35.1% at the low premium level to 40.9% at the moderately premium level. Aggressive discounts could set JC Penney apart among department stores and attract more low- to mid-market consumers with tempting furniture deals.

    Also, most retailers gave the deepest discounts on furniture at the high premium level, which can help to make upscale items accessible and affordable to a greater number of consumers.

    Additional discounts across product “popularity” levels

    CyberMondayVsBlackFriday_homefurnishings

    Almost all retailers offered a greater proportion of additional furniture discounts on Cyber Monday than on Black Friday, ranging from 67.6% for Wayfair to 7.8% for Home Depot.

    Across all levels of popularity for furniture, Wayfair dominated with discounts on the most diverse array of products to give more furniture shoppers an opportunity to save money.

    Meanwhile, Amazon and JC Penney offered the greatest proportion of discounts at the low level of popularity, possibly to declutter their furniture assortment to make room for in-demand products.

    Nearly every retailer offered deeper discounts on furniture on Cyber Monday than on Black Friday, with JC Penney being the most generous (39.1% vs. 5.3% for Wayfair).

    Home Depot and Wayfair prioritized discounts among less popular furniture, likely to clear them out and make more room in their assortments for items people really want.   

    Amazon and Walmart gave deeper discounts on highly popular furniture to battle it out over bestsellers.

    Holiday Furniture Pricing Inspires Us to Reimagine Our Space

    This year, more consumers decluttered their homes and more retailers decluttered their furniture assortment by clearing out 2020 merchandise with desirable deals on Black Friday and Cyber Monday.

    The findings of this pricing analysis hint at retailers’ competitive positioning. To own the furniture category, Wayfair aggressively allocated discounts across its assortment even if rivals gave deeper discounts. Target’s deep discounts helped to position the chain as a convenient option for shoppers’ cross-category needs, including furniture. JC Penney’s astonishingly deep discounts on Black Friday and Cyber Monday could help to liquidate inventory, whereas Amazon and Walmart battled over bestsellers.

    Click here for more Black Friday and Cyber Monday analysis to learn about retailers’ holiday pricing strategies during 2020’s e-commerce boom.

  • Black Friday Prices Wowed Fashionistas

    Black Friday Prices Wowed Fashionistas

    Retailers really wanted to dress us up this holiday season.

    This year’s Black Friday and Cyber Monday fashion pricing trends reflect how retailers have responded to the pandemic’s influence on apparel shopping to boost their resilience and competitiveness.

    For instance, since most consumers now cocoon at home, few of us are likely to splurge on fancy gowns or suits as holiday gifts for ourselves or others. That’s why we wanted to know which retailers doubled down on Black Friday fashion discounts and which ones used Cyber Monday discounts to make room for in-demand merchandise.

    To calculate which retailers’ prices offered the greatest proportion of discounts and the deepest discounts, we analyzed men’s and women’s fashions at Amazon, Bloomingdale’s, JC Penney, Macy’s, Neiman Marcus, Overstock, Nordstrom, Target and Walmart. We compared the pre-sale period (November 24-26) to the holiday sales period (Black Friday on November 27 through Cyber Monday on November 30) to gain insights into retailers’ pricing strategies in fashion.

    Top product types by additional discounts- Men’s fashion

    To review retailers’ holiday pricing strategies, we tracked three scenarios: whether prices decreased, increased or remained the same during the last week of November 2020.

    The overall proportion of men’s fashion items that maintained the same prices during the pre-sale and sales periods was 88.6%, ranging from 99.5% for JC Penney to 75.0% for Neiman Marcus.

    Neiman Marcus had the highest proportion of men’s fashions with a price decrease (25.0% vs. 1.4% for JC Penney). Top types of men’s fashions that had discounts were formal shoes, jackets and coats, and sports shoes. These findings seem to reflect how we rarely go out during the pandemic yet we’re exercising more.

    In addition, Amazon and Walmart were most active in offering discounts across all men’s fashion subcategories with Amazon offering more than double Walmart’s percentage of products discounted (15.9% vs. 7.1%).


    On Black Friday, JC Penney offered the most generous average discounts (35.6% vs. 9.4% for Overstock). While that contrast seems dramatic, it’s important to note JC Penney’s discounts applied to only 8 products compared to 929 for Overstock.

    Men’s fashions with the highest average discount on Black Friday included formal shoes, jackets and coats and jeans.

    Top product types by additional discounts- Women’s fashion

    For women’s fashions we also tracked whether prices decreased, increased or remained the same during the last week of November 2020. The vast majority of women’s fashions (89.3%) maintained the same prices during the pre-sale and sales periods. A whopping 99.3% of Target’s women’s fashion prices stayed the same.

    Neiman Marcus had the highest proportion of women’s fashions with a price decrease (33.4%), particularly on casual shoes, t-shirts and lingerie. JC Penney and Target offered the lowest proportion of price decreases on women’s fashions (1.9%).

    Similar to men’s fashions, Amazon and Walmart offered price discounts across all the women’s fashion subcategories with Amazon offering a higher proportion of products with discounts. (10.7% vs. 7.7% for Walmart)

    On Black Friday, JC Penney offered the most generous average discounts (45.0% vs. 12.2% for Overstock) yet JC Penney’s discounts applied to only 28 products compared to 1952 for Overstock.

    The types of women’s fashions with the highest average discount on Black Friday included tops, casual shoes and handbags. Perhaps women pampered themselves with a new purse and new tops to look chic on Zoom calls.

    Black Friday Vs Cyber Monday

    During this year’s holiday sales events, almost all retailers offered more additional discounts on men’s and women’s fashion on Cyber Monday than on Black Friday, possibly to sell off seasonal inventory before year-end. Nordstrom was the only exception, offering more discounts on Black Friday.

    On Cyber Monday, Target offered additional discounts on the greatest proportion of men’s fashions (63.3% vs. 10.6% for Walmart). Top types of men’s fashions with discounts included underwear, jeans, jackets and coats.

    Similarly, Target offered additional discounts on the greatest proportion of women’s fashions on Cyber Monday (79.4% vs. 3.2% for JC Penney). The most common types of discounted women’s fashions were dresses and jumpsuits, t-shirts and casual shoes.

    These findings suggest Target is aggressively pursuing value shoppers and positioning the chain as a convenient source for all the whole family’s apparel needs.

    Most retailers (Amazon, Nordstrom, Overstock, Target and Walmart) offered deeper additional discounts on men’s fashions on Cyber Monday than Black Friday, possibly to maximize year-end sales and clear out seasonal inventory. Cyber Monday discounts for men’s fashions ranged from 29.8% for Nordstrom to 11.0% for Overstock. Top types of men’s fashions that received Cyber Monday discounts included jackets and coats, formal shoes, sunglasses and t-shirts, which reflect how men are going out less.

    Conversely, most retailers (JC Penney, Macy’s, Neiman Marcus, Nordstrom and Walmart) offered deeper additional discounts on women’s fashions on Black Friday than Cyber Monday, possibly to entice women to get a jumpstart on the holiday sales weekend to maximize top line performance in this competitive category. Black Friday discounts for women’s fashions ranged from 45.0% for JC Penney to 12.2% for Overstock. Top types of women’s fashions with Black Friday discounts included swimwear, lingerie and t-shirts, which reflect seasonal merchandise.

    Additional discounts across products by “premiumness” level

    For almost every retailer, the percentage of fashions with additional discounts was higher on Cyber Monday than on Black Friday. Target had the highest proportion (62.7% vs. 5.7% for JC Penney). It appears Target really wants to win value-seeking apparel shoppers, by offering additional discounts on 93.3% of fashions at the low premium level (vs. 4.6% for Walmart).

    By contrast, Nordstrom had a higher percentage of fashions with additional discounts on Black Friday.

    Most retailers (Amazon, Bloomingdale’s, Neiman Marcus, Overstock, Target and Walmart) offered deeper discounts on Cyber Monday than Black Friday, likely make room for new seasonal merchandise.

    Neiman Marcus offered the most generous fashion discounts on Cyber Monday with an average additional discount of 30.1%, which ranged from 31.7% at the high premium level to 28.9% at the low premium level. This aggressive discounting could help Neiman Marcus stand out among department stores, and extend its reach and appeal by making fashions more affordable across price points.

    Conversely, JC Penney, Macy’s and Nordstrom offered deeper discounts on Black Friday. All three department stores were most generous at the low premium level for fashions, with JC Penney offering the deepest discounts (47.8%) to turn low premium fashions into irresistible Black Friday bargains.

    Additional discounts across products by “popularity” level

    Almost all retailers offered a greater proportion of additional fashion discounts on Cyber Monday than on Black Friday, ranging from 69.2% for Target to 5.2% for JC Penney, with a direct relationship between product popularity and additional discount percentage. Across all levels of popularity for fashions, Target was by far the most aggressive with discounts to appeal to the broadest variety of fashion shoppers.

    Only Nordstrom offered a higher proportion of additional discounts on fashions on Black Friday, focusing on both high and low levels of popularity.

    Most retailers (Amazon, Neiman Marcus, Overstock, Target and Walmart) offered deeper fashion discounts on Cyber Monday than on Black Friday, with both Neiman Marcus and Target being the most generous (28.8%). Amazon and Neiman Marcus were most generous with discounts among less popular items, while Overstock, Target and Walmart were most generous among moderately popular fashions.

    Conversely, JC Penney, Macy’s and Nordstrom offered more generous fashion discounts on Black Friday, with JC Penney being the most generous (39.2%). All three retailers offered the deepest discounts at the low level of popularity, possibly to make room for in-demand fashion items.

    2020’s Fashionable Holiday Prices

    As this year’s Black Friday and Cyber Monday fashion pricing results show, we prioritized comfort and basics over debonair formalwear. Since staying at home is in style, many retailers discounted dressier attire.

    In terms of competitive pricing strategies, Target’s aggressive discounts could boost the chain’s appeal among diverse fashion shoppers. Also, Neiman Marcus stood out among department stores by extending its reach and affordability across pricing tiers. 

    Click here for more Black Friday and Cyber Monday analysis to learn about retailers’ holiday pricing strategies during 2020’s e-commerce boom.


  • Country of Origin: E-retailers in India | DataWeave

    Country of Origin: E-retailers in India | DataWeave

    ‘Make in India’ is a headline you’re likely to have seen smeared across newspapers or as campaign rhetoric. E-retailers in India were mandated to display the country of origin against all the products starting 1st August, 2020. The rationale behind this move was to provide the customer the information which would aid the government to accelerate their plans on curbing imports.  

    To get an idea of the extent that this was followed, we looked at 29,000+ products on Amazon and 20,000+ products on Flipkart, across popular categories.

    What our data revealed (illustrated in the chart above) is that Flipkart had updated the country of origin information for 91% of the products while Amazon had updated for only 56%. In categories like Grocery/ Cooking Essentials and Personal Care, Flipkart updated this information across 100% of products that we looked at. 

    The chart above reveals interesting insights into the respective product mixes of Flipkart and Amazon. We narrowed our study to three categories that stood out; Electronics, Baby products and Men’s’ fashion. These are the categories we noticed that have the most number of products that are manufactured out of India. Apart from India, the largest manufacturer is China, where a lot of these products come from. Looking at this chart, we see that most of Flipkart’s products are manufactured in India, compared to its counterpart.

    To sum up, we noticed that Flipkart has updated 91% of its products while Amazon has updated only 56% of their products of the products we tracked. 

    With the heightened emphasis on Make in India and reducing imports, sellers importing from other countries might have to rethink how to replace the products they currently are sourcing with local products. This also provides an opportunity to the Indian manufacturers to produce popular products which are currently being imported.

    We’ll now have to wait and watch over the coming months to see how things unfold for these retailers and the sellers.

  • Amazon’s losing its pricing advantage this holiday season

    Amazon’s losing its pricing advantage this holiday season

    Amazon’s pricing advantage has declined in key categories, compared to last year as we enter 2020’s holiday season.

    The holidays are here and the retail industry is gearing up for the yearly stampede. In a report published by Bain & Company, in partnership with DataWeave, it was observed that, “When it comes to pricing, Amazon’s historical advantage is also deteriorating. The research shows that in October and November 2019, Amazon matched or beat competitors’ prices 81% of the time in the categories studied. By November of 2020, that rate dropped to 74%”. This was based on the four key categories where we had pricing data for Amazon and at least one other competitor.

    Amazon’s pricing advantage has declined in key categories

    Amazon_product_pricing

    Aggressive pricing, which was once Amazon’s forte, seems to be on a downward trend this year. All but one category saw an increase in the percentage of products where they beat the lowest price, ‘movies, music, video games’ – by a small margin of one percentage point.

    What could this shift be attributed to? The obvious would be the repercussions of COVID but there perhaps is more at work here. As observed last year, the behemoth that Amazon is, does not deter its competitors from constantly biting at the heels, with a steely determination to rope in market share. Everything from increased and specific customer demands, to government legislation, there are a lot of moving parts.

    One thing is for sure, this is surely just the beginning of the great e-commerce battle. For access to the full article that was published in the Retail Holiday Newsletter by Bain & Company and powered by DataWeave, click here.

  • How Essential Goods Have Shaped Retail Strategies

    How Essential Goods Have Shaped Retail Strategies

    The rapid evolution in essential goods is rattling retail. That’s because the COVID-19 pandemic has dramatically changed shopping habits and retail necessities, leading to unpredictable shifts in demand.

    Most notably, U.S. e-commerce has surged by an astonishing 45% year-over-year, as the pandemic accelerated online shopping by five years.[1] Since more consumers now work and learn from home, many pandemic-inspired habits will likely shape retail for years to come.[2]

    Now that the risk of the second wave lies ahead, it’s the ideal time for retailers to review pandemic bestsellers and patterns to adapt to shifts in shopping behavior.


    Pandemic’s bestsellers shape retail strategies

    2020’s unexpected consumption patterns give retailers a glimpse of how they can adapt and thrive. The best-selling essential goods during the pandemic have included:

    • Toilet paper: +734% year-over-year (YoY) growth in March[3]
    • Disposable gloves: +670% in March[4]
    • Fitness equipment: + 535% YoY in online sales for February to March[5]
    • Hand sanitizer: +470% YoY for the week ending March 7[6]
    • Yeast: +410% YoY for the four weeks ending April 11[7]
    • Puzzles: +370% YoY in the last two weeks of March
    • Pyjamas: + 143% in online sales between March and April[8]

    As such, retailers can ensure their assortments contain these types of popular cross-category items, which reflect overall themes of consumers’ needs for self-sufficiency, wellness and comfort.

    E-grocery is also soaring, as experts predict a 40% rise in U.S. online grocery sales in 2020 due to the pandemic.[9] Top categories bought by online grocery shoppers include:

    • Packaged non-fresh food (69%)
    • Toiletries, personal care and diapers (63%)
    • Household cleaning and paper products (61%)[10]

    In response to these trends, retailers can prioritize shelf-stable center store products and non-food consumer goods throughout the pandemic.

    How retailers boost agility, clarity and sales amid COVID-19 chaos

    Consumer panic led to pricing volatility for hard-to-find items like hand sanitizer, disinfectant wipes and masks.[11] To keep up with competitors’ online price fluctuations, more retailers use competitive analytics to adapt their own prices accordingly. Notably, McKinsey & Company cites data insights and price sensitivity as the top two disruptive trends the pandemic has turbocharged.[12]

    In March, shortages of toilet paper and flour led consumers to react with panic and hoarding that created urgent supply chain issues. To avoid out-of-stock items, more retailers now turn to data insights to identify potential disruptions. Up-to-date insights help retailers spot emerging market trends and adapt their assortment to stock in-demand items.

    Now that more consumers shop online, retailers are investing in digital promotions to boost sales. Data analytics help retailers quickly evaluate the effectiveness of their promotions, which can inspire consumers to fill their baskets. Nimbly adapting to competitors’ promotions is essential, as McKinsey cites rising competition for deals among the pandemic’s most disruptive retail trends.[13]

    Avoid empty shelves: The pandemic has motivated more retailers to rely on data insights to make fast, effective pricing and assortment decisions.

    As consumption habits evolve, high-level dashboards help retailers quickly spot inventory shortages to prevent out-of-stocks.

    To make their retail strategies pandemic-proof, leading retailers are collaborating with DataWeave to access accurate, actionable insights that boost online agility and sales. Applying DataWeave’s trusted data gives retailers clarity amid today’s chaotic market and shifting demand for essential goods, so they can make effective decisions fast. Insights also help retailers enhance the customer experience by supporting in-stock product assortments, competitive pricing and effective promotions that boost sales, trust and loyalty. To see how DataWeave helps retailers stay agile and competitive, visit dataweave.com.


    [1] Perez, Sarah. COVID-19 pandemic accelerated shift to e-commerce by 5 years, new report says. TechCrunch. August 24, 2020.

    [2] Gottlieb, David. 5 Strategic Imperatives for Retail’s New Normal. Total Retail. August 18, 2020.

    [3] Weiczner, Jen. The case of the missing toilet paper: How the coronavirus exposed U.S. supply chain flaws. Fortune. May 18, 2020.

    [4] Clement, J. COVID-19 impact on fastest growing e-commerce categories in the U.S. 2020. Statista. June 19, 2020.

    [5] Gibson, Kate. Coronavirus inspires fitness buying binge that tops New Year’s. CBS News. April 1, 2020.

    [6] Chasark, Krisann. Coronavirus impact: Hair dye becoming next high-demand item amid COVID-19 pandemic. ABC News. April 11, 2020.

    [7] Guynn, Jessica and Kelly Tyko. Dry yeast flew off shelves during coronavirus pantry stocking. Here’s when you can buy it again. USA Today. April 23, 2020

    [8] Thomas, Lauren. Comfort is en vogue during coronavirus: PJ sales surge 143%, pants sales fall 13%. CNBC. May 12, 2020.

    [9] Redman, Russell. Online grocery sales to grow 40% in 2020. Supermarket News. May 11, 2020.

    [10] Redman, Russell. Online grocery sales to grow 40% in 2020. Supermarket News. May 11, 2020.

    [11] Levenson, Michael. Price Gouging Complaints Surge Amid Coronavirus Pandemic. The New York Times. March 27, 2020.

    [12] Kopka, Udo, Eldon Little, Jessica Moulton, René Schmutzler, and Patrick Simon. What got us here won’t get us there: A new model for the consumer goods industry. McKinsey & Company. July 30, 2020.

    [13] Kopka, Udo, Eldon Little, Jessica Moulton, René Schmutzler, and Patrick Simon. What got us here won’t get us there: A new model for the consumer goods industry. McKinsey & Company. July 30, 2020.

  • How E-commerce Brands Build Customer Trust | DataWeave

    How E-commerce Brands Build Customer Trust | DataWeave

    Brands that build consumer trust will win big as online shopping explodes this year. As the COVID-19 pandemic propels more shoppers online, an astounding $5 trillion (30%) of annual global retail sales is up for grabs as the market shifts to e-commerce, according to Boston Consulting Group.[1]

    Notably, e-commerce has changed brands’ retail processes. Unlike brick-and-mortar stores, the digital shelf is where brands manage their company and products among online shoppers, influencing what they browse and buy.

    Rather than stocking merchandise through retailers’ physical stores, brands can now manage their online products by working with logistics experts like Fulfillment by Amazon. Instead of merchandising in stores with planograms and endcap displays, brands promote their digital assortment with targeted product content that resonates and keeps them coming back.[2] The evolution of retail can help brands save time and effort, and increase their agility and effectiveness.


    Gaining high visibility on the digital shelf can help brands boost their reach, brand awareness and sales. That’s why more brands are now investing in proven e-commerce best practices to increase consumer confidence by offering reliable products, relevant marketing and a smooth online experience. Now that the 2020 holiday sales season is underway, it’s the perfect time to see how leading brands compete in the increasingly crowded online market by demonstrating credibility and consistency.


    Market fragmentation increases brand complexity

    Selling across multiple online touchpoints means brands have more e-commerce websites and digital shelves to monitor to ensure compliance with brand guidelines to ensuring a consistent customer experience. To engage online shoppers, brands’ marketing strategies must now diligently manage their digital shelf across diverse online shopping arenas, including:

    • Direct-to-consumer (DTC) sites: More brand manufacturers are shortening the supply chain by bypassing retailers and selling directly to consumers, including sales through their own e-commerce websites.eMarketer predicts that U.S. DTC e-commerce sales will grow by 24% to reach nearly $18 billion in 2020.[3]

    • Retailers’ e-commerce sites: Brands are also migrating online because the retailers who sell their merchandise moved online this yearto adapt to the pandemic and survive shuttered storefronts. As of April 21, e-commerce grew 129% year-over-yearin U.S. and Canadian orders and U.S. e-commerce sales are on track to hit nearly $710 billion this year.[4] More than ever, sharing timely, accurate product information with retail partners is essential for success.

    • Online marketplaces: A growing number of brands are investing in digital advertising and content to stand out on popular, high-traffic online marketplaces. Global e-commerce leaders Amazon, eBay and China’s Alibaba and JD, are mostly search-based sites, as users know what they want and search for it, which makes product description pages and ads important marketing tools. Conversely, China’s Pinduoduo platform involves group-buying and interactive games to boost brand awareness and sales by entertaining online consumers and inspiring flattering word-of-mouth.[5] Among online marketplaces, digital content fuels brand discovery and sales.

    • Last-mile delivery channels: Brands can also sell in collaboration with their last-mile partners. Last-mile experts like Peapod, Instacart, Uber and Shipt offer online advertising opportunities for brands to reach new audiences. For instance, Instacart launched a self-serve advertising platform that lets brands promote their products in search results. Brands can choose the products to promote, set a budget and pay when users engage with those products.[6]

    • Social media: To reach and influence consumers where they already spend their time, more brands are investing in social media promotions and even embracing social commerce innovation. Social media matters to brands’ marketing effectiveness, as 52% of online brand discovery happens on social feeds.[7] Also, 92% of Instagram users say they’ve followed a brand, visited their website or made a purchase after seeing a product on Instagram.[8]

    Brand promotions have evolved beyond Google AdWords and Facebook campaigns. Now promotions include digital content and ads across all of these digital touchpoints, which increases the scope of brand marketing efforts to reach online consumers.

    How brands transform digital shelf complexity into clarity

    To earn online shoppers’ trust across e-commerce arenas, more leading companies are turning to a common solution: data.


    Too often, online shoppers abandon their cart due to concerns that they will unwittingly buy inauthentic products from fraudulent sellers. To protect their brands, manufacturers use data insights to pinpoint and prevent unauthorized sellers, counterfeit products and minimum advertised price (MAP) violations to demonstrate authenticity, accountability and price parity.

    Digital is the new normal”
    ~ Nike CEO John Donahoe
    [9]

    To invigorate underperforming online promotions, brands rely on analytics to connect the dots among their online promotions, marketing performance and share of voice. Insights on advertising, keywords and consumer reviews help brands make better marketing decisions faster. These insights help brands stand out from competitors and build relationships with shoppers by ensuring their promotions resonate and drive more sales online.

    To overcome low online traffic and sales, more brands apply data insights to improve their digital presence, visibility and sell-through rates. Brand analytics measure their popularity on e-commerce websites and track their stock status to improve accessibility, optimize digital shelf velocity and deliver a reliable customer experience that builds trust.


    Watch over your brand: To stay competitive and earn consumer trust, more brands now rely on data insights to make fast, effective decisions that enhance their reputation and boost online sales.

    As e-commerce explodes, more leading brands are collaborating with DataWeave for actionable brand analytics to protect their digital shelves, decrease complexity and boost consumer trust. These accurate, trusted insights help brands gain clarity to make smarter e-commerce decisions faster. Making data-driven brand management, promotional and digital marketing decisions helps brands prove their authenticity, improve marketing effectiveness and boost online sales. To see how DataWeave helps brands stand out, sell more and stay competitive, visit www.dataweave.com.



    [1] Taylor, Lauren, Chris Biggs, Ben Eppler, Henry Fovargue and Gaby Barrios.  How Retailers Can Capture $5 Trillion of Shifting Demand. Boston Consulting Group. August 31, 2020.

    [2] Gibbons, David. Ecommerce and content: How retailers have shifted strategies during the COVID-19 pandemic. Digital Commerce 360. August 18, 2020.

    [3] US Direct-to-Consumer Ecommerce Sales Will Rise to Nearly $18 Billion in 2020. eMarketer. April 1, 2020.

    [4] Wertz, Jia. 3 Emerging E-Commerce Growth Trends To Leverage In 2020. Forbes. August 1, 2020.

    [5] Lee, Emma. The incredible rise of Pinduoduo, China’s newest force in e-commerce. TechCrunch. July 26, 2018.

    [6] Goyal, Vivek. Browsing e-commerce: An untapped $250B+ opportunity. Medium. September 27, 2020.

    [7] Cooper, Paige. 43 Social Media Advertising Statistics that Matter to Marketers in 2020. Hootsuite. April 23, 2020.

    [8] Cooper, Paige. 43 Social Media Advertising Statistics that Matter to Marketers in 2020. Hootsuite. April 23, 2020.

    [9] Grill-Goodman, Jamie. ‘Digital is the New Normal,’ Nike CEO Says. RIS News. September 23, 2020.

  • Amazon Great Indian Festival Vs Big Billion Day- Who offered better discounts?

    Amazon Great Indian Festival Vs Big Billion Day- Who offered better discounts?

    The Great Indian Festival finally arrived and it coincided with Flipkart’s Big Billion Day Sale. The pandemic has pushed consumers to shop online and both, the Great Indian Festival and the Big Billion Day sales had been eagerly anticipated. Flipkart’s sale lasted between 16-21 October, while Amazon’s (in India) took started on 17th October.

    It is claimed that Amazon and Flipkart have hit $3.5 billion in sales in just four days. On the last day of its Sale, Flipkart claimed to have achieved 10 times growth as compared to last year’s Big Billion Day sale. Clearly, the sales have surpassed all the forecasts made for this year’s sale. We at DataWeave took a closer look to analyze the discounts that were offered across popular categories, to see if customers really had access to better deals and discounts. 

    Our Methodology:

    We looked at the top 500 products across categories like Fashion – men and women, electronics, Amazon devices, baby products, grocery and personal care. The pricing offered on these products across the sale period was compared with the pre-sale price, to understand the trend in discounts across the popular categories and brands.

    The Verdict:

    We segmented the products we were tracking into the following:

    Type 1: Products were either priced the same or were discounted over the sale compared to pre-sale 

    Type 2: Products were either priced the same or witnessed price increase during the sale compared to pre-sale 

    Type 3: Products which saw both price increase and decrease during sale compared to pre-sale

    Type 4: Products whose price continued to be the same even during the sale 

    flipkart_big_billion_day_2020_chart_1

    Flipkart clearly provided the better deals to customers for the categories we looked at during their Big Billion Day sale compared to Amazon. Flipkart discounted 54% of its products during the sale period compared to Amazon, and 26% of the products were discounted. 

    It is also interesting to note that in addition to offering more discounted products, Flipkart also offered additional discounts than Amazon.

    Amazon offered 13.2% additional discount and most of this average discounting can be attributed to a 33.8% discount on Amazon devices. It also ended up increasing the pricing for 16% of the products during the sale period, while Flipkart hiked the pricing for 6% products. 56% of products on Amazon continued being sold at the same price even during the sale. 

    Additional discounts across product premiumness levels

    Premiumness was based on the actual price of a product before the sale event. This was divided into low, medium and high premiumness levels, with high indicating higher selling prices.

    flipkart_big_billion_day_2020_chart_2
    big_billion_day_great_indian_sale_2020

    In Amazon devices, baby products, electronics and grocery-cooking essentials, Amazon showed a direct relationship between its additional discounts and the level of premiumness. While Flipkart did not seem to follow a particular pattern with respect to product premiumness. 

    Flipkart offered the highest discounts for premium products in the Fashion category (for both men and women) compared to the rest. 

    Top brands by additional discounts:

    We looked at popular brands across categories to arrive at brands that were being sold at the maximum discount. These brands appeared at least twenty times in the top 500 ranks we considered.

    amazon_great_indian_sale_2020_electronics

    Acer, Philips, Samsung, Lenovo, Bajaj, Asus which were common brands across both Flipkart and Amazon in the electronics category, were being sold at much deeper discounts on Flipkart (almost double), compared to that on Amazon.

    Avita was extremely popular under the laptop sub-category on Flipkart and was observed to be discounted the highest during the sale.

    In Fashion, Titan was the most discounted brand with 53.9% additional discount but only 4% and 2% of the products offered discounting in mens’ and womens’ fashion respectively. Reebok in mens’ fashion and Fastrack, Sonata and Puma in womens’ wear on Flipkart, had discounts across almost all the products. 

    amazon_great_indian_sale_2020_baby_care
    flipkart_big_billion_day_2020_baby_care

    In the baby care category, Hasbro gaming on Flipkart had the highest additional discount followed by Funskool. Both the brands had more than 85% of their products discounted. 

    Johnson’s, which was common on both Amazon and Flipkart, was offered at higher discounts on Amazon compared to Flipkart. However, only 31% products were discounted vs 72% on Flipkart.

    Most Visible Brands

    We looked at the top 200 ranks across each sub-category to narrow down on the most visible brands across the sale period.

    amazon_great_indian_sale_top_brands
    flipkart_big_billion_day_2020_top_brands

    Across all categories and their sub-categories, the sub-category laptop had distinct brands that hold the majority of the products. This is observed both in Amazon and Flipkart where brands like Lenovo, HP, Asus hold more than 33% share of the first 200 products. 

    “Mobile” category was dominated by brands like Redmi and Boat on Amazon, and Realme and OPPO on Flipkart. These brands occur at least 24% of the time in the top 200 ranks.

    Who Won?

    There are many ways to look at this. To begin with, the combined sales of Flipkart and Amazon during the festive season in India accounted for more than 90% of the e-commerce industry’s gross sales. That amounts to a 55% year-on-year growth. Delving further, we see that Flipkart was far more aggressive with their offerings.

    They discounted 56.8% additional products at an overall discount of 15%. On the other hand, Amazon retained their typical cautious approach to discounting, with only 28.4% of the products, at an overall discount of 12.8%.

    If we adopt a more macro view of the sales, we have to take into account that this year is somewhat of an anomaly. Given the social distancing norms and other SOPs governing the common man, more people have been ushered into the world of online shopping. The penetration extended far into the Tier 2 and Tier 3 cities as well, thus potentially benefiting Flipkart, owing to their interior reach.

    Going by the numbers, Flipkart seems to have taken this round without a doubt. As we observed though, there are many ways to look at this and what seems to stand out from these two giants, is the consumer. At the end of the day, it’s the consumer that in spite of these strange times, has shopped more than before, indicating that the situation is getting back to a semblance of normalcy.

    So Flipkart’s got the sales numbers but the consumer got deeper discounts on more products. As the old adage goes, ‘consumer is king’.

  • Prime Day 2020: Home categories fuel retail rivalry & desirable discounts

    Prime Day 2020: Home categories fuel retail rivalry & desirable discounts

    According to our preliminary analysis of Prime Day 2020, Amazon’s rivals offered more generous discounts within Home categories to stay competitive as more consumers invest in their homes this year.

    This year the COVID-19 pandemic has transformed consumers into homebodies who increasingly work, learn and shop from home. This year also marks the first time Prime Day took place in the Fall, jumpstarting the holiday sales season.

    At DataWeave, we wanted to know whether Prime Day 2020 lived up to the hype and how Amazon’s deals compared to other retailers’ discounts. Our analysis examines products across four popular Home categories: Bed & Bath, Furniture, Kitchen and Pet Care.

    Our Methodology

    We tracked the pricing of several leading retailers (Home Depot, Target, Walmart and Amazon) selling the Home categories of Bed & Bath, Furniture, Kitchen and Pet Care to assess their pricing and assortment strategies during this annual sales event. Our analysis focused on additional discounts offered during the sale to estimate the true value that the sale represented to consumers. Our calculations compared product prices on Prime Day versus the prices prior to the sale. The sample consisted of up to the top 750 ranked products across 16 popular product types for the home.

    The Verdict 

    Overall, Amazon reported the lowest price reduction in all Home categories (12.4%), compared to Target (22.1%), Home Depot (16.5%), and Walmart (15.1%). Yet Amazon reported the second-highest percentage of additionally discounted products (9.6% vs. 11.0% for Target).

    After Prime Day ended, certain retailers’ Home assortments saw more significant price increases than others. For instance, 88% of Target’s 760 products in Bed & Bath, Furniture, Kitchen and Pet Care received a price increase during the post-sale period, compared to 47% of Walmart’s 1005 products. Walmart’s everyday low price strategy helps to explain the difference between the two big box retailers.

    These results suggest that Prime Day 2020 may boost Amazon’s marketing and PR engagement yet its rivals offered the most generous deals in Home categories. As home-related categories’ sales soared during the pandemic, Amazon’s competitors offered deep discounts to stand out online and grow their market share. As such, consumers may want to embrace the habit of comparing multiple retailers’ websites to discover the best Prime Day deals in Home categories.

    Top product types by additional discount

    In Bed & Bath, Target offered the biggest average additional discount (27.4%) and Amazon offered the lowest (13.3%). Bed sheets and pillowcases were a popular product category for additional discounts across all four retailers, with Target offering the best average additional discount at 31.3%. Other popular product types among rival retailers included blankets, comforters and bathroom furniture.


    In Furniture, Home Depot (20.5%) offered the biggest overall additional discount, closely followed by and Target (19.2%). Living room furniture was a popular subcategory for all four retailers, with Home Depot offering the highest additional discount (29.1%). Other popular product types included furniture for the bedroom, home office, kitchen and dining room.

    In the Kitchen category, Target offered the biggest average additional discount for small appliances (21.8%), a subcategory in which all four retailers offered discounts. Within the large appliance subcategory, Walmart’s additional discounts were nearly triple Amazon’s (15.7% vs. 5.6%).

    Within the Pet Care category, Target offered the biggest average additional discount (18.5%). Cat food was a popular product category, with Target offering the best average additional discount (50.0%). Other popular product types across all four retailers included dog collars, leashes and dry dog food.

    Additional discounts across product “premiumness” levels

    Premiumness was calculated as the average selling price before the sale event. This was divided into low, medium and high premiumness levels, with high indicating higher selling prices.

    In Bed & Bath, most retailers showed an inverse relationship between their additional discounts and the products’ level of premiumness. Target offered the biggest additional discounts across all levels of premiumness, more than double Amazon’s discounts (27.2% vs. 12.3%). Target’s bold discounting strategy shows a commitment to protecting its competitive position across the entire Bed & Bath category.

    By far, Amazon offered the greatest percentage of additional discounts in Bed & Bath compared to its rivals across all levels of premiumness. Comparatively pervasive discounts help the e-commerce giant offer a greater variety of appealing deals within this category.

    In Furniture, most retailers showed a direct relationship between their additional discounts and the level of premiumness. Notably, Home Depot offered massive additional discounts at the high premium level, nearly triple Amazon and Walmart (34.5% vs. 12.7%). This move suggests Home Depot is serious about winning the business of upscale consumers in the Furniture category.

    Target differentiated its assortment by discounting by far the greatest portion of its Furniture at all premiumness levels (22.4%) and Home Depot discounted the least (4.4%). Amazon and Walmart distributed the greatest portion of their additional discounts to the moderate level of premiumness. Target’s strategy tries to attract all Furniture shoppers while Amazon and Walmart try to make their mid-market offerings affordable to more consumers.

    Across all levels of premiumness for Kitchen products, Target offered the biggest additional discounts, including almost double Amazon’s discounts at the medium level (22.5% vs. 13.4%). Target’s aggressive discounting shows a desire to be more competitive by attracting consumers at all levels of the Kitchen category.

    In the Kitchen category, most retailers offered a direct relationship between the proportion of additional discounts and the level of premiumness, yet Home Depot showed an inverse relationship. Amazon’s proportion of additional discounts across all levels of premiumness nearly tripled Home Depot’s (10.1% vs. 3.7%). This discount strategy shows Amazon’s willingness to offer shoppers deals across a broader variety of Kitchen items.

    In Pet Care, Walmart offered the highest overall additional discounts (16.2%), which could fortify its low-cost leadership position for pet lovers at all price points.


    While Target offered the greatest overall percentage of additional discounts in Pet Care, Amazon applied more discounts to the higher end of the premium spectrum and Target focused on the lower end.

    Additional discounts across visibility levels

    In Bed & Bath, Target offered the highest overall additional discounts across all levels of visibility (27.3%) and Amazon offered the lowest (12.4%). Amazon focused its additional discounts on the most visible Bed & Bath products to help online shoppers discover those items with ease and make them appealing enough to add to their cart.


    Amazon offered the lowest additional discounts in the Furniture category across all levels of product visibility. Yet, among the Furniture category’s most visible items, Amazon offered its highest additional discounts. Home Depot’s additional discounts approach was the most aggressive except among the lowest product visibility levels. Home Depot’s discount strategy shows a desire to compete for Furniture’s most visible items.

    In the Kitchen category, Home Depot consistently offered the lowest additional discounts among products at the higher visibility levels. Conversely, Target was the most aggressive in this category, offering additional discounts of up to 43.2% at moderate levels of visibility and double Home Depot’s discounts (26.3% vs. 13.4%) among the most visible items. Amazon may feel confident that men already choose Amazon for their apparel needs.

    In Pet Care, the retailers generally offered the most additional discounts for items in the middle of the visibility spectrum. Walmart offered the most aggressive additional discounts among the most visible Pet Care items, more than double Target’s discounts (13.5% vs. 6.5%).

    Overall, Prime Day 2020 offered an ideal time for Amazon to attract homebound consumers to invest in domestic products, yet its rivals offer much higher additional discounts in Bed & Bath, Furniture, Kitchen and Pet Care. How about other categories? Watch this space for more insights!

  • How Prime Day 2020 Deals Influenced Retail Pricing Strategies

    How Prime Day 2020 Deals Influenced Retail Pricing Strategies

    Our preliminary analysis reveals that Prime Day 2020 motivated Amazon’s rivals to offer deeper discounts in key categories to try to make their merchandise more magnetic and lure consumers away from the e-commerce giant.

    This year’s Prime Day is momentous, as the COVID-19 pandemic has encouraged more consumers to make online shopping a more regular habit. It also marks the first time Prime Day took place in the strategically significant final quarter of the year, kicking off the holiday sales season.

    At DataWeave, we wanted to know whether Prime Day 2020 lived up to the hype and how Amazon’s deals compared to other retailers’ discounts. Our analysis examines products across three popular categories: electronics, beauty and fashion.

    Our Methodology

    We tracked the pricing of several leading retailers (Best Buy, Target, Walmart and Amazon) selling consumer electronics, beauty and fashion to assess their pricing and assortment strategies during this annual sales event.

    Our analysis focused on additional discounts offered during the sale to estimate the true value that the sale represented to consumers. Our calculations compared product prices on Prime Day versus the prices prior to the sale. The sample consisted of up to the top 750 ranked products across 21 popular product types in consumer electronics, beauty and fashion.

    The Verdict

    Overall, Amazon reported the lowest price reduction in the Electronics, Beauty and Fashion categories (13.4%), compared to Best Buy (22.5%), Target (21.7%) and Walmart (16.3%). Yet Amazon reported the second-highest percentage of additionally discounted products (12.0% vs. 15.7% for Target).

    After Prime Day ended, certain assortments reflected more significant price increases than others. For instance, 97% of Target’s 158 products in Electronics, Beauty and Fashion had a price increase during the post-sale period, compared to 49% of Walmart’s 986 products. This discrepancy makes sense given Walmart’s everyday low price strategy.


    These results suggest that although Prime Day generates tremendous media buzz for Amazon, the most generous deals come from its rivals. To stand out and lure shoppers away from Amazon, competitors offered comparatively deeper discounts, especially in categories in which they want to grow their market share. This means online shoppers would be wise to compare prices across retailers’ websites to find the best cross-category deals on Prime Day.

    Top product types by additional discount

    In Electronics, Best Buy offered the biggest average additional discount (22.4%) and Amazon offered the lowest (9.4%). Tablets were a popular product category among Amazon, Best Buy and Walmart, with Best Buy offering the best average additional discount at 19.1%. Other popular product types among rival retailers included TVs, desktops and laptops.


    In Beauty, Target (13.2%) and Walmart (13.1%) almost tied for the biggest overall additional discount. Makeup was a popular beauty subcategory, with Walmart offering the highest additional discount at 19.7%. Other popular product types included hair care, skin care and fragrance.

    In Men’s Fashion, Target offered the biggest average additional discount of 28.1%. Suits and blazers were a popular fashion subcategory, in which Target offered the highest average additional discount at 50.0%. Other popular product types included T-shirts and tank tops, shirts and jeans.


    Within the Women’s Fashion category, Walmart offered the biggest average additional discount of 20.5%. Tops and tees were a popular product category across all three fashion rivals, with Walmart offering the best average additional discount at 23.6%. Other popular product types included dresses, jumpsuits and jeans.

    Additional discounts across product “premiumness” levels

    Premiumness was calculated as the average selling price before the sale event. This was divided into low, medium and high premiumness levels, with high indicating higher selling prices.


    In Electronics, Amazon showed a direct relationship between its additional discounts and the level of premiumness; Best Buy and Walmart showed an inverse relationship. Best Buy offered the biggest additional discounts across all levels of premiumness, nearly triple Amazon’s discounts (20.7% vs. 7.0% ) at the low end of the premium spectrum, and more than double Amazon’s discounts (18.5% vs. 7.3%) at the moderate level. Best Buy’s discounting strategy show it’s serious about protecting its competitive position in electronics.

    Best Buy and Walmart offered the most additional discounts at the high end of the premiumness spectrum, making both retailers more competitive in the high-ticket electronics category. By contrast, Amazon offered nearly double the additional discounts of its rivals within the low segment, which helps to protect its margins while making products even more affordable and appealing.


    In Beauty, Amazon and Walmart offered their biggest additional discounts at the low premium level, possibly to position those products as loss leaders. Meanwhile Target nearly doubled and tripled its rivals’ additional discounts at the high premium level (30.0% vs. 16.0% for Walmart and 11.0% for Amazon) to stand out in this intensely competitive category.

    Amazon stood out by discounting the greatest portion of its Beauty offerings at all premiumness levels and Target discounted the least. Amazon and Walmart showed a direct relationship between their distribution of additional discounts and the beauty products’ premiumness level.


    Across all levels of premiumness for Men’s Fashion, Target offered the biggest additional discounts, including more than triple Amazon’s discounts at the high end (38.4% vs. 12.4%). Target’s aggressive discounting shows a desire to be more competitive within the most premium segment of Men’s Fashion.

    Amazon’s additional discounts accounted for the greatest percentage of its Men’s Fashions across all levels of premiumness, nearly triple Target’s overall average (15.4% vs. 5.3%). This approach shows Amazon’s willingness to give shoppers deals across a broader variety of Men’s Fashion items.

    In Women’s Fashion, Target’s and Walmart’s overall additional discounts were comparable, and Amazon’s discounts were consistently the lowest among all levels of premiumness. Walmart offered its most generous discounts at the low and medium level of premiumness, which could reinforce its low-cost leadership image.

    While Amazon and Target offered a comparable overall percentage of additional discounts in Women’s Fashions, Amazon applied more discounts to the higher end of the premium spectrum and Target focused on the lower end.

    Additional discounts across visibility levels

    In Electronics, Amazon offered the lowest average additional discounts across all levels of visibility. Among the most visible electronics, Amazon and Best Buy gave the most visible electronics higher additional discounts to make those items more alluring to help consumers find the items fast and add them to their online baskets.

    Among the Beauty category’s most visible items, Amazon and Target offered their highest additional discounts. Yet Target was most aggressive in beauty, offering a 30% additional discount at the most visible end of the spectrum as well as at the least visible. This discount strategy shows Target wants to compete in Beauty, spreading its generosity beyond an exclusive focus on highly visible items.

    In Men’s Fashion, Amazon consistently offered the lowest additional discounts at all visibility levels. Target was the most aggressive in this category, offering additional discounts of 50% at moderate levels of visibility and 34.5% among the most visible items. Amazon may feel confident that men already choose Amazon for their apparel needs.

    In Women’s Fashion, the retailers generally offered the most additional discounts for items at the higher end of the visibility spectrum. Walmart offered the most aggressive additional discounts among the most visible items in Women’s Fashion to try to boost its market share in this category.

    Overall, while Prime Day is an effective way for Amazon to boost brand engagement, its rivals overwhelmingly offer higher additional discounts in Electronics, Beauty and Fashion. How about other categories like the booming Home space? Watch this space for more insights!

  • Food Delivery Boom Fuels Competition Among Restaurants

    Food Delivery Boom Fuels Competition Among Restaurants

    This year, homebound consumers crave the convenience of food delivery.
    Growing 20% since 2015, restaurant delivery has sparked intense rivalry to reach consumers’ homes. Although the pandemic led to $165 billion in lost sales industry-wide between March and July, experts predict online food delivery sales will reach $220 billion by 2023, accounting for 40% of total restaurant sales.[1,2]

    This massive market opportunity makes food delivery an urgent priority for restaurants to stay competitive and solvent during the pandemic. This year nearly one in six U.S. restaurants have closed either permanently or long-term.[3]

    Also, 40% of U.S. operators say they will likely be out of business within six months if economic conditions persist and 60% of Canadian restaurants could close permanently by November.[4,5]


    COVID-19 compounds market complexity

    Powerful market trends are rattling restaurants. During the pandemic, nearly 70% of operators have added third-party delivery to lift sales.[6]

    This year, third-party delivery from food delivery apps like Uber Eats, Grubhub and DoorDash will grow 21% over 2018.[7] The global market for cloud kitchens (also called ghost kitchens or virtual kitchens), commercial kitchens intended for delivery-only orders, will grow from $650 million in 2018 to $2.6 billion by 2026.[8]


    To avoid the need to rely on delivery partners, many chains invest in their own last-mile delivery capability to serve their fleet of restaurants.
    E-grocery sales are poised to surge 40% in 2020 and meal kits have boomeranged back into popularity, nearly doubling 2019 sales.[9, 10]

    Consumers demand speed to keep their food fast, fresh and hot. Prompt service matters, as one survey found when consumers face a food delivery issue, 93% want it resolved within 10 minutes.[11]

    The recession and job losses mean more consumers now need affordable food options. Meanwhile, restaurants are investing more in technology to modernize operations for efficient omnichannel service.

    How restaurants are adapting to 2020’s disruption


    Restaurant prices have risen during the pandemic to cover operating costs. Third-party delivery fees have led 41% of consumers to prefer to order food by contacting the restaurant directly (vs. 16% for third-party delivery).[12] To optimize pricing competitiveness, more restaurants now compare their delivery fees and offerings with rivals’ to spot and correct gaps, and keep their prices affordable.

    To streamline operational processes and costs during the pandemic, 28% of restaurants shrank their menus.[13]

    For clarity on which items to keep, operators now use data insights on restaurant listings and menu items down to the ZIP code level. This information also helps them decide whether to adapt to consumers’ diverse tastes, including vegan, gluten-free and organic, for competitive local assortments.



    Outperform rivals: Restaurant operators seek proof of their brand visibility on food delivery apps’ homepages.


    Restaurants have discovered consumers welcome reasons to celebrate at home this year. One chain’s weekly virtual happy hours on Facebook Live drew 80,000 participants and a $40,000 sales increase from delivery and takeout orders.[14]

    More restaurants now compare their promotional strategies with rivals’ to evaluate marketing performance, including homepage discoverability and visibility ranking, to ensure consumers find their brand online with ease.

    Delivery speed and precision also matter. A survey found 70% of consumers had food delivery order complaints, including late delivery (50%), incorrect order (37%) and cold or stale food (36%).[15] Using accurate geographic data can help restaurants improve speed and the customer experience.

    To gain a competitive advantage in today’s booming food delivery market, a growing number of leading chains and food delivery providers are collaborating with DataWeave to access actionable insights to make better strategic and operational decisions faster. Using trusted insights to make data-driven pricing, menu and promotional decisions help restaurants save time, reduce risk and gain clarity in today’s evolving market.

    Applying DataWeave’s accurate, up-to-date information also helps restaurants deliver affordability, convenience and variety to remain responsive to consumers and agile among competitors. To see how DataWeave helps restaurants stay relevant and competitive, contact us today.


    [1] Rogers, Kate. Winter is coming, bringing a new challenge to already-struggling restaurants. CNBC. September 14, 2020.
    [2] Zahava Dalin-Kaptzan. Food Delivery: Industry Trends for 2020 and beyond. Bringg. April 30, 2020.
    [3] Klein, Danny. 100,000 Restaurant Closures Expected in 2020. QSR. September 14, 2020.
    [4] Rogers, Kate. Winter is coming, bringing a new challenge to already-struggling restaurants. CNBC. September 14, 2020.
    [5] Charlebois, Sylvain. Don’t Want to Save the Restaurant Industry? Fine, but Use it to Save the Canadian Economy. Retail Insider. September 11, 2020.

    [6] Rogers, Kate. Winter is coming, bringing a new challenge to already-struggling restaurants. CNBC. September 14, 2020.
    [7] US Food Delivery App Usage Will Approach 40 Million Users in 2019. eMarketer. July 2, 2020.
    [8] Levy, Ari. Virtual Kitchen, founded by ex-Uber execs to help restaurants with delivery, raises $20 million. CNBC. Sept. 8 2020
    [9] Redman, Russell. Online grocery sales to grow 40% in 2020. Supermarket News. May 11, 2020.
    [10] De Leon, Riley. How the coronavirus pandemic delivery surge created a lifeline for Blue Apron meal kits. CNBC. May 22, 2020.
    [11] Guszkowski, Joe. Delivery services have room to improve, consumers say. Restaurant Business Online. Sept. 1, 2020.
    [12] Guszkowski, Joe. Consumers’ desire to order directly from restaurants is a big opportunity. Restaurant Business Online. Aug. 27, 2020.
    [13] Romeo, Peter. Best practices for weathering a second COVID wave. Restaurant Business Online. Aug. 28, 2020.
    [14] Ibid. 
    [15] Guszkowski, Joe. Delivery services have room to improve, consumers say. Restaurant Business Online. Sept. 1, 2020.

  • Introducing the CPG Brand Monitor by DataWeave

    Introducing the CPG Brand Monitor by DataWeave

    As DataWeave continues to engage with brands and manufacturers of all sizes, a consistent theme keeps emerging, “click and collect tracking”. Right now, brands rely on manual-store checks or waiting upwards of two weeks for a retailer to report sales data, which reveals low sales because a product is out of stock. In addition, there are always questions about the local price of your products compared to top competitors in the category. This is where DataWeave’s CPG Brand Monitor solution can help. 

    Click here for a quick tour of our dashboard.

    What we cover?

    On a daily basis, we track over 13,000 variant level SKUs across 100 stores, via seven of the top grocery retailers. We have selected the largest grocers in each region of the US, to allow for the widest coverage. These grocers include Albertsons/ Safeway in the west, HEB in Texas, Kroger in the upper mid-west, Wegmans in the Mid-Atlantic and Publix in the Southeast. 

    How does it work?

    In the application, you will see the list of all the SKUs we’re covering, with filters on the left side of the page to help with navigation. You can sort by Brand, Category, Store/ City, State, etc. After the filters are applied, the SKU list will be displayed based on these filters.  On the right side of the screen, you will see all the product level details including a 7-day price history, individual store level pricing/ stock availability and exportable charts and graphs. 

    How do I get access?

    Simply access the CPG Brand Monitor page, fill in your credentials via “Start Free Trial” and your login will be sent directly to your inbox. No commitments or phone calls are needed to test out the data. After a few days, our team will be in touch to make sure you understand how to navigate the tool and take you through our subscription options.   

    What else do we offer?

    DataWeave also offers a full Digital Shelf Analytics suite that covers Share of Voice (keyword, navigation and banner audits), Content Audit/ Optimization, Ratings/ Review Sentiment Analysis, Promotional Analysis, and much more. 

  • JioMart Launches Online Grocery Store

    JioMart Launches Online Grocery Store

    JioMart, the online channel for Reliance Retail Limited, launched in December 2019 as a contender in the e-grocery segment. Currently in India, this segment is being dominated by bigbasket, Amazon, Flipkart Supermart, Grofers, etc. After less than a year and from their initial launch in Mumbai, they now have their presence in 205 cities across India.

    According to their recent press release, they claim to be clocking over 250,000 daily orders, compared to bigbasket’s 220,000 and Amazon’s 150,000. To get an understanding of this rapid penetration, we had a look at the PIN codes that JioMart serves, spanning the country.

    The map below represents the percentage of PIN codes that are being served by JioMart’s online grocery in each state:

    **Disclaimer -Map for representation purposes only

    While states like Chandigarh, Delhi and Punjab in the North are covered extensively, JioMart has a stronger distribution in the Southern states.

    The image below shows the top ten states in India where JioMart’s online grocery has the highest presence:

    They’re yet to launch in 14 more states but it’s interesting to note that in this limited time, they’ve managed to cover 14% of the PIN codes in the country and all this, in the midst of lockdowns.

    Assortment

    To get an idea of the assortment in their range, we analyzed select PIN codes across three tiers of cities in India. The parameters we looked at were categories, brands and discounts to get an understanding of how JioMart is stacking up against its competitors. The cities we examined were:

    • Tier 1 – Bangalore, Delhi, Kolkata, Mumbai
    • Tier 2 – Ahmedabad, Jaipur, Kochi, Visakhapatnam
    • Tier 3 – Mohali, Mysore, Nagpur, Siliguri

    In its range, they offer eight broad categories, of which, we focussed on the four that offer the highest selection of products: home care, personal care, snacks & branded food and staples.

    The table below represents the average selection of products offered across each tier.

    Overview of discounts offered and the private label split

    Out of the assortment we looked at in the three tiers, we noticed that an average of 18% of the products are JioMart’s private labels. What stood out further is that private labels accounted for 48% in the Staples category and 24% in Personal Care. We noticed this trend (increase in the private label) when we did an analysis of Amazon.

    When it comes to discounts, we noticed that a near-total 91% of the products listed are being sold at a discount. Out of this, the highest discounts were witnessed in the Home Care and Staples categories.

    The brands with the highest number of products listed were Good Life, Reliance, Amul, Gillette and items sold loosely. All these accounted for 14% of the assortment. Out of these, Good Life, Reliance and the loose items are JioMart’s private labels.

    Competitor analysis

    To get an idea of where JioMart stands with relation to its competitors, we focussed on food and essentials in the Tier 1 cities. The table below highlights the number of product offerings in each category:

    It’s clear that in these categories (food and essentials), JioMart has the least number of products on discount. There’s no doubt that bigbasket is miles ahead in its product range/ assortment.

    To get a better idea of the discounting patterns, we analyzed the same categories to get a count of the number of products being discounted, as well as the average discount being offered. 

    We noticed that JioMart bookended our analysis – the least average discount, across the most number of products. Grofers offered the highest average discount of 23% with Flipkart Supermart and bigbasket closely behind. Lastly, bigbasket had the least number of products on discount with a little over 53%.

    Conclusion

    JioMart launched during a tumultuous and unprecedented time; the COVID-19 pandemic and the subsequent nation-wide lockdowns. Given this trial by fire, they managed to make an impact in this highly competitive space. Their expansion plans of tying up with mom and pop stores to fortify their penetration, had to take a back seat due to the ongoing situation but is sure to resume once conditions improve. This set-back did not however deter JioMart from attracting strategic investments from Facebook, Google and 12 other investors  in a span of 3 months. 

    In a study by Goldman Sachs, it found that India’s e-commerce business is expected to grow at a compound annual growth rate of 27% by 2024, resulting in a $99 billion market share. What’s even more shocking is that 50% of this market will be captured by Reliance Industries. It, therefore, stands to reason that all we’ve seen and heard of so far, is merely the tip of the iceberg and there’s surely more to come in the near future.

  • Market Intelligence Platform with Kenshoo

    Market Intelligence Platform with Kenshoo

    We’re thrilled to announce that we have teamed up with Kenshoo to offer an integrated marketing solution that combines DataWeave’s digital shelf analytics and commerce intelligence platform with Kenshoo’s ad automation platform. This in turn, provides better recommendations on promotions to retailers and consumer brands.

    As e-commerce surges, consumer brands can now promote their products through retail-intelligent advertising. Product discoverability, content audit, and availability across large marketplaces can be critical to a brand’s success. Using DataWeave’s digital shelf solutions, Kenshoo now can offer marketers greater visibility into a brand’s performance.

    Even large retailers and agencies can use our commerce intelligence platform to improve their price positioning, address category assortment gaps, and more.  

    Through this partnership, Kenshoo – a global leader in marketing technology, can help its significant base of consumer brands and retailers invest their marketing dollars intelligently and in a timely manner.

    At DataWeave, we have constantly strived to bring in a holistic approach to help our customers optimize their online sales channels. This partnership furthers our resolve in this direction. As we collectively strive to adjust to a post-COVID-19 world, we are observing an acceleration towards digital commerce. This acceleration and change in consumer behavior is going to be a lasting change, creating significant growth opportunities for both DataWeave and Kenshoo.

    With this partnership, we look forward to helping our customers make timely, intelligent, and data-driven decisions to grow their business.

  • Amazon Triples Down on its Private-label Product Portfolio

    Amazon Triples Down on its Private-label Product Portfolio

    Among Amazon’s most prominent and decisive steps in achieving retail dominance over the last few years has been its focus on expanding its private label portfolio.

    The most recent collaborative report between DataWeave and Coresight Research determines that Amazon’s private label assortment in early 2020 has grown three-fold over the previous two years, most of which is in categories outside of apparel and accessories.

    In addition, the report covers various facets of Amazon’s private label penetration and strategy. These include the size of Amazon’s private label portfolio, the distribution of private label products by category, the product ratings and number of reviews, the average price points across products and brands, and more.

    Our detailed and proprietary Amazon private label dataset includes information on over 20,000 products and 111 brands.

    Some of our key findings are:

    • Amazon’s private-label offering spans 22,617 products across 111 identified private labels.
    • Around half of the private-label products are in clothing, footwear and accessories, which is lower than the three-quarters found in our similar research from June 2018, indicating Amazon’s push into a broader range of categories.
    • The average Amazon private-label product generates a customer rating of 4.3 out of 5, representing positive customer feedback overall.

    Amazon’s Private-Label Offering Spans 22,617 Products across 111 Identified Private Labels

    The number of private-label products—22,617—is more than triple the total of 6,825 from June 2018 (see our previous report). The number of private-label brands also increased substantially (up 50% versus June 2018), indicating that the e-commerce giant has stepped up its private-label strategy.

    Around Half of Private-Label Products Are in Clothing, Footwear and Accessories

    Just over half of Amazon’s private-label products are in “clothing, footwear and accessories,” versus almost three-quarters when we undertook similar research in June 2018, indicating Amazon’s push into a broader range of categories. Other categories that feature more than 1,000 private-label products include “home and kitchen,” “grocery and gourmet food” and “tools and home improvement.”

    Source: DataWeave/Coresight

    The Average Amazon Private-Label Product Generates a Customer Rating of 4.3 out of 5

    We examined feedback provided by Amazon’s private-label customers: Customer satisfaction can be measured by the average star rating that customers have left in reviews. We chart both average star rating and average number of customer reviews per product in the graph below.

    The average Amazon private-label product generates a customer rating of 4.3 stars out of 5, suggesting overall solid customer satisfaction levels.

    Source: DataWeave/Coresight

    The full report is available for Coresight’s premium subscribers. It includes further details of categories and subcategories that suggest longer-term implications—including how Amazon targets a niche customer base through specific category labels but appeals to broader consumer needs by offering multicategory labels.

    To access DataWeave’s proprietary database on Amazon’s private label brands and products, reach out to us today!

  • How Apache Airflow Optimizes Complex Workflows in DataWeave’s Technology Platform

    How Apache Airflow Optimizes Complex Workflows in DataWeave’s Technology Platform

    As successful businesses grow, they add a large number of people, customers, tools, technologies, etc. and roll out processes to manage the ever-increasingly complex landscape. Automation ensures that these processes are run in a smooth, efficient, swift, accurate, and cost-effective manner. To this end, Workflow Management Systems (WMS) aid businesses in rolling out an automated platform that manages and optimizes business processes at large scale.

    While workflow management, in itself, is a fairly intricate undertaking, the eventual improvements in productivity and effectiveness far outweigh the effort and costs.

    At DataWeave, on a normal day, we collect, process and generate business insights on terabytes of data for our retail and brand customers. Our core data pipeline ensures consistent data availability for all downstream processes including our proprietary AI/ ML layer. While the data pipeline itself is generic and serves standard workflows, there has been a steady surge in customer-specific use case complexities and the variety of product offerings over the last few years.

    A few months ago, we recognized the need for an orchestration engine. This engine would serve to manage the vast volumes of data received from customers, capture data from competitor websites (which can range in complexity and from 2 to 130+ in number), run the required data transformations, execute the product matching algorithm through our AI systems, process the output through a layer of human verification, generate actionable business insights, feed the insights to reports and dashboards, and more. In addition, this engine would be required to help us manage the diverse customer use cases in a consistent way.

    As a result, we launched a hunt for a suitable WMS. We needed the system to satisfy several criteria:

    • Ability to manage our complex pipeline, which has several integrations and tech dependencies
    • Extendable system that enables us to operate with multiple types of databases, internal apps, utilities, and APIs
    • Plug and play interfaces to execute custom scripts, and QA options at each step
    • Operates with all cloud services
    • Addresses the needs of both ‘Batch’ and ‘Near Real Time’ processes
    • Generates meaningful feedback and stats at every step of the workflow
    • Helps us get away with numerous crontabs, which are hard to manage
    • Execute workflows repeatedly in a consistent and precise manner
    • Ability to combine multiple complex workflows and conditional branching of workflows
    • Provides integrations with our internal project tracking and messaging tools such as, Slack and Jira, for immediate visibility and escalations
    • A fallback mechanism at each step, in case of any subsystem failures.
    • Fits within our existing landscape and doesn’t mandate significant alterations
    • Should support autoscaling since we have varying workloads (the system should scale the worker nodes on-demand)

    On evaluating several WMS providers, we zeroed in on Apache Airflow. Airflow satisfies most of our needs mentioned above, and we’ve already onboarded tens of enterprise customer workflows onto the platform.

    In the following sections, we will cover our Apache Airflow implementation and some of the best practices associated with it.

    DataWeave’s Implementation

    Components

    Broker: A 3 node Rabbit-MQ cluster for high availability. There are 2 separate queues maintained, one for SubDags and one for tasks, as SubDags are very lightweight processes. While they occupy a worker slot, they don’t do any meaningful work apart from waiting for their tasks to complete.

    Meta-DB: MetaDB is one of the most crucial components of Airflow. We use RDS-MySQL for the managed database.

    Controller: The controller consists of the scheduler, web server, file server, and the canary dag. This is hosted in a public subnet.

    Scheduler and Webserver: The scheduler and webserver are part of the standard airflow services.

    File Server: Nginx is used as a file server to serve airflow logs and application logs.

    Canary DAG: The canary DAG mimics the actual load on our workers. It runs every 30 minutes and checks the health of the scheduler and the workers. If the task is not queued at all or has spent more time in the queued state than expected, then either the scheduler or the worker is not functioning as expected. This will trigger an alert.

    Workers: The workers are placed in a private subnet. A general-purpose AWS machine with two types of workers is configured, one for sub-DAGs and one for tasks. The workers are placed in an EC2-Autoscaling group and the size of the group will either grow or shrink depending on the current tasks that are executed.

    Autoscaling of workers

    Increasing the group size: A lambda is triggered in a periodic interval and it checks the length of the RMQ queue. The lambda also knows the current number of workers in the current fleet of workers. Along with that, we also log the average run time of tasks in the DAG. Based on these parameters, we either increase or decrease the group size of the cluster.

    Reducing the group size: When we decrease the number of workers, it also means any of the workers can be taken down and the worker needs to be able to handle it. This is done through termination hooks. We follow an aggressive scale-up policy and a conservative scale-down policy.

    File System: We use EFS (Elastic File System) of AWS as the file system that is shared between the workers and the controller. EFS is a managed NAS that can be mounted on multiple services. By using EFS, we have ensured that all the logs are present in one file system and these logs are accessible from the file server present in the controller. We have put in place a lifecycle policy on EFS to archive data older than 7 days.

    Interfaces: To scale up the computing platform when required, we have a bunch of hooks, libraries, and operators to interact with external systems like Slack, EMR, Jira, S3, Qubole, Athena, and DynamoDB. Standard interfaces like Jira and Slack also help in onboarding the L2 support team. The L2 support relies on Jira and Slack notifications to monitor the DAG progress.

    Deployment

    Deployment in an airflow system is fairly challenging and involves multi-stage deployments.

    Challenges:

    • If we first deploy the controller and if there are any changes in the DAG, the corresponding tasks may not be present in workers. This may lead to a failure.
    • We have to make blue-green deployments as we cannot deploy on the workers where tasks may still be running. Once the worker deployments are done, the controller deployment takes place. If it fails for any reason, both the deployments will be rolled back.

    We use an AWS code-deploy to perform these activities.

    Staging and Development

    For development, we use a docker container from Puckel-Airflow. We have made certain modifications to change the user_id and also to run multiple docker containers on the same system. This will help us to test all the new functionality at a DAG level.

    The staging environment is exactly like the development environment, wherein we have isolated our entire setup in separate VPCs, IAM policies, S3-Buckets, Athena DBs, Meta-DBs, etc. This is done to ensure the staging environment doesn’t interfere with our production systems. The staging setup is also used to test the infra-level changes like autoscaling policy, SLAs, etc.

    In Summary

    Following the deployment of Apache Airflow, we have onboarded several enterprise customers across our product suite and seen up to a 4X improvement in productivity, consistency and efficiency. We have also built a sufficient set of common libraries, connectors, and validation rules over time, which takes care of most of our custom, customer-specific needs. This has enabled us to roll out our solutions much faster and with better ROI.
    As Airflow has been integrated to our communications and project tracking systems, we now have much faster and better visibility on current statuses, issues with sub processes, and duration-based automation processes for escalations.
    At the heart of all the benefits we’ve derived is the fact that we have now achieved much higher consistency in processing large volumes of diverse data, which is one of DataWeave’s key differentiators.
    In subsequent blog posts, we will dive deeper into specific areas of this architecture to provide more details. Stay tuned!

  • Coronavirus Outbreak: Impact on E-Commerce Retailers and Consumer Brands

    Coronavirus Outbreak: Impact on E-Commerce Retailers and Consumer Brands

    The Coronavirus, otherwise known as COVID-19, has made landfall on U.S. shores. At the time of writing this article, there are over 230 confirmed cases in the country and 12 deaths. The growing unease about the virus, which has quickly accumulated 95,000+ confirmed cases globally, has, among other things, adversely affected businesses and stock markets the world over.

    In the wake of this outbreak, U.S. based retailers and brands would be prudent to brace themselves and plan ahead to minimize disruptions as much as possible.

    Businesses and consumers in China, the global epicenter of the epidemic, have been dealing with these challenges over the last couple of months. It’s likely that some of the trends observed in China would be mimicked in the U.S. as well, something that domestic retailers and brands would do well to study and prepare for.

    The Inadvertent E-commerce Wave

    When the outbreak happened in China, it caused an uptick in e-commerce adoption as shoppers were reluctant to step out of their homes and instead, opted to shop for their goods online.

    Reports indicate that Chinese online retailer JD.com’s online grocery sales grew 215% YoY over a 10-day period between late January and early February. Similarly, Carrefour’s vegetable deliveries grew by 600% YoY during the Lunar New Year period. Online sales of Dettol, a disinfectant produced by Reckitt Benckiser, rose 643% YoY between 10 February and 13 February on China’s Suning.com.

    In Singapore, another region affected by the virus more recently than in China, Lazada’s grocery arm, RedMart, and Supermarket chain, NTUC FairPrice, both reported an unprecedented surge in demand, which tested their delivery capabilities to the limit.

    This bump in online sales isn’t just restricted to grocery, but other categories as well. Jean-Paul Agon, CEO of L’Oréal, recently said that online sales of the brand’s beauty products increased in China in February.

    Given such a consistent shift in shopping behavior across coronavirus-affected regions, it’s logical to expect that a similar trend would be followed in the U.S. – in fact, it might already be underway.

    A recent survey by Coresight Research indicated that 27.5% of U.S. respondents are avoiding public areas at least to some extent, and 58% plan to if the outbreak worsens. Of those who have altered their routines, more than 40% say they are “avoiding or limiting visits to shopping centers/ malls” and more than 30% are avoiding stores in general. The survey also found consumers will likely begin to avoid restaurants, movie theaters, sporting events and other entertainment venues.

    Therefore, it’s essential for U.S. retailers and brands to swiftly energize their e-commerce readiness and be fully prepared to cater to the circumstances-induced shift in shopping behavior, inclined toward online.

    A Logistical Nightmare

    The most obvious area of impact for retailers and brands is in their supply chain and order fulfilment operations.

    A large portion of consumer product manufacturers rely to some extent on China, and the potential impact of the virus on supply chain processes is inescapable. Chinese factories have been operating at partial capacity, impacting supply chains globally. This has largely affected highly popular e-commerce categories like consumer electronics, fashion and furniture.

    Shares in the U.S. of furniture e-commerce retailer, Wayfair, fell as much as 26% toward the end of February, according to a Bloomberg report. The is particularly revealing, as the online retailer reportedly relies on China for half of its merchandise.

    Retailers struggling to cope with this stress in their supply chain systems would do well to warn their customers beforehand about delays in deliveries, like AliExpress has just done.

    For categories like CPG, as consumers increasingly shop online, retailers that offer Buy Online Pick Up In Store (BOPIS), should expect a surge in its adoption, and reinforce their online infrastructure and in-store operations to cater to the rising demand.

    In addition to disruptions in the supply chain, several other mission-critical areas are likely to get affected too.

    Keeping Up With The Online Surge

    As with any event of this magnitude, the business implications reach far and wide. The following are a few areas that we’ve identified as critical, based on our experience working with retailers and brands. Being aware of and focusing on these issues are likely to alleviate some of the issues faced by consumers today.

    Fair pricing: There have been several reports of price gouging on e-commerce platforms. Examples include 2-ounce Purell bottles being sold for $400 and face masks for up to $20. While these prices have mostly been set by third party merchants, brands are likely to face the flak from consumers. A recent Bloomberg article reported that online retailers still rely partly on employees to manually monitor these items. This approach has obvious limitations, such as products quickly reappearing on the website after being de-listed. Brands and e-commerce platforms will need to explore automated ways of controlling their online pricing practices at large scale.

    3P merchant and counterfeit management: Often, unauthorized third-party merchants selling an original manufacturer’s goods are the ones who unreasonably inflate prices. These merchants tend to test the markets on online marketplaces with their pricing, which adversely affects the brand image of the manufacturer. Further still, they sometimes list counterfeit or fake goods that make incorrect or extravagant claims. Brands will need to swiftly identify and de-list these merchants from online marketplaces.

    Ensuring stock availability: During times like these, it’s a common sight to see empty aisles at supermarkets selling items like canned food, water, paper products and personal care products. Consumers will benefit from brands monitoring their stock availability at stores, which will help them better align their supply chain operations to the rapidly changing demand patterns across the U.S. map. This way, efforts can be more targeted at regions with severe shortages.

    Content compliance: Helium 10, a technology provider for Amazon sellers, reported that since 26 February, 90% of searches on Amazon are coronavirus related, and searches for hand sanitizers spiked to 1.5 million searches in February compared to 90,000 in November. As a result, to arrest exploitative practices, some online marketplaces have announced policy guidelines on product content claiming health benefits. Words like ‘Coronavirus‘, ‘COVID-19‘, ‘Virus‘ and ‘epidemic’ are, in fact, prohibited.  Amazon has already de-listed several merchants claiming fraudulent cures. Ebay has gone as far as to ban all new listings for face masks, hand sanitizers, and disinfecting wipes, due to regulatory restrictions. In this context, retailers and brands will benefit from deploying tracking mechanisms that quickly identify offenders.

    The areas of business presented above are by no means a comprehensive list for retailers and brands to rely on during this time. Still, these are critical impact areas for them to address, even as huge efforts are made toward managing highly stressed supply chains.

    DataWeave Offers Support

    The coronavirus outbreak is likely to get worse before it gets better. As we enter unchartered territories, DataWeave is offering to contribute in small ways, pro bono, by leveraging our expert talent and competitive intelligence technology platform, to address some of the challenges faced by retailers and brands.

    We’re announcing a limited-time, no-cost offer to detect and report on price gouging, the presence of unauthorized third-party merchants, as well as stock availability across U.S. ZIP-codes. This offer will be valid for 4-6 weeks (timeline will be flexible based on how the outbreak develops) and limited to monitoring the top 10 U.S. online marketplaces, as well as critical product categories such as medicinal and hygiene-related products, emergency food items, survival-related products, fuel, etc.

    Reach out to us for further details.