Google Ad Manager: Setup guide
On this page
This guide explains how to collect data from Google Ad Manager.
Introduction
For a list of the fields that you can collect from Google Ad Manager, see Google Ad Manager.
Prerequisites
Before you start collecting data from Google Ad Manager, perform all of the following actions:
-
Ensure that the account you use to connect to Google Ad Manager has at least Executive or similar permissions that allow you to select a network on which to collect data. For more information on roles, see the Google documentation.
Creating a datastream to collect data from Google Ad Manager
The basics of creating a datastream to collect data from any data source are explained in our guide to Collecting data in Adverity. This guide contains information about the specific steps to create a datastream to fetch data from Google Ad Manager.
Configuration: Choose the data you want to collect from Google Ad Manager
To choose what data to collect and customize the Google Ad Manager datastream configuration, follow these steps:
-
(Optional) Rename your datastream.
-
In Network, select the network on which to collect data. If you cannot see a network, your Google account may have insufficient privileges. For more information on account roles and permissions, see the Google documentation.
-
In Report type, select the type of data to collect from Google Ad Manager. The selected report type determines the additional fields to populate.
-
In Dimensions, change the list of fields you want to see in your data extract.
-
In Custom targeting keys, configure how to breakdown your data.
To use this option, select
CUSTOM_DIMENSIONin the Dimensions field. -
In Dimension attributes, select dimension attributes.
-
In Filter statement, enter the filters for the data using PQL. For more information, see Configuring filters.
-
In Columns and Custom fields, change the list of fields that you want to see in your data extract
-
In Date Range Type, select the date range for which to collect data.
-
In Ad Unit View, select for which ad units you want to collect data.
Tips and best practices
Configuring filters (PQL)
Enter PQL filter statements in JSON format in the Filter statement field. Examples:
Equality with AND:
[
"WHERE FIELD_NAME1 = 'value1' AND FIELD_NAME2 = 'value2'"
]
OR list:
[
"WHERE FIELD_NAME = 'value1' OR FIELD_NAME = 'value2'"
]
IN list:
[
"WHERE FIELD_NAME IN ('value1', 'value2')"
]
NOT IN list:
[
"WHERE NOT FIELD_NAME IN ('value1', 'value2')"
]
LIKE wildcard:
[
"WHERE FIELD_NAME LIKE 'string%'"
]
See the PQL reference: Google Ad Manager documentation.
What’s next?
-
Apply Data Mapping to your collected data to harmonize data collected from different sources in Adverity.
-
Transform your data to meet your needs by creating and applying transformations to your datastream.
-
Load your data into a warehouse to continue working with your data in Adverity.
-
Load your data into an external destination of your choice.