Notification

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

Connect to Google Ad Manager 360

Visualize Google Ad Manager reports in Looker Studio.

Google Ad Manager is a comprehensive hosted ad serving platform that streamlines your ad management, whether you deliver ads to websites, mobile webpages, mobile apps, games, or a combination. Ad Manager offers a complete toolkit to manage your ads for a multi-screen audience.

Add Google Ad Manager as a data source to visualize your Ad Manager reports in Looker Studio. The most popular Ad Manager report dimensions and metrics are available. These reports can be securely shared with others in your organization or publicly.

This feature is only available to Google Ad Manager 360 customers.

Get started

Enable Looker Studio reporting for your Ad Manager network

  1. Sign in to Google Ad Manager.
  2. Click Admin and then Global settings.
  3. Scroll down to "Report settings" and enable Reports in Looker Studio.
    Only available in Google Ad Manager 360.
  4. Click Save.

Add a new permission to Ad Manager user roles

  1. Sign in to Google Ad Manager.
  2. Click Admin and then Access & authorization and then Roles.
  3. Select the user role associated with users who need to create Looker Studio reports.
  4. Next to "Reporting," add the View and share access to reporting data in Looker Studio permission.
  5. Click Save.

The built-in "Administrator" and "Executive" roles already have this permission.

Add Ad Manager as a data source in Looker Studio

  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 Ad Manager connector.
  4. If prompted to grant Looker Studio access to your account, click AUTHORIZE.
    You can revoke this access at any time.
  5. Click Available networks.
  6. Select the Ad Manager network you enabled, then select Historical as the report type.
  7. In the upper right, click Connect.
    1. The data source fields panel appears.
    2. The data source is now connected to your data set.
  8. In the upper right, click Create report to develop your first report.
Unable to connect?
Make sure your Ad Manager network has enabled the "Ad Manager Reporting in Looker Studio" network setting and that your Ad Manager user role has the "View and share access to Ad Manager data in Looker Studio" permission. All Ad Manager networks associated with your Google account appear here, even if these settings are not enabled.

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.

Tips for creating Ad Manager reports in Looker Studio

Your new Ad Manager data source allows you to visualize Ad Manager reporting data in Looker Studio. The most popular dimensions and metrics from the "Historical" report type in Ad Manager are available. Use the Ad Manager report template to get started quickly.

The "Ad Exchange historical" report type and the key-values dimension are not available.

How to separate Ad server, AdSense, and Ad Exchange data
Only the Total report metrics are included in Looker Studio reports. Use the Demand channel dimension field to see Ad server, AdSense, and Ad Exchange subtotals.

Share reports with other people with view-only or edit access. When sharing a report, the data source access credentials you choose determine what users can see in the report.

Use caution when sharing
For optimal security, share reports with view-only access and use the viewer's data source credential. The "Viewer's credential" requires each report viewer to have Ad Manager access.

Permission to edit reports can allow any user to gain access to more than you intended to share. For example, if you share a report filtered by a particular advertiser, but grant edit access to users, they could remove that filter and see all of your data.

Common questions

Why is my Looker Studio report loading slowly?

To ensure a positive Ad Manager reporting experience, each Ad Manager network is allotted a set amount of resources for data requests. Data requests from Looker Studio and the Ad Manager API for your network are prioritized below requests from Ad Manager reporting. If many users in your network are running Ad Manager reports, your Looker Studio reports might load more slowly.

How can I make my Looker Studio reports faster?

  • Include fewer dimensions and metrics in your charts.
  • Reduce the date range of your charts.
  • Reduce the number of charts on each page of your report, or distribute large groups of charts across multiple pages. Each chart represents a report request to Ad Manager, so many charts compete for your network's allotted Ad Manager reporting resources.
  • See also: Improve Looker Studio performance

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.

Was this helpful?

How can we improve it?
Search
Clear search
Close search
Main menu
7492957818538901022
true
Search Help Center
true
true
true
true
true
102097
false
false