Apr 14, 2020
Case Study

Benchmark store performance for McDonald's

Almudena Sanz
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

Las 2 Españas a Palos de Golf: quiénes y cómo son los que reparten tweets a izquierda y derecha.

La semana pasada, millones de personas en España acabaron imaginando en su cabeza algo que realmente nunca pasó: a un señor rico del barrio de Salamanca destrozando mobilario urbano con un palo de golf. Analizamos con datos y Graphext cómo se originó este bulo, y sobre todo quién hay detrás a izquierda y derecha propagando estas nuevas narrativas políticas

see more >

Las cifras de muertos en España por COVID-19 en contexto.

¿Quiénes son y dónde están los excesos de muertes en España en los últimos años por edad, sexo y Comunidades Autónomas?

see more >

How to look good on video calls: analyzing 1K rated Skype & Zoom rooms. COVID-19 Voyeurism.

Collecting 1000 thounsand screenshots from video calls on TV to find patterns of what makes you look good or bad

see more >

Clustering countries by Covid-19 Mobility Trends changes

We used the Apple data to cluster with Graphext countries that are experiencing similar behaviour of changes in people walking outside: 🔴Italy, Spain and other suddenly decrease by more than 90% 🟠Nordic, Germany slowly going back to the streets. 🟢Slowly reducing to -50% since February

see more >

Ready to try Graphext?

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

Start now