Build a Looker Studio Google Ads Dashboard Step by Step

A Looker Studio Google Ads dashboard turns raw campaign data into a report you can read in thirty seconds: spend, conversions, cost per acquisition, and ROAS, all in one place, refreshing automatically. This guide walks you through building one from scratch: connecting the data source, structuring the pages, choosing charts that answer real questions, and avoiding the layout mistakes that make most dashboards useless. By the end you will have a template you can clone for every client or account you manage.

Most dashboards fail not because of the tool. Looker Studio is free and the Google Ads connector is native. They fail because people dump every available metric onto one page and call it a report. A good dashboard answers three questions fast: are we hitting targets, where is the money going, and what changed. Build for those answers and the rest follows.

Step 1: Connect the Google Ads data source

Open Looker Studio, create a blank report, and add a data source. Search for the Google Ads connector, authorise the account, and select the specific account or manager account you want. The connector pulls a long list of fields, but you only need a handful to start: Campaign, Ad group, Date, Impressions, Clicks, Cost, Conversions, and Conversion value.

A common mistake is connecting at the wrong level. If you manage multiple accounts under an MCC, connect each account as its own data source rather than one blended mess. It keeps currency, time zone, and conversion settings clean. If you need a portfolio view across accounts, build that as a separate blended source later, once each account report is solid.

Step 2: Build calculated fields before you build charts

Google Ads gives you Cost and Conversions as raw fields, but CPA, ROAS, and conversion rate are not always pre-calculated the way you want. Create them once as calculated fields and reuse them everywhere. This is the single biggest factor in a dashboard that stays consistent.

Here are the calculations you will use on almost every report:

Define these at the data source level, not per chart. Edit the formula once and every chart that uses it updates. Defining the same formula five times in five charts is how dashboards drift out of sync.

Step 3: Lay out the three core sections

A clean Looker Studio Google Ads dashboard reads top to bottom in three layers. Resist the urge to add a fourth before these earn their place.

The scorecard summary

Across the top, place scorecards for the headline numbers: Cost, Conversions, CPA, ROAS, and Conversion value. Turn on comparison to the previous period so each scorecard shows the trend arrow and percentage change. This row answers “are we hitting targets” before anyone scrolls.

The trend view

Below the scorecards, add a time series chart with Cost and Conversions on a dual axis. This shows whether spend and results move together or diverge. A second time series for CPA or ROAS over time catches efficiency drift that totals hide. If CPA crept up 30 percent over the month, the totals might still look fine while the trend exposes the problem.

The breakdown tables

At the bottom, add tables that break performance down by Campaign, then Ad group, then Device. Use bar charts inside the table cells for spend and conversions so the eye finds the biggest line items instantly. Sort by Cost descending so the budget hogs sit at the top.

A dashboard that needs a verbal explanation has failed. If a client opens it cold and cannot tell within a minute whether the month was good or bad, the layout is wrong, not the client.

Step 4: Add controls so the template is reusable

The difference between a one-off report and a reusable template is the controls. Add a date range control at the top, a campaign filter (drop-down), and a device filter. Now the same report serves a quick weekly check and a deep monthly review without anyone editing charts.

For agencies, this is where the real efficiency comes from. Build one polished template, then clone it and swap the data source for each new account. Ten minutes of setup per client instead of an hour. If you manage paid search at scale, this reporting layer pairs naturally with disciplined campaign work: our Google Ads management service and a structured Looker Studio reporting setup follow exactly this pattern.

Step 5: Blend with GA4 only when you need to

The Google Ads connector tells you what happened inside the auction: impressions, clicks, cost, and platform-reported conversions. It does not tell you what users did after the click. For bounce rate, engaged sessions, or assisted conversions, blend in GA4.

Blend on a shared key (usually date plus campaign) and pull only the GA4 fields you need. Do not blend just because you can. Every blend adds load time and a chance for mismatched dimensions to break a chart. Keep a clean Google Ads page and a separate “on-site behaviour” page rather than forcing everything into one cluttered view.

If your conversion numbers between Google Ads and GA4 disagree (they almost always do), that is an attribution and tracking question, not a dashboard bug. We cover the why in our guide to GA4 and Google Ads conversion tracking, and accurate measurement upstream is what makes any dashboard trustworthy: see our tracking and measurement service.

Common dashboard mistakes to avoid

A few patterns separate a report people open daily from one they ignore:

• Too many metrics. If a number does not drive a decision, cut it. Twelve scorecards is noise.
• No comparison period. A figure with no context (spend was 4,000 euros) means nothing without “up 18 percent versus last month”.
• Vanity dimensions. Impression share by hour of day looks clever and changes nothing. Report on what you can act on.
• Inconsistent calculated fields. CPA computed differently on two charts destroys trust faster than a wrong total.
• No clear owner of the targets. A ROAS scorecard with no goal line is just a number floating in space.

Build the three-layer structure, define your metrics once, add the controls, and you have a dashboard that survives client meetings and saves you hours every reporting cycle. From there you can specialise: a lead-gen version centred on CPA and form fills, an e-commerce version centred on ROAS and revenue, a brand-versus-non-brand split for accounts where that distinction drives strategy.

If you are deciding which build to start with, the table below maps the common dashboard types to the metrics that earn the top row and the time each tends to take once you have a master template. These are experience-based ranges, not fixed numbers.