Retail & Services

LEROY MERLIN: Measuring and Optimizing Marketing and Media Actions across Channels with an Internal Media Mix Modeling Platform

Service
Cloud Services
Client
Leroy Merlin
Date
September 2023
Download
Key results
6
months of tool-building
50K
scenarios tested on 100K agents
20-25%
global contribution to revenue
An innovative and methodological approach to ABM Modeling that takes into account the specificities of our omnichannel media mix, allowing us to be agile and make the models evolve over time.
Pol-Amaury Cresp, Trafic Media & CRM Manager, Leroy Merlin France:
Google Cloud Platform
Power BI

Challenge

Measuring the impact of online & offline media investments on a regular and granular basis to support continuous ROI improvement

Leroy Merlin wished to build a decision-making tool to provide impact measurements for media investments online as well as offline (TV, radio…).

Approach

Modeling the behavior of consumers ("agents") instead of projecting each indicator

By using agents, our model can measure micro & macro KPIs instead of having one model per KPI, allowing not only for more precise results but also for the integration of internal (e.g., advertising) and external (e.g., weather, competition, inflation, other...) factors.

Results

A dynamic interface to measure and predict marketing performance

Successfully developed in ABM-based Power BI/Power apps by fifty-five, Leroy Merlin’s dynamic media mix modeling interface allows its marketing teams to update parameters  (such as budget) and measure ROI optimization across channels, automatically updating figures monthly. As a result, decision-making becomes better informed and more efficient.

6
months of tool-building
50K
scenarios tested on 100K agents
20-25%
global contribution to revenue
case studies

Other cases you may be interested in