The DataWeave Blog

Tag: Assortment

How Healthy is Your Assortment?
In 2025, both consumers and retailers continue to prioritize better health – albeit with evolving definitions and expectations.

The pandemic fundamentally transformed how consumers approach wellness, with this shift becoming entrenched in shopping behaviors years later. As shopping habits have permanently altered, retailers now face increased pressure to rapidly adapt their assortments with in-demand health and wellness products that enhance customer experience across various channels – online and offline.

Let’s explore how leading retailers are keeping consumers – and their own bottom lines – healthy by responding effectively to market trends to drive online sales and market share.

Health & Wellness Influence The Product Mix Across Categories

Consumption habits have changed dramatically since the onset of the pandemic. A McKinsey study shows that 82% and 73% of US, and UK consumers respectively now consider health & wellness a top priority. Typically shoppers adjust grocery shopping and meal planning at the start of the year, with many focusing on fresh, organic, and nutrient-rich foods.

The influential health and wellness mega-trend spans diverse retail channels, including grocery, pharmacy and mass. It extends across numerous categories like:
- Food and beverage (natural, organic, vegan, plant-based food)
- Health and personal care
- Beauty
- Cleaning products
- Fitness equipment
- Athleisure (apparel)
- Consumer electronics like health wearables.
Today’s health movement is so powerful and compelling that retailers have revised their business strategies to better serve health-conscious consumers. For instance, drugstores are reinventing themselves as healthcare destinations, with CVS and Kroger expanding into personalized care delivery and value-based clinics to enhance their health offerings.

Major retailers like Amazon, Walmart, and Target report robust sales in health and wellness categories. For example, Walmart saw a 4.6% increase in comparable sales in early 2024, driven significantly by grocery, consumables, and health-related products.

New product categories are gaining traction:
- Functional foods and beverages are seeing unprecedented growth, with Target launching over 2,000 wellness items in the category, including exclusive products priced under $10.
- Personalized nutrition and mental health products are surging, including tailored dietary solutions and stress-reducing items.
- Health wearables and wellness tech continue to rise in popularity, with over 150 new wellness tech items launched at Target this year, including innovative red-light therapy devices.
- Transparency and sustainability certifications like organic, non-GMO, and vegan labels are increasingly driving purchasing decisions.
- Clinically proven benefits offered by health & wellness products are gaining traction among Gen Z.
Retail’s Survival Of The Fittest Moves Online

As the omnichannel retail sector continues to grow, more shoppers now make purchase decisions within minutes using just a few clicks rather than physically visiting brick-and-mortar stores. In some cases, AI agents like Operator from Chat-GPT or Gemini (Google’s Chatbot) even make personalized, curated lists and reduce the time taken to make purchase decisions. Traditional retail paradigms are rapidly becoming obsolete as consumers grow savvier, more empowered, and better informed than ever before.

To stay competitive, more retailers are embracing AI-driven data insights to adjust their assortments to reflect consumer demand for health and wellness products.

According to industry experts, data insights have emerged as a critical retail strategy that continues to gain momentum. This is because retailers can no longer afford to guess how to approach their omnichannel strategy. They need the accuracy, clarity, and efficiency of data insights to guide their assortment and pricing decisions to outmaneuver competitors, maximize sales, and win market share as shopping evolves online.

Among its retail best practices, Bain & Company recommends retailers “lead with superior assortments that use a customer-centric lens to reduce complexity and increase space for the products customers love.” Insights can help retailers discover the optimal mix of national brands, private labels, limited-time offers, and value-added bundles.

“Lead with superior assortments …
increase space for the products consumers love“
~ Bain & Company

Determining the optimal mix of products also includes bestsellers and unique items that help retailers distinguish their offerings. Assortment insights help retail executives track competitors’ assortment changes and spot gaps in their own product assortment to adapt to emerging consumer trends and in-demand products.

Why Effective Assortment Planning Matters

Assortment planning sits at the heart of retail success, directly influencing profitability, customer satisfaction, and competitive differentiation. In today’s health-conscious market, getting your assortment right means:
- Meeting Customer Expectations: Today’s health-conscious consumers expect relevant, high-quality products that match their wellness goals. A well-planned assortment signals that a retailer understands its customers’ evolving needs.
- Optimizing Inventory Investment: Strategic assortment planning ensures capital is allocated to products with the highest return potential while minimizing investments in slow-moving items.
- Creating Competitive Advantage: A distinctive assortment that includes popular health and wellness products alongside unique offerings helps retailers stand out in a crowded marketplace.
- Reducing Lost Sales: Effective assortment planning minimizes the risk of stockouts on high-demand health and wellness items, preventing customers from shopping elsewhere.
- Supporting Omnichannel Strategies: Well-executed assortment planning ensures consistency across physical and digital touchpoints, creating a seamless customer experience.
- Improving Operational Efficiency: A thoughtfully curated assortment reduces complexity throughout the supply chain, from procurement to warehouse management to in-store operations.
As health and wellness continues to drive consumer spending, retailers who excel at assortment planning can capitalize on these trends more effectively than their competitors, turning market insights into tangible business results.

AI-Powered Assortment Analytics Driving Retail Success

The synergy of AI and data analytics into retail assortment planning is changing how businesses approach inventory management. Retailers using AI-driven predictive analytics have achieved a 36% SKU reduction while increasing sales by 1-2%, showcasing the efficiency of data-driven approaches according to a McKinsey report.

Retailers face several challenges that can hinder strategic assortment planning:
- Limited Understanding of Competition: Retailers struggle to gain comprehensive insights into their product assortments relative to competitors, often lacking visibility into their strengths and weaknesses across categories.
- Data Overload: Assortment planning involves handling vast amounts of data, making it challenging for category managers to extract actionable insights without user-friendly tools and visualization.
- Cross-Channel Consistency: With omnichannel retailing, ensuring consistency across physical stores, e-commerce, and other channels is complex. Misalignment can lead to customer dissatisfaction and loss of loyalty.
- Adapting to Changing Market Trends: Identifying top-selling products and tracking consumer preferences is challenging. Balancing the right mix of products is crucial; without analytics, retailers risk lost sales or excess slow-moving inventory.
- Scalability and Efficiency: As retailers expand into new markets or categories, scaling their assortment planning processes efficiently becomes a challenge. Legacy systems and manual methods often fail to support the agility needed for quick decision-making at scale.
DataWeave’s Assortment Analytics helps retailers address these challenges by providing a robust, easy-to-use platform that delivers actionable insights into product assortments and competitive positioning. With AI-driven, contextual insights and alerts, retailers can effortlessly identify high-demand, unique products, capitalize on catalog strengths, optimize pricing and promotions, improve stock availability, and refine assortments to maintain a competitive edge.

Beyond Data: Actionable Insights That Drive Results

DataWeave’s platform provides a comprehensive, insight-led view into assortments through several key dimensions:
- Stock Insights: Monitor stock changes across retailers to stay updated on availability.
- Category and Sub-Category Insights: Analyze assortment changes, identify newly introduced or discontinued categories, and track leading retailers in specific segments.
- Brand Insights: Identify newly introduced, missing, or discontinued brands, as well as leading brands within chosen categories.
- Product Insights: Identify bestsellers and evaluate their impact on your portfolio, analyzing pricing and promotions.
- Personalized Recommendations: Receive suggestions tailored to your behavior and user profile to refine decision-making.
- User-Configured Alerts: Stay informed with alerts designed to highlight significant changes or opportunities.
The platform addresses data overload by providing an intuitive, insight-driven view of your assortment. Category managers gain a comprehensive, bird’s-eye perspective of key changes within specified timeframes, allowing them to focus on what matters most.

Preparing for the Future of Retail Health

To avoid supply chain bottlenecks, inventory shortages, and out-of-stock scenarios, retailers are strategically using data insights to anticipate fluctuations in demand and proactively plan how to manage disruptions that could affect their assortments.

For variety that satisfies consumers’ diverse product needs, retailers are using data insights to determine whether to collaborate with nimble suppliers to promptly fill any gaps.

To further strengthen their assortments’ attractiveness, retailers are using AI-powered pricing analytics to offer the right product at the right price. These analytics help retailers know exactly how they compare to rivals’ pricing moves with relevant data so they can keep up with market fluctuations and stay competitive by earning consumer engagement, sales, and trust.

To Conclude…

Like nourishing habits that improve consumers’ health, data insights improve retailers’ e-commerce health. Advanced assortment and pricing analytics, powered by artificial intelligence, help retailers make better decisions faster to boost their agility, outmaneuver rivals, and fuel online growth.

In a retail landscape where consumer preferences for health and wellness continue to evolve rapidly, the retailers who thrive will be those who leverage data and AI to understand, anticipate, and meet these changing demands with the right products at the right time. Reach out to us to know more.
July 12, 2024
Why Strategic Competitive Insights Are Key to Optimizing Your Product Assortment
For retailers, the breadth and relevance of their product assortment are critical for success. Amid a crowded market filled with countless products clamoring for consumer attention, retailers must find innovative ways to distinguish themselves. While pricing undeniably impacts purchasing decisions, the diversity and distinctiveness of a retailer’s product range can provide a crucial competitive advantage.

Creating an attractive and profitable assortment that resonates with your target audience requires more than intuition; it demands deep insights into both your own and your competitors’ offerings. A well-curated assortment aligned with current trends can drive higher conversions and foster customer loyalty. However, achieving this perfect balance is a formidable challenge without the right insights.

This is where a data-driven strategy becomes essential, enabling you to curate a product mix that captivates and converts.

However, retailers often encounter significant challenges when attempting to strategically plan their assortments:
- Limited Competitive Insights: Gaining a clear understanding of your competitors’ assortment strengths and weaknesses across various categories is challenging. Without this visibility, it’s difficult to know where you have an edge or where you might be falling behind.
- Tracking Demand Patterns: Identifying top-sellers and monitoring shifts in consumer demand can be a struggle. Without the ability to easily detect trends or changes in demand, you risk missing opportunities to stock trending items.
Attempting to navigate these challenges manually is not only arduous but also susceptible to substantial errors.

How Assortment Analytics Solutions Help

The ideal Assortment Analytics solution must offer a fact-based approach to:
- Identify Strengths and Weaknesses: Understand how your assortment measures up against the competition.
- Stay Trend-Responsive: Keep your product mix fresh and aligned with the latest consumer trends.
- Boost Conversions: Create a relatively unique, customer-focused assortment that enhances conversions.
Many retailers attempt to analyze competitor assortments using manual, in-house methods, which inevitably leads to significant blind spots:
- Variations in product classifications and taxonomies across competitors make meaningful comparisons challenging.
- Gathering complete and accurate data across a vast competitive landscape is difficult.
- Inconsistent titles and descriptions hinder reliable product matching without AI assistance.
- Capturing and comparing detailed product attributes efficiently is nearly impossible without advanced tools.
To overcome these challenges, retailers need a scalable, accurate Assortment Analysis solution designed specifically for the complexities of modern retail needs.

DataWeave’s Assortment Analytics Solution

DataWeave addresses these challenges by providing retailers with a robust platform to gain actionable insights into their product assortments and the competitive landscape. Leveraging advanced analytics and AI-driven algorithms, Assortment Analytics empowers retailers to make informed assortment management decisions, optimize their product offerings, and stay competitive.

Armed with our insights, retailers can lead with their strengths and stock unique and in-demand products in their assortment. Further, by recognizing the strengths in their product catalog, they can craft effective pricing strategies and optimize their logistics, creating a more competitive and appealing shopping experience for their customers. Here are a few capabilities of DataWeave’s solution:

In-Depth Competitive Analysis Across Retailers

The solution offers detailed competitive analysis, revealing insights into competitors’ assortments. It maps competitor products to a common taxonomy, making comparisons accurate and meaningful. Retailers can visualize assortments at granular levels like category, sub-category, and product type.

The data for these insights is collected at configurable intervals, typically monthly or quarterly, and is consumed not only via dashboard summaries but also raw data files to enable in-depth analysis. Retailers have the flexibility to choose specific competitors, brands, products, and categories for tracking, allowing for a tailored and strategic approach to assortment optimization.

Brand and Category Views to Assess Your Portfolio

The solution provides a comprehensive evaluation of your product assortment through brand and category views. In brand views, your portfolio is assessed against competitors at the brand level, highlighting:
- Newly Introduced Brands: Insights into recently introduced brands, revealing shifts in the brand landscape.
- Absence or Limited Presence: Identification of brands lacking representation or with minimal presence compared to competitors, indicating areas for improvement.
- Strong Presence and Exclusivity: Recognition of brands where you excel, including exclusive offerings, showcasing your competitive edge.
Identifying Top-Selling Competitive Products To Boost Assortment Strategy

Beyond just comparing assortment numbers, the DataWeave solution surfaces insights into which competitor products are actually performing well. It equips category and assortment managers with indicators that assess competitor products in terms of their popularity and shelf velocity.

It analyzes metrics like pricing fluctuations, ratings, customer reviews, search rankings, and replenishment rates to pinpoint hot sellers you may want to stock. With these insights, merchandizing managers can pinpoint top-selling products among competitors, enabling informed decisions to enhance their assortment in comparison.

Sophisticated Attribute Tagging and Analysis

Using AI-powered attribute tagging, the solution simplifies granular product analysis within specific categories. An Apparel retailer, for instance, can filter the data to compare assortments based on attributes like material, pattern, color, etc.

Retailers can select attributes relevant to their products and gain detailed insights. These custom filter attributes dynamically populate the panel, facilitating targeted data exploration. Category and merchandizing managers can delve into critical details swiftly, enabling strategic decision-making and comprehensive competitive analysis within their categories.

You can capitalize on opportunities by stocking in-demand, on-trend items and address assortment gaps quickly. At the same time, you can double down on your strengths by enhancing your exclusive or top-performing product sets.

In summary, DataWeave’s Assortment Analytics solution provides an invaluable competitive edge. The insights enable evidence-based decisions to attract more customers, encourage bigger baskets, and maximize the value of every assortment choice.

To learn more, read our detailed product guide here or get on a exploratory call with one of our experts today!
June 13, 2024
Why Localized, Store-Specific Pricing and Availability Insights is Critical for Consumer Brands
Brands are becoming increasingly proficient in monitoring and refining their presence on online marketplaces, utilizing Digital Shelf Analytics to gather and analyze data on their online performance. These tools offer invaluable insights into enhancing visibility, adjusting pricing strategies, and improving content quality on eCommerce sites.

Yet, as the retail landscape shifts towards a more integrated omnichannel approach, it’s crucial for brands, particularly those in CPG, to apply similar strategies to their offline channels. For brands that count physical stores among their primary sales channels, gaining localized insights is key to boosting in-store sales performance.

Collecting shelf data from offline channels presents more challenges than online. Traditional methods, such as physical store visits, often fall short in reliability, timeliness, scale, and level of coverage.

However, the world of eCommerce provides a solution. As part of the effort to facilitate options like buy-online-pickup-in-store (BOPIS) for shoppers, major retailers make store-specific product details available online. Consumers often go online and select their nearest store to make purchases digitally before choosing a fulfillment option like picking up at the store or direct delivery. Aggregating this store-level information offers brands critical insights into pricing and inventory across a vast network of stores, enabling them to make informed decisions that improve pricing strategies and supply chain efficiency, thus minimizing stockouts in crucial markets.

Further, as consumers increasingly seek flexibility in how they receive their purchases—be it through in-store pickup, delivery, or shipping—brands need to adeptly monitor pricing and availability for these different fulfilment options. Such granular insight empowers brands to adapt swiftly and maintain a competitive edge in today’s dynamic retail environment.

Why does monitoring pricing and availability data across stores matter to brands?
- Hyperlocal Competitive Strategy: This allows brands to adjust their pricing strategies based on regional competition. By understanding the local market, brands can decide whether to position themselves as cost leaders or premium offerings. In particular, this is indispensable for Net Revenue Management (NRM) teams.
- Targeted Marketing Initiatives: Understanding regional price and availability enables brands to customize their marketing efforts for specific markets. By aligning their strategies with local demand trends and inventory levels, brands can more effectively engage their target audiences.
- Efficient Inventory Management: By keeping a close eye on store-level data, brands can better manage their stock, ensuring high-demand products are readily available while minimizing the risk of overstocking or running out of stock.
- Minimum Advertised Price (MAP) Monitoring: While brands cannot directly control retail pricing, staying updated on pricing trends helps them adjust their MAP to reflect the competitive landscape, consumer expectations, cost considerations, and regional differences. A strategic approach to MAP management supports brand competitiveness and profitability in a fluctuating market.
DataWeave’s Digital Shelf Analytics solutions equip brands with the necessary data and insights to do all of the above.

DataWeave’s Digital Shelf Analytics is location-aware

DataWeave’s Digital Shelf Analytics platform stands out with its sophisticated location-aware capabilities, enabling the aggregation and analysis of localized pricing, promotions, and availability data. Our platform defines locations using a range of identifiers, including latitudes and longitudes, ZIP codes, or specific stores, and can aggregate this data for particular states or regions.

The strength of the platform lies in its robust data collection and processing framework, which operates seamlessly across thousands of stores and regions. This system is designed to operate at configurable intervals—daily, weekly, or monthly—allowing brands to keep a vigilant eye on product availability, pricing strategies, and delivery timelines based on the selected fulfillment option.

Unlike many other providers, who may provide limited insights from a sample of stores, our solution delivers exhaustive analytics from every storefront. This comprehensive approach grants brands a strategic edge, facilitating efficient inventory tracking, precise pricing adjustments, and rapid responses to fluctuating market dynamics. It cultivates brand consistency and loyalty by enabling brands to adapt proactively to the changing landscape.

Aggregated store-level digital shelf insights via DataWeave

In the summarized view shown above, a brand can track how its various products are positioned across stores and retailers like Walmart, Amazon, Meijer, and others in the US.

Using DataWeave, brands can easily see important metrics like availability levels, prices, and other metrics across these stores gaining immediate visibility without having to physically audit them. the brand can track the same metrics for products across competitor brands and inform its own pricing, stock, and assortment decisions.

Store-level availability insights

We provide a comprehensive view of product availability, highlighting the distribution of out-of-stock (OOS) scenarios across various retailers and pinpointing the availability status throughout a brand’s network of stores. This capability enables swift identification of widespread availability issues, offering a bird’s-eye view of where shortages are most pronounced. By simply hovering over a specific location, detailed information about stock status and pricing for individual stores becomes accessible.

Such insights are crucial for brands to adapt their strategies, mitigate risks, and ensure they meet consumer needs despite the ever-changing retail ecosystem.

Store-level pricing insights

Retailers often adopt different pricing strategies to deal with margin pressure, local competition, and surplus stock. Grasping these pricing dynamics at a hyperlocal level enables brands to tailor their strategies effectively to maintain a competitive edge.

Our platform offers an in-depth look at how prices vary among retailers, across different stores, and throughout various regions. This analysis reveals the nuanced pricing tactics employed by retailers on a regional scale.

For example, brands might see that some retailers, like Kroger and Walmart in the chart below, maintain consistent pricing across their outlets, demonstrating a uniform pricing strategy. In contrast, others, such as Meijer and Shoprite, might adjust their prices to match local market conditions, indicating a more localized approach to pricing.

With DataWeave, brands can dive deeper into the pricing landscape of a specific retailer, examining a price map that provides detailed information on pricing at the store level upon hovering over a given location.

By presenting a historical analysis of average selling prices across different retailers, we equip brands with the insights needed to understand past pricing strategies and anticipate future trends, helping them to strategize more effectively in an ever-evolving market.

Digital Shelf Analytics that work for both eCommerce and brick-and-mortar store data

While established brands have made strides in gathering online pricing and availability data through Digital Shelf Analytics solutions, integrating comprehensive insights from both brick-and-mortar and eCommerce channels often remains a challenge.

DataWeave stands out for its capacity to collect data across diverse digital platforms, including desktop sites, mobile sites, and mobile applications. This capability ensures that omnichannel brands can have a holistic view of their pricing, promotional, and inventory strategies across all locations and digital landscapes.

Leveraging localized Digital Shelf Analytics to understand the intricacies of pricing and availability at the store level allows brands to fine-tune their approaches, swiftly adapt to local market shifts, and uphold a unified brand presence across the digital and offline spheres. This strategic agility places them in a favorable competitive position, enhancing customer satisfaction and trust, which are crucial for sustained success.

Know more about DataWeave’s Digital Shelf Analytics here.

Schedule a call with a specialist to see how it can work for your brand.
April 3, 2024
Valentine’s Day eCommerce Insights

Access to these types of real-time digital marketplace insights can enable retailers and brands to make strategic decisions and help drive profitable growth in an intensifying competitive environment. Be sure to reach out to our Retail Analytics experts for access to more details regarding the above analysis.

February 11, 2022
2021 Cost-Push Inflationary Trends Ran Rampant, Impacting Holiday Discounts

Business has been anything but usual this holiday season, especially in the digital retail world. The holiday hustle and bustle historically seen in stores was once again occurring online, but not as anticipated given the current strength of consumer demand and the reemergence of COVID-19 limiting in-store traffic. While ‘Cyber Weekend’, Thanksgiving through Cyber Monday, continues to further its importance to retailers and brands, this year’s performance fell short of expectation due to product shortages and earlier promotions that pulled forward holiday demand.

Holiday promotions were seen beginning as early as October in order to compete with 2020 Prime Day sales, but discounting, pricing and availability took an opposite direction from usual. This shift influenced our team to get a jump start on our 2021 digital holiday analysis to assess how drastic the changes were versus 2020 activity, and to understand how much of this change has been influenced by inflationary pressures and product scarcity.

Scarcity Becomes a Reality

Our initial analysis started by reviewing year-over-year product availability and pricing changes from January through September 2021, leading up to the holiday season, as detailed in our 2021 Cyber Weekend Preliminary Insights blog. We reviewed popular holiday categories like apparel, electronics, and toys, to have a broad sense of notable trends seen consistently throughout various, applicable marketplaces. What we found was a consistent decline in product availability over the last six months compared to last year, alongside an increase in prices.

Although retailers significantly improved stock availability in November and early December 2021, even digital commerce giants like Amazon and Target were challenged to maintain consistent product availability on their website as seen below. While small in magnitude, there is also a declining trend occurring again closer toward the end of our analysis period, post Cyber Weekend, across all websites included in our analysis.

Source: Commerce Intelligence – Product Availability insights for Home & Garden, Jewelry & Watches, Clothing & Shoes, Bed N Bath, Lighting & Ceiling Fans categories

Greater Discounts, Higher Prices?

With inflation at a thirty-nine year high, retailers and manufacturers have realized they can command higher prices without impacting demand as consumers have shown their willingness to pay the price, especially when threatened by product scarcity. Our assessment is that while some products and categories have responded drastically, manufacturers’ suggested retail prices (MSRPs) have increased nearly seven percent on average from January to December 2021. MSRP adjustments are not taken lightly either, as this is an indication increased prices will be part of a longer-term shift in product strategy.

Source: Commerce Intelligence – Pricing Insights for Bed & Bath, Electronics, Furniture, Healthy & Beauty, and Fashion categories on Amazon.com & Target.com each month in 2021 comparing price increases from January 2021 base

Our 2021 pre-Cyber Weekend analysis reviewed MSRP changes for select categories (Bed & Bath, Electronics, Furniture, Healthy & Beauty, and Fashion) on Amazon and Target.com, and found around forty-eight percent of products on Amazon and thirty-five percent of products on Target.com have increased their MSRPs year-over-year, but kept pre-holiday discount percentages the same.

Looking more specifically as to what year-over-year changes occurred on Black Friday in 2021, we observed MSRPs increasing across the board for all categories at various magnitudes. This indicates why 2021 discounts appeared to be greater than or equivalent to 2020 for many categories, when in reality consumers paid a higher price than they would have in 2020 for the same items.

Source: Commerce Intelligence – MSRP Pricing Insights for Bed & Bath, Electronics, Furniture, Healthy & Beauty, and Fashion categories on Black Friday November 27th, 2021, versus average MSRP pricing for the same SKU count from November 20-26th 2021

On Amazon.com, categories like health & beauty have already increase MSRPs by a much greater percentage and magnitude versus Target.com leading up to and during Black Friday 2021, while other categories like furniture have increased MSRPs evenly on average across both retail websites. The below chart cites a few specific examples of year-over-year SKU-level MSRP, promotional price, and discount changes within found within the electronics, furniture, fashion, and health & beauty categories.

Source: Commerce Intelligence – MSRP Pricing Insights for Bed & Bath, Electronics, Furniture, Healthy & Beauty, and Fashion categories on Black Friday November 27th, 2021, versus average MSRP pricing for the same SKUs on Black Friday November 26th, 2020.

Fewer, but Deeper Discounts

From October through early November 2021, fewer products were discounted compared to this same period in 2020, and the few that were saw much deeper discounts apart from the home improvement category. The most extreme example we saw in discounts offered was within furniture where only three percent of SKUs were on discount in 2021 compared to twenty-six percent in 2020. Interestingly, the magnitude of discount was also higher pre-Cyber Weekend 2021 versus 2020, but this trend was not exclusive to furniture and was also seen within electronics, health & beauty, and home improvement.

Source: Commerce Intelligence – Pricing Insights for Bed & Bath, Electronics, Furniture, Healthy & Beauty, and Fashion categories on Amazon.com & Target.com Pre-Black Friday average selling price during November 20-26th 2021 versus average selling price from November 13-19th 2021 compared to Pre-Black Friday average selling price during November 19-25th 2020 versus average selling price from November 12-18th, 2020.

Within the furniture category, the subcategories offering the greatest number of SKUs with price decreases on Black Friday 2021 were rugs by a wide margin, followed by cabinets, bed and bath, and entertainment units, but the magnitude of discounts offered were all under twenty percent.

Source: Commerce Intelligence – Pricing Insights for Bed & Bath, Electronics, Furniture, Healthy & Beauty, and Fashion categories on Amazon.com and Target.com on Black Friday November 27th, 2021, versus average pricing for the same SKUs from Pre-Black Friday November 20-26th 2021 and Black Friday November 26th, 2020, versus average pricing for the same SKUs from Pre-Black Friday November 19th-25th 2020

Accounting for this phenomenon could have been retailers’ attempts to clear inventory for SKUs which hadn’t sold even during the period of severe supply chain shortages. With more products selling at higher prices this year, retailers were also able to use fewer SKUs with greater discounts to attract buyer in hopes of filling their digital baskets with more full-priced goods, helping to protect margins heading in to Cyber Weekend. Scarcity threats also encouraged consumers to buy early, even when not on promotion, to ensure they would have gifts in time for the holidays.

The same trends seen pre-Cyber Weekend 2021 were also seen on Black Friday with a year-over-year decrease in the percentage of SKUs offered on discount versus 2020, and steeper price reductions for the discounted products which can also be attributed to the increase in MSRPs.

Source: Commerce Intelligence – Pricing Insights for Bed & Bath, Electronics, Furniture, Healthy & Beauty, and Fashion categories on Amazon.com and Target.com on Black Friday November 27th, 2021, versus average pricing for the same SKUs from Pre-Black Friday November 20-26th 2021 and Black Friday November 26th, 2020, versus average pricing for the same SKUs from Pre-Black Friday November 19th-25th 2020

2021 Black Friday Price Increases?

We all know Black Friday is all about price reductions, discounts and deals and so it’s rare to see actual price increases, yet for Black Friday 2021, trends ran counter to this. We observed price increases across all categories for around thirteen to nineteen percent of SKUs, with an average price increase of around fifteen percent in 2021 versus an average of only two percent in 2020.

Source: Commerce Intelligence – Pricing Insights for Bed & Bath, Electronics, Furniture, Healthy & Beauty, and Fashion categories on Amazon.com and Target.com on Black Friday November 27th, 2021, versus pricing for the same SKUs from Pre-Black Friday November 20-26th 2021 and Black Friday November 26th, 2020, versus average pricing for the same SKUs from Pre-Black Friday November 19th-25th 2020

At an account level, we noticed a few interesting differences happening on Black Friday 2021 versus 2020 regarding category price changes. On Target.com, almost ninety percent of the bed and bath SKUs analyzed had a price change on Black Friday in 2021 versus 2020 with eighty-two percent presenting a higher price year-over-year versus only around seven percent showing a decrease, where on Amazon nearly forty-four percent of bed and bath SKUs showed an increase in price and around thirty-eight percent showed a decrease. Except for the health and beauty category on Target.com, more than half of the SKUs in each category saw a price increase on Black Friday versus a price decrease.

Source: Commerce Intelligence – Pricing Insights for Bed & Bath, Electronics, Furniture, Healthy & Beauty, and Fashion categories on Amazon.com and Target.com on Black Friday November 27th, 2021, versus average pricing for the same SKUs on Black Friday November 26th, 2020.

The magnitude of year-over-year price changes seen on Black Friday 2021 was significant across all categories, but the magnitude of price increases found on Amazon.com within the health and beauty category outpaced the rest by far. We reviewed three hundred and sixty-five SKUs on Amazon.com within the health & beauty category and saw almost eighty-three percent of them had a price change with around thirty-one percent decreasing prices and around fifty-two percent increasing prices. This means that within the health & beauty category on Amazon.com, more than fifty percent of the SKUs tracked were sold at a one hundred and seventy-six percent higher price on average during Black Friday 2021 versus 2020.

Source: Commerce Intelligence – Pricing Insights for Bed & Bath, Electronics, Furniture, Healthy & Beauty, and Fashion categories on Amazon.com and Target.com on Black Friday November 27th, 2021, versus average pricing for the same SKUs on Black Friday November 26th, 2020.

The subcategories offering the greatest number of SKUs with price increases on Black Friday 2021 were cameras, followed by men’s fragrances, laptops, and desktops & accessories, but the magnitude of discounts offered were all under ten percent.

Source: Commerce Intelligence – Pricing Insights for Bed & Bath, Electronics, Furniture, Healthy & Beauty, and Fashion categories on Amazon.com and Target.com on Black Friday November 27th, 2021, versus pricing for the same SKUs from Pre-Black Friday November 20-26th 2021 and Black Friday November 26th, 2020, versus average pricing for the same SKUs from Pre-Black Friday November 19th-25th 2020

The Aftermath Post-2021 Cyber Weekend

Extending this analysis beyond the holiday weekend, we analyzed price change activity from December third through the ninth across the top US retailers (chart below) and found that price decreases have been very minimal, comparatively speaking. Though there was a spike in number of price decreases from December 8^th to the 9^th, the percentage of SKUs with price decreases was still very low (less than three percent). We anticipate this trend will continue into 2022.

Source: Commerce Intelligence – Pricing insights for Home & Garden, Jewelry & Watches, Clothing & Shoes, Bed N Bath, Lighting & Ceiling Fans categories

A Sign of Things to Come

A confluence of inflationary trends, product shortages and consumer liquidity have driven many marketplace changes to occur simultaneously. Government programs in the form of stimulus checks, have put extra money in consumers’ hands, and so they’ve been more willing to spend. That, coupled with the shock in the supply chain, has motivated people to buy far ahead of the 2021 holiday season. Hence, retailers have needed to rely much less on across-the-board discounts. Promotions have been more strategic – we’ve seen deeper discounts over fewer products, likely used to draw consumers in to buy certain items, and once they’re there, customers are buying everything else at a non-discount level. When these factors once again normalize, we could see a return to the “race to the bottom” that has occurred since the financial crisis of 2008-2009, but for once, retailers may be able to maintain some pricing power as the 2021 holiday shopping season played out.

Even though performance was not as anticipated and holiday sales did not grow as rapidly as they did in 2020, Cyber Monday was still the greatest online shopping day in 2021. Through it all, retailers managed to keep their digital shelves stocked and orders filled in time for the holidays for the most part, running the risk of housing aged inventory if goods didn’t arrive in time. Despite predictions for steep promotions in January 2022, with supply chains still challenged and inflationary pressures still full steam ahead, we don’t anticipate much in the way of enhanced discounts to continue beyond the holidays.

Access to these types of real-time digital marketplace insights can enable retailers and brands to make strategic decisions like how and when to address inflationary pressures, while also supporting many other day-to-day operations and help drive profitable growth in an intensifying competitive environment. Continue to follow us in the coming weeks for a detailed 2021 year-end review across more retailers and categories. Be sure to reach out to our Retail Analytics experts for access to more details regarding the above analysis.

January 4, 2022
How Brands Can Outperform Rivals With Next-Gen Digital Shelf Analytics

As eCommerce grows in complexity, brands need new ways to grow sales and market share. Right now, brands face urgent market pressures like out-of-stocks, an influx of new competition and rising inflation, all of which erode profitability. As online marketplaces mature, more brands need to make daily changes to their digital marketing strategies in response to these market pressures, shifts in demand, and competitive trends.

eMarketer forecasts 2021 U.S. eCommerce will rise nearly 18% year-over-year (vs. 6.3% for brick-and-mortar), led by apparel and accessories, furniture, food and beverage, and health and personal care. The eCommerce industry is also undergoing fundamental changes with newer entities emerging and traditional business models evolving to adapt to the changed environment. For example, sales for delivery intermediaries such as Doordash, Instacart, Shipt, and Uber have gone from $8.8 billion in 2019 to an estimated $35.3 billion by the end of 2021. Similarly, many brands have established or are building out a Direct to Consumer (D2C) model so they can fully own and control their customer’s experiences.

In response, DataWeave has launched the next generation of our Digital Shelf Analytics suite to help brands across retail categories directly address today’s costly market risks to drive eCommerce growth and gain a competitive advantage.

“Our new enhancements help brands improve online search rank visibility and quantify the impact of digital investments – especially in time for the busy holiday season.”
~ Karthik Bettadapura, CEO and co-founder, DataWeave

The latest product enhancements provide brands access to tailored dashboard views that track KPI achievements and trigger actionable alerts to improve online search rank visibility, protect product availability and optimize share of search 24/7. Dataweave’s Digital Shelf Analytics platform works seamlessly across all forms of eCommerce platforms and models – marketplaces, D2C websites and delivery intermediaries.

Dashboard for Multiple Functions

While all brands share a common objective of increasing sales and market share, their internal teams are often challenged to communicate and collaborate, given differing needs for competitive and performance data across varying job functions. As a result, teams face pressure to quickly grasp market trends and identify what’s holding their brands back.

In response, DataWeave now offers executive-level and customized scorecard views, tailored to each user’s job function, with the ability to measure and assess marketplace changes across a growing list of online retail channels for metrics that matter most to each user. This enhancement enables data democratization and internal alignment to support goal achievement, such as boosting share of category and content effectiveness. The KPIs show aggregated trends, plus granular reasons that help to explain why and where brands can improve.

Brands gain versatile insights serving users from executives to analysts and brand and customer managers.

Prioritized, Actionable Insights

As brands digitize more of their eCommerce and digital marketing processes, they accumulate an abundance of data to analyze to uncover actionable insights. This deluge of data makes it a challenge for brands to know exactly where to begin, create a strategy and determine the right KPIs to set to measure goal accomplishment.

DataWeave’s Digital Shelf Analytics tool enables brands to effectively build a competitive online growth strategy. To boost online discoverability (Share of Search), brands can define their own product taxonomies across billions of data points aggregated across thousands of retailer websites. They can also create customized KPIs that track progress toward goal accomplishment, with the added capability of seeing recommended courses of action to take via email alerts when brands need to adjust their eCommerce plans for agility.

“Brands need an integrated view of how to improve their discoverability
and share of search by considering all touchpoints in the digital commerce ecosystem.”
~ Karthik Bettadapura, CEO and co-founder, DataWeave

Of vital importance, amid today’s global supply chain challenges, brands gain detailed analysis on product inventory and availability, as well as specific insights and alerts that prompt them to solve out-of-stocks faster, which Deloitte reports is a growing concern of consumers (75% are worried about out-of-stocks) this holiday season.

User and system generated alerts provide clarity to actionable steps to improving eCommerce effectiveness.

You also have visibility to store-level product availability, and are alerted to recurring out-of-stock experiences.

Scalable Insights – From Bird’s Eye to Granular Views

DataWeave’s Digital Shelf Analytics allows brands to achieve data accuracy at scale, including reliable insights from a top-down and bottom-up perspective. For example, you can see a granular view of one SKUs product content alongside availability, or you can monitor a group of SKUs, say your best selling ones, at a higher level view with the ability to drill down into more detail.

Brands can access flexible insights, ranging from strategic overviews to finer details explaining performance results.

Many brands struggle with an inability to scale from a hyper-local eCommerce strategy to a global strategy. Most tools available on the market solve for one or the other, addressing opportunities at either a store-level basis or top-down basis – but not both.

According to research by Boston Consulting Group and Google, advanced analytics and AI can drive more than 10% of sales growth for consumer packaged goods (CPG) companies, of which 5% comes directly from marketing. With DataWeave’s advanced analytics, AI and scalable insights, brands can set and follow global strategies while executing changes at a hyper-local level, using root-cause analysis to drill deeper into problems to find out why they are occurring.

As more brands embrace eCommerce and many retailers localize their online assortment strategies, the need for analytical flexibility and granular visibility to insights becomes increasingly important. Google reports that search terms “near me” and “where to buy” have increased by more than 200% among mobile users in the last few years, as consumers seek to buy online locally.

e-Retailers are now fine-tuning merchandising and promotional strategies at a hyper-local level based on differences seen in consumer’s localized search preferences, and DataWeave’s Digital Shelf Analytics solution provides brands visibility to retailer execution changes in near real-time.

Competitive Benchmarking

Brand leaders cannot make sound decisions without considering external factors in the competitive landscape, including rival brands’ pricing, promotion, content, availability, ratings and reviews, and retailer assortment. Dataweave’s Digital Shelf Analytics solution allows you to monitor share of search, search rankings and compare content (assessing attributes like number of images, presence of video, image resolution, etc.) across all competitors, which helps brands make more informed marketing decisions.

Brands are also provided visibility into competitive insights at a granular level, allowing them to make actionable changes to their strategies to stay ahead of competitors’ moves. A new module called ‘Sales and Share’ now enables brands to benchmark sales performance alongside rivals’ and measure market share changes over time to evaluate and improve competitive positioning.

Monitor competitive activity, spot emerging threats and immediately see how your performance compares to all rivals’, targeting ways to outmaneuver the competition.

Sales & Market Share Estimates Correlated with Digital Shelf KPIs

In a brick-and-mortar world, brands often use point of sale (POS) based measurement solutions from third party providers, such as Nielsen, to estimate market share. In the digital world, it is extremely difficult to get such estimates given the number of ways online orders are fulfilled by retailers and obtained by consumers. Dataweave’s Digital Shelf Analytics solution now provides sales and market share estimates via customer defined taxonomy, for large retailers like Amazon. Competitive sales and market share estimates can also be obtained at a SKU level so brands can easily benchmark their performance results.

Additionally, sales and market share data can also be correlated with digital shelf KPIs. This gives an easy way for brands to check the effect of changes made to attributes, such as content and/or product availability, and how the changes impact sales and market share. Similarly, brands can see how modified search efforts, both organic and sponsored, correspond to changes in sales and market share estimates.

Take Your Digital Shelf Growth to the Next Level

The importance of accessing flexible, actionable insights and responding in real-time is growing exponentially as online is poised to account for an increasing proportion of brands’ total sales. With 24/7 digital shelf accessibility among consumers comes 24/7 visibility and the responsibility for brands to address sales and digital marketing opportunities in real-time to attract and serve online shoppers around the clock.

Brands are turning to data analytics to address these new business opportunities, enhance customer satisfaction and loyalty, drive growth and gain a competitive advantage. Companies that adopt data-driven marketing strategies are six times more likely to be profitable year-over-year, and DataWeave is here to help your organization adopt these practices. To capitalize on the global online shopping boom, brands must invest in a digital shelf analytics solution now to effectively build their growth strategies and track measurable KPIs.

DataWeave’s next-gen Digital Shelf Analytics enhancements now further a brand’s ability to monitor, analyze, and determine systems that enable faster and smarter decision-making and sales performance optimization. The results delight consumers by helping them find products they’re searching for, which boosts brand trust.

Connect with us to learn how we can scale with your brand’s analytical needs. No project or region is too big or small, and we can start where you want and scale up to help you stay agile and competitive.

November 30, 2021
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
January 6, 2021