# Build a Google Ads dashboard in Looker Studio

> Connect Google Ads, pick Overall Account Fields, and build a spend, ROAS and Search campaign dashboard marketers trust.

Source: https://mentionx.ai/learn/looker-studio/looker-studio-google-ads-dashboard  
Author: Dipuck Jones, founder of MentionX  
Updated: 5 November 2026  
Level: Practitioner

**A Google Ads dashboard in Data Studio should make spend, efficiency and Search health obvious without requiring every stakeholder to learn the Ads UI. You will connect the Google Ads connector, choose Overall Account Fields, build an account overview and a Search deep dive, and label conversion columns so they do not disagree with GA4. Freshness stays fixed at 12 hours — plan for that.**

> **Key takeaways**
>
> - Use **Overall Account Fields** when you need mixed dimensions and metrics in one source.
> - MCC sources can include **up to 50** sub-accounts each.
> - Freshness is **every 12 hours**, not configurable.
> - Label **which conversion** the ROAS uses.
> - Keep Performance Max and Search on separate tables before you blend narratives.

*Checked 5 November 2026 (CET) against Google Cloud Data Studio documentation, the Data Studio product page, the Looker Studio-is-Data-Studio blog post, connector help pages and the Analytics Help pages cited in Sources. Google renames and moves features often, so confirm labels and limits in your own account. "Our view" marks MentionX opinion. Ledgerline is a fictional company used for illustration.*

## Connect Google Ads

1. Create a reusable data source > Google Ads connector.
2. Authorise an account with access to the customer or MCC.
3. Select the customer. For MCC rollups, select sub-accounts (max 50 per source per Google's docs).
4. Choose **Overall Account Fields** unless you know you need a single legacy report type.
5. Connect, set owner credentials, accept 12-hour freshness.
6. Name it `Google Ads — Brand (owner)`.

## Page plan

| Page | Contents |
|---|---|
| Account overview | Cost, conversions, conv. value, ROAS/CPA scorecards; daily cost time series; campaign table |
| Search | Search campaigns only: impressions, clicks, CTR, IS metrics you have access to, search terms via Sheets if needed |
| PMax / Demand Gen | Separate tables so Search CTR is not blended with visual inventory |
| Diagnostics | Disapproved assets count via Sheets export if not in connector fields you need; learning-period notes |

For AI Max / AI Overviews ads context, link stakeholders to [Google Ads in AI Overviews and AI Mode](https://mentionx.ai/learn/google-ads/google-ads-ads-in-ai-overviews-ai-mode) rather than forcing every concept into one chart.

## Conversion honesty

Pick one primary conversion column and write it on the cover:

- Google Ads conversion action "Lead - GA4"
- Or Ads-only offline import
- Or revenue for ecommerce

If leadership also watches GA4 key events, put both on a blend page later ([lesson 12](https://mentionx.ai/learn/looker-studio/looker-studio-cross-channel-roi-blend)) instead of pretending they are identical on this page.

## Calculated fields worth adding

- CPA = Cost / Conversions (NULLIF guarded)
- ROAS = Conversion value / Cost
- CPC = Cost / Clicks
- Search vs non-Search CASE on Campaign type / Channel type fields available in your field list (confirm names in your source)

## Campaign table columns

| Column | Why |
|---|---|
| Campaign | Identity |
| Campaign type / Channel | Segment Search vs PMax |
| Cost | Spend |
| Clicks | Volume |
| Conversions | Primary action only |
| Cost / Conv | Efficiency |
| Conv. value / Cost | If ecommerce or value tracking |

Sort by Cost descending for weekly reviews; by Cost / Conv ascending when hunting efficiency.

## Worked example: Ledgerline

*Ledgerline is a fictional accounts-payable software company. Details are illustrative.*

| Metric (28 days) | Value (illustrative) |
|---|---|
| Cost | $48,500 |
| Primary conversions | 310 |
| CPA | $156 |
| GA4 key events (same window) | 1,120 |
| Note | Ads conversions are a subset of GA4 leads by design |

### Walkthrough

1. Finance compared Ads UI at 11:40 with Data Studio and saw a spend gap. Footer explained 12-hour freshness.
2. They standardised on "Lead - GA4" as the dashboard conversion.
3. Search page excluded PMax to stop CTR arguments.
4. Weekly review used this report beside the [Google Ads monthly review routine](https://mentionx.ai/learn/google-ads/google-ads-monthly-review-routine).
5. Competitor A reported ROAS without naming the conversion; Ledgerline's labelled ROAS held up in diligence.

> **Pro move:** add a scorecard comparison: Ads conversions vs GA4 key events for the same range, with a text box "Not expected to match 1:1". That pre-empts the most common cross-tool fight.

## Search terms and assets

The Ads connector field list may not expose every UI report you love. Common pattern:

1. Keep account and campaign tables on the connector.
2. Export Search terms weekly to Sheets for a diagnostic page.
3. Export asset policy / disapproval counts similarly if needed.

Label those pages "Sheet export — not live Ads API".

## Impression share and diagnosis

If impression share fields are available in Overall Account Fields for your account type, add them on the Search page only. Do not average IS across PMax and Search.

## Alignment with Google Ads Academy

- [Google Ads for Marketers](https://mentionx.ai/learn/google-ads/google-ads-for-marketers)
- [GA4 key events import](https://mentionx.ai/learn/google-ads/google-ads-ga4-key-events-import)
- [Monthly review routine](https://mentionx.ai/learn/google-ads/google-ads-monthly-review-routine)
- [Ads in AI Overviews and AI Mode](https://mentionx.ai/learn/google-ads/google-ads-ads-in-ai-overviews-ai-mode)

Use the dashboard in the monthly review meeting; do not reinvent the routine inside Data Studio.

## Daily vs weekly use

| Cadence | What to open |
|---|---|
| Daily (ops) | Account overview scorecards + campaign table sorted by cost |
| Weekly | Search page + conversion definition check + CPA vs target |
| Monthly | Full review with [monthly routine](https://mentionx.ai/learn/google-ads/google-ads-monthly-review-routine) |

Daily users should not fight average position metaphors from SEO on this Ads board — keep vocabularies separate.

## Conversion action hygiene table

| Action name in Ads | Counts in dashboard? | Notes |
|---|---|---|
| Lead - GA4 | Yes — primary | Matches import |
| Newsletter signup | No | Soft metric |
| Phone call | Optional secondary page | Label clearly |
| Purchase | Ecommerce only | Value metrics |

Publish this table on the Diagnostics page. When someone adds a new conversion action in Ads, the dashboard stays intentional instead of silently shifting CPA.

## MCC rollup pattern

If you manage many accounts under an MCC:

1. Respect the **50 sub-account** cap per Google Ads data source.
2. Split brands across multiple data sources when you exceed 50.
3. Name sources `Ads — Region EU (owner)` not `Ads — all`.
4. Keep brand-level reports on brand sources; use MCC rollups for leadership only when definitions match.

Mixing vastly different margin businesses into one ROAS table creates politics, not insight.

## Our view

Our view: an Ads dashboard that hides the conversion definition is a liability. Label the action on the cover even if it feels redundant. Redundancy is cheaper than a wrong budget cut.

## Common mistakes

- **ROAS with no conversion definition.**
- **Mixing Search CTR with PMax in one average.**
- **Expecting real-time Ads numbers.**
- **Connecting 80 MCC children in one source** (cap is 50).
- **Personal login as owner** on a client Ads source.

## Try it yourself

Connect Google Ads with Overall Account Fields. Build overview scorecards and a campaign table. Write the conversion definition on the cover. Compare Cost to the Ads UI the next morning, not the same hour.

## Quick quiz

**1. Can you set Google Ads freshness to 1 hour?**

*Answer:* No. It is fixed at 12 hours.

**2. What is the MCC sub-account cap per data source?**

*Answer:* 50.

**3. Why separate Search and PMax tables?**

*Answer:* To avoid mixing channel inventories and misleading CTR or efficiency averages.

## What should you check before the next lesson?

- Ads data source on owner credentials.
- Conversion labelled.
- Freshness note in footer.

Previous: [Build a GA4 marketing dashboard in Looker Studio](https://mentionx.ai/learn/looker-studio/looker-studio-ga4-marketing-dashboard). Next: [Build a Search Console dashboard in Looker Studio](https://mentionx.ai/learn/looker-studio/looker-studio-search-console-dashboard). Or return to the [Looker Studio for Marketers track](https://mentionx.ai/learn/looker-studio/looker-studio-for-marketers). Related: [Google Ads for Marketers](https://mentionx.ai/learn/google-ads/google-ads-for-marketers), [Google Ads GA4 key events import](https://mentionx.ai/learn/google-ads/google-ads-ga4-key-events-import), [Google Ads monthly review routine](https://mentionx.ai/learn/google-ads/google-ads-monthly-review-routine).

## Common questions

**How many Google Ads sub-accounts can one data source cover?** Google documents that manager (MCC) accounts can connect and report on up to 50 sub-accounts per data source.

**Why is Ads data in Data Studio not identical to the Ads UI at noon?** Google Ads freshness in Data Studio is fixed at every 12 hours. The live Ads UI can move faster. State that in the footer.

**Should conversion columns match GA4 key events?** Not automatically. Align conversion actions in Google Ads with imported GA4 key events where that is your source of truth, and label which conversion column the dashboard uses.
## Sources

- Google Cloud, [Connect to Google Ads](https://cloud.google.com/looker/docs/studio/connect-to-google-ads)
- Google Cloud, [Manage data freshness](https://cloud.google.com/looker/docs/studio/manage-data-freshness)
- All accessed 5 Nov 2026.

## Frequently asked questions

### How many Google Ads sub-accounts can one data source cover?

Google documents that manager (MCC) accounts can connect and report on up to 50 sub-accounts per data source.

### Why is Ads data in Data Studio not identical to the Ads UI at noon?

Google Ads freshness in Data Studio is fixed at every 12 hours. The live Ads UI can move faster. State that in the footer.

### Should conversion columns match GA4 key events?

Not automatically. Align conversion actions in Google Ads with imported GA4 key events where that is your source of truth, and label which conversion column the dashboard uses.

---

Written and reviewed by Dipuck Jones for MentionX Learn. The HTML version of this page: https://mentionx.ai/learn/looker-studio/looker-studio-google-ads-dashboard