Your CMO just asked which advertising channel drives the most sales. TV spend and sales both increased this quarter, correlation 0.78. Looks like TV is the winner, right? Not so fast. Radio spend also increased. Newspaper spend increased. Even your organic social activity ramped up. Which channel actually caused the lift?

This is the attribution problem every marketer faces. Simple correlations mislead because multiple channels move together. What you need is multiple linear regression: a statistical method that isolates each channel's independent contribution by controlling for all other channels simultaneously. It answers the critical question: If I increase TV spend by $1,000 while holding Radio and Newspaper constant, how much do sales increase?

Before we draw conclusions from correlation, let's check the experimental design. Or in this case, the observational design, because most marketing data comes from campaigns you already ran, not controlled experiments. That means we need regression to tease apart confounded effects.

Worked Example: A Made-Up Media Mix

Question: In made-up data, how does sales change as TV, Radio, and Newspaper spend changes?

Inputs: Simulated data, seed 41. The script makes 120 rows. Spend and sales use $1,000 units. Noise is added to sales. The names TV, Radio and Newspaper mirror a well-known textbook set, but this data is simulated and is not that set. The script builds in a sales formula with an intercept of 20 and slopes of 0.45 for TV, 1.10 for Radio and 0.05 for Newspaper, plus noise with a standard deviation of 8.

Method: Use ordinary least squares, a way to find the best fit line, with an intercept, or start value. A slope is the sales change as one spend value changes, while the other spend values stay fixed.

import numpy as np

seed = 41
rng = np.random.default_rng(seed)
rows = 120
# Spend and sales are in thousands of dollars.
tv = rng.normal(100, 25, rows)
radio = rng.normal(40, 12, rows)
news = rng.normal(30, 10, rows)
noise = rng.normal(0, 8, rows)
sales = 20 + 0.45 * tv + 1.10 * radio + 0.05 * news + noise
X = np.column_stack([np.ones(rows), tv, radio, news])
coef, _, _, _ = np.linalg.lstsq(X, sales, rcond=None)
pred = X @ coef
r2 = 1 - np.sum((sales - pred) ** 2) / np.sum((sales - sales.mean()) ** 2)

print(f"Simulated data, seed {seed}")
print(f"Rows: {rows}")
print("Inputs: TV, Radio, Newspaper spend; "
      "each spend and sales are in $1,000 units")
print("Method: ordinary least squares with an intercept")
print(f"Estimated intercept: {coef[0]:.3f}")
print(f"Estimated TV slope: {coef[1]:.3f}")
print(f"Estimated Radio slope: {coef[2]:.3f}")
print(f"Estimated Newspaper slope: {coef[3]:.3f}")
print(f"In-sample R-squared: {r2:.3f}")

Printed output (copied from a run with python3 -I):

Simulated data, seed 41
Rows: 120
Inputs: TV, Radio, Newspaper spend; each spend and sales are in $1,000 units
Method: ordinary least squares with an intercept
Estimated intercept: 20.538
Estimated TV slope: 0.420
Estimated Radio slope: 1.196
Estimated Newspaper slope: 0.008
In-sample R-squared: 0.845

Result: The TV slope is 0.420 (built in: 0.45). Both measures use $1,000 units, so this means a $420 sales link per $1,000 of TV spend, with the other spend values fixed. The Radio slope is 1.196 (built in: 1.10), or $1,196 in sales per $1,000 of Radio spend. The Newspaper slope is 0.008 (built in: 0.05), or $8 in sales per $1,000 of Newspaper spend. The Newspaper effect was built in but is small, and this run shows no interval, so it cannot separate that slope from zero. That is low power, not no effect. The fit score on these rows, called R-squared, is 0.845.

Limit: These data are made up. The slopes do not show what ads cause in a real market. The fit score uses the rows the model saw, so it is in-sample.

The Attribution Problem: Why Single-Channel Analysis Fails

Imagine you're analyzing 200 weeks of advertising data. Each week you spent money on TV, Radio, and Newspaper ads. Sales varied from $1,600 to $27,000 per week. Your first instinct: calculate correlation between each channel and sales.

To see which of your own marketing channels drive sales, try the free media mix model tool.

Here's what you find:

  • TV spend correlates with sales at r = 0.78 (strong positive)
  • Radio spend correlates with sales at r = 0.58 (moderate positive)
  • Newspaper spend correlates with sales at r = 0.23 (weak positive)

The naive conclusion: TV is the winner, invest everything there. But correlation measures association, not causation. TV spend might correlate with sales because you tend to increase all channels simultaneously during high-demand seasons. Or because TV spend tracks with Radio spend (if you run integrated campaigns). Or because both TV and sales are driven by a third variable, say, product quality improvements over time.

The fundamental issue: when multiple predictors correlate with both the outcome and each other, simple correlation conflates direct effects with confounding. You can't isolate TV's true contribution without controlling for Radio and Newspaper.

Did You Randomize? The Gold Standard Question

If you could run a true experiment, you'd randomly assign different TV budgets to different markets while holding Radio and Newspaper constant. Then compare sales. Randomization breaks the correlation between TV and other channels, isolating causation.

But most marketing data is observational. You spent money, tracked results, and now want to learn from it. Multiple regression is your next-best tool. It statistically "controls" for confounders by estimating each channel's effect while mathematically holding others constant. Not as strong as randomization, but far better than raw correlation.

How Multiple Regression Isolates Channel Effects

Multiple linear regression fits this equation to your data:

Sales = β₀ + β₁(TV) + β₂(Radio) + β₃(Newspaper) + ε

Where:

  • β₀ (intercept): Expected sales when all channels spend $0
  • β₁ (TV coefficient): Sales change per $1,000 increase in TV, holding Radio and Newspaper constant
  • β₂ (Radio coefficient): Sales change per $1,000 increase in Radio, holding TV and Newspaper constant
  • β₃ (Newspaper coefficient): Sales change per $1,000 increase in Newspaper, holding TV and Radio constant
  • ε (residual): Unexplained variation

The "holding constant" clause is the key. Regression finds the unique contribution of each channel after accounting for the others. The TV coefficient is the TV spend slope when Radio and Newspaper spend stay fixed. It is not a partial correlation.

Here's the practical translation: β₁ is a TV spend and sales link in weeks where Radio and Newspaper budgets stay fixed. It does not prove a sales lift. A cause claim needs good grounds or a random test.

When to Use This Analysis: The Decision Checklist

Use advertising spend effectiveness regression when:

  1. You have historical spend data across multiple channels
  2. You want to isolate each channel's independent contribution rather than just overall correlation
  3. Your channels vary independently enough to separate their effects (check multicollinearity: look at the correlation between predictors)
  4. You're making budget allocation decisions and need to know ROI per channel
  5. You haven't run randomized experiments and need to learn from observational campaign data

Don't use this analysis when:

  • You have very few observations (the confidence intervals will be wide)
  • Your channels are perfectly collinear. You always spend the same proportion on TV and Radio (regression can't separate their effects)
  • You expect significant interaction effects (TV amplifies Radio's effectiveness), standard regression assumes additive effects
  • You have time-series data with strong autocorrelation or seasonality (use time-series regression or ARIMA instead)

Reading the Report: Card by Card

Let's walk through a sample report of 200 weeks of advertising data. It is a separate example from the made-up script above, so its numbers differ. Each section below shows a card from the regression report, with the insight it reveals and how to interpret the numbers.

Spend Distribution by Channel

Spend Distribution by Channel
Spend Distribution by Channel : Preview from case study

Before running regression, inspect the distribution of your predictors. This box plot shows TV spend ranges from near $0 to $300K, with a median around $150K. Radio spans $0 to $50K, median ~$25K. Newspaper runs $0 to $115K, median ~$30K.

What to look for: Outliers and skewness. If you see extreme outliers (e.g., one week with 10x normal spend), they can distort regression coefficients. Consider whether those weeks represent true variation you want to model or data errors you should exclude. Heavy skewness may warrant log-transforming spend variables, though linear models often handle moderate skewness well.

In this dataset, distributions are reasonably symmetric with some high-spend outliers. That's fine. Those outlier weeks provide valuable information about high-budget effectiveness. If you had 95% of weeks at $100K TV spend and one week at $500K, that single observation would have disproportionate leverage. Here the variation is spread out enough to trust the estimates.

Practical check: Confirm you have sufficient variation in each channel. If TV spend was constant at $150K every week, the regression can't estimate its effect. You need variation to measure impact. This dataset passes: each channel varies substantially across weeks.

Spend & Sales Correlation Matrix

Spend & Sales Correlation Matrix
Spend & Sales Correlation Matrix : Preview from case study

This heatmap reveals two critical patterns: how each channel correlates with sales (top row) and how channels correlate with each other (off-diagonal cells).

Correlation with sales: TV shows the strongest correlation with sales (0.78), followed by Radio (0.58) and Newspaper (0.23). As discussed earlier, these are crude associations. They don't isolate each channel's independent effect. But they set a baseline: if regression coefficients diverge dramatically from these correlations, investigate why.

Multicollinearity check: The off-diagonal cells show how the channels correlate with each other. Channels that vary independently of one another are easier for regression to separate.

Contrast with a problematic scenario: imagine you always spend $2 on Radio for every $10 on TV. Then regression struggles to distinguish their effects. It can estimate the combined TV+Radio impact, but not each individually. The coefficients would have huge standard errors and flip signs based on small data changes.

What if you see high multicollinearity? Three options: (1) Collect more data with greater independent variation. (2) Combine correlated channels into a single "integrated campaign" variable. (3) Use regularization methods (Ridge or Lasso regression) that stabilize coefficients when predictors correlate. For most marketing analyses, option 1 is best: run campaigns where channels vary independently.

Channel Effect Sizes (Standardized Coefficients)

Channel Effect Sizes (Standardized Coefficients)
Channel Effect Sizes (Standardized Coefficients) : Preview from case study

Standardized coefficients put all channels on the same scale, answering: Which channel has the largest effect per unit of its own variation? Here, TV's standardized coefficient is 0.18, Radio is 0.47, Newspaper is near 0.00.

Interpretation: In this report, a one-standard-deviation increase in Radio spend goes with a 0.47 standard-deviation increase in sales, and a one-standard-deviation increase in TV spend goes with a 0.18 standard-deviation increase. Newspaper's standardized coefficient is near zero, which is not proof that it has no effect.

Why does Radio show a larger standardized coefficient than TV despite TV having stronger raw correlation? Because Radio's effect is concentrated: each dollar of Radio drives more sales than each dollar of TV. But you typically spend more on TV, so TV's total impact (unstandardized coefficient × average spend) might still be larger. Standardized coefficients compare per unit of variation, not per dollar.

When to use standardized vs. raw coefficients:

  • Standardized: Comparing relative importance when channels use different units or scales. Useful for executive summary: "Radio has the largest effect per SD of spend."
  • Raw (unstandardized): Budget planning. You need dollar-in, dollar-out estimates: "Spend $1,000 more on Radio, and the model links about $189 more in sales."

Both views matter. Standardized tells you which lever has the most impact per unit of variation. Raw tells you the dollar link between spend and sales.

Statistical Power and Sample Size

Few rows give wide confidence intervals. A small effect can then go unseen, which is low power, not no effect. The made-up example above shows this: it built in a small Newspaper slope of 0.05, and the run's estimate of 0.008 could not be separated from zero.

What's your sample size? If you are evaluating a new channel with a small expected effect, collect more data before trusting the coefficient estimates.

Regression Coefficients Table

Regression Coefficients Table
Regression Coefficients Table : Preview from case study

This is the core output: raw regression coefficients with standard errors, t-statistics, p-values, and confidence intervals. Here's what each column reveals:

Coefficient: The estimated sales change per $1,000 increase in spend, controlling for other channels.

  • Intercept (2.939): Expected sales when all channels spend $0. In practice, this is extrapolation, you never actually spend zero on all channels, so focus on the slope coefficients.
  • TV (0.047): The TV model value links spend and sales, holding Radio and Newspaper constant. It does not show that TV spend drove the change.
  • Radio (0.189): The Radio model value links spend and sales, controlling for TV and Newspaper. It does not show that Radio spend drove the change. Do not call it ROI; ROI needs a profit measure and a method.
  • Newspaper (−0.001): A near-zero coefficient. A p-value of 0.860 means this report cannot separate it from zero, which does not rule out a small effect.

Standard Error: Uncertainty in the coefficient estimate. TV's SE is 0.001, Radio's is 0.009, Newspaper's is 0.006. Smaller SE means more precise estimate. SE depends on sample size and residual variance: more data and less noise yield tighter estimates.

t-statistic and p-value: Tests the null hypothesis that the true coefficient is zero.

  • TV: t = 32.8, p < 0.001. Reject the null. TV's effect is highly significant.
  • Radio: t = 21.9, p < 0.001. Radio's effect is highly significant.
  • Newspaper: t = −0.18, p = 0.860. Fail to reject the null. The data cannot separate Newspaper from zero.

Use the p-value to judge evidence against a zero coefficient. Use the value and its range to judge size and doubt. TV's coefficient is small (0.047) with a small p-value. Newspaper's coefficient is tiny and its p-value is large, so this report cannot separate it from zero.

95% Confidence Interval: The range within which the true coefficient likely falls. TV's CI is [0.044, 0.049], tight bounds, high precision. Radio's CI is [0.172, 0.206]. Newspaper's CI is [−0.013, 0.011], which includes zero.

Wide CIs indicate low precision, often due to small sample size or high multicollinearity. Narrow CIs (like TV and Radio here) give you confidence in the point estimate.

Regression Diagnostics: Did You Check the Assumptions?

Linear regression assumes:

  1. Linearity: Relationship between spend and sales is linear (not exponential or logarithmic)
  2. Independence: Observations are independent (no autocorrelation in time-series data)
  3. Homoscedasticity: Residual variance is constant across spend levels (not fanning out)
  4. Normality: Residuals are approximately normally distributed

Check residual plots. If residuals show patterns (curved trends, increasing variance at high spend), the model may be misspecified. Consider transformations (log spend, log sales) or polynomial terms. For time-series marketing data, test for autocorrelation (Durbin-Watson statistic) and add lagged variables if needed.

Actual vs Predicted Sales

Actual vs Predicted Sales
Actual vs Predicted Sales : Preview from case study

This scatter plot shows how well the regression model predicts sales. Each point represents one week: x-axis is actual sales, y-axis is predicted sales from the fitted model. The diagonal line is the ideal, perfect predictions fall exactly on it.

What you want to see: Points tightly clustered around the 45-degree line across the full range of sales. Here, R² is 0.897 on the rows the model saw, meaning 89.7% of the variation in sales is accounted for by the three channels in-sample. Predictions are accurate from low-sales weeks (~$2K) to high-sales weeks (~$27K).

Red flags to watch for:

  • Systematic underprediction at high spend: Points above the line at the right edge. Suggests diminishing returns, the linear model overestimates high-spend effectiveness. Consider adding quadratic terms (TV²) to model saturation.
  • Systematic overprediction at low spend: Points below the line at the left edge. Suggests a threshold effect: channels don't work until spend exceeds a minimum. Consider piecewise regression or excluding very low-spend weeks.
  • Increasing scatter at high spend: Heteroscedasticity, variance grows with spend level. Use robust standard errors or weighted least squares.

This plot shows none of those issues: residuals are evenly distributed around the line at all spend levels. A straight line looks adequate for this report.

Practical implication: Predictions are most believable inside your typical spend range. If you're considering a massive budget increase (e.g., 5x your historical max), extrapolation risk is high. The linear relationship may not hold.

Turning Regression Results Into Budget Decisions

You've read the report. Now what? Here's how to translate coefficients into action:

Step 1: Identify significant channels. TV and Radio have p < 0.001, so the data points to a link with sales for both. Newspaper has p = 0.860 and a near-zero coefficient: test it in a controlled experiment before increasing or cutting spend.

Step 2: Compare the dollar links per channel. These are model values, not ROI. ROI needs a profit measure and a method.

  • TV: 0.047 in sales per $1 of spend (model value)
  • Radio: 0.189 in sales per $1 of spend (model value)
  • Newspaper: near 0 in sales per $1 of spend (model value)

Radio's model value is about four times TV's here. Does that mean shift all budget to Radio? Not necessarily. Consider three factors:

  1. Saturation: Radio's high value may reflect that you're currently underspending there. As you increase Radio spend, the link may weaken (diminishing returns). The linear model doesn't capture this: consider testing higher Radio budgets in a controlled experiment.
  2. Reach: TV may have larger total reach even if the per-dollar link is lower. If your goal is brand awareness, reach matters. If your goal is direct sales, the per-dollar link matters more.
  3. Complementarity: TV and Radio may interact, TV builds awareness, Radio drives conversion. The regression assumes additive effects. If you suspect synergies, add interaction terms (TV × Radio) to the model.

Step 3: Allocate budget at the margin. The regression tells you which channel to increase next. If you have an extra $10K to spend, the model points to Radio. Once Radio saturates or reaches competitive parity, TV becomes the next option. This is marginal analysis: allocate based on where the next dollar is linked with the most sales, then test it.

Step 4: Test your assumptions. Regression on observational data gives you correlations, not proven causation. Before reallocating millions, run a controlled experiment: randomize some markets to high Radio spend, others to current levels. Measure the difference. If the experimental lift is close to the regression coefficient, that supports the reading. If not, investigate confounders the regression missed.

Common Pitfalls and How to Avoid Them

Pitfall 1: Confusing correlation with causation. Just because the TV coefficient is 0.047 doesn't mean TV causes sales. It means TV and sales are associated after controlling for Radio and Newspaper. If you spent more on TV during holiday seasons (when sales are naturally high anyway), the coefficient conflates TV's true effect with seasonal demand. Solution: Add control variables (month, seasonality indicators) or run randomized tests.

Pitfall 2: Ignoring time lags. TV advertising might drive sales with a 2-week delay. The regression assumes spend and sales occur in the same week. If effects lag, coefficients are biased toward zero. Solution: Add lagged predictors (TV spend from 1 week ago, 2 weeks ago) or use distributed lag models.

Pitfall 3: Overfitting with too many predictors. If you add 20 channels with only 100 observations, the model will fit noise. Adjusted R² penalizes extra predictors: use it instead of raw R². Solution: Use cross-validation to test out-of-sample prediction accuracy.

Pitfall 4: Extrapolating beyond your data range. The model predicts sales for spend levels you've observed. If your max historical TV spend is $300K and you plug in $1M, the prediction is pure guesswork. Diminishing returns likely kick in at high spend. Solution: Stay within historical ranges or fit non-linear models (polynomial, log) that capture saturation.

Pitfall 5: Assuming linearity. Real advertising often shows S-curves: no effect until a threshold, then rapid growth, then saturation. Linear regression misses this. Solution: Plot spend vs. sales to eyeball the functional form. If non-linear, use log transformations, polynomial terms, or specialized media mix models (adstock models with decay and saturation).

Pitfall 6: Ignoring interaction effects. TV might amplify Radio's effectiveness (synergy) or compete with it (cannibalization). Standard regression assumes effects add independently. Solution: Add interaction terms (TV × Radio) and test if they're significant. If the interaction coefficient is positive and significant, the channels synergize.

Advanced Extensions: When to Go Beyond Basic Regression

The three-channel linear regression shown here is a starting point. Real media mix modeling often requires additional sophistication:

Adstock models: Advertising has carryover effects. This week's TV ad influences next week's sales. Adstock models apply exponential decay to capture lagged impact. Instead of just TV spend this week, you model "effective TV exposure" = current spend + 0.5 × last week's spend + 0.25 × two weeks ago, etc. This better reflects how advertising builds and decays over time.

Saturation curves: Spend effectiveness declines at high budgets. A common form is diminishing returns: Sales = β × log(Spend). Or use Hill curves (S-shaped) to model both thresholds and saturation. These non-linear models require non-linear regression or transformation, but they capture reality better than straight lines.

Bayesian regression: Incorporate prior beliefs about channel effectiveness (from industry benchmarks or past campaigns) and update them with your data. Bayesian methods also quantify uncertainty more fully. You get probability distributions over coefficients, not just point estimates. Useful when sample size is small and you want to blend data with prior knowledge.

Hierarchical models: If you have data across multiple markets or products, fit a hierarchical model that estimates market-specific coefficients while borrowing strength from the overall average. This prevents overfitting to small markets and improves estimates for all.

Causal inference methods: If you can't randomize, use quasi-experimental designs like difference-in-differences (compare markets that increased TV to those that didn't) or regression discontinuity (if spend thresholds create natural experiments). These methods strengthen causal claims from observational data.

When should you use these advanced methods? When basic regression diagnostics fail (non-linear residual patterns, autocorrelation), when you have strong prior knowledge to incorporate, or when budgets are large enough that incremental accuracy justifies the modeling complexity.

Checking Your Model: Holdout Testing

How do you know the regression model will work on new data? Fit it on a training set (say, first 150 weeks) and test predictions on a holdout set (last 50 weeks). For example, if training R² is high but holdout R² drops a lot, you've overfit.

For the sample report, the full-sample R² is 0.897. In a holdout test, expect the holdout R² to be lower. If it's much lower, simplify the model: remove predictors the data cannot separate from zero or reduce interaction terms.

Cross-validation is even better: split data into 5 folds, train on 4, test on 1, rotate through all folds. Average the test-set R² across folds for a robust estimate of out-of-sample performance. This is a common way to test out-of-sample accuracy when you can't run new experiments.

Integrating Regression Into Your Marketing Workflow

One-time regression analysis is useful. Continuous regression-driven optimization is powerful. Here's how to build it into your workflow:

Monthly refresh: Re-run the regression each month as new campaign data arrives. Track how coefficients change. If TV's coefficient drops, you may be saturating the channel or facing increased competition. Adjust budgets accordingly.

Automated alerts: Set thresholds, if any channel's p-value exceeds 0.05 (loses significance), flag it for review. If a previously non-significant channel becomes significant, test increasing its budget.

Budget optimizer: Feed regression coefficients into an optimization algorithm that maximizes predicted sales subject to your total budget constraint. This automates the allocation step: "Given a total budget and the model values for TV, Radio and Newspaper, how should I allocate?" The optimizer will favor the channel with the larger model value until diminishing returns kick in, then shift to the next. Treat its output as a hypothesis to test.

A/B testing integration: When regression suggests a channel with a strong link to sales, check it with a controlled test. Randomize some markets to high spend, measure the lift, compare to regression prediction. If they align, that supports the reading. If they diverge, investigate what the regression missed (interaction effects, unobserved confounders).

Attribution modeling: Combine regression (for overall channel effectiveness) with user-level attribution (for individual customer journeys). Regression tells you TV spend is linked with 0.047 in sales per dollar on average. Attribution tells you which customers saw TV ads before converting. Together, they paint a complete picture.

Correlation Is Interesting. Causation Requires an Experiment.

Remember: regression on observational data estimates associations, not proven causal effects. The coefficients are "causal" only to the extent that you've controlled for all relevant confounders. If there's an omitted variable (e.g., competitor pricing, product quality changes) that correlates with both spend and sales, coefficients are biased.

The strongest evidence comes from randomized experiments where you control spend levels. Regression on observational data is the next-best tool: far superior to raw correlation, but not a substitute for true experiments. Use it to generate hypotheses and prioritize which channels to test experimentally.

What This Analysis Does NOT Tell You

Be clear about the limits:

It doesn't tell you why a channel works. Radio's coefficient is 0.189, but is that because Radio ads are more persuasive? Because Radio reaches your target demographic better? Because Radio reminds people who saw TV ads? Regression is a black box, inputs and outputs, no mechanism. To understand why, run qualitative research or controlled experiments that isolate causal pathways.

It doesn't tell you which creative works. The analysis averages across all TV ads you ran. Some may do better, others worse, but you see only the average. To optimize creative, you need ad-level data and A/B tests of different messages, formats, and calls-to-action.

It doesn't predict what happens if you change strategy. The coefficients reflect historical spend patterns. If you suddenly shift from brand-building TV to direct-response TV, ROI may change. Regression assumes the future resembles the past. If your strategy or market shifts, re-estimate.

It doesn't account for external factors. Competitor actions, economic conditions, seasonality, if these aren't in the model, they're confounded with your channels. Add control variables (GDP, competitor spend, holiday indicators) to isolate your advertising effects from external shocks.

It doesn't guarantee profitability. A sales link per dollar is not a profit measure. Combine the regression with your margins and business economics to determine which channels are truly profitable.

Your turn

Bring your own data and the question you actually need answered.

MCP AnalyticsData science by email Send us your data and your question, and we will reply. ds@mcpanalytics.ai

FAQs: Advertising Spend Effectiveness Regression

What is the difference between correlation and causation in advertising analysis?

Correlation shows two variables move together, such as TV spend and sales both rising. Causation means one drives the other. Multiple regression links each channel with sales while the other channels stay fixed, but this alone does not show cause. A cause claim needs good grounds or a randomized test where you control who sees which ads.

How do I know if my regression coefficients are statistically significant?

Use the p-value to judge evidence against a zero coefficient. Use the coefficient and its confidence interval to judge size and doubt: an interval that includes zero means the data cannot separate that channel from zero. In the report walk-through below, TV and Radio have p-values under 0.001 and Newspaper has p = 0.860. A large p-value is not proof of no effect, especially with few rows.

What does multicollinearity mean and why does it matter?

Multicollinearity means your advertising channels are correlated with each other, so when TV spend goes up, Radio spend also tends to increase. This makes it harder to separate each channel's effect. Strong multicollinearity inflates standard errors and makes coefficients unstable. Check the correlation matrix between channels and look at how much the coefficients move when you add or drop a channel.

How large a sample do I need for media mix modeling?

There is no single number. With few rows, the confidence intervals are wide and a real effect can go unseen. That is low power, not no effect. In the made-up example above, 120 rows were enough to recover the large TV and Radio slopes but could not separate the small Newspaper slope from zero. If you test more channels or expect smaller effects, collect more data or run a longer campaign.

When should I use standardized coefficients instead of raw coefficients?

Use standardized coefficients to compare channels that use different scales. They put everything in standard deviation units. Use raw coefficients to read dollars in and dollars out: in the made-up example above, the Radio slope of 1.196 links each extra $1,000 of Radio spend with about $1,196 of sales, with the other channels fixed. That link is not proof that the spend caused the sales.

Next Steps: From Analysis to Action

You've read the regression report. The coefficients point to Radio as the channel with the largest link to sales, TV as moderate, Newspaper as near zero. What now?

1. Check with a controlled experiment. Randomize some markets to higher Radio spend and others to current levels. Measure the sales difference. If the experimental result is close to the regression coefficient, that supports the reading.

2. Model non-linearity. The regression assumes a constant link: each Radio dollar is linked with 0.189 in sales regardless of total spend. Reality: the link likely weakens at high spend (saturation). Fit a log or polynomial model to capture diminishing returns.

3. Add control variables. Include seasonality (month dummies), competitor actions (if you have data), economic indicators (consumer confidence). This isolates advertising effects from external factors and improves coefficient accuracy.

4. Test interactions. Does TV amplify Radio's effectiveness? Add a TV × Radio interaction term. If significant and positive, the channels synergize, coordinate campaigns for maximum impact.

5. Optimize budget allocation. Use the coefficients to simulate different budget scenarios. Build a simple optimizer that maximizes predicted sales subject to your total budget. Run it monthly as coefficients update.

6. Measure long-term effects. Current-week spend may drive next-quarter sales (lagged effects). Add lagged predictors to capture long-term ROI. Some channels (brand-building TV) show delayed impact that immediate regression misses.

Before you draw conclusions, let's check the experimental design. Or in this case, let's run the experiment to check the observational regression. That's the difference between correlation and causation.

Related Articles