codexier.

Marketing & SEO

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.

SourceUse it forWatch out for
GA4Sessions, key events such as leads, landing pages, channelsOnly counts consented users fully; modelled data may apply
Google AdsCost, clicks, conversions per campaignConversions follow Ads attribution settings, not GA4's
Search ConsoleOrganic clicks, impressions, queries, pagesData 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.

Sharing and access

  1. Create the report and data sources under a company Google account, not a personal one.
  2. Decide whether data sources use the owner's credentials or each viewer's; owner's credentials let viewers see data without their own access to GA4.
  3. Share view access by name, avoid public links, and schedule a monthly email delivery as a PDF if people prefer the inbox.
  4. Keep edit access to one or two people and note changes in a text box on a hidden page.

When you do not need a custom dashboard: if one person looks at the numbers occasionally, GA4's own reports and Search Console are enough. When several people need the same numbers every month, or you pay for ads and want cost per lead in one place, our tracking and analytics setup fixes the tracking and builds the dashboard on top. Start with the GA4 setup guide, see the pricing page, or book a call.

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