Offline marketing analytics: spend and recorded responses

Offline marketing analytics compares campaign spend with recorded responses, orders and revenue under an explicit mapping rule. Use campaign codes or documented response routes, and give each campaign the same follow-up window. A customer's location can describe the report, but it does not prove that person saw an advertisement or that the campaign caused a sale.

Define what counts as a recorded response

Start with the activity you can actually observe. A campaign-specific inquiry form, response code or dedicated response route can create a record that names the campaign. A regional sales total alone cannot make that connection.

Write down the response qualification rule before ranking campaigns. For example, count a company inquiry once per campaign after removing repeated submissions. Do not combine booth visits, qualified inquiries and completed orders under the same response label unless the report clearly separates them.

This is a channel and campaign comparison rather than recipient-level direct marketing analysis. For planning evidence beyond response records, use marketing research analytics. When a campaign also uses an online marketplace, the separate Amazon marketing analytics guide covers seller sales and spend reconciliation.

Assemble the campaign, response and order exports

Use a campaign schedule with campaign ID, region, activity date, spend and the approved observation window. Include the costs assigned to that campaign, such as printing, placement and event expenses. Keep the cost boundary consistent across periods.

The response export needs a response ID, campaign code, response date, qualification status and an existing account reference where available. The order export needs order ID, account reference, order date, recorded revenue and refunds. Use a documented reference already in these files; do not assume an identity match from a name or address.

Prepare a deduplicated response worksheet:

Assign each order once in this additive report, even if a buyer inquired through several routes. Document the allocation rule and keep conflicting matches in an exception list. An unresolved match is not a confirmed zero response or zero sale.

Work a regional and period comparison

A US industrial supplier runs regional print campaigns. The illustrative records below use a 30-day response window from each campaign's release and count orders within 30 days after an eligible response. Extract after both windows have completed, and apply refunds recorded through the reporting cutoff of October 15, 2026.

Campaigns have distinct IDs even when region and channel repeat. These are the source totals:

With the desired campaign ID in H2 on the prepared response worksheet, count eligible responses and sum their matched orders:

=COUNTIFS(B2:B5000,H2,D2:D5000,1)
=SUMIFS(E2:E5000,B2:B5000,H2,D2:D5000,1)

Microsoft's COUNTIFS documentation explains that each counted row must meet every criterion. Microsoft's SUMIFS documentation covers the corresponding conditional sum. These formulas summarize prepared records; they do not validate campaign mappings by themselves.

In the campaign summary, with spend in C, recorded responses in D and matched orders in E, calculate:

=C2/D2
=E2/D2
=C2/E2

These are cost per recorded response, orders per recorded response and cost per matched order. Here each response has at most one matched order, so orders per response is also the share of responses converting to an order. If repeat orders are allowed, show distinct responding buyers separately rather than calling an order count a buyer conversion rate.

Total cost per response is $32,000 divided by 370, or $86.49. Total conversion is 69 divided by 370, or 18.65%. Round displayed ratios to two decimal places after calculation; never average campaign percentages to obtain the total.

Reconcile the response population and revenue

The response totals need an audit trail before the campaign ranking is useful:

The checks are 410 minus 10 equals 400, and 370 plus 30 equals 400. This simplified example has no disqualified responses or late mapped responses; a real reconciliation should show those categories separately when present. The unmapped records remain unresolved. Do not redistribute them in proportion to regional sales.

Finance checks the matched order amounts independently:

The revenue check is $27,600 less $1,800, giving $25,800, tied to the mapped order records. Refunds are recorded through a common cutoff, giving the older campaigns more refund observation time. Before ranking net revenue, use an equal refund-age window or a documented final-adjustment policy. This is matched net revenue, not campaign profit. The marketing ROI versus ROAS guide covers the margin and cost distinction, while customer acquisition cost requires a separate new-customer definition and expense boundary.

MID-JUL has lower recorded cost per matched order than MID-JUN. That observation supports reviewing response handling, offer changes and local conditions. It cannot establish causal lift, because the period, audience and other influences may also have changed.

Where offline comparisons go wrong

• Inferring exposure from geography. A buyer in the campaign region may never have encountered the activity.
• Changing response definitions. Counting all inquiries in one campaign and qualified inquiries in another breaks comparability.
• Using incomplete follow-up. A recent release has had less time to accumulate responses and orders.
• Counting an order repeatedly. Multiple responses can otherwise attach the same sale to several campaigns.
• Hiding unmapped records. Apparently precise rankings can depend on a large pool of unresolved responses.

Covirage is not affiliated with Microsoft.

Compare your offline campaign records in Covirage

Bring a sample of your own campaign cost, response and order exports; Covirage maps the columns, and its tools compute and check the comparisons. The external AI model explains the results with every figure traced to its rows. Create a free Covirage account, which takes about a minute, then set up your business and bring your files.

See sales insights for the business context.