McDonald's France
We made fast food even faster. McDonald’s is famous for cheeseburgers and fries, but with 1.5 million customers daily, each transaction producing 20 to 30 data points, it has also become a technology organization. With all that data available, McDonald’s wanted to build a complete perspective of a customer’s lifetime value, with visibility into each step of their journey. Understanding likes and dislikes based on data analysis would provide McDonald’s the opportunity to improve the customer experience at a variety of intersections globally helping to identify and apply cost optimization strategies.
Overview
THE CHALLENGE
McDonald’s France wanted to improve the customer experience at a variety of intersections globally. They wanted to capitalize on the power of data to build a complete perspective of a customer’s lifetime value (CLV), with visibility into each step of their journey.
THE SOLUTION
Ollion helped Mcdonald's France move from a traditional data warehouse to a data lake, reducing the effort required to analyze or process data sets across different properties and applications.
THE OUTCOME
McDonald’s France now has visibility into the speed of service with a dedicated dashboard focused on speed of service, customer lifetime value, and conversion rate to help grow the business. The analytics also helped the teams make data-driven, accurate decisions and implement operational changes to impact operational efficiency using knowledge around prep time to influence fulfillment.
The challenge
To meet its data collection and analysis needs, McDonald’s France needed a modern data platform equipped with data processing capabilities and cloud architecture. Focused on data insights rather than data management, the McDonald’s team partnered with Ollion utilizing AWS Glue to move from a traditional data warehouse to Amazon Redshift, reducing the effort required to manage and analyze the data to meet the business demands.
Making an impact
McDonald’s is the world’s leading global foodservice retailer with over 36,000 locations in over 100 countries. More than 80% of McDonald’s restaurants worldwide are owned and operated by independent local businessmen and women. McDonald’s and its franchisees employ 1.9 million people worldwide.
McDonald’s, with its multi-national reach, generates and collects an abundance of data. Creating insight from that data required a new approach to data management to ensure flexibility and scalability. The technology necessary to accomplish McDonald’s analytics goals is both cost-effective and efficient in the cloud – key catalysts for initiating the project within McDonald’s groups, gaining buy-in from key stakeholders and engaging the business quickly.
McDonald’s France data journey
With so much data available, and the goal of improving customer experience as motivation, McDonald’s France prioritized three types of data sources – sales, speed of service, and customer experience. While collecting, aggregating, and cleaning data is a huge feat on its own, McDonald’s France also had to navigate a high level of data integration complexity.
As an omnichannel restaurant, McDonald’s juggles information from point of sales systems with sales happening online, offline, and across dozens of different locations. Data sources include multiple data vendors, mobile apps, loyalty programs, customer relationship management (CRM) systems, and other digital interfaces. Combined with one digital ecosystem, this data is the force that drives the entire customer journey. Once consolidated, the opportunity is to find a correlation between the customer data that transforms the puzzle into a holistic view of the customer experience.
Transforming data operations
To meet its data collection and analysis needs, McDonald’s France needed a modern data platform equipped with data processing capabilities and cloud architecture. Focused on data insights rather than data management, the McDonald’s team partnered with Ollion utilizing AWS Glue to move from a traditional data warehouse to Amazon Redshift, reducing the effort required to manage and analyze the data to meet the business demands.
During the process, McDonald’s emphasized the importance of ongoing data collection from anywhere and everywhere across their many data sources. From revenue numbers and operational statistics to social media streams, kitchen management systems, and commercial, regional and structural data – they wanted everything stored for potential future use. Historical data will help them establish benchmarks, forecast sales projections and understand customer behavior over time.
The outcome
Ollion walked alongside McDonald’s France to empower them to monitor and visualize key KPIs to make data-driven decisions about their team’s operational efficiencies through a dashboard built on Amazon Quicksight utilizing Amazon CloudWatch, Athena, and SageMaker. National teams can make data-based, accurate decisions using the dashboard and implement logistical changes in operations. They’re able to impact operational efficiency using knowledge around prep time to influence fulfillment.
While their data journey has only begun with this first step of capitalizing on the power of data to understand and increase customer lifetime value (CLV), these initial steps opened the door to new data and prescriptive analytics possibilities. The models established by McDonald’s France will be used as an example to expand data investments throughout the McDonald’s corporation.
Thank you for your great effort, your time and your patience on this complex project in an international environment. You did an incredible job! On behalf of McDonald’s France, we were very pleased to work alongside you.
MCDONALD'S
