Notification

This Help Center is moving to Cloud. Learn more about the migration.

Connect to Google Ads

Connect Looker Studio to Google Ads reports.

Google Ads allows you to reach potential customers with online ads. The Looker Studio Google Ads connector enables Google Ads advertisers to access performance report data within Looker Studio.

In this article:

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

  1. Sign in to Looker Studio.
  2. On the Looker Studio home page, in the top left, click The Create icon. Create, and then select Data Source.
  3. Select the Google Ads connector.
  4. If prompted to grant Looker Studio access to your account, click AUTHORIZE.
    You can revoke this access at any time.
  5. Click ALL ACCOUNTS.
  6. Select an account. You can search by account ID or by name.
  7. 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.
  8. In the upper right, click CONNECT.
    1. The data source fields panel appears.
    2. 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.

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:

  1. In the upper right, click CREATE REPORT. The report editor appears.
  2. Click ADD TO REPORT.
    1. This action adds the data source to the report.
    2. 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. Or learn more about the report editor.

Want to use this data source with different accounts? Try adding a data control.

The data control gives report viewers a way to select the account that provides the data they want to see in a report. This can eliminate the need to create separate reports and data sources for your various accounts. Learn more.

Notes

Zero impression entities

Entities, such as AdGroup or Campaign, with zero impressions will not 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 will not 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 will not 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. 

Learn more about Google Ads

Was this helpful?

How can we improve it?
Search
Clear search
Close search
Google apps
Main menu