Blog · Finance metrics and formulas · Sales teams
Calculate television advertising return from matched campaign revenue, contribution and complete production and placement costs. A worked market comparison shows the spreadsheet formulas, reconciliation checks and effect of a longer observation window without treating attribution as causal lift.
ROI on TV advertising compares contribution associated with the campaign, after advertising costs, with the full campaign investment. Use matched sales and cost records for a defined market and observation window. Label the answer attribution-based unless suitable evidence estimates what would have happened without the advertising.
TV performance measurement includes audience delivery, reach, frequency, creative response and scheduling. This guide addresses the narrower finance question: did the contribution assigned to the campaign cover the investment under the stated rules?
Ratings and impressions help assess delivery. Nielsen's explanation of TV audience measurement describes ratings, impressions and the distinction between identifying viewed content and identifying viewers. None of those audience counts is a ledger of sales or contribution.
The marketing ROI versus ROAS guide owns the general financial distinction. Here, contribution before advertising is net revenue less product and variable delivery costs. Full campaign investment includes media placement, creative production and other approved campaign costs.
Attribution-based TV ROI = (matched contribution before advertising − full campaign investment) / full campaign investment
Do not include advertising in the contribution deduction and then subtract it again as investment. Finance should approve the cost boundary before comparing markets, stations or campaign cohorts.
Start with the campaign schedule and station or media-owner invoices. Retain campaign ID, market, station or service, planned and actual airdate, creative identifier, delivered placement and any credits. Record canceled or replaced spots so the cost file describes what was actually purchased.
Add production, editing, talent or rights, agency and measurement invoices where they are in scope. Allocate shared production using an approved basis and retain the allocation alongside the original total. Accounting treatment and this campaign decision view can differ; state the campaign scope rather than silently switching between them.
Next, export campaign responses and matched orders from the CRM, plus net revenue, credit memos and variable costs from finance. A response may use a dedicated phone number or URL, but repeated contacts are not additional sales. Bookings, invoices and cash receipts are different outcomes; choose one and label it.
If several channels claim the same order, use one agreed allocation rule. The marketing attribution guide covers that choice. Neither a short response window after a commercial nor an exposure match makes the assigned sale automatically incremental.
A fictional US office furniture retailer reviews a September 2026 TV campaign. The approved attribution file contains completed orders observed through October 7, 2026, for Dallas and Phoenix. Each order receives one campaign allocation, and the net revenue already reflects discounts and known refunds.
| Market | Matched net revenue (USD) | Product and variable costs (USD) | Placement (USD) | Allocated production (USD) | Other campaign costs (USD) |
|---|---|---|---|---|---|
| Dallas | 240,000 | 132,000 | 50,000 | 12,000 | 3,000 |
| Phoenix | 160,000 | 96,000 | 35,000 | 8,000 | 2,000 |
| Total | 400,000 | 228,000 | 85,000 | 20,000 | 5,000 |
The production allocations sum to the original $20,000 investment. These are attributed financial outcomes, not findings from a controlled experiment.
Put the table in A:F, with market in A and the two market rows in rows 2:3. In Excel or Google Sheets, calculate contribution in G, full investment in H, contribution after advertising in I and ROI in J:
G2 = B2-C2
H2 = SUM(D2:F2)
I2 = G2-H2
J2 = IF(H2=0,NA(),I2/H2)
Fill down. Format J as a percentage, retaining the underlying precision. Dollar amounts are exact and displayed percentages are rounded to one decimal place.
| Market | Contribution before advertising (USD) | Full campaign investment (USD) | Contribution after advertising (USD) | Attributed ROI |
|---|---|---|---|---|
| Dallas | 108,000 | 65,000 | 43,000 | 66.2% |
| Phoenix | 64,000 | 45,000 | 19,000 | 42.2% |
| Total | 172,000 | 110,000 | 62,000 | 56.4% |
The combined return is =SUM(I2:I3)/SUM(H2:H3). Averaging the two percentages would give the smaller investment the same weight as the larger one.
The contribution identity is $400,000 − $228,000 = $172,000. The investment check is $85,000 + $20,000 + $5,000 = $110,000. Subtracting investment leaves $62,000, and dividing that by $110,000 gives the reported 56.4%.
Match the $400,000 to the selected order and credit memo rows. Match the $110,000 to invoices and approved allocations. Investigate unmatched orders, missing variable costs and unallocated expenses before using the return to change budgets.
Now change only the observation cutoff for a Dallas sensitivity check. Additional matched orders observed through October 15 bring $30,000 of net revenue and $16,500 of associated variable costs; campaign investment stays unchanged.
| Dallas measure | Through October 7 (USD) | Through October 15 (USD) |
|---|---|---|
| Matched net revenue | 240,000 | 270,000 |
| Product and variable costs | 132,000 | 148,500 |
| Contribution before advertising | 108,000 | 121,500 |
| Campaign investment | 65,000 | 65,000 |
| Contribution after advertising | 43,000 | 56,500 |
The longer-window Dallas return is $56,500 / $65,000 = 86.9%. This demonstrates cutoff sensitivity; it is not a valid basis for ranking Dallas against Phoenix's shorter window. Recompute both markets at equal maturity before comparing them.
An incremental claim needs suitable causal evidence. Research on randomized geographic advertising experiments describes causal return estimation and difficulties involving heterogeneous regions and interference. A market comparison alone does not supply that evidence. Covirage is not affiliated with Nielsen, Google or Microsoft.
Use advertising ROI by medium for a consistent cross-media comparison, or billboard advertising ROI for the distinct out-of-home response problem.
Bring your campaign and market register, invoices, attributed order records and matched revenue and cost file to Covirage; it maps the columns, and its tools compute and check the supplied comparisons. 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 data.
See Covirage for sales teams for the business context behind those figures.
Match a dedicated response route, campaign code or approved attribution record to completed orders, then connect those orders to finance's net revenue and costs. Keep the airdate, market and observation window. A sales increase after a spot airs is supporting context, not proof that the spot caused it.
Yes, when it belongs to the agreed campaign investment. Include creative, production, editing, rights, agency and measurement expenses as applicable. Allocate shared assets across markets or campaigns using a documented basis, and ensure the total allocation reconciles to the original invoice without charging the same cost twice.
No. Revenue divided by media spend is a revenue multiple. This ROI convention deducts product and variable delivery costs, subtracts the full campaign investment, and divides the remaining contribution by that investment. Different cost boundaries can produce different returns from the same attributed sales.