Connect to Google Data Studio

Visualize Ad Manager reports in Data Studio

You can add Ad Manager as a data source in Data Studio to create data visualization reports. The most popular Ad Manager report dimensions and metrics are available. These reports can be securely shared with others in your organization or publicly.

Learn more in the Data Studio Help Center.

Get started

Enable Data Studio reporting for your Ad Manager network

  1. Sign in to Google Ad Manager.
  2. Click Admin and then Global settings.
  3. Check the Ad Manager Reporting in Google Data Studio checkbox. 

     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 Data Studio reports.
  4. Add the View and share access to Ad Manager data in Google Data Studio permission.
  5. Click Save.

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

Add Ad Manager as a data source in Google Data Studio

  1. Sign in to Data Studio.
  2. On the left, navigate to the DATA SOURCES Home page.
  3. In the top left, click , then select Data Source.
  4. Select the Ad Manager connector.
  5. If prompted to grant Data Studio access to your account, click AUTHORIZE.
    You can revoke this access at any time.
  6. Click Available networks and then choose the Ad Manager network you enabled and then choose Ad Manager as the report type.

    The Ad Manager report type represents "Historical" reports in Ad Manager.

  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 Google Data Studio" network setting and that your Ad Manager user role has the "View and share access to Ad Manager data in Google Data Studio" permission. All Ad Manager networks associated with your Google account appear here, even if these settings are not enabled.

Create, share, and view reports

Create reports using your new Ad Manager data source to visualize Ad Manager reporting data. 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 Data Studio reports. Use the Demand channel dimension field to see Ad server, AdSense, and Ad Exchange subtotals.

Share reports with other people, similar to how you share in Google Drive, 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.

Find help or provide feedback

The best resource for answering questions are the Data Studio Help Center and the Data Studio product forum. You can also provide feedback to Google with suggestions for the product, votes for new dimensions or metrics, or other product issues you encounter.

Google support teams cannot provide assistance with Data Studio reports.

Common questions

Why is my Data 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 Data Studio and the Ad Manager API for your network are prioritized below requests from Ad Manager Query Tool. If many users in your network are running Ad Manager reports, your Data Studio reports might load more slowly.

How can I make my Data 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 query to Ad Manager, so many charts compete for your network's allotted Query Tool resources.
Was this helpful?
How can we improve it?