Your guide to Google Display & Video 360

This guide contains detailed information about collecting data from Google Display & Video 360.

Introduction

This guide contains detailed information about using Google Display & Video 360 in Adverity.

To create a datastream to collect data from Google Display & Video 360, follow the steps in our guide to Collecting data in Adverity. If these steps are not detailed enough, refer back to this Google Display & Video 360 guide for detailed configuration instructions.

For more information on the data fields that you can collect from Google Display & Video 360, see List of supported fields.

Prerequisites

Before you start collecting data from Google Display & Video 360, perform all of the following actions:

To collect data for advertisers or partners, you need to select their IDs in the datastream configuration page.
- To list advertisers or partners in the datastream configuration page, ensure that the account you use to connect to Google Display & Video 360 has Read only or higher role. For more information, see the Google documentation.
- With Reporting only role, you can still collect data for advertisers or partners, but you need to enter the IDs in the Advertiser and Partner fields in the Google Display & Video 360 datastream configuration page.
To collect data about meta fields, ensure that the account you use to connect to Google Display & Video 360 has Standard or higher role.

Creating a datastream to collect data from Google Display & Video 360

This section of the Google Display & Video 360 guide contains information specific to Google Display & Video 360. Not all steps in the datastream creation process will be described here. If a step is not described here, follow the process in our guide to Collecting data in Adverity.

Configuration: Choose the data you want to collect from Google Display & Video 360

To choose what data to collect and customize the Google Display & Video 360 datastream configuration, follow these steps:

(Optional) Rename your datastream.

In Partners and Advertisers, select the partners and advertisers for which to collect data.

In Group by, Meta fields, and Metrics, change the list of fields that you want to see in your data extract.

(Optional) In Dimension Filter, enter a valid JSON expression. For more information, see Configuring the dimension filter with a JSON expression.

What's next?

Apply Data Mapping to your collected data to harmonize data collected from different sources in Adverity.
Store your data in Adverity Data Storage for further analysis in Adverity.
Transform your data to meet your needs by creating and applying enrichments to your datastream.

Troubleshooting Google Display & Video 360

The Missing Migration Mode field appears when configuring my Google Display & Video 360 datastream

This field may not be present if you are configuring a recently created datastream. If this field is present, this means the datastream is connected to the older version of Google Display & Video 360.

Select Keep field names to retain the legacy field names for an older authorization to Google Display & Video 360. Select Rename fields to update the old field names to the new field names.

There are empty fields in the date column in the data I have collected from Google Display & Video 360

When you fetch data from Google Display & Video 360, if there are empty fields in the date column, Adverity automatically creates a "no_date" extract for the empty dates. A warning is displayed in the normal extract explaining this.

This example shows the normal extract (with the date in the extract title) and the "no_date" extract below

Advanced Google Display & Video 360 tips

Validating combinations of metrics and dimensions

To validate possible combinations of metrics and dimensions, use the Google Display & Video 360 user interface. Create an offline report where you select the desired combination of fields and set additional options. If you select invalid options and try to save the report, Google Display & Video 360 informs you about the correct options. Until you use the correct options, you are not able to save the report.

For example, to save the audience composition report type, set one of the following filters in the Google Display & Video 360 user interface:

Partner
Advertiser

Configuring the dimension filter with a JSON expression

When configuring a Google Display & Video 360 datastream, you can configure a dimension filter for most Datastream Types. Enter a JSON expression into the dimension filter to collect data on certain fields. Use the dimension filter to collect highly-specific data from your data source.

To configure data collection from a datastream, follow these steps:

Select the workspace you work with in Adverity and then, in the platform navigation menu, click Datastreams.
Open the Google Display & Video 360 datastream by clicking on its name.
In the top navigation panel, click Settings.
In Dimension Filter, enter a valid JSON expression. See below for an example of a valid JSON expression.
Click Save.

Examples of a JSON expression

Typically, a JSON expression would take the following format.

{
  "type": string,
  "value": string
}

Where type is the name of the column that contains the dimension value you want to include in the filter. Find the name of the dimension in this list of filters.

And value is the dimension value by which you want to filter your data.

You can use multiple expressions within a single JSON expression. For example, use a JSON expression to retrieve two specific values from a Google Display & Video 360 datastream as follows:

The values to retrieve are 8069163 and 8067471 for the dimension FILTER_ADVERTISER.

To retrieve this set of data, enter the following JSON expression into Dimension Filter.

[
  {
    "type": "FILTER_ADVERTISER",
    "value": "8069163"
  },
  {
    "type": "FILTER_ADVERTISER",
    "value": "8067471"
  }
]