Slide 1

Slide 1 text

1 & Marketing Mix Modelling As part of a data-driven business model

Slide 2

Slide 2 text

2 & 9/12/2023 Implementation of a data driven business-model based on Marketing Mix Modelling

Slide 3

Slide 3 text

3 & 9/12/2023 Implementation of a data-driven business model based on Marketing Mix Modelling Who are we? Rui Conde Data Analytics Lead Stefan Hulsbos Data Analytics Consultant

Slide 4

Slide 4 text

4 & 9/12/2023 Implementation of a data-driven business model based on Marketing Mix Modelling 14.1 billion euros revenue >100 Export to countries 31 Facilities in countries Employees 21,715 Member dairy farmers 15,137 millions of consumers Every day

Slide 5

Slide 5 text

5

Slide 6

Slide 6 text

6 & 9/12/2023 Implementation of a data-driven business model based on Marketing Mix Modelling Fruitful partnership to reach our common goal Entire data domain Data Science and Analytics Engineering Global Commercial Analytics Team Data-driven approach (in-house) Understanding consumer behaviour

Slide 7

Slide 7 text

7 & What is driving this loss? 9/12/2023 Implementation of a data-driven business model based on Marketing Mix Modelling CONSUMER BASE SALES VOLUME time Business challenge we are facing

Slide 8

Slide 8 text

8 & 9/12/2023 Implementation of a data-driven business model based on Marketing Mix Modelling Understanding consumer behavior What consumers do What consumers feel and think +

Slide 9

Slide 9 text

9 & 9/12/2023 Implementation of a data-driven business model based on Marketing Mix Modelling Influencing consumer behaviour Which factors are contributing to our sales? PR OD UC TS DIS TRI BU TIO MEDIA P RI C E

Slide 10

Slide 10 text

10 & 9/12/2023 Implementation of a data-driven business model based on Marketing Mix Modelling Influencing consumer behaviour Which factors are contributing to our sales?

Slide 11

Slide 11 text

11 & 9/12/2023 Implementation of a data-driven business model based on Marketing Mix Modelling Identify the most important sales drivers The Power of Marketing Mix Modelling + - Lockdown Promo Price Media Competitor distribution 2 1 3 4 time

Slide 12

Slide 12 text

12 & 9/12/2023 Implementation of a data driven business-model based on Marketing Mix Modelling Setting yourself up for the future The Power of Marketing Mix Modelling

Slide 13

Slide 13 text

13 & 9/12/2023 Implementation of a data-driven business model based on Marketing Mix Modelling How does it technically work? Understanding Marketing Mix Modelling Phase II: Feature selection Which factors explain sales? Multiple Linear Regression Analysis & Competitio n R2 = 0.91 -0.84 +1.45 Phase I: Data ingestion Phase III: Outcome Now Past Future Target Predicted

Slide 14

Slide 14 text

14 & MEDIA SPEND PRICE INDEX MARKETING MIX MODELLING Brand A Category SALES VOLUME 9/12/2023 Implementation of a data-driven business model based on Marketing Mix Modelling Deep dive on key drivers – Integrated Story Storytelling with Marketing Mix Modelling Brand A Competitor

Slide 15

Slide 15 text

15 & Model Output 9/12/2023 Implementation of a data-driven business model based on Marketing Mix Modelling Deep dive on key drivers – Promo effectiveness Storytelling with Marketing Mix Modelling Competitor Switch Category Expansion Changing from other FrieslandCampina product Stock-up Promo Uplift Drive quality Promo Uplift Promo Uplift

Slide 16

Slide 16 text

16 & 9/12/2023 Implementation of a data driven business-model based on Marketing Mix Modelling

Slide 17

Slide 17 text

17 & 9/12/2023 Implementation of a data-driven business model based on Marketing Mix Modelling The effect of media is more complex than you initially think Message vs sales uplift Decay Saturation

Slide 18

Slide 18 text

18 & Media Optimization 9/12/2023 Implementation of a data-driven business model based on Marketing Mix Modelling Deep dive on key drivers – Media optimization Storytelling with Marketing Mix Modelling Uplift saturation Avg. monthly spend Media Uplift Avg. weekly spend Uplift saturation Model Output Media Uplift Media spend Time Media Spend

Slide 19

Slide 19 text

19 & 9/12/2023 Implementation of a data-driven business model based on Marketing Mix Modelling Kickstart your Marketing Mix Modelling journey Data collection Model development Insights

Slide 20

Slide 20 text

20 & 9/12/2023 Implementation of a data driven business-model based on Marketing Mix Modelling

Slide 21

Slide 21 text

21 & Questions? You can also find us at booth 8!