A CMO wants one page that answers four questions. Are we spending what we planned? What pipeline did the money produce, and at what cost per opportunity, by channel? What changed, and what did the team fix? What do you need me to decide?
Everything else, from click-through rates to impression share, belongs in the appendix or in your own working dashboards. This guide covers what goes on that page, a simple template, the mistakes that cost you credibility, and how to explain attribution honestly.
What a CMO actually wants from a paid media report
Your CMO isn’t managing the campaigns. They’re deciding where the next dollar goes and defending the budget to the CEO and CFO. Your report should make both easier.
That means four things, in this order:
- Spend against plan. Did we spend what we said we would? If not, why, and what’s the month-end forecast?
- Pipeline and cost per opportunity by channel. What did each channel produce in sales pipeline, and what did each opportunity cost?
- What changed and what the team fixed. The two or three movements that matter, with the cause and the action taken.
- What needs a decision. Budget moves, tests or trade-offs you can’t make alone.
Lead with the bottom line. If the CMO reads only the first three lines, they should know whether paid media is on track.
A one-page template
Use the same layout every month so the CMO learns where to look. Here is a simple outline.
| Section | What goes in it | Example |
|---|---|---|
| Headline | One or two sentences: on track or not, and the single biggest thing | “Paid media created $1.2M in pipeline at $2,400 per opportunity, 8% better than last quarter. LinkedIn needs a budget decision.” |
| Spend vs plan | Plan, actual, variance and month-end forecast, by channel | LinkedIn $40K of $45K plan, forecast $44K |
| Pipeline by channel | Opportunities, pipeline value, cost per opportunity and closed-won, by channel, with the attribution rule named | Google: 18 opportunities, $610K pipeline, $2,100 per opportunity (sourced) |
| Trend | The same numbers for the last three months or quarters | A small table or one simple chart |
| What changed | Two or three movements, each with its cause | “Microsoft Ads cost per click up 35% after a competitor entered our brand terms” |
| What we fixed | Problems found and the action taken, with the result so far | “Repaired broken UTMs on 6 LinkedIn campaigns; pipeline credit restored from Sep 12” |
| Decisions needed | Each with a recommendation, the cost and the expected effect | “Move $8K/month from Display to LinkedIn retargeting. Recommend yes.” |
| Notes | Attribution rule, lag window, data caveats | “Opportunities counted 60 days after spend. Sep data excludes a 4-day tracking outage.” |
A few rules for the layout:
- One page. If it needs two, the second page is an appendix.
- Numbers in tables, not paragraphs. A CMO scans before reading.
- Every number has a comparison. Plan, last month, or last year. A number on its own says nothing.
- Name the attribution rule next to every pipeline figure.
Step by step: how to build it each month
1. Pull spend from the ad platforms
Take actual spend by channel from LinkedIn Campaign Manager, Google Ads, Microsoft Advertising and any other platform you run. Put it next to the plan.
Add a month-end forecast for the current month. Forecast from your own weekday pattern, not a straight line, because many B2B accounts spend less at weekends. Remember each platform has its own overspend allowance. Google Ads, for example, can spend up to twice your average daily budget on a given day but caps monthly charges at 30.4 times the daily budget. One high day isn’t a pacing problem.
2. Pull pipeline from the CRM, not the ad platforms
Pipeline and opportunities come from HubSpot or Salesforce. That’s what sales and finance trust, and it’s where the deal value lives.
Ad platforms count actions, like form fills and clicks. CRMs count people and deals. The numbers will never match exactly, and they shouldn’t be expected to. If you need to set up channel credit in your CRM first, follow our guides for HubSpot and Salesforce.
3. Apply a lag window
B2B pipeline arrives weeks or months after the spend that created it. Dreamdata’s 2022 benchmarks, from 414 accounts, found an average of 192 days from first touch to closed-won, and 87 days when the first touch was paid.
So don’t divide this month’s spend by this month’s opportunities. Measure your own typical gap between a lead being created and its opportunity being created. Then compare spend with opportunities created that many days later. State the window on the page.
4. Calculate cost per opportunity by channel
Cost per opportunity = channel spend in the period ÷ opportunities created and credited to that channel in the lagged period.
Show cost per lead too if you like, but put cost per opportunity first. A cheap lead that never becomes a sales conversation isn’t cheap.
5. Write the “what changed” and “what we fixed” sections
Pick the two or three movements that changed the numbers most. For each, give the cause and the action. “CTR fell” isn’t useful. “CTR on our main LinkedIn campaign fell 30% after the same ads ran for 10 weeks; we launched three new creatives on Oct 3” is.
Then list what the team fixed, with the result so far. This is the section CMOs remember, because it shows the team is managing the spend, not just reporting it.
6. Frame the decisions
Each decision needs a recommendation, the cost and what you expect to happen. “Should we spend more on LinkedIn?” is a question. “Add $10K/month to LinkedIn retargeting, where cost per opportunity is $1,800 against $3,100 for prospecting. Recommend yes, review in 90 days” is a decision the CMO can make in the meeting.
How to explain attribution honestly
Attribution is where paid media reports lose trust. The fix is to be plain about what you measured and what you didn’t.
Name the rule. There are three common ways to credit pipeline to a channel:
| Rule | What it counts | Good for |
|---|---|---|
| Sourced | Pipeline where the channel brought in the first contact | The simplest, most defensible number |
| Opportunity creation | Pipeline where the channel was the last paid touch before the opportunity was created | Fairer to channels that close the gap late |
| Influenced | Pipeline at accounts the channel reached before the opportunity was created | Account-based programs and awareness spend |
Pick one as your headline number and keep it the same every month. Show the others in the appendix if they help.
Say what the numbers miss. Some pipeline will always be missing from software attribution: people who saw an ad, didn’t click, and later searched your brand. HockeyStack’s study of 8,528 self-reported attribution responses found only 53% overlap with software attribution for search and 60% for social. Some disagreement is normal.
Don’t over-claim. Sourced pipeline isn’t the same as revenue, and influenced pipeline isn’t proof the ads caused the deal. Say so before the CFO does.
Show the lag. A campaign launched last month hasn’t had time to produce pipeline. Say when it will be fair to judge it.
Common mistakes
Leading with vanity metrics
Impressions, clicks and click-through rate tell you how the ads are working. They don’t tell a CMO what the money produced. Keep them in the appendix for diagnosis.
Treating platform-reported conversions as the source of truth
Each platform counts its own conversions with its own rules, and they overlap. Add up LinkedIn, Google and Microsoft “conversions” and you’ll often get more than the leads in your CRM. Platform-reported pipeline also undercounts slow deals. Google’s offline conversion imports from CRM connectors look back only 14 days on the first run, and LinkedIn’s click cookie lasts 30 days. Use the CRM for leads, opportunities and pipeline.
No lag window
Judging spend on pipeline in the same month makes every new campaign look like a failure and every paused one look like a success. Always state the window.
Changing the attribution rule month to month
If the rule changes, the trend means nothing. Pick one and stick with it. If you must change it, restate the history.
Reporting problems without fixes
“CPC rose 40%” leaves the CMO with a worry and no action. Pair every problem with what you did or what you propose.
Burying the decision
If you need a budget change approved, put it on the first page with a recommendation, not in the last slide.
Different numbers in different decks
If the CMO’s dashboard, the board deck and your report show different pipeline figures, trust goes. Use one source, one rule and one lag window everywhere.
How PipeHalo builds this report for you
Pulling this together by hand means exports, spreadsheets and a lot of reconciling. PipeHalo keeps it current every morning, like a checkup that also writes the notes.
The Leadership summary is a one-page PDF for a VP or CMO, for a month, a quarter or dates you choose. It shows what the ad money produced, a six-month trend, this month’s pacing with a forecast at the current run rate, what the team fixed and what needs attention. With HubSpot or Salesforce connected, it includes pipeline and cost per opportunity by channel, taken from the CRM rather than platform-reported conversions, with each deal credited to the one channel that sourced it.
The Monday Brief is an email every Monday morning to each team member who hasn’t turned it off. It covers the 3 open issues with the most money at stake, this month’s pacing, last week’s spend and results by channel against the week before, and, with a CRM connected, new pipeline by channel. It’s the short version of this report, every week, so nothing in the monthly one is a surprise.
Behind both, the daily checks flag pacing, creative, cost, results and tracking problems, and the actions log records what your team fixed and, for most flag types, how the number moved in the 14 days after. That’s your “what we fixed” section, already written. PipeHalo changes nothing in your accounts unless you approve it. Agencies get a white-label version for clients; see PipeHalo for agencies.
Try the live demo to see the Leadership summary built from 13 months of sample LinkedIn, Google and Meta ads and HubSpot data.
Related questions
What KPIs should a paid media report for a CMO include?
Spend against plan, pipeline and cost per opportunity by channel, closed-won where enough time has passed, and the trend over the last three periods. Click and impression metrics belong in the appendix.
How often should I report paid media results to the CMO?
A one-page report monthly or quarterly, with a short weekly update on pacing and the biggest issues. The weekly note means the monthly report holds no surprises.
Should I use the ad platforms’ conversion numbers in a CMO report?
Use them to manage campaigns, not to report results. For leads, opportunities and pipeline, use your CRM, because platforms count overlapping actions with their own rules.