Collecting data from Google Display & Video 360

This guide explains how to collect data from Google Display & Video 360. 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 Display & Video 360, see Google Display & Video 360.

  • Google Display & Video 360 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 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

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 Display & Video 360.

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:

  1. (Optional) Rename your datastream.

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

  1. (Optional) To reverse the selection, select the Exclude partners and/or Exclude advertisers checkbox.

    For example, if you select one partner in the Partners field and select the Exclude partners checkbox, Adverity will fetch data for all partners except the selected option.

  1. In Report type, select the type of data to collect from Google Display & Video 360.

  1. If you selected the Custom report type, fill in the following fields. For all other report types, go to the next step.

    • In Query ID, select the query that you want to use to collect data.

    • In Timezone, select the time zone in which you want to collect data.

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

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

  2. (Optional) Select the Include only targeted user lists checkbox to only collect data for the user lists targeted in the dimension filter above.

What's next?

Troubleshooting Google Display & Video 360

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:

  1. Select the workspace you work with in Adverity and then, in the platform navigation menu, click Datastreams.

  2. Open the Google Display & Video 360 datastream by clicking on its name.

  3. In the top navigation panel, click Settings.

  4. In Dimension Filter, enter a valid JSON expression. See below for an example of a valid JSON expression.

  5. 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"
  }
]