Walmart Vs. Soriana: Consumer Foot traffic Analysis

Mobility data analytics are transforming the way commercial strategies are defined in the retail business, and supermarket chains are no exception.

Friday, August 27, 2021

Understanding what consumers think, what they want and what they do is critical for companies in the retail sector. This is where Big Data tools play an important role, as it is possible to measure the affluence at a location and customer behavior, among other aspects. With this information, it is possible to model the performance of points of sale and estimate the turnover of competitors or potential locations.

With Big Data techniques, large volumes of anonymous mobility data are collected through mobile devices, and by combining this information with geospatial data, it is possible to analyze in detail the performance of a given point of interest (POI), such as a store, a supermarket or a restaurant.

The correlation between foot traffic and sales in the retail and restaurant sectors has been extensively studied and tested, making the development of these studies a priority for evaluating locations.

Case Study: Walmart Revolucion vs. Soriana Hiper Estadio (Guadalajara, Mexico)
PREDIK Data-Driven carried out a detailed study of two hypermarkets operated by Walmart Mexico and Organizacion Soriana in Guadalajara, specifically Walmart Revolucion and Soriana Hiper Estadio.

Mobility data was analyzed in the two establishments and in the area surrounding the stores, with the objective of comparing and analyzing foot traffic in the two supermarkets. For this purpose, mobility data was collected and analyzed to understand the behavior of people visiting both supermarkets. This analysis seeks to answer the following questions:

How are visits distributed in each establishment?
The first step is to locate both points on the map, as well as to select the area of interest. This is important because if the location is within a plaza, it must be delimited correctly to avoid considering observations that do not correspond to the specific place.

Using geospatial and Big Data techniques, all observations recorded within the areas of interest are extracted. Something to keep in mind is that the resolution of the data is such that it allows us to see in which specific areas inside the supermarket, the movement of people is concentrated. This is very useful when conceptualizing the design of the interior space and the distribution of the sections that make up the supermarket.

Heat map showing the concentration of people inside the Walmart Revolucion supermarket:

Heat map showing the concentration of people inside the Soriana Hiper Estadio:

With this information, a natural question arises: Which supermarket is most visited?

Percentage distribution of the visits registered in the period analyzed:

With the correct analysis of registered visits, we know that Walmart has 55% more visits than Soriana supermarket, which corresponds to the popularity and size of each store.

It is also possible to see the evolution of visits over time, which can be very useful to identify trends in the behavior of visitors and potential customers.

Analysis of the evolution of foot traffic (visits) between February and April 2021:

What days of the week are the most crowded?

Mobility data is multidimensional, which means that in addition to knowing the exact point of a visit, we know the exact time at which it was recorded. This allows us to better understand consumer behavior and design practically personalized commercial strategies.

It is also possible to further analyze the data and determine the visits per hour. This analysis serves both to know the busiest times, as well as to identify the devices of the workers of both establishments, since they are the ones that will be out of business hours.

In the same way, we identified the hours in which there is a higher concentration of workers outside business hours. This data is very interesting, as it can help to understand the supply, distribution and inventory process of the competing supermarket.

What are the characteristics of the surrounding areas of Walmart Revolucion and Soriana Hiper Estadio supermarkets?

Although visits are correlated with the performance of an establishment, they are not the only important factor. Another fundamental aspect that should be analyzed is the environment of the location, since it allows to know other commercial establishments, to analyze the visitation they receive, and to understand how they are and how potential customers who move around the supermarket behave.

Heat map showing the mobility of people around Walmart Revolucion:

Heat map showing the mobility of people around Soriana Hiper Estadio:

The analysis of the environment gives us a more general picture of the area and how many people move around. This data, combined with other factors, is really useful when it comes to predicting the turnover of an establishment.

What other insights can be obtained by analyzing mobility data?

  • Understanding which customers share both chains

By analyzing the records of mobile devices registered during a given period of time in a specific location, such as a supermarket, it is possible to identify consumers, and know, for example, that customers who identified themselves at the Walmart supermarket are also customers of the Soriana supermarket.

Analysis to identify Soriana customers who were also at Walmart, and vice versa:

  • Customer Profiling
Another possible use is customer profiling, since it is possible to know in which other places (stores, restaurants, shopping malls, residential areas, among others) the people who visited an establishment were. Thus, Walmart and Soriana can know how their customers behave, since they can know where and how long they were before and after visiting their supermarket. This allows them to generate high-value insights to optimize the understanding of current consumers and search for new potential customers with similar behaviors.

  • Identifying suitable areas to establish new points of sale
With mobility data, it is possible to clearly understand the behavior of the people who pass through a given area, understand what they are like, their tastes, preferences, socioeconomic level and purchasing potential. This, together with an in-depth analysis of the commercial establishments in the area in question, becomes a crucial factor in determining the best locations for the opening of new stores.

  • What is the turnover potential of my competitor or a point of sale?
Through machine learning models, it is possible to predict the turnover of a specific POS. With these models, Soriana could get to know what is the turnover potential of its competitor Walmart in a specific week, month, or year. These models can also be used to predict the turnover potential of an outlet that is about to open. This is ideal to complement feasibility studies for new stores in expansion plans.

¿Busca soluciones de inteligencia comercial para su empresa?

Learn how location analytics is helping retail companies. Contact us!

this site is protected by reCAPTCHA and Google's privacy policy and terms of service.
Need assistance? Contact us
(506) 4001-6423

More on this topic

Visits battle: Whole Foods Market vs. Sprouts Farmers Market

October 2021

Understanding consumer mobility patterns is critical for all types of businesses. Big Data tools, spatial data, and anonymized and aggregated mobility data play a very important role in these analyses, as they enable the measurement of foot traffic and consumer behavior patterns in any given area or point of interest.

Foot traffic analytics, location intelligence, and point-of-sale categorization have revolutionized the way retailers implement expansion models, commercial and operational strategies in the supermarket franchise focused on more organically sourced products.

Foot traffic Analytics: Burger King Vs. McDonald´s

October 2021

Location and Footfall Analytics has changed the way retailers implement marketing and commercial strategies in the fast-food restaurant franchise business.

Understanding consumers’ mobility behavioral patterns are critical for all types of restaurants. Big Data tools and spatial data play a very important role in these analyses since they make it possible to measure the foot traffic and mobility patterns of any area or point of interest. By performing these studies, businesses understand and predict the performance of their stores, as well as estimate the competitors’ turnover or identify areas for expansion planning. (site selection)

McDonald's Vs. Burger King: Foot traffic Analysis

September 2021

Location Analytics has changed the way marketing and commercial strategies are defined in the fast-food restaurant franchise business.

Understanding consumers’ behavior patterns is critical for all types of restaurants. Big Data tools play a very important role in this analysis, since they make possible to measure the foot traffic and mobility patterns of a specific area or location, among other variables.

Big Data to Estimate Competitors' Turnover and Revenue

September 2021

A competitive analysis begins by defining the target and its scope, exploiting different sets of structured and unstructured data available thanks to innovative tools that help to identify and measure competing brands and estimate their sales.

With Big Data tools that help analyze large volumes of information like predictive models, location intelligence and mobility data, it's possible to generate a competitive analysis, which consists of identifying the main competing companies and estimating their turnover, quantifying their potential sales, identifying gaps in the market, predicting the cost of developing new products, discovering trends, among others.