Apr 14, 2020
Case Study

Benchmark store performance for McDonald's

Almudena Sanz

McDonald’s Spain has over 500 stores, and collects millions of sales transaction data from them. The sales data is extremely useful to benchmark performance across stores. But before diving into the analysis, how to make sure we are comparing the same types of stores to make the analysis relevant?  

Using Graphext, we helped McDonald’s to categorize their stores based on their typical customer profiles. We started by plotted a map of all the McDonald’s stores across Spain using their location coordinates. Once this step is done, the system automatically groups stores with similar profiles by colour.


We all know that McDonald’s offers a diverse menu to meet the consumers´preferences, and this is well reflected on how people choose their food items across different regions.

The red cluster on the map shows stores along the coastal regions. If you look at these stores performance, they sell a lot of individual drinks, individual fries, and people go there for early dinner (they are probably tourists who are not yet used to the 9pm Spanish dinner time).

In comparison, looking at the orange cluster representing stores from Southern Spain, you can see they sell a lot more local menus and coffees (yes, McDonald’s offers croquetas and tortillas in Spain!). You can just imagine a local from the small town of Granada go to McDonald’s for a coffee and snack and enjoy an afternoon break.

After the store analysis, we also did a product basket analysis to see how products are being sold together. Finding out how products are associated with each other is very useful to create product bundles or design promotion strategy.

We know that McCafe is a very popular new product line from McDonald’s. Last time I went to a McCafe, I was impressed by the fancy pastries they offer, from croissants, cookies, to chocolate macarons. So we want to take a look at what are some of the most popular items sold together with a cappuccino.  We have already guessed orders of other coffees and croissants must be very popular, but surprisingly, we also found out Kit Kat chocolate bar goes well with cappuccino too! Next time when you go to McDonald’s, perhaps try the cappuccino and Kit Kat combo to see if you like it.

Interested to know more about Graphext? Want to learn more? Request a demo!

Want to do something like this?

Start now

Other stories

Cómo el Congreso de los Diputados tuiteó durante el Estado de Alarma

Prácticamente todos los diputados del Congreso actual, la XIV legislatura, tienen cuenta en Twitter y gran parte de su trabajo consiste en leer y escribir tweets. Para bien o para mal, los políticos nunca han tenido más poder y facilidad para mandar directamente sus mensajes a los ciudadnos sin el filtro de la prensa. Analizamos las principales narrativas que cada partido movió.

see more >

How US Congress Tweets in 2020

We analyzed almost 200K tweets from members of Congress, comparing across parties and seeing what worked for each one. We found interesting insights by analyzing the way each party worded their opinions.

see more >

Finding opportunities in Madrid's Real Estate sector

We analyzed more than 20k advertisements in real estate websites to try to find underpriced houses with Graphext's predictive algorithms. Along the way we looked into the relationships between prices and factors such as education level or location index to try to find insights and patterns in the data.

see more >

Airlines, the 2008 financial crisis and the lipstick effect

We analyzed 30K airlines services reviews and saw that there are clear jumps in ratings marked by the 2008 financial crisis and subsequent economic recovery. Could these factors have impacted consumers, or have airlines improved their services? We used Graphext to gain insight into the data and try to find an answer to these questions.

see more >

Subscribe to new blogposts

Thank you! Your submission has been received!

Sorry. Something failed

Ready to try Graphext?

Want to know more about our smart data discovery tool?
Ask us for a demo!

Start now