Blog · Finance metrics and formulas · Sales teams
Measure newspaper and magazine campaign returns using recorded responses, matched net revenue and complete print costs. The worked example includes spreadsheet formulas, a refund adjustment and the checks that keep attributed sales separate from incremental sales.
Newspaper advertising ROI compares contribution associated with print advertising, after campaign costs, with the campaign investment. Match recorded responses to completed orders, use revenue after discounts and returns, and include production as well as placement. The same approach covers magazine advertising when its issue dates and response window stay visible.
A coupon code, dedicated phone number or campaign URL gives you a response route. It can connect a purchase to the advertisement under an agreed attribution rule. It cannot establish whether the purchase would have happened without that advertisement.
Circulation is a separate delivery measure. The Alliance for Audited Media's definitions distinguish newspaper circulation from readership and unduplicated print-and-website audience. Do not multiply circulation by an assumed order rate and present the result as realized revenue.
Agree the financial definition with finance before the campaign begins. This guide uses contribution before marketing: net sales less product and variable delivery costs. The investment is the complete print campaign cost. The marketing ROI versus ROAS guide explains why revenue alone is not the return.
Attribution-based newspaper ROI = (matched contribution before marketing − print campaign cost) / print campaign cost
The campaign owner maintains placement and response records. Sales operations matches inquiries to orders, while finance approves revenue, refunds, variable costs and campaign expenses. Keep those responsibilities explicit when an agency supplies only a response report.
Start with the insertion order and invoice, then add the publication name, edition, issue date, format, geography and campaign code. For a newspaper-and-website bundle, ask for the placement cost allocation rather than silently calling the whole bundle print.
Export inquiries from the CRM with response date, campaign identifier, inquiry ID and matched order ID. Deduplicate repeat contacts before counting inquiries. One person calling and later using the campaign URL is one inquiry when your definition is unique prospects.
Add invoiced revenue after discounts, credit memos and refunds, excluding sales tax. Match product and variable fulfillment costs to the same orders. Keep coupon discounts in net revenue; deducting them again as campaign spend understates return. The credit notes and returns guide covers the revenue correction.
Use a fixed observation cutoff. Newspaper and magazine campaigns may mature differently, so report immature results as provisional. A longer response window is a measurement choice, not permission to claim every later order from a respondent.
A fictional US commercial kitchen supplier runs print placements during September 2026 and observes matched orders and refunds through October 15, 2026. The agreed rule assigns each order to one print response code. All orders below are completed; no quoted pipeline is included.
| Placement | Unique inquiries | Matched orders | Net revenue (USD) | Product and variable costs (USD) | Placement cost (USD) | Production (USD) | Tracking (USD) |
|---|---|---|---|---|---|---|---|
| Local newspaper | 180 | 72 | 36,000 | 19,800 | 6,500 | 1,000 | 500 |
| Trade magazine | 120 | 48 | 28,800 | 15,840 | 4,500 | 1,200 | 300 |
| Total | 300 | 120 | 64,800 | 35,640 | 11,000 | 2,200 | 800 |
Put the table in columns A:H, with placement in A and data in rows 2:3. Calculate contribution in I, full campaign cost in J, contribution after advertising in K and ROI in L:
I2 = D2-E2
J2 = SUM(F2:H2)
K2 = I2-J2
L2 = IF(J2=0,NA(),K2/J2)
Fill down. Inquiry-to-order conversion is =IF(B2=0,NA(),C2/B2), which gives 40.0% for each placement. That is a response conversion rate, not a readership conversion rate.
| Placement | Contribution before advertising (USD) | Campaign cost (USD) | Contribution after advertising (USD) | Attributed ROI |
|---|---|---|---|---|
| Local newspaper | 16,200 | 8,000 | 8,200 | 102.5% |
| Trade magazine | 12,960 | 6,000 | 6,960 | 116.0% |
| Total | 29,160 | 14,000 | 15,160 | 108.3% |
The combined return is =SUM(K2:K3)/SUM(J2:J3). Dollar amounts are exact; percentages are rounded to one decimal place. The identity $64,800 − $35,640 − $14,000 = $15,160 checks the numerator, while $11,000 + $2,200 + $800 = $14,000 checks the investment.
Reconcile the revenue to the selected orders and their credit memos, not the whole month's sales. Reconcile the investment to the placement and supplier invoices. Retain unmatched inquiries as an exception list rather than inventing revenue for them.
Suppose a later magazine-order refund reduces net revenue by $2,400 and finance confirms a corresponding $1,320 product-cost reversal. Campaign spending stays unchanged. Reopen the original campaign result rather than leaving it overstated.
| Magazine measure | Original (USD) | After adjustment (USD) |
|---|---|---|
| Net revenue | 28,800 | 26,400 |
| Product and variable costs | 15,840 | 14,520 |
| Contribution before advertising | 12,960 | 11,880 |
| Campaign cost | 6,000 | 6,000 |
| Contribution after advertising | 6,960 | 5,880 |
The revised magazine ROI is $5,880 / $6,000 = 98.0%. A response count can remain unchanged while the financial answer deteriorates. Use the actual cost reversal; a refund does not automatically recover fulfillment or servicing costs.
If the budget decision requires incremental profit, design a suitable controlled test. Research on geographic advertising experiments describes causal return estimation and explains why geographic differences require careful treatment. Covirage is not affiliated with the Alliance for Audited Media or Google.
For broader budget comparisons, use advertising ROI by medium; for a different offline response setting, see billboard advertising ROI.
Bring the placement invoices, coupon or CRM response file, order export and matched revenue and costs to Covirage; it maps the columns, and its tools compute and check the supplied campaign 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 sales insights for the sales decisions those reconciled figures support.
Coupons can identify orders associated with an offer when the order register retains the code. Match those orders to net revenue and costs, and deduplicate repeated redemptions. Coupon use does not establish incrementality because existing customers may redeem an offer on purchases they already intended to make.
Yes, provided the cost and contribution definitions are consistent. Retain the magazine issue date and a suitable response window because readers may keep an issue longer. Keep magazine and newspaper results separate until each campaign has had the agreed time to generate orders and refunds.
No. Circulation describes distributed copies under the publisher's stated definition. It does not count people who noticed your advertisement, contacted your company or completed a purchase. Use circulation to assess delivery and use your response and order records to calculate the financial return.