Marketing Mix Modeling with Excel - Analytics Course

Marketing Mix Modeling with Excel: Learn the Science behind Advertising Investment

4.35 (147 reviews)
Udemy
platform
English
language
Analytics & Automation
category
instructor
5,460
students
1.5 hours
content
Mar 2022
last update
FREE
regular price

What you will learn

Learn what Marketing Mix Modeling (MMM) are

How to explore Marketing Data

How to deploy a Learning Algorithm on EXCEL

Diminishing Return with Excel: How much can I spend before CPA increases?

Adstock with Excel: What's the lagged effect of your ads?

Description

I present to you the first Masterclass on Marketing Mix Modeling on Excel.


The science behind advertising investment.


Within the Masterclass you will discover:


- Ep 1: What are MMMs and how to exploit them to generate business growth


- Ep2: How to explore marketing data and deduce analysis hypotheses


- Ep3: How to use a learning algorithm on your data with EXCEL


- Ep4: How to simulate Diminishing Returns and AdStocks EXCEL


- Ep 5: How to create a predictive simulator on excel


- Ep 6: How to create an automatic advertising budget allocator with Excel.


This methodology has not been effected by cookie's restrictions and IOS14, for this reason MMM has becoming one of the most adopted methodology for Marketing Analytics in 2022.

The course has been designed to be extremely practical, and above all, suitable for beginners.


I chose excel, because it is a very powerful tool, usable by everyone.


I created it with the idea of ​​sharing everything I wanted to know when I started this path of analysis.


Everything will be FREE and public


For the moment I have created the first 5 lessons.


If you like this format, I will continue to share the entire Marsterclass.


This masterclass has already helped 100 students to implement marketing mix modeling inside their organization

Content

Marketing Analytics and Mix Modeling: Science behind Marketing Investment

Ep. 1 Marketing Mix Modeling: Science behind Marketing Investment
Ep. 2 Marketing Mix Modeling: Marketing Data Exploration
Ep. 3 Marketing Mix Modeling: Learning algorithm with Excel
Ep 4: Marketing Mix Modeling: Diminishing Returns and Adstock transformations
Ep 4.1: Marketing Mix Modeling: How to display Dim. Returns and AdSock Graphs

Screenshots

Marketing Mix Modeling with Excel - Analytics Course - Screenshot_01Marketing Mix Modeling with Excel - Analytics Course - Screenshot_02Marketing Mix Modeling with Excel - Analytics Course - Screenshot_03Marketing Mix Modeling with Excel - Analytics Course - Screenshot_04

Reviews

Sandy
April 17, 2023
why you announced one more video at the end of 6. Ep. 5 Marketing Mix Modeling: How to Create a Scenario Simulator on Excel but you do not provide this video?
Idan
April 11, 2022
Can you please explain what the rate means in real life? Where do I take this number from? what is representing? Budget scale? That was unclear though
Balaji
March 19, 2022
Hi, Thanks for the wonderful course, it helped me to understand how adstock transformation works. one question? Transf. = (adstock(t-1)*beta+spent(t))^alpha what is the model name of the formula which u have used ? As there are different models like Negative expo, log decay. Which one is this.
Liz
March 12, 2022
Really learnt a lot from this, thanks for your walk through . its very advanced for me but I definitely will be using this in my next role and who knows maybe we will pay Casandra to do it instead. :)
Federico
February 18, 2022
The course made me fully understand mmm and now I know how to tackle a project on my own, highly recommended
Cristian
February 18, 2022
Thanks Gabriele, this is the very first course I managed to find on Marketing Mix Modeling and seeing it applied and explained through the hole process using only excel is just extremely useful. The course is complete and well explained and it's definitely the starting point for anyone in the marketing industry who wants to learn about MMM and start using them.

Charts

Price

Marketing Mix Modeling with Excel - Analytics Course - Price chart

Rating

Marketing Mix Modeling with Excel - Analytics Course - Ratings chart

Enrollment distribution

Marketing Mix Modeling with Excel - Analytics Course - Distribution chart
4541968
udemy ID
2/9/2022
course created date
2/18/2022
course indexed date
Angelcrc Seven
course submited by