Blog · Board and management reporting
Campaign dashboards compare spend, qualified outcomes and financial results on a consistent basis. Work through a US distributor's campaign layouts, their reconciliations and a change in spending.
Campaign dashboards compare spending, qualified outcomes and financial results for the same campaign population. The useful layout has separate spending, funnel and contribution views, with totals that agree across the underlying files. A strong revenue number cannot repair a duplicated order or an incomplete observation window.
Suppose a fictional US industrial distributor, Harbor Supply, wants to decide which April 2026 campaigns to repeat. Marketing supplies advertising charges and campaign invoices, sales supplies qualified prospect and order records, and finance supplies net sales and cost of goods sold. Each file carries the same approved campaign ID.
Choose one credited campaign per order for this example. If the company instead splits credit, keep fractional weights whose sum matches the order amount. Keep unassigned orders visible in a reconciliation rather than quietly dropping them. The broader method belongs in campaign analytics; the layout here shows the resulting comparisons.
The acquisition period is April 1 through April 30, 2026. Each qualified prospect gets a 60-day outcome window measured from qualification, with the last window ending June 29. The June 30 review includes orders within each prospect's window. Later orders stay outside this comparison even when they appear in the latest finance export.
Put the period, window, attribution rule and export dates above the views. The SEC's guidance on key performance indicators calls for clear definitions, calculation methods and explanations of management's use in public-company disclosures. Applying that discipline to an internal campaign review makes the numbers easier to challenge and reuse.
These are reconciled campaign summaries, not individual advertising events. Qualified prospects are deduplicated within campaign; orders are distinct order IDs. A prospect credited to more than one campaign would require a separate overlap check before presenting a companywide unique-prospect count.
| Campaign | Budget (USD) | Spend (USD) | Qualified prospects | Orders | Net revenue (USD) | COGS (USD) |
|---|---|---|---|---|---|---|
| Search | 13,000 | 12,000 | 80 | 10 | 60,000 | 36,000 |
| Webinar | 7,500 | 8,000 | 50 | 8 | 48,000 | 26,400 |
| 4,500 | 4,000 | 40 | 6 | 24,000 | 14,400 | |
| Total | 25,000 | 24,000 | 170 | 24 | 132,000 | 76,800 |
Spend includes the campaign's approved advertising, production and event costs. Net revenue is after returns and allowances. Finance must apply a consistent COGS policy: the IRS's explanation of gross profit subtracts cost of goods sold from net receipts after returns and allowances. That supports the gross-profit step below; it does not define a universal campaign-profit measure.
This view answers whether the campaign consumed the agreed budget. Use actual spend minus budget, with a positive amount meaning overspend.
| Campaign | Budget (USD) | Actual spend (USD) | Actual minus budget (USD) |
|---|---|---|---|
| Search | 13,000 | 12,000 | -1,000 |
| Webinar | 7,500 | 8,000 | 500 |
| 4,500 | 4,000 | -500 | |
| Total | 25,000 | 24,000 | -1,000 |
The check is 25,000 minus 1,000 equals 24,000. The actual total must also match the campaign cost register, including unpaid costs already incurred under the company's review policy. Do not compare invoice-date spending for one campaign with cash payments for another.
An underspend is a control result, not proof of effectiveness. Search stayed below its authorization, but the next views decide what the spending produced.
Cost per qualified prospect = Campaign spend / Qualified prospects
Qualified-to-order rate = Distinct orders / Qualified prospects
Here, each buying prospect places one order, so the order rate also represents the share of qualified prospects who bought. If repeat orders are allowed, count distinct buying prospects for that conversion rate instead.
| Campaign | Cost per qualified prospect (USD) | Qualified-to-order rate |
|---|---|---|
| Search | 150.00 | 12.5% |
| Webinar | 160.00 | 16.0% |
| 100.00 | 15.0% | |
| Total | 141.18 | 14.1% |
Search costs 12,000 / 80 = $150.00 per qualified prospect. The combined cost is 24,000 / 170 = $141.18, rounded to cents; the combined order rate is 24 / 170 = 14.1%, rounded to one decimal. Divide summed counts rather than averaging campaign percentages.
Email has the lowest acquisition cost, while Webinar converts the largest share. Neither fact yet answers which contributes the most dollars. Keep campaign engagement metrics in a supporting view rather than substituting clicks for qualified sales outcomes.
Gross profit = Net revenue minus COGS
Contribution after campaign spend = Gross profit minus Campaign spend
This contribution definition excludes corporate overhead and other selling costs. Label those exclusions beside the figure. See gross margin versus contribution margin for the distinction between cost layers.
| Campaign | Gross profit (USD) | Campaign spend (USD) | Contribution after spend (USD) |
|---|---|---|---|
| Search | 24,000 | 12,000 | 12,000 |
| Webinar | 21,600 | 8,000 | 13,600 |
| 9,600 | 4,000 | 5,600 | |
| Total | 55,200 | 24,000 | 31,200 |
The proof is 132,000 minus 76,800 minus 24,000 equals 31,200. Webinar produces the largest contribution after campaign spending in this cohort. That is an allocation result, not proof that removing Webinar would remove the same amount of revenue.
Change one input: Search spending rises to $15,000 while its outcomes and COGS stay fixed. Cost per qualified prospect becomes 15,000 / 80 = $187.50. Contribution becomes 60,000 minus 36,000 minus 15,000 = $9,000, a $3,000 decline. The variation shows why a revenue-only view misses an important change.
Marketing owns campaign IDs and spending classifications; sales operations owns qualification and order status; finance owns revenue and cost reconciliation. Record the next decision after these owners resolve exceptions. A completed cohort can then move into post campaign analysis for the repeat, change or stop decision.
Bring your advertising, CRM and finance exports with campaign IDs, dates, qualified outcomes, revenue and costs. 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 and bring a sample of your own data.
See sales insights for the supporting business context.
Include campaign identity, acquisition dates, the outcome cutoff, budget, actual spending, qualified prospects, orders, revenue and the costs used in contribution. Keep financial outcomes separate from intermediate activity. Add the definition and owner of each measure so readers can interpret changes consistently.
Match the review schedule to the decision and the available files. A spending review can use recent completed cost records, while revenue comparisons need enough time for prospects to buy. Display the export dates and maturity status rather than treating every refresh as a final result.
No. Revenue is sales assigned to a campaign under a stated rule. Profit measures subtract defined costs. Show cost of goods sold and campaign spending explicitly, and identify excluded overhead. Assigning revenue also does not establish how much revenue the campaign caused.