Google Ads connects to Data Studio through a free, Google-built connector in under two minutes. The connection is the easy part. The thing that catches people is choosing between a single account and a manager (MCC) account, because that choice decides whether your report can ever show more than one client.
What you need first
- A Google account with access to the Google Ads account — read access is enough
- The Customer ID if you’re picking from a long list (top-right in Google Ads, formatted 123-456-7890)
- Nothing else. Free and native, no connector subscription.
Connect Google Ads, step by step
- Go to datastudio.google.com, signed in with the account that has Ads access.
- Create → Data source.
- Choose “Google Ads” — marked By Google.
- Pick the account. Both individual accounts and manager (MCC) accounts appear here.
- Choose the account type — see below, this is the decision that matters.
- Connect, then Create report.
Single account or manager account?
| Choice | Use it when | Consequence |
|---|---|---|
| Single account | One advertiser, one report | Simplest. Adding a second client later means a second data source. |
| Manager (MCC) | An agency reporting on many accounts | One source covers all sub-accounts, with an Account name dimension to filter by — but numbers roll up unless you filter, so a scorecard shows every client combined. |
If you’re an agency, connect at the manager level and add an account filter control to the page. Building one report per client from single-account sources works, but you’ll be maintaining fifteen near-identical reports within a year.
How to check it worked
Add scorecards for Cost and Clicks over the last 28 days and compare with Google Ads itself.
Two things that make numbers differ legitimately: time zone (the data source uses the Ads account’s time zone, which may not be yours) and currency — a manager account aggregating sub-accounts in different currencies will produce a Cost figure that means nothing. If you report across currencies, filter to one account or convert deliberately with a calculated field.
Three things worth knowing early
- Conversions are defined in Google Ads, not here. If your conversion column looks wrong, the fix is in the Ads account’s conversion settings — Data Studio only reports what Ads reports.
- Attribution follows the Ads account. Change the attribution model in Google Ads and historical numbers in your Data Studio report change with it. That surprises people mid-quarter.
- Not every Ads report type is exposed. The connector covers campaign, ad group, keyword and ad-level data well. Some specialised reports — auction insights especially — aren’t available and can’t be reconstructed.
What to build first
- Cost, clicks, conversions and cost per conversion as scorecards with a previous-period comparison
- Cost and conversions over time on a combo chart — spend and result on one picture
- Campaign table sorted by cost, showing CTR, CPC, conversions and cost per conversion
- Search terms or keywords, sorted by spend, to spot budget going nowhere
The single most useful calculated field for a Google Ads report is a wasted-spend flag: cost above some threshold with zero conversions. A CASE statement on those two fields turns a keyword table into a to-do list, which is what a client actually wants.
Comparing Google Ads with other channels
The obvious next question is how paid search compares to paid social — and here the free path stops.
Google Ads is native and free. Meta, LinkedIn, TikTok and Microsoft Ads have no native connector at all, so a genuine cross-channel report needs a paid one. Before you buy, check whether the comparison you want is actually cross-channel: plenty of “PPC reports” are Google-only and cost nothing.
If you do need it, entry tiers are around $23–32 a month — Windsor.ai is the cheapest way in for multi-client work (75 accounts on the entry plan), Coupler.io suits you if the same data also needs to reach Sheets or a warehouse, and Supermetrics is the established choice at agency scale.
Frequently asked questions
Is the Google Ads connector free?
Yes — built by Google, listed under “By Google”, and free. Data Studio itself is free too.
Should I connect a single account or my manager account?
Manager if you report on more than one advertiser, then add an account filter. Single account is simpler for one advertiser but doesn’t scale.
Why don’t my costs match Google Ads exactly?
Usually time zone or currency. The data source uses the Ads account’s time zone, and a manager account mixing currencies produces a meaningless combined Cost.
Can I see auction insights in Data Studio?
No. Some specialised Google Ads reports, auction insights among them, aren’t exposed by the connector.
Why did my historical conversion numbers change?
Attribution is defined in Google Ads, not Data Studio. Changing the attribution model there changes what the connector reports, including for past periods.
Can I show Google Ads and Meta Ads in one report?
Yes, but Meta needs a paid third-party connector — Google provides no native one. Google Ads on its own stays free.