Blog · Board and management reporting
Choose a marketing dashboard layout for budget control, lead quality, or campaign contribution. One worked US company example shows how the same matched exports support different decisions.
Marketing KPI dashboard examples are most useful when each layout answers a specific business decision: where spending differs from budget, where lead quality weakens, or which campaigns retain contribution after their costs. The same matched records can support all of these views, but the headline measures should change with the question.
The examples below use one fictional US distributor. They show the numbers and the placement of each panel, so you can choose a layout before investing time in presentation. The separate marketing dashboard guide covers building and reconciling the underlying report.
The distributor reviews closed acquisition cohorts in September 2026. Every included lead has completed the same agreed observation window. Marketing supplies campaign costs and unique leads; sales supplies accepted leads and new customers; finance supplies matched net revenue and cost of goods sold.
For this illustration, each lead and customer belongs to one channel under the team's acquisition-credit rule. Campaign costs include the same defined categories for every channel. Unmatched transactions stay on an exception list rather than being assigned to whichever channel looks plausible.
| Channel | Budget (USD) | Campaign cost (USD) | Unique leads | Accepted leads | New customers |
|---|---|---|---|---|---|
| Paid search | 12,000 | 10,000 | 100 | 40 | 8 |
| Webinars | 8,000 | 9,000 | 120 | 48 | 6 |
| Partners | 5,000 | 6,000 | 60 | 36 | 9 |
| Total | 25,000 | 25,000 | 280 | 124 | 23 |
| Channel | Matched net revenue (USD) | Cost of goods sold (USD) |
|---|---|---|
| Paid search | 32,000 | 19,200 |
| Webinars | 30,000 | 18,000 |
| Partners | 36,000 | 21,600 |
| Total | 98,000 | 58,800 |
Attribution is a credit-assignment choice. Google's attribution documentation describes assigning credit for important actions across touchpoints. Record the rule used in your exports; do not add several platforms' credited totals as though they were distinct sales.
Use this layout when the meeting ends with a spending decision. Put budget and actual cost together, then show which campaigns explain the difference. A large lead count can distract from an unapproved commitment, so keep outcome metrics below the spending exceptions.
| Dashboard position | What to show | Decision supported |
|---|---|---|
| Top summary | Total budget, actual cost, and variance | Is total spending within the approved amount? |
| Center table | Channel budget beside actual cost | Where did spending move? |
| Lower exception panel | Missing invoices, accruals, and commitments | Is the apparent headroom available to spend? |
Budget variance = Actual campaign cost - Approved budget
| Channel | Calculation (USD) | Variance (USD) | Reading |
|---|---|---|---|
| Paid search | 10,000 - 12,000 | -2,000 | Below budget |
| Webinars | 9,000 - 8,000 | 1,000 | Above budget |
| Partners | 6,000 - 5,000 | 1,000 | Above budget |
| Total | 25,000 - 25,000 | 0 | At budget |
The top summary alone hides the action. Paid search's underspend offsets the other channels' overspend, but that does not authorize a budget transfer. The owner should review each exception and any remaining commitments before changing allocations.
For a recurring spreadsheet view, the existing KPI dashboard template supplies a general actual-versus-target structure. It is a starting layout; the cost policy still belongs to your team.
Use this layout when the decision concerns campaign targeting or the handoff to sales. Lead volume goes beside acceptance and customer outcomes, so a low cost per lead does not automatically win the comparison.
| Dashboard position | What to show | Decision supported |
|---|---|---|
| Top summary | Leads, accepted leads, and new customers | How much usable demand progressed? |
| Center table | Cost per lead and per accepted lead | Which channels supply usable leads economically? |
| Lower exception panel | Rejection reasons and unresolved leads | What should marketing and sales investigate? |
Cost per lead = Campaign cost / Unique leads
Cost per accepted lead = Campaign cost / Accepted leads
Accepted-lead conversion = New customers / Accepted leads
| Channel | Cost per lead (USD) | Cost per accepted lead (USD) | Accepted-lead conversion |
|---|---|---|---|
| Paid search | 100.00 | 250.00 | 20.0% |
| Webinars | 75.00 | 187.50 | 12.5% |
| Partners | 100.00 | 166.67 | 25.0% |
| Total | 89.29 | 201.61 | 18.5% |
For example, webinars cost 9,000 / 120 = $75.00 per lead, but convert 6 / 48 = 12.5% of accepted leads into customers. Partners cost more per initial lead, yet less per accepted lead. Investigate acceptance criteria and rejection reasons before moving budget; the table identifies a question, not a guaranteed future return.
Totals divide summed costs or customers by summed denominators. Google's SUMIFS documentation describes conditional sums that can create the channel totals from a working sheet. Do not average displayed channel ratios to produce the company figure.
Dollar ratios are rounded to two decimal places and percentages to one, using unrounded calculations. For a sales-focused audience, sales dashboard examples show how the emphasis changes after the lead handoff.
Use this layout when finance and marketing are deciding whether campaign economics justify continued spending. Put the cost bridge in the center, with an explicit label describing what remains excluded.
| Dashboard position | What to show | Decision supported |
|---|---|---|
| Top summary | Matched revenue and contribution after campaign costs | What remains from the observed cohort? |
| Center table | Revenue, product cost, and campaign cost bridge | Which channels retain the most contribution? |
| Lower exception panel | Returns, unmatched sales, and incomplete cohorts | What could change the interpretation? |
Gross profit = Matched net revenue - Cost of goods sold
Contribution after campaign costs = Gross profit - Campaign cost
| Channel | Gross profit calculation (USD) | Gross profit (USD) | Less campaign cost (USD) | Contribution (USD) |
|---|---|---|---|---|
| Paid search | 32,000 - 19,200 | 12,800 | 10,000 | 2,800 |
| Webinars | 30,000 - 18,000 | 12,000 | 9,000 | 3,000 |
| Partners | 36,000 - 21,600 | 14,400 | 6,000 | 8,400 |
| Total | 98,000 - 58,800 | 39,200 | 25,000 | 14,200 |
The check is 98,000 - 58,800 - 25,000 = $14,200, matching the summed channel contributions. This is contribution before costs outside the stated policy, not company net profit. The marketing ROI versus ROAS comparison explains the different denominator choices if the review also needs a return ratio.
Change only partner campaign cost from $6,000 to $8,000. Partner gross profit stays $14,400, so contribution becomes 14,400 - 8,000 = $6,400. The layout makes the $2,000 reduction visible even though lead volume, customer count, and revenue do not move.
Covirage is not affiliated with Google.
Bring matched marketing, sales, and finance files, or a Google Sheet containing those records. Covirage maps the columns, and its tools compute and check the illustrated 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 export.
See self-service analytics for the supporting approach to answering business questions from your files.
Include the decision, reporting period, spend, relevant outcomes, and the records excluded from the comparison. A budget review needs actuals against budget. A lead review needs accepted leads and conversion. A contribution review needs matched revenue, product costs, and campaign costs.
Choose the layout that supports the manager's next action. Use budget variance to control commitments, funnel counts to investigate lead quality, and contribution to review campaign economics. A single page can summarize these views, but each measure should retain its definition and source.
Apply the same cost policy, customer definition, attribution rule, and observation window to every channel. Show the underlying counts beside rates. Separate mature cohorts from recent activity so channels with longer sales cycles are not penalized simply because their opportunities remain open.
A dashboard can show how sales were matched or credited under a stated rule. That alone does not establish what would have happened without the campaign. Label attributed results clearly and use a separate evaluation design when the decision requires evidence of incremental impact.