In-House Data: Online FMCG Assortment analysis

You’re looking at a series of quick in-house-made e-Commerce analyses concerning the online product assortment that we post weekly on our LinkedIn page.
The results come from our data that are collected at every e-point of sale and analyzed by our consultants. 
Every week, we pick a different retailer in a different country, focusing on a specific online category to offer you a detailed outlook on the FMCG omnichannel. 

Assortment
Analysis in the US

In the sheet below,  we zoomed in on the cheese category at Kroger, US.
You can see the average number of products decreasing until week 19 and then rebounding. However, without reaching its level before the Covid-19 crisis. (March 9, 2020 to May 24, 2020)

analysis share of assortment kroger data impact cheese category covid-19

We added one more sheet portraying the differences between Walmart’s stores. As you can see below, the manufacturers’ share of search can double from one online store to another in the ice cream category. (P7 : Two first weeks of July, 2020)

analysis share of assortment walmart data impact ice cream category

Our analysis of over 6800 online stores yields market insights our competitors can’t provide. Look at our study of the American diaper category for an example of what full-scale data collection generates.

Our category-wide share of assortment tracking is the most granular in the industry and is visualized clearly and simply with our user-friendly dashboard.

Assortment
Analysis in the UK

We chose an example from the UK market, specifically from the retailer Tesco. As you can see below, the chocolate category assortment decreased by 36% which impacted most of the manufacturers. (March 9, 2020 to June 14, 2020)

Grocery - sweet
united kingdom online grocery analysis assortment tesco data impact chocolate category

In continuing the analysis in this country, we checked how the cheese online assortment has been evolving at Tesco. After analyzing 322 different online stores, we noticed that the cheese online assortment has been recovering since week 13 but is still 13% lower than in week 11, positively affecting small labels. (March 9, 2020 to June 28, 2020)

united kingdom analysis assortment tesco data impact cheese category

After analyzing 321 different online stores of Tesco UK, we observed a decrease in the online assortment of the chocolate category this year compared to last year. The chocolate category’s online assortment decrease impacted mainly Tesco’s private label and very small market actors. (P5 – P7 : June 01, 2020 to July 15, 2020)

Grocery - sweet
analysis share of assortment number of products walmart data impact chocolate category

To give you a view of the evolution of assortment for an other retailer, we analyzed 125 online stores of Sainsbury’s. This sheet portrays a general increase in the size of the online beer assortment, occurring in week 30. This increase of 32% will have an impact mainly on large manufacturers. (June 22, 2020 to August 23, 2020)

analysis sheet of the share of assortment at Sainsbury's in the UK

We then decided to focus on a search-based analysis. The sheet below portrays important disparities between different online stores of Sainsbury’s in the ice cream category. It displays a clear correlation between the store’s share of assortment and share of search. Higher the manufacturer’s share of assortment, the higher the chance of its product being in the TOP 10. (Two last weeks of July, 2020)

analysis sheet of the share of assortment share of search at Sainsbury's uk showing the correlation between them

Halloween went around the corner and UK retailers showed that they were ready!
The chocolate & candy categories have grown by +60,6 products in the last 3 weeks at AsdaTesco & Sainbury’s. (September 21, 2020 to October 11, 2020)

Grocery - sweet
Weekly Analysis: UK haloween assortment Analysis at Tesco

It’s the chocolate season!
Looking into the retailers in the UK, the seasonal online chocolate products increased for Halloween and remain elevated for the Christmas season!
Retailers analyzed: AsdaSainsbury’s & Tesco

#chocolate #christmas

Grocery - sweet
Analysis sheet UK category size evolution christmas chocolate products

The online chocolate category grew 14% for Valentine’s day, with 40% of that growth coming from special occasion products.

Grocery - sweet
Analysis UK product assortment chocolate valentine's day

During the last quarter of 2020, one laundry detergent brand had 61.7% share of voice in the UK, more than all others combined.
Retailers analyzed: AsdaTescoSainsbury’s, and Morrisons.

Analysis sheet UK share of voice laundry detergent
Our category-wide share of assortment tracking is the most granular in the industry and is visualized clearly and simply with our user-friendly dashboard.
 

Assortment
Analysis in Belgium

To continue our weekly analysis, we went to Belgium to see what has been happening with the beer category at Delhaize. After analyzing 136 different online stores, we noticed that the beer category assortment decreased by 37% which strongly impacted the market leader. (February 24, 2020 to June 21, 2020)

belgium analysis assortment delhaize data impact beer category

For the same retailer Delhaize, and the same number of online stores, we noticed that the hot beverage category assortment decreased by 56%. However, the situation seems to be improving with a positive impact on small labels. (March 2, 2020 to July 5, 2020)

belgium analysis assortment delhaize data impact hot beverage

With Christmas approaching, the online range of craft beer products has actively increased, especially at Delhaize.
Cheers to that!

#christmascountdown #beer

Analysis sheet Belgium perfect shelf craft beer spirits
Assortment
Analysis in France

Welcome to the soft drink category Assortment at Carrefour, France. In the sheet below, you can see that the soft drink category eCommerce Assortment has been reduced by 30% due to long out of stock and certain product delistings.

The market leaders have been strongly impacted by the situation. (March 9, 2020 to May 17, 2020)

 
france analyse assortiment carrefour data impact soft drink categorie

We then analysed the online alcohol category in France, and observed a large increase in banner activations during Week 46 focused on the Beer & Cider and Spirits segments.

Analyse activation de banières publicitaires france boissons alcoolisées

In France, the online water category was strongly impacted by consumer stockpiling behavior during the first lockdown and only returned to its pre-covid standard at the end of the year. (Online water category vs the year 2020)

Analyse france ruptures stocks eau et boissons

Our data analysis includes category-wide share of assortment monitoring at all of the major retailers in more than 40 countries.

digital Shelf online grocery
Assortment
Analysis in Spain

We selected an example from Carrefour, Spain: the baking mix category. As you can see in the sheet below, the online baking mix assortment decreased by 39% during the COVID crisis. However, in this specific example, the decrease impacted only one of the market leaders. (February 17, 2020 to June 21, 2020)

spain analysis online assortment carrefour data impact baking mix category
Assortment
Analysis in Canada

Hello Canada! We compared the online chocolate categories at Loblaws and Thrifty Foods, finding out that the online chocolate category is nearly two times larger at Thrifty Foods than at Loblaws. (October 19, 2020 to October 25, 2020)

Grocery - sweet
SOA Thrifty canada chocolate

If you want to follow the analysis sheets that come out twice a week on our LinkedIn page, you should have a look on our LinkedIn.

We hope we have brought you new knowledge. This concludes our Online Assortment Analysis page, keep in mind that it is updated day by day to guarantee you all the new trends you see in product Assortment across the FMCG eCommerce markets.
If you are also interested, we invite you to check our weekly out-of-stock analysis.

Don't miss a thing !
CPG ecommerce newsletter

Subscribe to our newsletter

Privacy policy

Data collection - Use of cookies - Consent

DataImpact undertakes to ensure that the collection and processing of your data, carried out from the www.dataimpact.io site, comply with the Data Protection Act and the RGPD. This processing is necessary for the execution of our services and the internal functioning of our company. For any information on the protection of personal data, you can also consult the site of the Commission Informatique et Liberté www.cnil.fr.

Identity of the data owner:

Personal data are collected by : Société par actions simplifiée DataImpact whose registered office is at 39 Rue Lucien Sampaix, 75010 Paris, RCS PARIS 799 367 222 T: +33 (0)1 42 51 87 08

Purpose - use of your data:

DataImpact is likely to collect personal data about you for the purposes necessary for its activity, whether in terms of recruitment, responding to your requests for information, execution and monitoring of service contracts. Types of data collected: DataImpact only collects data that is strictly necessary for the purposes of its activity. The personal data collected can be the following:

-In the context of a request for information (name, first name, email, telephone, company name).

-As part of a recruitment process: (surname, first name, email, telephone, company name), information on the curriculum vitae (marital status, surname, first name, date and place of birth, nationality, professional background, academic background, hobbies)

-If necessary, connection data including your IP address may be collected for purely statistical purposes.

Origin of the data:

The personal data collected by DataImpact are those directly given by the person concerned when using the contact form or surfing on the site www.dataimpact.io.

Intended transfers of personal data to a non-EU Member State:

To date, DataImpact does not transfer, nor envisage any transfer of your personal data to a non-European Union member state.

Retention period of the categories of data processed:

Connection data are kept at the latest within one year after connection to the www.dataimpact.io website.
Data relating to applicants for a post are kept at the latest five years after the last contact, with a view to possible recruitment.

Data of prospects are kept no later than three years after the last contact.

Customer data are kept for the duration of the service contract.

Protection of your data:

DataImpact ensures that its employees and service providers, subcontractors or hosts, also respect the absolute confidentiality of the information provided to them.

We maintain in-house electronic and organizational security measures in relation to the collection, storage, and communication of data.

Your rights under the Data Protection Act:

DataImpact takes all appropriate measures in order to facilitate the exercise of the rights of its clients regarding their personal data (right of access, rectification, deletion, limitation of processing, portability, to define the fate of its data after death).

The information provided in connection with the exercise of these rights is provided in writing or electronically. On request, the information may be provided orally. All requests should be sent by post to 739 Rue Lucien Sampaix, 75010 Paris or to [email protected].

In accordance with the regulations in force, your request must be signed and accompanied by a photocopy of an identity document bearing your signature and specify the address to which the reply should be sent. A reply will then be sent to you as soon as possible and in any event within one month of receipt of the request.

Flows out of your data after your death:

The new article 40-1 of the French Data Protection Act allows individuals to give instructions regarding the storage, deletion and communication of their data after their death.

You can read the procedure relating to these directives by following the following link: “https://www.cnil.fr/fr/ce-que-change-la-loi-pour-une-republique-numerique-pour-la-protection-des-donneespersonnelles#mortnumerique”.

Cookies:

You are informed that, during your visits to the www.dataimpact.io website, a cookie may, if necessary, be automatically installed on your browser software. A cookie is a small file stored on your computer. As such, it is a block of data that does not allow users to be identified but is used to record information relating to their browsing on the site. Cookies are used, on the one hand, to facilitate your navigation on the site and, on the other hand, for statistical purposes. In order to better know the frequentation of the site, we (mainly) measure the number of pages viewed, visitors, visits, as well as the activity of visitors on our site and their frequency of return.

The parameters of the browser software make it possible to inform about the presence of cookies and possibly to refuse them in the manner described at the following address “http://www.cnil.fr/vos-libertes/vos-traces/les-cookies/”.

You have the right to access, withdraw and modify personal data communicated through cookies under the conditions indicated above.

Terms of Service

Article 6 III of the Law of 22 June 2004

Société par action simplifiée DataImpact
39 Rue Lucien Sampaix, 75010 Paris
T: +33 (0)1 42 51 87 08
M: [email protected]
RCS PARIS 799 367 222

Director of publication: Yacine TERKI

Hosting : O2 SWITCH 222 Boulevard Gustave Flaubert 63000 Clermont-Ferrand

Terms and conditions of use:

The information contained and consultable on this site is provided for information purposes by DataImpact. They can be modified at any time without notice. Under no circumstances does it constitute advice or a service of any kind whatsoever. You assume full responsibility for the use of this site or the information it contains.

DataImpact cannot be held responsible for damages related to the consultation or use of the website by the user. Hypertext links may refer to third party sites over which DataImpact has no control.

DataImpact declines all responsibility for the content of these sites. The use of this service is reserved for strictly personal use. Any reproduction or representation, of all or part of the information, brochures or logos contained on the site, on any medium whatsoever, is prohibited. Failure to comply with this prohibition constitutes an infringement that may result in civil and criminal liability of the counterfeiter.