Collecting data from Google Display & Video 360

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

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 configuration page.

    • To list advertisers or partners in the 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 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 to collect data from any are explained in our guide to Collecting data in Adverity. This guide contains information about the specific steps to create a 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 configuration, follow these steps:

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

  2. (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, will fetch data for all partners except the selected option.

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

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

  5. In Metadata type, select the metadata report type for which you want to collect data.

    Note

    The Users metadata type is available only when using the Service account authorization. For more information, see the Google documentation.

  6. Select the Include archived line items checkbox to collect this data.

  7. In Targeting type, select the targeting type for which to collect data.

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

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

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

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, automatically creates a “no_date” extract for the empty dates. A warning is displayed in the normal extract explaining this.

image1

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 s and s#

To validate possible combinations of s and s, 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.

Hint

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 filter with a JSON expression#

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

To configure data collection from a , follow these steps:

  1. Go to the Datastreams page.

  2. Open the Google Display & Video 360 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 value you want to include in the filter. Find the name of the in this list of filters.

And value is the 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 as follows:

  • The values to retrieve are 8069163 and 8067471 for the 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"
  }
]
Contents