Collecting data from Google Ad Manager

This guide explains how to collect data from Google Ad Manager. To learn how to collect data from a different data source, go back to the Available data sources in Adverity overview.

Introduction

For a list of the fields that you can collect from Google Ad Manager, see Google Ad Manager.

  • Google Ad Manager can collect a maximum of 1 million rows per single report. To fetch more data than this, split your fetch into smaller date ranges in the Initial Fetch step of creating a datastream.

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 Creating a datastream. 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:

  1. (Optional) Rename your datastream.

  1. 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.

  1. In Report type, select the type of data to collect from Google Ad Manager. The selected report type determines the additional fields to populate.

    This guide explains the configuration for the Run Ad Hoc Query report type.

  1. In Dimensions, change the list of fields you want to see in your data extract.

  2. In Custom targeting keys, configure how to breakdown your data.

    To use this option, select CUSTOM_DIMENSION in the Dimensions field.

  3. In Dimension attributes, select dimension attributes.

  4. In Filter statement, enter the filters for the data using PQL. For more information, see Configuring filters.

    You can filter only by the fields selected in the datastream.

  5. In Columns and Custom fields, change the list of fields that you want to see in your data extract

  6. In Date Range Type, select the date range for which to collect data.

  7. In Ad Unit View, select for which ad units you want to collect data.

What's next?

Advanced Google Ad Manager tips

Configuring filters

To configure the query filter, enter the PQL query in the JSON format, for example:

[
	"WHERE FIELD_NAME = 'value'"
]

The following operators can be used in a query:

AND

This operator filters by multiple conditions using AND logic.

[
	"WHERE FIELD_NAME1 = 'value1' AND FIELD_NAME2 = 'value2'"
]

OR

This operator filters by multiple conditions using OR logic.

[
	"WHERE FIELD_NAME = 'value1' OR FIELD_NAME = 'value2'"
]

IN

This operator returns the matching values compared to a list.

[
	"WHERE FIELD_NAME IN ('value1', 'value2')"
]

NOT IN

This operator returns the non-matching values compared to a list.

[
	"WHERE NOT FIELD_NAME IN ('value1', 'value2')"
]

LIKE

This operator matches the field values to a wildcard.

The % symbol represents zero, one, or multiple characters.

[
	"WHERE FIELD_NAME LIKE 'string%'"
]

For more information about the PQL syntax, see the Google Ad Manager documentation.