Marketing campaign analysis report: results and checks

A marketing campaign analysis report should show whether a campaign met its objective, what the recorded result cost, and what management should do next. Use a stable layout that separates the target from the outcome and the outcome from the recommendation. Every total needs an export, a definition and a check.

A reusable report layout

Start with the decision the report must support. A lead-generation review needs a different emphasis from a contribution review, but both need fixed dates and explicit rules. This layout can be copied into a document or spreadsheet; it is a structure to fill, rather than a promised downloadable file.

Keep the objective unchanged after results arrive. If management changes the target, preserve the original beside the revision. Otherwise a report can appear successful because its definition of success moved.

Fill the report from identifiable rows

Use lead and opportunity IDs to count outcomes, campaign IDs to identify spending, and invoice or order IDs to connect recorded revenue with direct costs. Maintain a separate list of unmatched records. A blank campaign field should remain visible rather than silently dropping out of the report.

Choose the revenue basis with finance. The worked example uses net invoiced revenue after credits and the COGS attached to those sales. The IRS explanation of gross profit for businesses selling products starts with receipts after returns and allowances, then subtracts cost of goods sold. That supports the arithmetic distinction; the management report still needs the company's own accounting policy and reporting dates.

Campaign cost includes media, production, event charges and allocated campaign labor on a documented basis. Do not include the same labor in both direct delivery cost and campaign cost. If some costs remain unrecorded, label the contribution provisional and name the missing category.

For a deeper review of stage movement, link the report to marketing funnel analysis. Keep that diagnosis separate from the summary result. Use marketing cohort analysis when campaigns differ in how long their leads have had to convert.

Worked results table and formulas

A US distributor reviews the lead cohort and observation date in the layout above. Each opportunity is assigned to one campaign, all won deals shown have been invoiced, and the cost register includes the agreed full campaign costs. The source totals are:

Put those columns in A:G, with campaign rows in 2:4. Add gross profit in H, contribution after campaign cost in I, contribution ROI in J and campaign cost per opportunity in K. Enter these formulas in H2, I2, J2 and K2, respectively:

=E2-F2
=H2-G2
=IF(G2=0,"",I2/G2)
=IF(C2=0,"",G2/C2)

Copy down and format J as a percentage. A blank for a zero denominator means the ratio is undefined, not that the campaign has no return or cost. Display dollars to cents for unit costs and percentages to one decimal place.

Contribution ROI here is contribution after campaign cost divided by campaign cost. It is not a claim that all those sales were incremental. The marketing ROI and ROAS comparison explains why the revenue-to-spend ratio answers a different question.

The total contribution is 290,000 - 173,000 - 53,000 = $64,000, exceeding the stated $60,000 target by $4,000. Total ROI is 64,000 / 53,000 = 120.8%. Total cost per opportunity is 53,000 / 90 = $588.89. Calculate these ratios from totals, not an average of the campaign percentages.

If the cost register has campaign in column A and approved cost in B, Excel can sum each campaign using:

=SUMIFS(Costs!B2:B1000,Costs!A2:A1000,A2)

Microsoft's SUMIFS documentation describes the criteria-based summing used here. Covirage is not affiliated with Microsoft.

Checks before the report goes to management

Reconcile the 18 wins to unique won opportunity IDs. Tie $290,000 to the selected invoice and credit rows, $173,000 to their COGS, and $53,000 to the approved campaign cost register. The accounting identity is 173,000 + 53,000 + 64,000 = $290,000. Every reported revenue dollar is accounted for by COGS, campaign cost or remaining contribution.

This is a campaign subset, so it may not equal the whole company's revenue. Show exclusions separately and reconcile the subset plus those exclusions to the finance export. Check that repeated campaign memberships have not duplicated invoices or costs.

Write the management conclusion separately from the arithmetic: the cohort exceeded its contribution target, search and webinar produced equal contribution, and partner spending needs review. Assign that review to the marketing director. A post-campaign analysis can then examine execution and recommendations without crowding the recurring report.

Where the report goes wrong

• Results replacing objectives. A high lead count does not prove a contribution objective was met. Keep the agreed target beside the actual measure.
• Pipeline counted as revenue. Open opportunities are possible future outcomes. Present them separately from invoiced sales and identify the observation date.
• Media spend presented as full cost. Missing production, event or labor costs overstate contribution. Show the cost scope even when the amount is incomplete.
• Overlapping campaign credit. A sale assigned in full to several campaigns inflates the total. Use exclusive assignments or supplied fractional allocations that reconcile to each sale.
• Credit interpreted as impact. Recorded assignment explains how the report allocates results. Establishing incremental impact requires a separate comparison designed for that question.

Build the supporting comparison in Covirage

Bring a file or Google Sheet containing campaign assignments, recorded outcomes, revenue and the costs agreed for your report. Covirage maps the columns; its tools compute and check the supporting figures, and the external AI model explains them with every figure traced to its rows. Create a free Covirage account, then set up your business and bring a sample of your own data.

See Covirage for board reporting for the supporting reporting context.