Blog · Board and management reporting
Media mix analysis compares spending and recorded outcomes across advertising channels. Build a channel summary from campaign and finance exports, check the totals and keep attribution separate from evidence of incremental impact.
Media mix analysis compares the share of advertising spend allocated to each channel with its recorded leads, reach and assigned revenue. Start from campaign exports and finance totals, apply consistent definitions, and compare channel summaries. The resulting table shows where money and recorded outcomes sit; it does not prove what additional spending would cause.
This is a review of media-channel allocation. It is narrower than marketing mix analysis covering product, price, place and promotion, and it does not perform causal marketing mix modeling. The practical question is: do the spending shares and recorded results warrant a closer review?
Choose a period, currency, spending boundary and revenue definition. A fictional US business below reviews July 2026 in USD. Media spend includes charges after credits and excludes agency fees. Leads are qualified business inquiries, counted once under the agreed channel assignment. Recorded revenue is net recognized revenue from finance, including returns and credits, assigned to channels under that same reporting rule.
Document attribution separately. Google's attribution guide defines attribution as assigning credit across interactions. Credit assignment explains how a report distributes recorded results. It is not, by itself, evidence of the sales that would disappear if a channel stopped.
Use a mapping of campaign ID to channel and retain the original campaign name for review. Include an unassigned category instead of silently losing campaigns with missing mappings. If a campaign changes channel classification, state when the change applies and keep the comparison consistent.
Reconcile campaign details before rolling them up. The separate paid media analytics guide covers campaign-level spend, lead and sales checks. Here, the unit of review is the channel, so the marketing owner can discuss allocation with finance.
Prepare one business summary, named Raw, with channel in column A, reporting month in B, net media spend in C, attributed qualified leads in D and recorded assigned revenue in E. Aggregate outcomes before combining them with costs so that multiple lead or revenue rows do not repeat campaign spending.
On a Summary sheet, list channels in A and place the selected reporting month in K1. Use the same month value and format as the Raw sheet. Enter the expressions after these cell labels and fill down:
B2 =SUMIFS(Raw!$C$2:$C$1000,Raw!$A$2:$A$1000,$A2,Raw!$B$2:$B$1000,$K$1)
C2 =SUMIFS(Raw!$D$2:$D$1000,Raw!$A$2:$A$1000,$A2,Raw!$B$2:$B$1000,$K$1)
D2 =SUMIFS(Raw!$E$2:$E$1000,Raw!$A$2:$A$1000,$A2,Raw!$B$2:$B$1000,$K$1)
Cover the full export in every range. The Excel SUMIFS reference and Google Sheets SUMIFS reference describe the multiple-criteria sum. Covirage is not affiliated with Microsoft or Google.
| Channel | Net media spend (USD) | Attributed qualified leads | Assigned revenue (USD) |
|---|---|---|---|
| Paid search | 40,000 | 500 | 120,000 |
| Paid social | 30,000 | 750 | 90,000 |
| Display | 20,000 | 250 | 30,000 |
| Sponsorship | 10,000 | 100 | 20,000 |
| Total | 100,000 | 1,600 | 260,000 |
Add spend share in E, assigned revenue share in F, cost per qualified lead in G and revenue per media dollar in H:
E2 =B2/SUM($B$2:$B$5)
F2 =D2/SUM($D$2:$D$5)
G2 =IF(C2=0,"",B2/C2)
H2 =IF(B2=0,"",D2/B2)
| Channel | Spend share | Assigned revenue share | Cost per lead (USD) | Revenue / spend |
|---|---|---|---|---|
| Paid search | 40.00% | 46.15% | 80.00 | 3.00 |
| Paid social | 30.00% | 34.62% | 40.00 | 3.00 |
| Display | 20.00% | 11.54% | 80.00 | 1.50 |
| Sponsorship | 10.00% | 7.69% | 100.00 | 2.00 |
| Total | 100.00% | 100.00% | 62.50 | 2.60 |
Round displayed percentages and ratios to two decimal places; calculate from unrounded values. The total cost per lead is 100,000 / 1,600 = $62.50. Total revenue per media dollar is 260,000 / 100,000 = 2.60. Both divide summed inputs rather than averaging channel ratios.
Reach describes people or accounts exposed, while impressions count advertising deliveries. The measures are not interchangeable. For example, Google's reach documentation explains that its unique reach measurement accounts for exposure across devices using statistical models.
Suppose the supplied July reach summaries are:
| Channel | Reported reach | Treatment in the review |
|---|---|---|
| Paid search | Not supplied | Leave missing; do not enter zero |
| Paid social | 600,000 | Keep the supplier's measurement definition |
| Display | 500,000 | Keep the supplier's measurement definition |
| Sponsorship | 80,000 | Label the supplied audience estimate |
Do not add this column. Overlap between channels is unknown, and the sponsorship estimate may use a different measurement basis. Reach provides delivery context within each channel's stated method; it does not repair an attribution gap.
Spending shares must cover the complete spending population:
| Spend reconciliation | Amount (USD) |
|---|---|
| Posted media costs | 98,000 |
| Supplied month-end accrual | 2,000 |
| Total media spend | 100,000 |
Keep the accrual identifiable so it can be reversed or updated when invoices arrive. Revenue needs a separate bridge for the selected finance scope:
| Revenue reconciliation | Amount (USD) |
|---|---|
| Assigned to paid channels | 260,000 |
| Without a paid assignment | 40,000 |
| Net recognized revenue | 300,000 |
Channel revenue shares describe the assigned $260,000. Labeling that denominator prevents an overstatement of paid media's coverage.
If finance later corrects paid social's assigned revenue from $90,000 to $95,000, holding all other inputs fixed, its revenue-to-spend ratio becomes 95,000 / 30,000 = 3.17. The assigned total becomes $265,000 and the overall ratio becomes 2.65. That is a recording change, not evidence that advertising suddenly became more effective.
Display receives a larger spending share than its assigned revenue share. Ask whether its objectives, sales lag and credit rules explain that difference before proposing a cut. Paid social has a lower recorded cost per lead than search, but both show the same revenue per media dollar. Lead quantity alone would give an incomplete ranking.
This use of mix concerns allocation across media channels. Product mix analysis covers products, while price volume mix analysis and rate volume mix analysis address revenue changes driven by different components.
Bring a file or Google Sheet with channel mappings, spending, attributed leads and the revenue totals used by finance. Covirage maps the columns; its tools compute and check the channel comparisons, and the external AI model explains the results with every figure traced to its rows. Create a free Covirage account and bring a sample of your own export.
See sales insights for the supporting approach to reviewing recorded commercial outcomes.
A descriptive media mix review summarizes recorded channel spending and outcomes. Marketing mix modeling uses statistical methods to estimate relationships between marketing activity and business results under stated assumptions. A channel spreadsheet alone does not provide those estimates or establish the incremental effect of advertising.
Usually not. A person can encounter advertising in several channels, and suppliers may estimate reach differently. Keep channel reach separate unless a supplied measurement has already removed overlap across those channels. Adding the reported figures can overstate the number of unique people reached.
Use that result to investigate rather than as an automatic allocation rule. The channel may receive late-stage attribution, serve an existing audience or have limited capacity. Check margin, customer quality and the evidence available for additional spending before proposing a controlled change.