Marketing mix modeling in Digital Marketing - Mini Project: Build & Apply

Marketing Mix Modeling

📖 Scenario: You work as a marketing analyst for a retail company. Your manager wants to understand how different marketing channels like TV ads, online ads, and promotions affect sales. You will build a simple model to organize this information step-by-step.

🎯 Goal: Create a basic marketing mix model that lists marketing channels and their spend, sets a sales target, calculates total marketing spend, and identifies if the spend meets the target.

📋 What You'll Learn

Create a dictionary called marketing_spend with exact channels and spend values

Create a variable called sales_target with the exact value 100000

Calculate total spend by summing values in marketing_spend and store in total_spend

Create a variable called meets_target that is True if total_spend is greater than or equal to sales_target, otherwise False

💡 Why This Matters

🌍 Real World

Marketing mix modeling helps businesses understand how different marketing efforts contribute to sales, so they can spend money wisely.

💼 Career

Marketing analysts and managers use these models to plan budgets and improve campaign effectiveness.

1

Set up marketing spend data

Create a dictionary called marketing_spend with these exact entries: 'TV': 40000, 'Online': 35000, 'Promotions': 25000

Digital Marketing

# Create the marketing_spend dictionary with exact channel names and spend values
# Your code here

Hint

Use curly braces {} to create a dictionary with keys as channel names and values as spend amounts.

2

Set the sales target

Create a variable called sales_target and set it to the exact value 100000

Digital Marketing

marketing_spend = {'TV': 40000, 'Online': 35000, 'Promotions': 25000}
# Set the sales_target variable to 100000
# Your code here

Hint

Just assign the number 100000 to the variable sales_target.

3

Calculate total marketing spend

Create a variable called total_spend and set it to the sum of all values in the marketing_spend dictionary

Digital Marketing

marketing_spend = {'TV': 40000, 'Online': 35000, 'Promotions': 25000}
sales_target = 100000
# Calculate total_spend by summing all values in marketing_spend
# Your code here

Hint

Use the sum() function on marketing_spend.values() to add all spend amounts.

4

Check if marketing spend meets sales target

Create a variable called meets_target that is True if total_spend is greater than or equal to sales_target, otherwise False

Digital Marketing

marketing_spend = {'TV': 40000, 'Online': 35000, 'Promotions': 25000}
sales_target = 100000
total_spend = sum(marketing_spend.values())
# Set meets_target to True if total_spend >= sales_target, else False
# Your code here

Hint

Use a comparison operator >= to compare total_spend and sales_target.

Practice

1. What is the main purpose of Marketing Mix Modeling in digital marketing?

easy

A. To design new product features

B. To understand which marketing activities increase sales

C. To create social media content

D. To manage customer service requests

Solution

1. Step 1: Understand the goal of marketing mix modeling

   Marketing mix modeling uses data to find out which marketing efforts affect sales.

2. Step 2: Identify the correct purpose

   Among the options, only understanding which marketing activities increase sales matches this goal.

3. Final Answer:

   To understand which marketing activities increase sales -> Option B

4. Quick Check:

   Marketing mix modeling = Understand sales drivers [OK]

Hint: Focus on sales impact to find the main purpose [OK]

Common Mistakes:

• Confusing marketing mix modeling with content creation
• Thinking it manages customer service
• Assuming it designs product features

2. Which of the following is a key input used in marketing mix modeling?

easy

A. Customer support tickets

B. Website design templates

C. Advertising spend data

D. Employee work schedules

Solution

1. Step 1: Identify typical data used in marketing mix modeling

   Marketing mix modeling uses data like advertising spend, prices, and promotions to analyze sales impact.

2. Step 2: Match the correct input

   Advertising spend data is a key input, unlike support tickets, design templates, or schedules.

3. Final Answer:

   Advertising spend data -> Option C

4. Quick Check:

   Key input = Advertising spend data [OK]

Hint: Look for data related to marketing activities [OK]

Common Mistakes:

• Choosing unrelated data like support tickets
• Confusing design templates with data
• Selecting employee schedules mistakenly

3. Consider a marketing mix model that shows TV ads increase sales by 10%, online ads by 15%, and price discounts by 5%. Which activity has the highest impact on sales?

medium

A. Online ads

B. TV ads

C. Price discounts

D. All have equal impact

Solution

1. Step 1: Compare the percentage impacts given

   TV ads increase sales by 10%, online ads by 15%, and price discounts by 5%.

2. Step 2: Identify the highest percentage

   15% (online ads) is greater than 10% and 5%, so online ads have the highest impact.

3. Final Answer:

   Online ads -> Option A

4. Quick Check:

   Highest impact = Online ads (15%) [OK]

Hint: Pick the largest percentage impact value [OK]

Common Mistakes:

• Choosing TV ads because they are traditional
• Assuming price discounts have biggest effect
• Thinking all impacts are equal

4. A marketing mix model shows negative sales impact for a certain promotion. What could be a likely reason?

medium

A. The model incorrectly included unrelated data

B. The promotion was not run during the period analyzed

C. The promotion was too expensive and reduced profit

D. The promotion caused customers to buy more

Solution

1. Step 1: Understand negative impact in modeling

   A negative sales impact means the model found the promotion reduced sales or had no positive effect.

2. Step 2: Identify common modeling errors

   Including unrelated or incorrect data can cause wrong negative results in the model.

3. Final Answer:

   The model incorrectly included unrelated data -> Option A

4. Quick Check:

   Negative impact often means data or model error [OK]

Hint: Check for data errors if impact is negative [OK]

Common Mistakes:

• Assuming negative impact means promotion was expensive
• Thinking promotion was not run without checking data
• Believing negative impact means more sales

5. A company wants to allocate a $100,000 marketing budget across TV ads, online ads, and promotions. Marketing mix modeling shows online ads have twice the sales impact per dollar compared to TV ads, and promotions have half the impact of TV ads. How should the company prioritize spending?

hard

A. Spend all on TV ads only

B. Spend equally on all three channels

C. Spend most on promotions, less on online ads, least on TV ads

D. Spend most on online ads, less on TV ads, least on promotions

Solution

1. Step 1: Understand relative impact per dollar

   Online ads impact = 2x TV ads impact; Promotions impact = 0.5x TV ads impact.

2. Step 2: Prioritize budget based on impact

   To maximize sales, allocate more budget to online ads (highest impact), then TV ads, then promotions (lowest impact).

3. Final Answer:

   Spend most on online ads, less on TV ads, least on promotions -> Option D

4. Quick Check:

   Highest impact gets most budget [OK]

Hint: Allocate budget proportional to impact strength [OK]

Common Mistakes:

• Spending equally without considering impact
• Ignoring promotions impact and overspending there
• Putting all budget into TV ads only