Unlike Meta Ads, Google Ads ships with a free, native Looker Studio connector maintained directly by Google. Connecting takes two minutes. What takes longer — and what most tutorials skip — is understanding which metrics actually come through, how to handle data freshness, and how to cross these numbers with real Shopify sales without producing a misleading report.
This guide covers setup, the Google Ads-specific data traps, and which architecture to adopt based on your needs.
Basic setup: two minutes
In Looker Studio, create a new data source and select the Google Ads connector from the Google connectors list. Authorize access with the Google account that has rights on your ad account, then choose the account to connect.
Two modes at this step:
Individual account — you select one specific ad account. Simple, fine if you only manage one.
Manager account (MCC) — you connect the parent account overseeing multiple client accounts. Data from all accounts comes through with a dimension to filter by account. This is the option to favor as soon as you manage multiple stores or clients, since it avoids maintaining a growing pile of separate data sources.
Once the source is created, Google Ads fields (impressions, clicks, cost, conversions, conversion value, etc.) are directly available in your charts.
What actually comes through — and what’s missing
The native connector exposes most of the metrics from the Google Ads interface: performance by campaign, ad group, keyword, device, and geography, with standard metrics (impressions, clicks, CTR, CPC, cost, conversions, conversion value, calculable ROAS).
What’s unavailable or limited:
- The search terms report isn’t exposed by the connector — you have to check it in the Google Ads interface or export it separately. That’s an annoying gap, since search terms are exactly where you find queries worth excluding.
- Performance Max data is partially available: overall campaign ROAS comes through, but channel-level breakdown (Search, Display, YouTube) stays as limited as it is in the interface — we cover this in our article on Google Ads KPIs for Shopify.
- Merchant Center metrics (product feed quality) aren’t in this connector — you’d need the separate Merchant Center connector.
Trap number one: the conversion attribution date
This is the most common source of confusion in Google Ads reporting, and it’s worth understanding before building anything.
Google Ads attributes a conversion to the click date, not the date the conversion actually happened. Concretely: a user clicks your ad on August 1st and buys on August 5th. Google Ads records that conversion on August 1st, retroactively.
Direct consequence: a report you check today covering the last 7 days will show numbers that keep increasing over the following days, as delayed conversions get backfilled. Data from the last 3-7 days is therefore systematically understated at the moment you look at it.
How to handle it: exclude the last 3 days from trend analysis, or add a visible note on the dashboard indicating that recent data is incomplete. Without that, you’ll wrongly conclude that performance is dropping at the end of every period.
Crossing Google Ads with real Shopify sales
The Google Ads connector gives you spend and conversions as Google counts them. Your real sales live in Shopify. These two figures will never match exactly, for the structural reasons we detail in our attribution guide.
For a dashboard that makes sense:
- Display Google Ads spend (source: Google Ads connector) and real Shopify revenue (source: Shopify export or BigQuery) separately, with the source labeled on each scorecard
- Calculate a blended ROAS (total Shopify revenue ÷ total spend across all platforms) rather than stacking each platform’s self-reported ROAS
- Keep native Google Ads ROAS for arbitrating between Google campaigns, not as an absolute profitability measure
That’s exactly the structuring logic covered in our Looker Studio dashboard guide.
When to move to BigQuery
The native connector is plenty for standard campaign reporting. Three signals indicate it’s time to move to BigQuery:
- You want more than 12-18 months of history for reliable year-over-year comparisons
- You need to join Google Ads with Shopify at the data level (real margin by campaign, LTV by acquisition source)
- You manage multiple accounts and the report is getting slow — API quotas and query volume eventually degrade the experience
The Google Ads → BigQuery transfer is configured through the BigQuery Data Transfer Service, which populates daily tables automatically with no code to maintain.
FAQ
Is the Google Ads connector for Looker Studio free? Yes, entirely. Unlike Meta Ads, which requires a paid third-party connector, Google Ads has a free native connector maintained by Google, with no limit on accounts or data volume.
Can I connect multiple Google Ads accounts in one report? Yes. You can either add multiple data sources (one per account) or connect a manager account (MCC) directly to aggregate everything — the second option is far easier to maintain across several accounts.
Why do conversions in Looker Studio differ from the Google Ads interface? Usually because of the conversion window: Google Ads attributes a conversion to the click date, not the date the conversion happened. A report on the last 7 days will therefore show numbers that keep changing in the following days.
Want a dashboard that centralizes Google Ads, your other ad platforms, and real Shopify sales without guesswork? Check out our Shopify Dashboards offer or book a free 30-minute call.