Blog · Board and management reporting
A marketing dashboard connects campaign costs, CRM outcomes and recorded revenue under agreed definitions. Build the view from business exports, calculate its measures and reconcile its totals before using it to allocate spending.
A dashboard marketing teams can reconcile connects campaign spending, CRM outcomes and recorded revenue in a view whose totals can be checked. The build starts with identifiers, dates and definitions; charts come after the reconciliations. Keep pipeline, booked sales and recognized revenue in separate columns because they describe different stages of the same commercial activity.
Suppose a US business supplier wants to review campaigns that ran from January 1 through March 31, 2026. It will compare their qualified opportunities and subsequent revenue through June 30, 2026. This is a campaign cohort review, with a fixed follow-up date, rather than a comparison of unrelated monthly totals.
Write that scope above the dashboard. Also record the currency, whether spending includes agency fees, what makes an opportunity qualified and which revenue measure finance has approved. A campaign's booked contract value cannot silently become recognized revenue when the report changes hands.
Use one primary source campaign per opportunity for this example. If your business uses shared credit, agree the allocation before calculating; the marketing attribution guide owns that separate choice. Keep the dashboard build focused on applying the rule consistently.
Ask the source owners for these files and retain their original totals:
| Export | One row represents | Fields needed |
|---|---|---|
| Spending | A dated cost entry | Service date, campaign ID, amount, currency |
| Opportunities | One qualified opportunity | Opportunity ID, source campaign, qualification date, status, amount |
| Revenue | A recognized revenue line | Revenue line ID, opportunity ID, recognition date, net revenue |
The opportunity file must show statuses and amounts as of June 30, rather than whatever the CRM happens to show today. Revenue should be net of the adjustments finance includes in this report.
Match revenue to opportunities using approved opportunity IDs. Carry the source campaign and cohort label into the reporting copy. Put unresolved matches in an exception list. Do not connect costs directly to every contact or invoice line: that repeats spending whenever a campaign has several outcomes.
For a fuller inventory and readiness review, use marketing data sources and reconciliation. Here, the practical gate is whether each file has a defined row meaning, usable identifiers and a control total.
The following illustrative results come from the scoped exports. Every opportunity qualifies in the campaign quarter. At the follow-up date, this example has no lost opportunities; every qualified opportunity is open or won.
| Campaign | Spend (USD) | Qualified opportunities | Open opportunities | Won opportunities | Open pipeline (USD) | Booked value (USD) | Recognized revenue (USD) |
|---|---|---|---|---|---|---|---|
| Search | 12,000 | 8 | 6 | 2 | 90,000 | 60,000 | 36,000 |
| Webinar | 8,000 | 6 | 5 | 1 | 60,000 | 40,000 | 24,000 |
| Partners | 4,000 | 4 | 3 | 1 | 30,000 | 30,000 | 20,000 |
| Total | 24,000 | 18 | 14 | 4 | 180,000 | 130,000 | 80,000 |
For an Excel implementation, put campaign IDs in summary cells A2:A4. Set B1 to January 1, C1 to April 1 and D1 to July 1, 2026, using actual date values. Exclusive upper bounds include every dated entry before the following period begins.
On Spend, columns A:D are service date, campaign ID, amount and currency. Spending for the campaign in A2 is:
=SUMIFS(Spend!C:C,Spend!B:B,$A2,Spend!A:A,">="&$B$1,Spend!A:A,"<"&$C$1,Spend!D:D,"USD")
Microsoft documents SUMIFS as adding values that meet multiple criteria. This formula applies the campaign, service period and currency together.
On Opportunities, columns A:E are unique opportunity ID, campaign ID, qualification date, snapshot status and amount. Count the qualified cohort with:
=COUNTIFS(Opportunities!B:B,$A2,Opportunities!C:C,">="&$B$1,Opportunities!C:C,"<"&$C$1)
Add Opportunities!D:D,"Open" as another criteria pair for open counts, or Opportunities!D:D,"Won" for wins. Microsoft's COUNTIFS documentation confirms that all supplied criteria must be met. Sum pipeline using the same conditions:
=SUMIFS(Opportunities!E:E,Opportunities!B:B,$A2,Opportunities!C:C,">="&$B$1,Opportunities!C:C,"<"&$C$1,Opportunities!D:D,"Open")
For booked value, replace "Open" with "Won". On Revenue, columns C:F are recognition date, net revenue, matched campaign and approved cohort label. Recognized revenue is:
=SUMIFS(Revenue!D:D,Revenue!E:E,$A2,Revenue!F:F,"Q1-2026",Revenue!C:C,">="&$B$1,Revenue!C:C,"<"&$D$1)
Covirage is not affiliated with Microsoft. The Excel marketing dashboard guide covers the spreadsheet presentation in more depth.
The spending check is 12,000 + 8,000 + 4,000 = $24,000, equal to the scoped source export. The opportunity check is 14 open + 4 won = 18 qualified. Open pipeline is 90,000 + 60,000 + 30,000 = $180,000; booked value is 60,000 + 40,000 + 30,000 = $130,000.
The finance export contains $100,000 of recognized revenue in the follow-up period. Its bridge must remain visible:
| Revenue reconciliation | Amount (USD) |
|---|---|
| Matched to this campaign cohort | 80,000 |
| Outside this cohort or unresolved | 20,000 |
| Finance export total | 100,000 |
The check is 80,000 + 20,000 = $100,000. Review the remaining $20,000 by reason; do not allocate it merely to make campaign coverage appear complete. These are whole-dollar figures with no rounding required.
Use a compact table for campaign comparison and a separate exception panel for unresolved amounts. The marketing dashboard examples cover layout choices. For leadership interpretation and decision ownership, see the CMO dashboard.
Bring your campaign cost export, opportunity snapshot and finance revenue file, with the agreed campaign and cohort definitions. Covirage maps the columns; its tools compute and check the comparisons, and 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 self-service analytics for the supporting approach to answering business questions from your files.
Include spending, qualified opportunity counts, open pipeline and recorded revenue, with the period and measurement basis beside each. Add the extraction date, unmatched amounts and the person responsible for each definition so the reader can judge whether the comparison is complete.
Match the update schedule to the decision and the slowest reliable source. Campaign costs may change before finance closes revenue. Label provisional results, retain the previous version and use an agreed cutoff when comparing campaign cohorts.
A dashboard can report spending and outcomes linked under an attribution rule. That alone does not prove incremental impact or profit. ROI requires an agreed benefit measure, relevant costs and a defensible explanation of what would have happened without the campaign.