B2B guide
B2B marketing dashboard: what to track and how to build one that sales trusts
A B2B marketing dashboard shows how marketing spend turns into qualified leads, sales opportunities and pipeline, in one place that marketing, sales and finance all accept. This guide is for B2B marketing leads and the agencies that report for them. We cover the metrics that matter, the page plan we use, the CRM data work that most templates skip, a worked cost-per-SQL example, and when a dashboard is the wrong purchase.

Quick answer
What should a B2B marketing dashboard include?
A B2B marketing dashboard should connect spend by channel to leads, MQLs, SQLs, opportunities and pipeline value, with cost per stage and conversion rates between stages. It needs CRM data, not just web analytics, and it should group leads by the month they were created so long sales cycles are measured fairly.
- A B2B marketing dashboard must join ad platforms and web analytics to CRM stages and pipeline.
- Capture UTMs and click IDs into CRM fields before building charts, or attribution will fail.
- Cohort leads by created month so long sales cycles do not distort cost per SQL.
- Move to BigQuery once you pass five sources or need non-equality joins.
What is a B2B marketing dashboard and who reads it?
A B2B marketing dashboard is a shared report that follows a buyer from the first click to a closed deal. It differs from an ecommerce or PPC report because the money arrives weeks or months after the click, and the revenue sits in the CRM rather than in the ad platform or GA4.
Three audiences read it, and each asks a different question. The CMO or head of marketing asks which channels produce pipeline and what each qualified lead costs. Sales leadership asks whether the leads are any good, which shows in MQL to SQL conversion and opportunity rates. Finance asks whether marketing spend is earning its place in the budget.
That last question has become sharper. Gartner's 2026 CMO Spend Survey, run from January to March 2026 among 401 marketing leaders, found marketing budgets at 7.8% of company revenue, up only slightly from 7.7% in 2025. Flat budgets mean every channel has to show its contribution to pipeline, and a dashboard built only on clicks and form fills cannot do that.
Which metrics belong on a B2B marketing dashboard?
Start with the funnel stages your CRM already records, then attach cost to each stage. Most B2B teams use some version of lead, MQL, SQL, opportunity and closed-won, and the dashboard should use the exact definitions sales has agreed to, written down in the report itself.
The table below is the core set we put on the first page. Everything else, such as engagement rate, impression share or email open rate, belongs on channel pages where specialists can use it.
| Metric | Where the data lives | Why it matters |
|---|---|---|
| Spend by channel | Google Ads, LinkedIn Ads, Microsoft Ads, Meta | The cost side of every ratio below |
| Leads and MQLs | CRM (HubSpot, Salesforce, Zoho, Pipedrive) | Volume that marketing is accountable for |
| Cost per MQL and cost per SQL | Calculated: spend divided by stage count | Compares channels on quality, not clicks |
| MQL to SQL rate | CRM lifecycle stage history | Shows whether sales accepts the leads |
| Opportunities and pipeline value | CRM deal or opportunity object | The figure finance and the board care about |
| Closed-won revenue and win rate | CRM | Confirms pipeline quality over time |
| Sales cycle length | CRM created and closed dates | Tells you how long to wait before judging a channel |
How should a B2B marketing dashboard be laid out?
Five pages cover most B2B teams. Each page answers one question, and filters for date, channel, campaign, region and product line carry across pages so a viewer can follow a thread without rebuilding the view.
- Summary: spend, MQLs, SQLs, pipeline value and cost per SQL against target, with month-on-month change.
- Funnel: stage counts and conversion rates from lead to closed-won, split by channel and by lead source.
- Channels: one section per ad platform with spend, CTR, conversions and cost per MQL, plus organic search from Search Console.
- Cohorts: leads grouped by created month, showing how many reached SQL, opportunity and won after 30, 60 and 90 days.
- Accounts: target account list with engaged contacts, open opportunities and the campaigns that touched them, for teams running account-based programs.
Why do most B2B marketing dashboards fail?
They fail because the CRM does not know where each lead came from. Ad platforms report conversions, GA4 reports sessions, and the CRM reports deals, but unless the source of each lead is stored on the CRM record, there is no reliable way to join them.
The fix is upstream of Data Studio. Forms need hidden fields that capture utm_source, utm_medium, utm_campaign and the ad click ID where the platform passes one (gclid for Google Ads), and those values must land in CRM properties that never get overwritten. Without this, the dashboard can only show platform-reported conversions, which sales rarely trusts.
The second failure is timing. A lead created in March may become an opportunity in June. If the dashboard counts June opportunities against June spend, it rewards whatever ran three months ago and punishes this month's experiments. Cohort views, which group every outcome by the lead's created date, solve this.
The third failure is definitions. If marketing counts an MQL at form fill and sales counts it after a call, the numbers will never match. Agree the definitions, write them on the dashboard, and build them as calculated fields with CASE statements so they cannot drift between pages.
How do you connect CRM, ads and GA4 in Data Studio?
Data Studio connects natively to GA4, Google Ads, Search Console, Sheets and BigQuery. LinkedIn Ads, Microsoft Ads, Meta, HubSpot and Salesforce need partner connectors from vendors such as Supermetrics, Windsor.ai, Porter Metrics, Funnel, Power My Analytics or Catchr. Vendor prices change often, so check them directly before you budget.
For small setups, a blend in Data Studio can join spend to CRM leads on date and campaign. Blends are limited to five sources and equality joins, and a blend lives inside one report. On November 5, 2026 Google added a Union operator to blends, which appends rows across up to five tables and removes duplicates. That helps stack spend from several ad platforms into one channel table, but it does not lift the five-table ceiling.
Most B2B dashboards outgrow blends quickly. Matching a lead to the campaign that created it, attributing an opportunity to an account, or rolling up spend by quarter while deals close in another quarter all need modelling that is easier in BigQuery. We load ads, GA4 and CRM data into BigQuery, build one table per question, partition by date to keep query costs low, and point Data Studio at those tables. The report then runs on clean, pre-joined data instead of live blends.
| Setup | Fits when | Watch out for |
|---|---|---|
| Native connectors plus blends | Up to five sources, one region, simple campaign naming | Equality joins only, slow pages, GA4 quota errors with many viewers |
| Partner connector into Sheets | Small CRM exports, weekly refresh is enough | Sheet size limits, manual fixes creeping in |
| BigQuery model | CRM joins, cohorts, many accounts or regions | Needs modelling skills and a small Google Cloud bill |
Worked example: cost per SQL by channel
Here is an illustrative quarter for a B2B software company, using round numbers to show the arithmetic rather than any real client. The team spends 30,000 on LinkedIn Ads and 20,000 on Google Ads.
LinkedIn produces 300 leads and 60 SQLs, so cost per lead is 100 and cost per SQL is 500. Google Ads produces 400 leads and 40 SQLs, so cost per lead is 50 and cost per SQL is also 500. A dashboard that stops at cost per lead says Google Ads is twice as efficient. A dashboard that reaches SQL says the two channels cost the same per qualified conversation.
Add one more stage and the picture can flip again. If 15 of LinkedIn's SQLs become opportunities and 6 of Google's do, cost per opportunity is 2,000 for LinkedIn and about 3,333 for Google Ads. That is the reason a B2B marketing dashboard must reach at least opportunity stage before anyone moves budget.
The cohort view adds the time dimension. If those leads were created in January, the 90-day cohort will not be complete until April. Judging the quarter in early March would undercount both channels, and the slower channel most.
Build it yourself, buy a template, or hire an agency?
The right route depends on how clean your CRM data is and how many people need to trust the numbers. Templates are quick to start but assume clean UTMs and a standard funnel. In-house builds work when you have an analyst who owns both the CRM and the reporting. An agency makes sense when the data work spans several systems and the dashboard has to hold up in front of sales and finance.
| Route | Good fit | Main risk |
|---|---|---|
| Template from a connector vendor | One or two ad platforms, clean UTM capture, small team | Stops at platform conversions, no CRM stages |
| In-house build | An analyst with CRM admin rights and time | Knowledge sits with one person, fixes wait |
| Data Studio agency | Several ad platforms, a CRM, cohorts, sales and finance as readers | Needs a clear written scope to compare quotes |
When should you not build a B2B marketing dashboard yet?
Do not build one while the CRM has no source fields or lifecycle stages. The dashboard will only make bad data look official. Fix form capture and stage definitions first, then report on them for a month before building pages.
Do not build one if fewer than a handful of deals close each quarter. With very small numbers, cost per opportunity swings wildly, and a simple monthly spreadsheet reviewed in a meeting may serve you better. Revisit the dashboard when volume grows.
And do not build one to settle an argument about attribution models. A dashboard can show first-touch, last-touch and campaign-influenced views side by side, but it cannot choose the model for you. Agree the decision rule first.
How we build B2B marketing dashboards at Greenwolf Tech Labs
We start with a free review of your CRM fields, form capture and ad accounts, then quote a fixed price for the build. Our team designs the funnel definitions with your marketing and sales leads, builds the data model in Sheets or BigQuery depending on volume, and delivers Data Studio pages with documented calculated fields and a reconciliation against CRM totals.
We have built multi-channel marketing dashboards covering spend, leads and return across Google Ads, Meta, LinkedIn, GA4 and Search Console, and we have delivered 100+ projects for 200+ clients. Reports and data sources are owned by your account from day one, and agencies can take the same build as a white-label template for their own B2B clients.
FAQ
Frequently asked questions
What KPIs should be on a B2B marketing dashboard?
Track spend by channel, leads, MQLs, SQLs, opportunities, pipeline value and closed-won revenue, plus cost per MQL, cost per SQL and the conversion rate between each stage. Add sales cycle length so viewers know how long to wait before judging a channel.
Can Data Studio connect to HubSpot or Salesforce?
Not natively. HubSpot and Salesforce data reaches Data Studio through partner connectors such as Supermetrics, Windsor.ai or Porter Metrics, or through a pipeline into BigQuery. For cohort and attribution views, BigQuery is usually the more reliable route.
How do I connect LinkedIn Ads spend to CRM leads?
Capture UTM parameters in hidden form fields and store them on the CRM contact, then join LinkedIn spend to leads on campaign and date. Consistent campaign naming across LinkedIn and your UTMs matters more than any connector choice.
What is the difference between MQL and SQL on a dashboard?
An MQL is a lead marketing judges ready for sales, usually based on fit and engagement. An SQL is a lead sales has accepted for active follow-up. The rate between them is one of the clearest signals of lead quality, so show it by channel.
Why do my dashboard numbers not match the CRM?
Common causes are different stage definitions, timezone or date field mismatches, deleted or merged records, and blends that drop rows without a matching key. A good build includes a reconciliation page that compares dashboard totals to CRM reports for the same period.
How long does it take to build a B2B marketing dashboard?
It depends mostly on CRM data quality and the number of sources. A dashboard on clean data with native and partner connectors is a shorter project than one that needs form capture fixes, field mapping and a BigQuery model. We give a timeline with the fixed quote after the free review.
Is Data Studio good enough for B2B reporting, or do we need Power BI or Tableau?
Data Studio is free to build and view, and with BigQuery behind it, it handles B2B funnel and cohort reporting well. Teams already standardised on Microsoft or with heavy governed modelling needs may prefer other tools, which we compare in our Data Studio vs Power BI guide.
Keep reading
Related pages
Get started
Tell us what your reporting has to do
Describe the dashboards you need, who reads them and where the data sits. We reply within one business day with an approach, the connectors involved and a fixed-price plan.
- Free 30-minute reporting review
- Fixed quote before any work starts
- Everything built and owned in your Google account
Prefer email? info@greenwolftechlabs.com
Get a free proposal
Two lines is enough to start.