Building a Marketing Dashboard in Looker Studio
By CodexierPublished 5 min read
Most marketing dashboards are built once, admired for a week and never opened again, because they show everything and answer nothing. Looker Studio is free, connects directly to GA4, Google Ads and Search Console, and can produce a one-page view that a busy owner actually reads. This guide starts from the questions, connects the data, keeps the page small and ends with filters, comparisons and sharing.
Questions the dashboard must answer
- How many leads, bookings or orders did we get this month, and how does that compare with last month?
- Which channels brought them: organic search, paid search, social, email, direct?
- What did paid leads cost per lead?
- Is organic search visibility growing, measured by clicks and impressions?
- Which landing pages turn visitors into leads, and which do not?
Connecting GA4, Ads and Search Console
Looker Studio has free native connectors for Google's own products. Add each as a data source, sign in with an account that has at least read access, and check that the fields you need are available. Each source keeps its own definitions: a GA4 key event, a Google Ads conversion and a Search Console click are counted differently, so do not expect them to match exactly.
| Source | Use it for | Watch out for |
|---|---|---|
| GA4 | Sessions, key events such as leads, landing pages, channels | Only counts consented users fully; modelled data may apply |
| Google Ads | Cost, clicks, conversions per campaign | Conversions follow Ads attribution settings, not GA4's |
| Search Console | Organic clicks, impressions, queries, pages | Data arrives a few days late; some queries are hidden |
Blending sources in one chart is possible but fragile. Show them side by side and let the reader compare instead.
One page, few charts
The layout that works for small businesses is simple. At the top, a row of scorecards: leads, cost, cost per lead, organic clicks, each with the change against the previous period. In the middle, one time series of leads by week. At the bottom, a table of channels with sessions, leads and conversion rate, and a second table of landing pages. That is enough to answer the questions above. Everything else can go on a second page for the person who wants detail. Our guide to dashboards people read covers the design principles.
Scorecards
Four to six numbers with comparison arrows. Label them in plain words, such as Leads, not key_event_count.
Trend
One line chart by week, not by day, so noise does not hide the direction.
Tables
Channels and landing pages, sorted by leads, with no more than ten rows each.
Filters and date comparisons
Add a date range control at the top with a default such as last 28 days, and set the comparison to the previous period on every scorecard. For seasonal businesses, add a second view comparing with the same period last year, since a Swedish shop's December or a restaurant's July says little compared with the month before. A channel filter and, for multi-location businesses, a filter by city or page group are usually the only other controls needed. Every extra filter makes the page harder to read.
Frequently asked questions
Is Looker Studio free?
The standard Looker Studio is free and includes connectors for Google products. There is a paid Pro version with team features, and some third-party connectors, for example for Meta Ads or LinkedIn, charge their own subscription.
Why do leads differ between GA4 and Google Ads?
They use different attribution, counting and consent handling. Google Ads credits conversions to ad clicks by its own rules, while GA4 splits them across channels. Pick one source per question and stick to it.
Can we include Meta or LinkedIn ads?
Yes, through third-party connectors or by exporting data to Google Sheets and connecting the sheet. Both add maintenance, so add them only if those channels matter to your budget.
How often should we look at the dashboard?
Weekly for a quick check, monthly for decisions. Looking daily mostly shows noise. Schedule the monthly email so the review happens even when nobody remembers to open the report.
Get one page you will actually read
Book a short call and tell us which questions you want answered each month. We check whether your tracking can answer them and what the dashboard should show.
Book a free 15-minute call