Analytics · Marketing · Advertising · Spend Effectiveness
Executive Summary

Executive Summary

Key findings from the multi-channel advertising regression

n_observations
200
r_squared
0.9149
adj_r_squared
0.9136
rmse
1.49
f_statistic
702.1
p_value_model
0
The multi-channel advertising model explains 91.5% of sales variance (R² = 0.9149, Adjusted R² = 0.9136), with an overall fit that is statistically significant (F = 702.1, p = 0). The channel with the largest standardized effect on sales is tv_spend, meaning a one-standard-deviation increase in that channel's budget produces the greatest lift relative to its own variability. Prediction error is 1.49 units of sales on average, giving decision-makers a reliable baseline for budget allocation.
Interpretation

The multi-channel advertising model explains 91.5% of sales variance (R² = 0.9149, Adjusted R² = 0.9136), with an overall fit that is statistically significant (F = 702.1, p = 0). The channel with the largest standardized effect on sales is tv_spend, meaning a one-standard-deviation increase in that channel's budget produces the greatest lift relative to its own variability. Prediction error is 1.49 units of sales on average, giving decision-makers a reliable baseline for budget allocation.

Visualization

Spend Distribution by Channel

Box plot of spend values for each advertising channel

Interpretation

The box plot shows the spend distribution for each advertising channel across 200 budget periods. Medians per channel: tv_spend (med= 164.9 ); radio_spend (med= 22.4 ); newspaper_spend (med= 52.8 ). Channels with wider interquartile ranges have more variable budgets, which gives the regression more statistical power to estimate their effect. Outlier periods (extreme spends) can exert undue influence on coefficients and should be reviewed before finalising budget recommendations.

Visualization

Spend & Sales Correlation Matrix

Pairwise correlations between advertising channels and sales

Interpretation

The heatmap shows pairwise Pearson correlations between all spend channels and sales. The channel most strongly correlated with sales is tv_spend (r = 0.757). Correlations between spend channels reveal multicollinearity risk: values above 0.7 indicate that two channels move together in the budget, which can inflate standard errors and make individual coefficient estimates less reliable.

Visualization

Channel Effect Sizes (Standardized Coefficients)

Standardized regression coefficients by advertising channel

Interpretation

Standardized coefficients (beta weights) measure each channel's effect in standard-deviation units, making them directly comparable regardless of how dollars are scaled. The dominant channel by standardized effect is tv_spend (β = 0.742). Channels with beta weights near zero contribute negligible independent lift to sales after accounting for the other channels in the model.

Data Table

Regression Coefficients Table

Coefficients, standard errors, and confidence intervals per channel

channelcoefficientstd_errort_valuep_valueci_lowerci_upper
tv_spend0.04390.001235.3900.04140.0463
radio_spend0.20510.007327.9500.19070.2196
newspaper_spend0.00550.00321.7210.0868-0.00080.0118
Interpretation

The regression table shows raw coefficients (sales change per unit of spend), standard errors, t-statistics, p-values, and 95% confidence intervals for each channel. 2 of 3 channels are statistically significant (p < 0.05). The largest raw effect is radio_spend (coefficient = 0.2051), meaning each additional unit of radio_spend spend is associated with 0.2051 additional sales units, holding other channels constant.

Visualization

Actual vs Predicted Sales

Scatter of observed vs model-predicted sales

Interpretation

Each point compares the model's predicted sales to the actual observed sales for one budget period. Points on the 45-degree diagonal indicate perfect predictions; scatter around the line represents unexplained variation. The model achieves R² = 91.5%, explaining 91.5% of total sales variance, with a root mean squared error of 1.49 units. Systematic curves or funnels in this chart would suggest the linear model needs transformation or additional variables.

Visualization

Residuals vs Fitted Values

Diagnostic check for OLS assumption validity

Interpretation

Residuals (actual minus predicted) plotted against fitted values check whether the OLS assumptions hold. A random horizontal band around zero indicates valid homoscedasticity (constant variance). Mean residual = 0 (should be near 0); maximum absolute residual = 4.43. A funnel shape (widening variance at higher fitted values) would suggest log-transforming the sales outcome, while a curve would indicate a non-linear relationship that a polynomial or interaction term might address.

Visualization

Per-Channel Sales ROI Estimate

Regression coefficients as sales-per-unit-spend ranked by channel

Interpretation

ROI estimates are the raw regression coefficients: sales units generated per additional unit of spend in each channel, holding all other channels constant. The highest-ROI channel is radio_spend with an estimated 0.2051 sales units per unit of spend. Note that these estimates assume the current spend mix and may not hold at dramatically different budget levels due to diminishing marginal returns — channels ranking near zero or negative are candidates for budget reallocation.

Your data has more stories to tell. Run any analysis on your own data — 60+ validated R modules, interactive reports, AI insights, and PDF export. 2,000 free credits on signup.
Try Free — No Signup Sign Up Free

Report an Issue

Tell us what's wrong. You'll get a free re-run of this analysis so you can try again with different parameters. If the re-run still doesn't meet your expectations, we'll refund your credits.

Want to run this analysis on your own data? Upload CSV — Free Analysis See Pricing