Building a Marketing Dashboard in Looker Studio

Building a Marketing Dashboard in Looker Studio That Leaders Actually Read

Most marketing dashboards die in week three. The team builds a beautiful grid of charts, shares the link, and then nobody opens it. By the next quarterly review someone is back in a spreadsheet, copy-pasting numbers at 11pm.

The problem is rarely the tool. Looker Studio (the free product formerly called Google Data Studio) is plenty capable. The problem is that the dashboard answers questions nobody asked. It shows sessions and bounce rate when the CEO wants to know how many qualified leads cost last month and whether they turned into pipeline.

This guide walks through building a marketing dashboard in Looker Studio that survives. You will see how to pick the right metrics, connect data sources without paying for a connector, lay out a page people scan in ten seconds, and avoid the mistakes that make most dashboards quietly useless. Numbers in the examples are illustrative.

Start with the decision, not the chart

Before you open Looker Studio, write down the three or four decisions this dashboard should support. A dashboard is a tool for deciding something: where to move budget, which channel to scale, which campaign to kill.

A practical filter: if a metric changing would not change anyone's behavior, it does not belong on the main page. Sessions usually fail this test. Cost per qualified lead usually passes it.

For a B2B marketing team, the decisions usually sound like this:

  • Are we generating enough qualified leads to hit the pipeline target?
  • Which channels produce leads that actually close, and at what cost?
  • Is spend tracking ahead of or behind plan?
  • Where is the funnel leaking this month?

Map each decision to one or two metrics. That short list becomes your dashboard. Everything else is a second page for analysts, not the front page for leadership. If you have not nailed down which numbers matter, the work on the marketing KPIs that actually predict revenue is worth doing first, because a clear KPI set makes the build trivial.

Choose the metrics that earn their place

A leadership dashboard works best with a tight set. Think one screen, no scrolling for the headline numbers. Here is a starting set for a B2B team running paid and organic:

Metric What it answers Where it comes from
Marketing-qualified leads (MQLs) Are we feeding the pipeline? CRM or GA4 conversions
Cost per qualified lead (CPL) Are leads getting cheaper or pricier? Ad spend ÷ MQLs
Pipeline created Is marketing influencing revenue? CRM (deal stage)
CAC and payback Is growth efficient? Spend ÷ new customers
Spend vs. plan Are we on budget? Ad platforms + plan figure
Lead-to-customer rate Is lead quality holding up? CRM

Notice what is missing: impressions, clicks, click-through rate, average session duration. Those are diagnostic metrics. They help you explain why CPL moved, so they live on a deeper page. They do not help a founder decide anything in a Monday review.

If CPL, CAC, and payback are fuzzy in your head, the mechanics are covered in the guides on how to calculate CAC correctly and reading the LTV-to-CAC ratio. Get the definitions consistent before you visualize them, or the dashboard will just broadcast confusion faster.

Connect your data sources

Looker Studio pulls from connectors. Some are native and free, some are partner connectors you pay for, and some data you bring in through a sheet. For most marketing teams, a mix of three approaches covers everything.

Native Google connectors (free)

Google Ads, GA4, Search Console, BigQuery, and Google Sheets all have free native connectors. If your stack is Google-heavy, you can build most of a dashboard without spending a cent.

GA4 is usually the backbone for web conversions. Connect it, and you get events, conversions, traffic sources, and channel groupings out of the box. If your GA4 is not set up to record the right conversion events, fix that first, because the dashboard inherits whatever GA4 knows. The setup details are in the walkthrough on getting GA4 configured for B2B.

Non-Google platforms

LinkedIn Ads, Microsoft Ads, HubSpot, Salesforce, and similar tools do not have free native connectors in Looker Studio. You have three options:

  1. Paid partner connectors (Supermetrics, Windsor.ai, Coupler, and others). They cost a monthly fee but save real engineering time. Pricing scales with the number of data sources and rows, so check it against your needs.
  2. Google Sheets as a buffer. Export or pipe platform data into a sheet, then connect the sheet. Free, but someone has to keep the sheet fed, which usually means a scheduled script or a tool like Make or Zapier.
  3. BigQuery as a warehouse. For larger teams, land everything in BigQuery first, model it, then connect Looker Studio to clean tables. More setup, far more control.

A reasonable starting point for a small team: native connectors for Google sources, one paid connector for LinkedIn and the CRM, and a sheet for anything odd. You can graduate to BigQuery when the manual steps start to hurt.

Blend, do not bolt together

Looker Studio can blend data sources (its version of a join). You might blend GA4 conversions with Google Ads spend to compute CPL in one chart. Blends join on a common key, usually date or campaign name. They work, with two caveats: campaign naming has to be consistent across platforms, and blends can get slow if you join large sources on high-cardinality keys. Keep blends simple and tested. When a metric looks wrong, a broken blend is the usual suspect.

Design a page people actually scan

A dashboard is read in a glance or not at all. The eye starts top-left and moves right, then down. Put your most important number where the eye lands first.

A layout that works for a leadership page:

Recommended Looker Studio dashboard layout A top row of four scorecards for headline metrics, a middle row with a trend line and a channel bar chart, and a bottom row with a funnel and a data table. Marketing Overview · date range filter MQLs 142 CPL $78 Pipeline $310k Spend vs plan 96% Leads & CPL trend Leads by channel Funnel: lead to customer Top campaigns table

Some rules that hold up across dashboards:

  • Scorecards on top. Four to six big-number tiles, each with a comparison to the prior period. A number with no comparison is trivia.
  • One trend, one breakdown. A time series shows direction. A bar chart shows which channel or campaign drives it.
  • Color with restraint. Use one accent color and gray. Green-for-good, red-for-bad only when the metric has a clear good direction.
  • A date control at the top. Let the reader change the range without you rebuilding anything.
  • Round numbers. $78 reads faster than $77.94. Set the decimal places to zero on currency scorecards.

Resist the urge to fill empty space. White space is what makes the important number pop. A page with eight charts says everything matters, which means nothing does.

A build order that keeps you sane

Build in this sequence and you will not paint yourself into a corner.

  1. Sketch on paper first. Decisions, then metrics, then a rough grid. Five minutes here saves an hour of dragging boxes.
  2. Connect one source and verify the numbers. Connect GA4, drop in a single scorecard for conversions, and check it against the GA4 interface for the same date range. If they disagree, stop and fix it now. Trust is the whole game.
  3. Add calculated fields. CPL is spend divided by leads. Create it as a calculated field so the math lives in one place. Name fields clearly (CPL, not Field 3).
  4. Build the scorecards, then the charts. Top row first, comparison periods on, formatting clean.
  5. Add filters and date controls. A channel filter and a date range cover most needs.
  6. Add a second page for diagnostics. Clicks, CTR, landing page performance, search terms. This is where analysts dig when the headline number moves.
  7. Set up scheduled delivery. Looker Studio can email a PDF on a schedule. A Monday 8am email beats hoping people open a link.

That last step matters more than it sounds. A dashboard nobody visits is worth nothing. Push it to inboxes, or pin it in the channel where your team already lives.

Common mistakes that quietly kill a dashboard

Vanity metrics on the front page. Impressions and sessions feel like progress. They rarely change a decision. Move them to page two.

No comparison period. "142 leads" means nothing alone. "142 leads, up 18% from last month" tells a story. Turn on comparison on every scorecard.

Mismatched numbers across sources. When GA4 says 90 conversions and the CRM says 70, people stop trusting the whole dashboard. Decide which source is the source of truth for each metric and label it. Some gap between GA4 and your CRM is normal because they count different moments; explain the gap rather than hide it.

Marketing data with no revenue. A dashboard that stops at leads cannot answer the only question leadership truly cares about: did this make money? Pull in pipeline and closed-won from the CRM, even if the connection is a weekly sheet export. Tying spend to revenue is the point of closed-loop reporting, and it is what turns a marketing report into a business case.

Slow load times. Too many blends, huge date ranges, and high-cardinality dimensions make pages crawl. If a page takes more than a few seconds, people stop opening it. Use extracted data sources or BigQuery for heavy datasets, and keep the default date range tight.

Building it once and walking away. Channels change, campaigns get renamed, and a connector silently breaks. Put a 15-minute monthly check on someone's calendar to confirm the numbers still tie out.

When Looker Studio is the right tool, and when it is not

Looker Studio is free, plays well with Google's stack, and is fast to build in. For most small and mid-sized B2B teams, it is the right call.

It starts to strain in a few cases. Very large datasets get slow unless you put BigQuery behind it. Complex data modeling (heavy joins, custom logic across many sources) is painful in blends and better done upstream in a warehouse. And if you need row-level security across many client accounts, a heavier BI tool may fit better. For a single company tracking its own marketing, those limits rarely bite. The honest answer for most readers: start in Looker Studio, and only move when you feel a specific wall.

FAQ

Is Looker Studio free?

Yes. The core product is free, including native connectors to Google Ads, GA4, Search Console, Sheets, and BigQuery. You only pay if you use paid partner connectors (for LinkedIn, HubSpot, and similar) or if BigQuery query costs add up. There is also a paid tier (Looker Studio Pro) that adds team management and support, but most marketing teams do not need it.

How do I connect LinkedIn Ads or HubSpot?

There is no free native connector for either. You can use a paid partner connector like Supermetrics or Windsor.ai, pipe the data into Google Sheets through an automation and connect the sheet, or load it into BigQuery. For a small team, a single paid connector covering your non-Google sources is usually the least painful route.

What metrics belong on a marketing dashboard?

Lead with the numbers that drive decisions: qualified leads, cost per qualified lead, pipeline created, CAC and payback, and spend against plan. Keep clicks, impressions, and session metrics on a separate diagnostic page. If a metric changing would not change anyone's behavior, it does not earn a spot on the main view.

Why do my GA4 and CRM numbers not match?

Because they count different things at different moments. GA4 records a form submit or event on your site; the CRM records a contact that may be created, merged, or filtered later. Bots, blocked tracking, and timing differences widen the gap. Pick one source of truth per metric, label it, and explain the discrepancy instead of trying to force the numbers to be identical.

How often should the dashboard update?

GA4 and Google Ads data refresh on their own cadence (intraday for GA4, daily for most reporting). Looker Studio pulls live unless you use an extracted source. For decision-making, a daily refresh is plenty, and a scheduled weekly email to stakeholders is what actually drives the dashboard getting read.

Can one dashboard cover the whole funnel?

It can, if you bring in CRM data alongside marketing data. The trick is structure: a clean leadership page for headline outcomes, then deeper pages for channel diagnostics and funnel stages. Trying to cram everything onto one screen is what makes dashboards unreadable.

Quick checklist before you share it

  • The top row answers a real decision, not "how busy were we?"
  • Every scorecard has a comparison period.
  • Numbers tie out to the source platforms for the same date range.
  • Revenue or pipeline appears, not just leads.
  • One accent color, generous white space, round numbers.
  • A date control and at least one useful filter.
  • A scheduled email or a pinned link so people actually see it.

A good dashboard pays for itself the first time it stops a bad budget decision. If yours has turned into a wall of charts nobody reads, or you are still rebuilding the same report by hand every month, that is a fixable problem. We help B2B teams connect their ad platforms, GA4, and CRM into one view that ties spend to pipeline. Send us your current setup and we will give you a free 20-minute teardown of what to cut, what to add, and what to automate first.