Tutorialspoint

Mid-Year Savings Flat 10% OFF, Use Code: MID10

Marketing Mix modeling with Excel - Science behind Advertising Investments

person icon Gabriele - Cassandra MMM

4.1

Marketing Mix modeling with Excel - Science behind Advertising Investments

A better way of Marketing analytics for a cookie-less world

updated on icon Updated on Jul, 2024

language icon Language - English

person icon Gabriele - Cassandra MMM

English [CC]

category icon Business,Data Science,Excel

Lectures -7

Duration -1.5 hours

4.1

price-loader

30-days Money-Back Guarantee

Training 5 or more people ?

Get your team access to 10000+ top Tutorials Point courses anytime, anywhere.

Course 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:

  1. Ep 1: What are MMMs and how to exploit them to generate business growth
  2. Ep2: How to explore marketing data and deduce analysis hypotheses
  3. Ep3: How to use a learning algorithm on your data with EXCEL
  4. Ep4: How to transform media into Diminishing Returns and AdStocks EXCEL
  5. Ep 4.1 How to show diminishing returns and adstocks graphs
  6. Ep 5: How to create a predictive simulator on excel
  7. 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.

For the moment I have created the first 6 lessons.

If you like this format, ask me what you want to know more and I'll add new content over time 

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

Goals

  • Learn what Marketing Mix Modeling (MMM) are and how they can help your organization grow
  • 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?
  • Scientific budget allocation: how to create a model that suggests to you how to allocate budget to decrease CPO

Prerequisites

  • In this course you will need a basic understanding of Excel or Google Sheet and have worked in marketing so you can understand marketing data.
Marketing Mix modeling with Excel - Science behind Advertising Investments

Curriculum

Check out the detailed breakdown of what’s inside the course

Marketing Mix Modeling Using Excel: The Science Behind Advertising Investments
7 Lectures
  • play icon Ep. 1 Marketing Mix Modeling: Science behind Marketing Investment 26:02 26:02
  • play icon Ep. 2 Marketing Mix Modeling: Marketing Data Exploration 09:48 09:48
  • play icon Ep. 3 Marketing Mix Modeling: Learning algorithm with Excel 11:13 11:13
  • play icon Ep 4: Marketing Mix Modeling: Diminishing Returns and Adstock transformations 17:16 17:16
  • play icon Ep 4.1: Marketing Mix Modeling: How to display Dim. Returns and AdSock Graphs 11:03 11:03
  • play icon Ep. 5 Marketing Mix Modeling: How to Create a Scenario Simulator on Excel 08:23 08:23
  • play icon Ep. 6 - Marketing Mix modeling: How to Minimize Cost Per Order using Excel Solver 07:42 07:42

Instructor Details

Gabriele - Cassandra MMM

Gabriele - Cassandra MMM


Course Certificate

Use your certificate to make a career change or to advance in your current career.

sample Tutorialspoint certificate

Our students work
with the Best

Related Video Courses

View More

Annual Membership

Become a valued member of Tutorials Point and enjoy unlimited access to our vast library of top-rated Video Courses

Subscribe now
Annual Membership

Online Certifications

Master prominent technologies at full length and become a valued certified professional.

Explore Now
Online Certifications

Talk to us

1800-202-0515