Sign in

Blog · Finance metrics and formulas · Sales teams

Newspaper advertising ROI: measure print campaign returns

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.

The short answerNewspaper advertising ROI is matched contribution after print campaign costs divided by those campaign costs. Track a coupon, campaign URL or phone response to the final order, use revenue after discounts and refunds, and deduct product and variable fulfillment costs. Include placement, creative and tracking expenses. This measures attributed return unless separate evidence establishes 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.

Decide what the print campaign can establish

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.

Assemble the response and finance records

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.

Worked example: newspaper and magazine placements

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.

What changes when a refund arrives?

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.

Where it goes wrong

  • Coupons are assumed incremental. Discounts can subsidize purchases that would have happened anyway.
  • An insertion is treated as delivery proof. Retain the agreed publication or placement evidence alongside the invoice.
  • Production is charged twice. Allocate shared artwork once across the placements using a recorded basis.
  • Magazine results close too soon. Keep the response and refund cutoff consistent when comparing campaigns.

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.

Reconcile your print results in Covirage

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.

Questions people ask

Can newspaper coupons measure advertising ROI?

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.

Should magazine advertising use the same ROI formula?

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.

Does newspaper circulation show advertising response?

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.