Blog · Finance metrics and formulas · Sales teams
Calculate billboard and other out-of-home campaign returns from matched sales, contribution and complete campaign costs. A worked example separates tracked response from geographic comparisons and explains what neither can prove about incremental sales.
ROI on billboard advertising is the contribution associated with the campaign after campaign costs, divided by those campaign costs. Start with matched orders and full costs, rather than traffic counts or impressions. Unless the evidence supports a causal estimate, call the answer an attribution-based return.
Write down the campaign dates, locations, response window and outcome definition. A roadside board, transit display and indoor screen can use the same financial method, but their response routes and audience evidence differ. Keep each format identifiable in the campaign register.
Audience delivery is useful for checking the placement you purchased. Geopath's glossary distinguishes circulation, impressions, reach and frequency; these are audience measures, not a sales ledger. Ask the supplier which definition, geography and period its report uses.
For this calculation, contribution means net revenue less product and variable fulfillment costs, before advertising. Campaign investment includes placement, creative production, installation and the other agreed campaign costs. The marketing ROI versus ROAS guide owns the underlying denominator distinction.
Attribution-based billboard ROI = (matched contribution before advertising − full campaign cost) / full campaign cost
Sales and finance should approve the scope together. Decide whether repeat customers count, when refunds become final and how shared creative is allocated. Retain the same policy when comparing campaigns.
Export the placement register, response log, order register, credit memos and campaign invoices. Include campaign ID, format, location, response date, order ID, order date, net revenue, variable costs and campaign cost category. Record the approved observation cutoff alongside the file.
Use a memorable URL or phone number for a roadside board. A QR code can suit a pedestrian or indoor placement; it should not depend on a driver using a phone. Ask sales staff to record the campaign identifier consistently when customers call.
Deduplicate repeated calls and form submissions before matching orders. If an order has several advertising touches, apply one agreed allocation rule; the marketing attribution guide explains that separate job. Leave unmatched responses visible instead of assigning an estimated sale to each one.
A fictional US commercial flooring company reviews one completed campaign. Response capture runs from September 1 through September 30, 2026, and matched orders are observed through October 15, 2026. Each order is assigned to one response route, so the rows do not claim the same revenue twice.
| Format | Matched net revenue (USD) | Product and variable costs (USD) | Placement (USD) | Production and installation (USD) | Other campaign cost (USD) |
|---|---|---|---|---|---|
| Roadside billboards | 60,000 | 36,000 | 6,000 | 7,000 | 1,000 |
| Transit displays | 42,000 | 25,200 | 4,000 | 5,000 | 1,000 |
| Indoor screens | 18,000 | 10,800 | 2,000 | 2,000 | 1,000 |
| Total | 120,000 | 72,000 | 12,000 | 14,000 | 3,000 |
Put these columns in A:F, with the format in A and the three format rows in rows 2:4. In Excel or Google Sheets, calculate contribution in G, campaign cost 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, then format J as a percentage. Dollar amounts are exact; displayed percentages are rounded to one decimal place.
| Format | Contribution before advertising (USD) | Campaign cost (USD) | Contribution after advertising (USD) | Attributed ROI |
|---|---|---|---|---|
| Roadside billboards | 24,000 | 14,000 | 10,000 | 71.4% |
| Transit displays | 16,800 | 10,000 | 6,800 | 68.0% |
| Indoor screens | 7,200 | 5,000 | 2,200 | 44.0% |
| Total | 48,000 | 29,000 | 19,000 | 65.5% |
The total is =SUM(I2:I4)/SUM(H2:H4), not the average of the row percentages. Reconcile $120,000 to the matched order and credit memo register, and $29,000 to campaign invoices. The identity $48,000 − $29,000 = $19,000 proves the numerator.
A geographic comparison can reveal a question that tracked responses miss. Keep it separate from the response-based return because all-area revenue includes orders already counted above and orders with no tracked response.
| Area | Comparable period before campaign revenue (USD) | Campaign observation period revenue (USD) | Change (USD) |
|---|---|---|---|
| Campaign area | 120,000 | 132,000 | 12,000 |
| Comparison area | 104,000 | 110,000 | 6,000 |
The difference in changes is $12,000 − $6,000 = $6,000. It is an observational revenue contrast, not automatically incremental billboard revenue. Weather, promotions, territory changes and different underlying trends can affect the comparison. Do not add it to the tracked revenue table.
Random assignment and suitable design strengthen causal evidence, although research on randomized geographic advertising experiments also identifies challenges from heterogeneous regions and interference. See association and cause before labeling an area difference as lift. Covirage is not affiliated with Geopath, Google or Microsoft.
Use advertising ROI by medium when comparing this result with print or digital campaigns on a consistent cost and observation basis.
Bring your placement invoices, response-to-order records and matched revenue and cost file to Covirage; it maps the columns, and its tools compute and check the supplied campaign and geographic 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 comparisons.
Use a memorable campaign URL, dedicated phone number or recorded campaign code, then match the response to an order identifier. Keep untracked sales separate. A customer using the response route supplies attribution evidence, but that evidence does not show whether the customer would have bought anyway.
No. Impressions measure audience exposure under the supplier's stated methodology and can include repeated exposure. They are not unique buyers, inquiries or completed sales. Keep the audience delivery report beside the sales evidence rather than converting every impression into an assumed revenue amount.
Use your company's required return, campaign objective and confidence in the sales evidence. The answer depends on contribution margin, full placement and production costs, response delays and competing uses of the budget. A positive attributed return alone does not establish that another placement will produce incremental profit.