HomeAboutServicesMAGNET Framework™ResultsPortfolioInsightsAcademyBook a Free Strategy Call →
▶ Phase 06 — Track

KPI Dashboards

A dashboard full of impressions, clicks, and follower counts is not a marketing dashboard - it is a distraction machine. The dashboards that drive real decisions show pipeline created, CAC by channel, LTV trends, and the conversion rates that determine whether your funnel is healthy or quietly hemorrhaging revenue.

Build Your KPI Dashboard →

Why Most Marketing Dashboards Are Useless

Walk into almost any marketing team's weekly review meeting and you will see the same thing: a screen full of graphs showing website sessions, social media impressions, email open rates, and ad click-through rates. The team reports that sessions are up 12% month-over-month. The CEO nods. Everyone moves on. And nobody in that room can answer the question that actually matters: is marketing generating revenue?

Most marketing dashboards are useless not because the data in them is wrong, but because the data in them is disconnected from business outcomes. Activity metrics - the number of things marketing did and how many people nominally interacted with those things - are easy to measure, easy to improve, and almost completely irrelevant to whether the business is growing. You can increase website traffic by 50% by targeting the wrong audience. You can double your email open rate by sending to a smaller, better list. You can triple your LinkedIn impressions by posting daily content that your customers never read. None of these numbers represent marketing success.

The difference between a reporting dashboard and a decision dashboard is this: a reporting dashboard tells you what happened. A decision dashboard tells you what to do about it. A reporting dashboard shows that MQL volume was 47 this month. A decision dashboard shows that MQL volume was 47 (down 12% vs. target), that 31 of those came from organic search (up 8%), that 8 came from paid LinkedIn (down 40% vs. last month), and that the LinkedIn MQLs cost $340 each versus $87 for organic - then surfaces the question of whether LinkedIn spend should be paused pending a creative refresh.

The second reason most dashboards fail is organizational: they are built once, celebrated briefly, and then ignored after the first month. This happens when dashboards are designed to impress rather than to be used. A 40-metric dashboard that requires 30 minutes to interpret does not get opened on Monday morning. A focused 8-metric dashboard that answers the questions a marketing leader needs to make this week's decisions gets referenced every day.

72%Of marketing teams report on activity metrics rather than revenue impact
3xMore pipeline generated by teams with real-time revenue dashboards vs. weekly reports
8Core KPIs that matter in a B2B marketing dashboard - everything else is noise

The 8 KPIs Every Marketing Dashboard Must Include

These are the eight metrics that belong in every B2B marketing dashboard, regardless of company size, industry, or channel mix. They are the minimum viable measurement set for understanding whether marketing is contributing to revenue growth.

1. Pipeline Created

Pipeline created is the total value of new opportunities created in your CRM where marketing was the source or a contributing touch. This is the most important marketing metric in B2B. Show it this month, this quarter year-to-date, and trending against target. When pipeline creation is below target, every other metric becomes secondary - the question is why, and the dashboard should surface enough data to answer it. Pipeline created should always be shown in dollar value, not just opportunity count, because a hundred low-value opportunities does not represent the same output as twenty enterprise-level deals.

2. Pipeline Influenced

Pipeline influenced captures all deals in the CRM that had at least one marketing touchpoint in the 90 days prior to opportunity creation, regardless of whether marketing is credited as the primary source. This metric is essential for demonstrating the breadth of marketing's contribution to revenue - particularly for companies that rely heavily on outbound sales, where direct sourcing attribution often underrepresents marketing's role. Pipeline influenced should be expressed as both a dollar amount and as a percentage of total pipeline.

3. CAC by Channel

Customer acquisition cost by channel is the total marketing spend on a specific channel divided by the number of new customers acquired from that channel in the same period. This is not blended CAC. Blended CAC hides enormous variation between channels that perform very differently and should be allocated very differently. A company might have a blended CAC of $1,200 but a LinkedIn CAC of $3,800 and an SEO CAC of $420. Those are very different business realities that require very different strategic responses.

4. MQL Volume and Quality Score

MQL volume tracks the number of marketing-qualified leads generated this period, segmented by channel and campaign. Quality score tracks the percentage of those MQLs that met your ICP criteria based on firmographic and behavioral signals. Volume without quality is noise. A campaign that generates 200 MQLs with a 15% ICP match rate is substantially less valuable than a campaign generating 60 MQLs with a 70% ICP match rate, even though the first number looks more impressive in a report.

5. MQL-to-Opportunity Conversion Rate

The MQL-to-opportunity rate measures what percentage of MQLs are accepted and converted to opportunities by the sales team. This metric lives at the intersection of marketing and sales and is the most important indicator of lead quality. If your MQL-to-opportunity rate is below 20%, your MQL definition is too loose and you are wasting sales team time. If it is above 50%, your MQL threshold may be too restrictive and you are leaving pipeline creation on the table. Track this rate by channel and by campaign to identify which programs are generating genuinely sales-ready leads.

6. Pipeline Velocity

Pipeline velocity measures the average number of days from MQL creation to closed-won. This is your sales cycle length as measured from the moment marketing hands off a lead. Changes in pipeline velocity signal important shifts in buyer behavior, competitive dynamics, or sales process efficiency. When velocity slows, deals are stalling - and the dashboard should be able to show where in the funnel they are stalling. When velocity accelerates, something in the marketing or sales motion is working particularly well and is worth understanding deeply.

7. ROAS by Channel

Return on ad spend by channel measures the revenue attributed to each paid channel relative to the spend on that channel. This is the primary efficiency metric for paid media. ROAS is most meaningful when calculated on closed-won revenue rather than pipeline value, because pipeline has a close rate attached to it that varies by source. A Google Ads campaign with a 4:1 ROAS on attributed closed-won revenue tells a clear story. A LinkedIn campaign with a 1.2:1 ROAS on pipeline value that has historically closed at 30% is doing better than it looks - which is why showing ROAS alongside historical close rates by channel is essential context.

8. LTV:CAC Ratio

The LTV to CAC ratio measures the lifetime value of a customer relative to what it cost to acquire them. A 3:1 ratio is the widely cited B2B benchmark - for every dollar you spend acquiring a customer, you should expect to earn three dollars over that customer's lifetime. Below 1:1 means you are destroying value with every customer you acquire. Above 5:1 is often a signal that you are underinvesting in growth. Track this ratio by channel and by customer segment, because a single blended LTV:CAC ratio can mask the reality that your enterprise segment has a 6:1 ratio while your SMB segment is operating at 1.5:1.

"If your marketing dashboard does not show pipeline and CAC, it is not a marketing dashboard. It is a press release you send to yourself every Monday."

Dashboard Architecture: What Tools to Use

The right dashboard tool depends on the complexity of your data, the technical sophistication of your team, and the reporting cadences you need to support. Most companies need two to three layers of reporting infrastructure, not one.

Native CRM Dashboards

For most companies under $20M in revenue, native CRM dashboards in HubSpot or Salesforce are sufficient for tracking the core 8 KPIs. HubSpot's marketing analytics and revenue reporting are genuinely strong for mid-market companies. Salesforce reporting is more flexible but requires more configuration and a dedicated admin to maintain. The limitation of native CRM dashboards is that they only see data that lives in your CRM - they cannot easily blend paid media spend data from ad platforms with CRM pipeline data without manual integration work.

Business Intelligence Tools

Google Looker Studio is the entry-level BI tool for marketing dashboards and it is free. It connects directly to Google Analytics 4, Google Ads, and via partner connectors to LinkedIn, HubSpot, Salesforce, and most major ad platforms. For companies that want a unified view of spend, pipeline, and revenue across platforms, Looker Studio is a strong starting point. Tableau and Looker (the paid product, now part of Google Cloud) provide more sophisticated modeling capabilities and are appropriate for companies with complex multi-source data environments where a dedicated data analyst is building and maintaining the reporting layer. The rule of thumb: use native CRM tools until they constrain you, then invest in a BI layer.

Building a Dashboard People Actually Use

A dashboard is only valuable when it is actually consulted when decisions are being made. Building a dashboard that people use requires three things: it must answer the specific questions the audience has, it must be fast to open and interpret, and it must be embedded in an existing workflow rather than requiring a separate step to access.

The most successful dashboards I build for clients are organized around questions, not metrics. Instead of a page labeled "Pipeline Metrics," there is a section titled "Are we on track to hit pipeline target this quarter?" with the specific data points that answer that question: pipeline created to date, pipeline target, gap to target, and the top three sources of pipeline this quarter. Anyone opening that dashboard immediately knows what they are looking at and why it matters.

Speed of interpretation matters more than comprehensiveness. A dashboard that takes 20 minutes to fully understand will not be opened on a busy Monday morning. Design for the 90-second scan. Every visualization should have a clear takeaway that is apparent within seconds. Use color coding consistently - green for on or above target, amber for within 10% below target, red for more than 10% below target. Remove any metric that does not drive a decision. If you cannot describe the action you would take based on a particular number being either higher or lower than expected, that number does not belong on the dashboard.

Weekly vs. Monthly vs. Quarterly Dashboard Cadences

Different decisions require different data freshness and different levels of aggregation. Building a single dashboard that tries to serve weekly tactical decisions and quarterly strategic reviews simultaneously will do both poorly.

The weekly dashboard should focus on leading indicators: MQL volume this week versus last week, pipeline created this week, ROAS on active paid campaigns, and any anomalies or alerts - a campaign that has suddenly stopped spending, a landing page conversion rate that has dropped, an MQL volume spike that needs follow-up. This dashboard should be lightweight, near real-time, and action-oriented. It answers the question: what needs my attention this week?

The monthly dashboard should show full-funnel performance against monthly targets: MQL volume, MQL-to-opportunity rate, pipeline created, CAC by channel, and ROAS trends. Monthly data has enough volume to be statistically meaningful for mid-market companies and provides the right level of aggregation for understanding channel performance and budget allocation decisions.

The quarterly dashboard is a retrospective and forward-looking analysis: pipeline created and influenced versus quarterly targets, LTV:CAC trends, channel performance rankings, year-over-year comparisons, and next quarter forecasts. This dashboard supports QBR preparation, board reporting, and annual planning discussions.

The Dashboard Hierarchy: CMO, Manager, and Channel Dashboards

Different people within a marketing organization need different levels of detail. A well-designed dashboard infrastructure has at least three layers that serve different audiences with appropriately aggregated information.

The CMO or VP of Marketing dashboard shows the 8 core KPIs at a glance, trended over time, compared to targets. It should be a single page or screen - the executive view that answers "how is marketing performing this quarter?" in under 90 seconds. This is the dashboard that gets screenshotted and put in board decks.

The marketing manager dashboard goes one level deeper: performance by campaign within each channel, A/B test results, funnel conversion rates by traffic source, and email performance metrics. This is the operational dashboard that a marketing manager or demand gen manager lives in daily to optimize active programs.

Channel-specific dashboards - one for paid search, one for paid social, one for email, one for content/SEO - provide the granular data needed to optimize within a specific channel. These are built in partnership with whoever manages that channel and contain the metrics that are specific to how that channel is measured and optimized. A paid search dashboard includes quality scores, impression share, and keyword performance. An email dashboard includes deliverability, list health, and automation performance. A content dashboard includes organic traffic, keyword rankings, and content-influenced pipeline.

Frequently Asked Questions

How many metrics should be on a marketing KPI dashboard?
An executive KPI dashboard should contain 6 to 10 metrics maximum. More than that and the dashboard becomes a reporting document that requires time to interpret rather than a decision tool that delivers instant clarity. The discipline of limiting a dashboard to the metrics that matter most forces the important prioritization conversation about what you are actually managing the business toward. If you cannot get to 10 metrics or fewer, it is usually a symptom of unclear strategic priorities rather than a genuine measurement need.
How do you connect CRM pipeline data to ad platform spend data in one dashboard?
The most practical approach for most mid-market companies is Google Looker Studio with a combination of native connectors and a data blending layer. You connect your CRM (HubSpot or Salesforce via a partner connector), your ad platforms (Google Ads, LinkedIn, Meta directly), and Google Analytics 4. Looker Studio's data blending function lets you join these datasets on shared dimensions like campaign name or UTM source. For companies with more complex data needs, a purpose-built revenue operations platform like HubSpot's Marketing Hub Enterprise or a dedicated BI tool with a warehouse layer (BigQuery, Snowflake) will provide more flexibility and reliability.
What is a good benchmark for MQL-to-opportunity conversion rate?
Industry benchmarks for MQL-to-opportunity conversion rates typically range from 20% to 40% for B2B technology and services companies. Below 20% suggests your MQL definition is too permissive and you are sending low-quality leads to sales. Above 40% can indicate your MQL threshold is too restrictive - you are only counting as MQLs the leads that are nearly at the decision stage, which means you are missing earlier-stage pipeline opportunities that a nurture sequence could develop. The right benchmark for your specific business depends on your sales cycle, deal complexity, and how your sales team defines "opportunity."
How often should marketing KPI dashboards be reviewed?
Paid media and active campaign dashboards should be checked at least 3 times per week - more frequently when you are running time-sensitive campaigns with daily budget implications. The full marketing KPI dashboard should be formally reviewed weekly in the marketing team's operating cadence and monthly in a cross-functional review that includes sales leadership. The quarterly version feeds the QBR process and board reporting cycle. The mistake most teams make is either checking dashboards too infrequently (monthly reviews mean you cannot course-correct campaigns that are underperforming) or too frequently (daily full-funnel reviews on metrics that do not have enough volume to be meaningful at that cadence).
What is pipeline velocity and why does it matter?
Pipeline velocity is the average number of days it takes for a lead to move from MQL status to closed-won. It is a composite measure of lead quality, sales process efficiency, and competitive dynamics. When pipeline velocity slows, deals are getting stuck somewhere in the funnel - and identifying where the stall is happening (at MQL-to-SAL handoff, at demo-to-proposal stage, at proposal-to-close) tells you exactly where to focus attention. When velocity accelerates, it often means lead quality has improved (ICP-matched leads close faster), the sales process has been streamlined, or competitive differentiation has strengthened. Tracking velocity by channel also reveals important differences - leads from referrals typically move 40-60% faster than leads from paid media.

Stop reporting activity. Start tracking revenue.

I build KPI dashboards that show what actually matters - pipeline, CAC, LTV, and ROAS - connected to closed revenue. Dashboards people actually open, because the data inside them drives decisions.

Book a Free Dashboard Consultation →