Connect Google Ad Manager to Google Data Studio with Windsor.ai
Directly connect Google Ad Manager to Google Data Studio, in minutes, and in an easy-to-use format.
About Google Ad Manager
Google Ad Manager is an ad management platform for large publishers who have significant direct sales. Ad Manager provides granular controls and supports multiple ad exchanges and networks, including AdSense, Ad Exchange, third-party networks, and third-party exchanges.
Learn more about Google Ad Manager
About Google Data Studio
Looker Studio or formerly known as Google Data Studio is a data visualization platform that helps businesses convert data into customizable informative reports and dashboards. It provides a simple and intuitive interface for users to create interactive reports and visualizations with their data. Data analysis using Google Data Studio provides businesses with valuable information that they can use to make informed decisions about their operations.
Learn more about Google Data Studio
About the Google Ad Manager Google Data Studio Connector
The Google Ad Manager Google Data Studio connector pulls metrics and dimensions from Google Ad Manager. The insights are retrieved at the account, campaign, placement and line item level.
Once the user successfully logs into the connector it’s possible to choose the metrics and dimensions to create a report.
Prerequisites
To set up the connector, the user should have:
- Access to a Google Ad Manager account.
- Google account for Google Ad Manager to Google Data Studio integration.
- A Windsor account. Start your free trial now.
(Visit our privacy policy and terms of use)
How to connect Google Ad Manager to Google Data Studio?
Step 1: Select Google Ad Manager as a Data Source and grant access to Windsor.ai.
Step 2: Go to “Select Destination” and select Google Data Studio as a data destination.
Step 3: Select the fields on the right, and click on Google Data Studio (Looker Studio) destination.
Step 4: Select the connect and authorize access to your data source.
Google Data Studio Templates for Google Ad Manager
Do you plan to connect and visualize Google Ad Manager data in Google Data Studio?
These free and customizable Google Data Studio Google Ad Manager templates will assist you in visualizing your data for easy reporting and analysis.
Google Data Studio Tutorials for Google Ad Manager
Would you like to take your Google Data Studio Google Ad Manager dashboards to the next level?
Here are some of our favorite tutorials to help you:
Available Google Ad Manager Metrics and Dimensions
| Name | Type | Description |
|---|---|---|
| Account id | TEXT | Breaks down reporting data by advertising company Company.id. Can be used to filter by Company.id. Compatible with any of the following report types: Historical, Future sell-through, Reach, Ad speed. |
| Account name | TEXT | Breaks down reporting data by advertising company. Company.name and Company.id are automatically included as columns in the report. Can be used to filter by Company.name. Corresponds to "Advertiser" in the Ad Manager UI. Compatible with any of the following report types: Historical, Future sell-through, Reach, Ad speed. |
| Ad network id | TEXT | The network that provided the ad for SDK ad mediation. If selected for a report, that report will include only SDK mediation ads and will not contain non-SDK mediation ads. SDK mediation ads are ads for mobile devices. They have a list of ad networks which can provide ads to serve. Not every ad network will have an ad to serve so the device will try each network one-by-one until it finds an ad network with an ad to serve. The ad network that ends up serving the ad will appear here. Note that this id does not correlate to anything in the companies table and is not the same id as is served by ADVERTISER_ID. Compatible with any of the following report types: Historical, Reach. |
| Ad network name | TEXT | Name of the ad network. |
| Ad server clicks | NUMERIC | The number of clicks delivered by the ad server. |
| Ad server CTR | PERCENT | The CTR for an ad delivered by the ad server. |
| Ad server impressions | NUMERIC | The number of impressions delivered by the ad server. |
| Ad server targeted impressions | NUMERIC | The number of impressions delivered by the ad server by explicit custom criteria targeting. |
| Ad unit id | TEXT | The id of the ad unit. |
| Ad unit name | TEXT | The name of the ad unit. |
| AdSense impressions | NUMERIC | The number of impressions an AdSense ad delivered for line item-level dynamic allocation. Compatible with the "Historical" report type. |
| Advertiser | TEXT | The name of the advertiser company assigned to an order. |
| Advertiser id | TEXT | The id of the advertiser company assigned to an order. |
| Campaign | TEXT | Breaks down reporting data by placement. Placement.name and Placement.id are automatically included as columns in the report. Can be used to filter by Placement.name. Corresponds to "Placement" in the Ad Manager UI. Compatible with any of the following report types: Historical, Future sell-through, Reach. |
| Clicks | NUMERIC | The number of clicks delivered by the ad server. Corresponds to "Ad server clicks" in the Ad Manager UI. Compatible with the "Historical" report type. |
| Country | COUNTRY | Country associated to IP address from ad slot request |
| Creative | TEXT | The name of the Creative that served to the ad slot request. |
| Creative size | TEXT | Size of creative that served to the ad slot request. Creative size does not represent the actual size of a creative being served. |
| Creative type | TEXT | Type of creative that served to the ad slot request. |
| Date | DATE | Breaks down reporting data by date in the network time zone. Can be used to filter by date using ISO 8601's format 'YYYY-MM-DD'". Note: In v201802 and later, this dimension is compatible with the following time zone types: TimeZoneType.PUBLISHER TimeZoneType.PROPOSAL_LOCAL Corresponds to "Date" in the Ad Manager UI. Compatible with any of the following report types: Historical, Future sell-through, Reach, Ad speed. |
| Impressions | NUMERIC | The number of impressions an AdSense ad delivered for line item-level dynamic allocation. Corresponds to "AdSense impressions" in the Ad Manager UI. Compatible with the "Historical" report type. |
| Line item Delivery Indicator | TEXT | Indicates the progress made for the delivery of the line item. |
| Line item Delivery pacing | TEXT | Represents delivery rate type for the line item. |
| Line item id | TEXT | The id of the line item associated to the Creative that served to the ad slot request. |
| Line item name | TEXT | The name of the line item associated to the Creative that served to the ad slot request. |
| Line item type | TEXT | Type of line item associated to the Creative that served to the ad slot request. |
| Month and year | TEXT | Breaks down reporting data by month and year in the network time zone. Can be used to filter on month using ISO 4601 format 'YYYY-MM'. Note: In v201802 and later, this dimension is compatible with the following time zone types: TimeZoneType.PUBLISHER TimeZoneType.PROPOSAL_LOCAL Corresponds to "Month and year" in the Ad Manager UI. Compatible with any of the following report types: Historical, Future sell-through, Reach, Partner finance. |
| ORDER_DELIVERY_STATUS | TEXT | Delivery status of the order. Not available as a dimension to report on, but exists as a dimension in order to filter on it using PQL. Valid values are 'STARTED', 'NOT_STARTED' and 'COMPLETED'. Compatible with any of the following report types: Historical, Reach. |
| Order id | TEXT | The id of the Order associated to the line item linked to the Creative that served to the ad slot request. |
| Order name | TEXT | The name of the Order associated to the line item linked to the Creative that served to the ad slot request. |
| Placement id | TEXT | The id of the placement that currently includes an ad unit associated with an impression, click, or other event. |
| Placement name | TEXT | Name of the placement that currently includes an ad unit associated with an impression, click, or other event. |
| Region | TEXT | Region associated with the IP address included in the ad slot request. |
| Spend | NUMERIC | The total CPM and CPC revenue generated by the ad servers including line item-level dynamic allocation. Corresponds to "Total CPM and CPC revenue" in the Ad Manager UI. Compatible with the "Historical" report type. |
| Total ad requests | NUMERIC | The total number of times that an ad request is sent to the ad server including dynamic allocation. |
| Total clicks | NUMERIC | The total number of clicks delivered including line item-level dynamic allocation. |
| Total CTR | NUMERIC | The ratio of total clicks on ads delivered by the ad servers to the total number of impressions delivered for an ad including line item-level dynamic allocation. |
| Total impressions | NUMERIC | The total number of impressions delivered including line item-level dynamic allocation. |
| Total cost | NUMERIC | The total CPM and CPC revenue generated by the ad servers including line item-level dynamic allocation. Corresponds to "Total CPM and CPC revenue" in the Ad Manager UI. Compatible with the "Historical" report type. |
| Video viewership Average view rate | NUMERIC | Average percentage of the video watched by users. |
| Video viewership Average view time | NUMERIC | Average time(seconds) users watched the video. |
| Video viewership Complete | NUMERIC | The number of times the video played to completion. |
| Video viewership Completion rate | NUMERIC | Percentage of times the video played to the end. |
| Video viewership Engaged view | NUMERIC | The number of engaged views i.e. ad is viewed to completion or for 30s, whichever comes first. |
| Video viewership First quartile | NUMERIC | The number of times the video played to 25% of its length. |
| Video viewership midpoint | NUMERIC | The number of times the video reached its midpoint during play. |
| Video viewership Start | NUMERIC | The number of impressions where the video was played. |
| Video viewership third quartile | NUMERIC | The number of times the video played to 75% of its length. |
| Video viewership Video length | NUMERIC | Duration of the video creative. |
| Video viewership View-through rate | NUMERIC | View-through rate represented as a percentage. |