Marketing KPIs and a Dashboard Your CEO Will Trust
Open the last marketing deck you sent leadership and count the slides that mention pipeline.
Marketing teams tend to report on dozens of metrics. CEOs care about three questions: how much pipeline did marketing create, how much of it closes, and what did it cost.
The gap between those two lists is why marketing dashboards get ignored.
Why the dashboard gets ignored
It was built for marketers, not for the people deciding the budget. Open rates, sessions, impressions and MQL volume help you tune a campaign. They don't answer what leadership is asking: is marketing contributing to revenue, and is the spend worth it?
A dashboard that can't answer that isn't a reporting tool. It's a defensive document.
The other problem is trust. If marketing's numbers don't match what sales sees in Salesforce, leadership goes with the Salesforce number every time, because that's where the deals live.
Before a board meeting, pull one opportunity and check its source in both systems.
The five marketing KPIs that belong on it
Five numbers answer those three questions. Everything else is supporting detail. Each one gets a written definition, because "pipeline" means three different things in three different meetings.
Marketing-sourced pipeline. The dollar value of opportunities created in the period whose first recorded touch was a marketing channel. Show marketing-influenced pipeline (opportunities with a marketing touch before they were created) next to it, labeled as influenced. Never add the two together.
Win rate on sourced pipeline. Of the marketing-sourced opportunities that closed in the period, what share closed won? Won divided by won plus lost, so open deals don't drag it down. This is how you show the sourced pipeline is worth having.
Pipeline-to-spend. Sourced pipeline divided by marketing spend. Spend $50k in a quarter, source $500k, and it's 10:1. CFOs read that instantly. It isn't ROI, though. ROI needs closed revenue, and ideally margin.
MQL to SQL conversion. Of the leads that became MQLs in the period, what share reached SQL? It tells leadership whether marketing's leads are worth sales' time. A low rate means lead quality is off or sales isn't working the leads. Either way, it's a conversation to have out loud.
Sales cycle length. Average days from first marketing touch to closed won. Trend it. If it's stretching, something is slowing down: lead quality, a longer buying process, a new competitor.
Build it in Salesforce
This dashboard belongs in Salesforce, not in a separate BI tool sales never opens. Same data, same screen, and pipeline review stops being an argument about whose number is right.
It only works if the attribution data sits on the right objects. Four pieces, and they're easy to mix up:
- Campaign Members record which Leads and Contacts responded to which campaigns.
- Primary Campaign Source is a field on the Opportunity. Salesforce often fills it with the most recent campaign, so don't treat it as first touch unless you've set a rule that makes it one.
- Campaign Influence connects an Opportunity to every campaign its contacts touched before it opened. That's your influenced view. Each campaign shows the full deal value, so never sum influenced pipeline across campaigns.
- First-touch fields (UTM source, medium, campaign and a first touch date) are custom fields, written once and carried from Lead to Contact to Opportunity. That's your sourced view. (How to capture them on the form.)
Lifecycle needs the same care. Converting a Lead in Salesforce isn't the same event as sales qualifying it, so store MQL Date and SQL Date as fields, map them from Lead to Contact, and report from those.
If that data isn't there, it comes first. A dashboard on incomplete attribution makes numbers that fall apart the first time someone asks a follow-up question.
The four reports
- Opportunities with first-touch fields, filtered by Created Date, for sourced pipeline. Win rate gets its own version: filtered by Close Date and a closed stage, so it counts deals that closed in the period.
- Campaigns with Campaign Influence, plus campaign Actual Cost or your spend sheet, for influenced pipeline and pipeline-to-spend.
- Leads and Contacts with MQL Date and SQL Date, grouped by MQL Date. Filter the Leads side to unconverted leads, or a converted person shows up twice.
- Closed won Opportunities with First Touch Date and Close Date for cycle length.
Stack them into one dashboard, filter for this quarter and the trailing twelve months, and share it with the same view sales leadership uses. Put the definitions in the dashboard description so nobody guesses which "pipeline" they're looking at.
What to cut from the CEO view
This part matters as much as what goes in.
Traffic, impressions, open rates, downloads. These are health metrics for the marketing team to watch, and leadership doesn't need them.
Raw MQL volume. A count without a conversion rate is a vanity number. 500 MQLs at 5% is 25 SQLs. 200 MQLs at 25% is 50.
Anything you can't trace to pipeline or revenue. If you can't draw the line, it doesn't belong in the report leadership uses to judge marketing.
Keep the metrics you cut on your own team's dashboard. You'll still need them on Tuesday.
Before you build
- Write one sentence each defining sourced and influenced pipeline. Does sales agree?
- Which field holds first touch on the Opportunity today? Is anything overwriting it?
- Do MQL Date and SQL Date exist, and do they survive Lead conversion?
- Where does spend live, and who updates it?
- Which metric on your current dashboard would you miss if it disappeared?
The half page that makes it stick
The numbers need a story around them before leadership will trust them.
Pair the dashboard with a short monthly note, about half a page: what pipeline looked like, what drove it, what's in progress and what I'm watching next month.
That note is what makes the numbers feel owned by someone with judgment. It's also the page leadership reads before deciding whether to move budget.
Skip the build
The B2B Attribution System
The locked UTM system, GA4 and CRM setup, the model decision guide and the dashboard. $399.
See the Attribution SystemNot sure your data is ready? Run the free audit first.
Notes from the Field.
Every other week, one broken thing and how I’d fix it.
One email every other week · unsubscribe anytime · Privacy policy