Google Ads lets you reach potential customers with online ads. The Looker Studio Google Ads connector enables Google Ads advertisers to access performance report data within Looker Studio.
How to connect to Google Ads
A Looker Studio data source can connect to any one Google Ads account to which you have access. Google Ads users with manager (MCC) accounts can connect to and report on up to 50 sub-accounts per data source.
Select an individual account
On the Looker Studio home page, in the top left, click Create, and then select Data Source.
Select the Google Ads connector.
If prompted to grant Looker Studio access to your account, click AUTHORIZE.
You can revoke this access at any time.
Click ALL ACCOUNTS.
Select an account. You can search by account ID or by name.
Select Overall Account Fields .
The Overall Account Fields selection combines all your Google Ads fields into a single list for a selected customer account, which lets you combine the dimensions and metrics from any of your Google Ads reports in your Looker Studio reports.In the upper right, click CONNECT.
- The data source fields panel appears.
- The data source is now connected to your dataset.
Select manager (MCC) accounts
If you have access to a Google Ads manager account, you can select MANAGER ACCOUNTS in the Accounts panel. Select the account and any sub-accounts to include in this data source. You can select up to 50 sub-accounts.
Use the currency drop-down menu on the right to filter your accounts according to currency type.
If you select All currencies and choose accounts that use different currencies, Looker Studio converts all revenue-related fields to the currency of the top level manager (MCC) account. See How cost data is converted from other local currencies for more details on currency conversion.
Configure the data source
The data source fields panel is where you configure the data source by renaming fields and adding descriptions, adding calculated fields, and changing data types and aggregations. Learn more about working with data source fields.
Control who sees the data
At the top of the fields panel, you can change the data credentials. Credentials control who can see the data that this data source provides.
OWNER'S CREDENTIALS let other people view or create reports that use this data without requiring them to have their own access to the dataset.
VIEWER'S CREDENTIALS, on the other hand, require each user of the data source to provide their own credentials to access the dataset.
SERVICE ACCOUNT CREDENTIALS rely on a special type of Google Account that represents a non-human user that can authenticate and be authorized to access data.
Learn more about data credentials.
Create a new report from the data source
To create a new report from the data source, follow these steps:
- In the upper right, click CREATE REPORT. The report editor appears.
- Click ADD TO REPORT.
- This action adds the data source to the report.
- You can now create charts and controls that get their data from this data source.
New to Looker Studio?
Take the Create a report tutorial.
Notes
Zero impression entities
Entities, such as AdGroup or Campaign, with zero impressions won't appear in Google Ads data sources.
Creative assets reporting
The Google Ads connector for Looker Studio is aligned with the public Google Ads API for creative assets reporting. To return accurate results when using Clicks or Impressions metrics in combination with creative asset dimensions, be sure to also include the Ad Type and Asset ID dimensions in your chart. Otherwise, the chart may show inaccurate results. Charts that aren't correctly configured will display a message that warns you about the invalid combination of dimensions and metrics.
Auction Insights data
Starting on August 24, 2024, Auction Insights fields won't be available for new data sources in Looker Studio. Starting on September 23, 2024, existing data sources will lose access to Auction Insights fields. To prevent your reports breaking, we recommend removing these fields from your reports and charts:
- Auction Insight - Domain
- Auction Insight - avg. position
- Abs. top of page rate
- Position above rate
- Impr. share
- Outranking Share
- Overlap Rate
- Top of page rate
- Auction Insight - Store display name
- Shopping impression share
- Shopping outranking share
- Shopping overlap Rate
Frequently asked questions about Auction Insights deprecation
Why is Action Insights data being removed from Looker Studio?
The removal of this data is an update to the Looker Studio product.
Can I get an exception from this product change?
No. Auction Insights data will be removed from all Looker Studio reports without exception.
Will this affect existing reports that have Auction Insights data?
Yes. On September 23, 2024, the data connectors on Looker Studio will no longer return Auction Insights data. The data won't be available for new reports starting on August 24, 2024.
Will the rest of my report continue to function properly?
It depends on whether the specific charts include Auction Insights data. If your report includes Auction Insights data, it may no longer function properly.
Does it matter which connector I use to get Auction Insights?
No. This change will impact Auction Insights data regardless of the connector that is used to access it. These include (but are not limited to) the Google Ads, BigQuery, and Google Sheets connectors.