A board-ready paid media report answers three questions on one page: did we spend what we planned, what pipeline and revenue did that spend create, and what will next quarter's budget produce. Show spend against budget, pipeline and won revenue by channel, cost per opportunity and ROAS over time, and a forecast with a range.
What the board actually asks
- Control: are we on budget, and if not, why?
- Return: what did the money produce in pipeline and revenue?
- Trend: is it getting more or less efficient?
- Next: what do we expect next quarter, and what would more or less budget change?
Clicks, impressions and platform conversions belong in the appendix. They help the team run campaigns but rarely answer any of these questions.
A one-page layout
| Block | What to show | Where it comes from |
|---|---|---|
| Spend against budget | Quarter budget, spend, projected quarter end, variance | Ad platforms and the budget plan |
| Pipeline created | Opportunities, pipeline value, cost per opportunity, by channel | CRM deals matched to campaigns |
| Revenue won | Won revenue, customers, ROAS, CAC, payback | CRM closed won deals |
| Trend | Cost per opportunity and ROAS by quarter | The same data over 4 to 6 quarters |
| Forecast | Expected pipeline and revenue next quarter, with a range | Pipeline per dollar, win rate and cycle |
A worked example
| Channel | Spend | Budget | Opportunities | Pipeline | Won revenue | Cost per opportunity | ROAS |
|---|---|---|---|---|---|---|---|
| Google Ads | $96,000 | $100,000 | 48 | $1,440,000 | $384,000 | $2,000 | 4.0 |
| LinkedIn Ads | $118,000 | $110,000 | 32 | $1,280,000 | $236,000 | $3,688 | 2.0 |
| Microsoft Ads | $19,000 | $20,000 | 11 | $220,000 | $76,000 | $1,727 | 4.0 |
| Total | $233,000 | $230,000 | 91 | $2,940,000 | $696,000 | $2,560 | 3.0 |
All dollar figures in the examples are illustrative. They are not results from any account.
The headline for this quarter: 1.3% over budget, driven by LinkedIn, with $2.9 million of pipeline at about $12.60 of pipeline per dollar. LinkedIn costs the most per opportunity and returns the least so far, so next quarter's plan moves part of its budget to search unless its open pipeline closes.
How to build it
- Fix the definitionsWrite down what counts as pipeline, which revenue number you use and the attribution rule. Put it in a footnote and keep it the same each quarter.
- Close the loop firstPipeline by channel needs CRM deals tied to campaigns. See closed-loop reporting.
- Show the variance and the reasonA number off budget without a reason invites questions. One line per variance is enough.
- Lead with the decisionEnd with the budget move you recommend and the pipeline it should produce.
- Keep the method visibleBoards trust numbers they can trace. Keep the formulas one click away.
What Pacing Console shows
Pacing Console holds most of the page in one place. The pacing board and Forecast give spend against budget and the projected month or quarter end. Performance shows a 13-month trend of spend and cost per conversion by channel. On Enterprise, the Pipeline and Revenue pages give opportunities, pipeline, won revenue, ROAS, CAC and payback by campaign and channel for 3, 6 or 12 months, each with Export CSV for your deck, and the Forecast adds expected won revenue and the budget needed to hit a target, each with how it is calculated. Enterprise budgets also add fiscal-year plans, purchase orders and a month-end accrual export for finance. Open the live demo to see the pages on sample data.
Plans: CRM lifecycle stages (contacts, MQLs, SQLs and opportunities by campaign, with cost per stage) are on Pro, USD 49 per workspace per month. The Pipeline and Revenue pages, revenue forecasts, what-if scenarios and budget targets need Enterprise. See Plans, pricing and billing.
Questions people ask
What paid media metrics should a CMO show the board?
Spend against budget, pipeline created, revenue won, cost per opportunity, ROAS or CAC, the trend over several quarters, and a forecast for next quarter.
Should I report platform conversions to the board?
Usually not as a headline. Platform conversions measure activity, not value, and are counted differently by each platform.
How do I show paid media impact when deals take months to close?
Lead with pipeline created and cost per opportunity for the quarter, and show won revenue over a longer window, such as the last 12 months.
How do I explain a budget overrun to the board?
Give the amount, the cause and what it produced. An overrun on a campaign with strong pipeline per dollar is a different conversation from one with none.
How often should the board see paid media numbers?
Quarterly is typical, with a monthly version for the leadership team.
Related articles
Last updated 2026-11-22. Platform and CRM rules change, so check their own help for the current details.