B2B Marketing Performance Dashboard
It's the quarterly business review, and the marketing slide is the best one in the deck. Marketing-sourced pipeline is up again, the MQL target is beaten for the sixth month running, and cost per lead is the lowest it's been. Then the CFO asks a simple question: if pipeline keeps climbing, why are new customers flat?
That question lands harder when budgets aren't growing. Gartner's 2026 CMO Spend Survey put marketing budgets at 7.8% of company revenue, against 7.7% in 2025, and 56% of the CMOs it asked said they lacked the budget to deliver their 2026 strategy. A team in that position has to show which of its dollars produce customers, not just leads.
The tools have made that harder, too. Google retired its first click, linear, time decay and position-based attribution models, which stopped being available in Google Analytics in November 2023, leaving last click and data-driven. And the top of the funnel is thinning. Pew Research Center found in 2025 that Google users clicked a traditional result in 8% of visits when an AI summary appeared, against 15% when one didn't.
The company on this dashboard is made up: a US software firm selling safety and compliance training to mid-size manufacturers. Its numbers are modeled rather than drawn from a SimpleKPI customer. None of the seven targets below has a published benchmark we could verify, so all of them are starting points.
What is a Marketing KPI Dashboard?
Overview
A B2B marketing KPI dashboard shows whether the money marketing spends turns into leads that sales accepts, deals that sales didn't find on its own, and customers at a cost the business can carry.
It starts with the budget. Marketing spend vs budget comes from the finance ledger, not the ad platforms, and catches the month an event or a new tool quietly blows through the plan.
Next come the people arriving. Organic search sessions measure the unpaid traffic the content and SEO team earns, and the one part of the funnel no budget line can buy directly.
Then the handoff. MQL to SQL conversion rate is the share of marketing's leads that a rep spoke to and accepted. Cost per SQL divides program spend by those accepted leads, so a cheap lead nobody wants doesn't flatter it.
Then the money. Marketing-sourced pipeline is the value of new opportunities that started with marketing. Marketing ROI follows those deals through to signed contracts and sets the first year's value against everything marketing spent. Blended customer acquisition cost sits at the end, covering every sales and marketing dollar per new customer won. Unlike pipeline and ROI, no change to a lead or credit definition can move it.
Who benefits from this dashboard?
- VP of Marketing: Pipeline and blended CAC are what the board asks about. With cost per SQL beside them, the answer to "is marketing working?" arrives with its reason.
- Demand Generation Manager: Watches MQL to SQL conversion month by month, because a jump in MQLs with no jump in SQLs usually means a list source has gone bad.
- Content and SEO Lead: Organic sessions are theirs to defend. Seeing them next to SQLs and pipeline stops a traffic dip being read as a content failure when the leads are still arriving.
- Marketing Operations: Owns the definitions and the CRM fields behind them. When a number jumps, they're the first to check whether the business changed or the counting did.
- CFO: Spend vs budget and blended CAC let finance judge marketing on the same terms it judges every other cost.
Switch off SQL auto-accept. Some teams set the CRM to mark a lead accepted if no rep rejects it within a set time, so a lead nobody looked at counts the same as one a rep qualified on a call. Your conversion rate will fall the day you turn it off. That's the real number arriving, not a bad month.
Dashboard Example Overview
The example company has about $46 million in annual revenue and sells contracts averaging around $24,000 a year to manufacturers with 200 to 2,000 staff. A marketing team of nine runs content, events, email and lead generation, on a budget of about $320,000 a month including salaries, a little over 8% of revenue. It reports monthly against seven KPIs:
- Marketing Spend vs Budget: Total marketing spend for the month, programs plus team cost, divided by the month's budget. Taken from the ledger, so agency invoices and event deposits count in the month they're booked.
- Organic Search Sessions: Website sessions that arrived from unpaid search results. It's the widest point of the funnel and the one the team controls least.
- MQL to SQL Conversion Rate: SQLs divided by MQLs created in the month. An SQL is a lead a rep has held a discovery call with and accepted in the CRM. Nothing is accepted by default.
- Cost per SQL: Marketing program spend, excluding salaries, divided by SQLs. A cleaner efficiency number than cost per lead, because it only counts leads sales wanted.
- Marketing-Sourced Pipeline: The value of new opportunities created from marketing SQLs, where the account had no open opportunity and wasn't on a rep's named-account list in the previous 90 days.
- Marketing ROI: First-year contract value of new customers won from marketing-sourced deals, minus total marketing spend, divided by total marketing spend. It inherits the pipeline definition, so it's only as honest as the sourcing rule.
- Blended Customer Acquisition Cost: Everything sales and marketing spent in the month, salaries, commissions, programs and tools, divided by new customers won. Monthly CAC is noisy, so read it as a trend.
In late 2024, every lead and pipeline number on the board is green. Marketing-sourced pipeline is $2.79 million in October against a $2.5 million target. MQL to SQL conversion is 38.1%, cost per SQL is $605, and marketing ROI, credited by last click, is 130.4%.
Spring 2025 looks even better on the slides. In February conversion reaches 40.8% and cost per SQL falls to $538, and April's pipeline is $2.87 million. The team is booking more than 900 MQLs a month, many of them from paid content syndication: ebook downloads bought by the lead.
Blended CAC is the number that doesn't fit. It climbs from $28,410 in October 2024 to $31,900 in March 2025, because new customers aren't rising with the pipeline. In April, finance adds marketing-sourced and sales-sourced pipeline together for the quarter and gets well over 100% of total pipeline. Both teams are claiming the same deals.
The cause is two definitions. Any MQL a rep didn't reject within 48 hours was auto-accepted as an SQL, so leads reps ignored counted as qualified. And pipeline was credited by last click, so an outbound deal a rep had worked for weeks became marketing-sourced when the prospect clicked a nurture email before booking the demo. ROI inherited the same credit.
In May 2025 marketing and sales agree new rules: an SQL needs a discovery call and a rep's acceptance, and pipeline only counts as marketing-sourced on the terms in the list above. The old records didn't hold enough to rebuild earlier months, so the team leaves the history as it was and flags the break in every review from then on. In one month, conversion drops from 40.3% to 16.4%, cost per SQL rises from $541 to $1,261, pipeline falls from $2.87 million to $1.84 million, and ROI from 118.9% to 28.8%. Nothing about the business changed in May. Only the counting did.
Then the real work. Between July and October 2025 the team stops buying syndicated ebook leads and rebuilds lead scoring around fit (manufacturers in its size band) and intent (demo requests, pricing page visits, case study views). MQLs fall from 954 in June to 586 in October, while SQLs hold between 149 and 162 a month, so conversion climbs to 25.4%. The gated ebooks give way to ungated plant-floor case studies and compliance checklists that reps can send after a first call.
October 2025 goes the wrong way. The team takes a large booth at a fall manufacturing trade show, spend reaches 104.8% of budget and cost per SQL jumps to $1,459. Most of the badge scans never qualify, and the ones that do take months to reach an opportunity, so pipeline slides to $1.64 million in December, its lowest on the strict definition. November's spend is held to 94.7% to claw the overspend back.
From there it's steady. Pipeline passes the new $2.0 million target in April 2026 at $2.22 million and reaches $2.44 million in September. ROI crosses 100% in July 2026 and is 115.9% in September, with conversion at 30.8% and cost per SQL at $980. Blended CAC, the number that warned them first, is $24,120, down from its $31,900 peak.
Organic search didn't recover. Sessions fell from 42,234 in October 2024 to a low of 31,199 in July 2026, and ended September at 33,007, even with more content published. The team stopped treating traffic as the content team's scoreboard. Instead, the content lead now reports which case studies reps sent before deals closed, a measure for that team's own review rather than this board.
Creating a Marketing Dashboard in SimpleKPI
-
Step 1 Sign off MQL and SQL definitions with the sales leader
Write down what score makes an MQL, who can accept an SQL, what a rep has to do before accepting, and how long a lead can sit before it's recycled. Get the head of sales to agree it in writing. If a definition ever changes, record the month in the KPI's definition and say so in every review, because the step it causes will otherwise be read as performance.
The KPI selection guide covers how to test whether a measure is worth keeping.
-
Step 2 Take spend from finance and leads from the CRM
Ad platforms, the email tool and the webinar platform each report their own conversions, and they overlap. Use the finance ledger for spend and CAC, the CRM for MQLs, SQLs and pipeline, and web analytics only for sessions. One source per number, and marketing ops owns the mapping.
-
Step 3 Settle who gets credit before the quarter starts
Decide which deals count as marketing-sourced, sales-sourced or partner-sourced, and make the three add up to total pipeline. Agree it with sales before the quarter, not after. A rule argued over at the end of a quarter always favors whoever is presenting.
-
Step 4 Review conversion with sales monthly and CAC with finance quarterly
Run a monthly pipeline review with the sales leader on conversion, cost per SQL and marketing-sourced pipeline, with the paid media detail left on the advertising dashboard and rep performance on the sales dashboard. Take spend vs budget and blended CAC to finance each quarter, when enough deals have closed for the number to mean something.
List of Marketing KPIs
We couldn't find a verified published benchmark for any of these seven, so every target below is this example's starting point. The nearest published figure, Gartner's 7.8% of revenue, sizes the budget but doesn't set a target for any line on it. For a longer list to choose from, see 28 marketing KPI must-haves.
| KPI Name | Typical Target | Description / Calculation |
|---|---|---|
| Marketing Spend vs Budget | ≤ 100% (starting point) | Total marketing spend, programs plus team cost, divided by the month's budget. Taken from the finance ledger. |
| Organic Search Sessions | ≥ 40,000 a month (starting point) | Website sessions arriving from unpaid search results in the month. |
| MQL to SQL Conversion Rate | ≥ 25% (starting point) | SQLs accepted by a rep after a discovery call divided by MQLs created. No auto-accept. |
| Cost per SQL | ≤ $1,200 (starting point) | Marketing program spend, excluding salaries, divided by SQLs. Lower is better. |
| Marketing-Sourced Pipeline | ≥ $2.0 million a month (starting point) | Value of new opportunities from marketing SQLs where the account had no open deal and wasn't on a rep's named-account list in the prior 90 days. |
| Marketing ROI | ≥ 100% (starting point) | First-year contract value of new customers won from marketing-sourced deals, minus total marketing spend, divided by total marketing spend. |
| Blended Customer Acquisition Cost | ≤ $27,000 (starting point) | Total sales and marketing cost, including salaries, commissions, programs and tools, divided by new customers won. Lower is better. |
Why Marketing Dashboards Matter
Most B2B marketing numbers can be raised by loosening how they're counted, and the team doing the counting is usually the team being judged. That isn't dishonesty. It's what happens when lead scoring, CRM acceptance rules and attribution settings are chosen one at a time by different people over several years.
These seven work against each other in ways a single chart hides. Buying syndicated leads raises MQLs and lowers cost per lead, then drags conversion down. Tightening the MQL score lifts conversion but can starve pipeline if it's pushed too far. Organic traffic can fall while content does more for the pipeline than ever. And pipeline and ROI can climb while CAC climbs too, which means the deals marketing is being credited with aren't the ones that are closing.
That's why blended CAC belongs on a marketing dashboard even though marketing doesn't control all of it. It's built from finance's costs and closed customers, so no change to lead scoring or attribution can move it. When it disagrees with the marketing numbers beside it, believe CAC first and go looking for the definition that's flattering the rest.
For the example team, the most useful chart on the board ended up being the one with a step down in May 2025 that everyone in the room can now explain. Pipeline of $2.44 million a month on the strict definition is less than the $2.87 million it once reported, and ROI of 115.9% is less than the 130.4% it started with. They're also the first marketing figures the CFO hasn't questioned.
Building it in SimpleKPI
Build this dashboard yourself with SimpleKPI's KPI dashboards, or start from the Marketing KPIs template. The mechanics are the same whatever you track:
- KPIs: each one gets a target, an entry frequency and tags, so you can report by team, site, product or whatever you split the numbers by.
- Data: type numbers in, import a spreadsheet, or use an integration or the API. The dashboard updates as each number lands, so daily and monthly KPIs sit side by side.
- Reports: scheduled KPI reports email the numbers to people who never log in.
- AI: Kip, the built-in AI, suggests targets and flags indicative benchmarks (AI estimates, not peer data) once some history builds up.
- Price: $79 a month for unlimited users and KPIs, as one flat price, with a 14-day free trial and no card needed.
