Google Display & Video 360 Setup Guide
Follow our setup guide to connect Google Display & Video 360 to Fivetran.
Prerequisites
To connect Google Display & Video 360 to Fivetran, you need the following:
- A Google account
- An active Google Display & Video 360 subscription
- A Google Display & Video 360 user account with an Admin role or a Standard role
Setup instructions
In the connector setup form, enter the Destination schema name of your choice.
Enter the Destination table name.
Click Authorize to allow Fivetran to access your Google Display & Video 360 account using OAuth.
Select your Google account and click Allow. You will be redirected back to the setup form.
Select the Report Configuration Method you want to use. You can either configure a new report manually, or reuse the configuration of a query that already exists in your Google Display & Video 360 account.
If you choose Create new configuration:
(Optional) If you only want to include in your reports data for specific partners or advertisers, select them in the Partners and Advertisers drop-down menus, respectively. The Advertisers drop-down menu contains all the advertisers available for the selected partners. If you want to include data for all available partners or all available advertisers, don't select any value in the corresponding drop-down menu.
In the Report Type drop-down menu, select the report type you want to sync. The default value is
TYPE_GENERAL
.In the Dimensions and Metrics drop-down menus, select the fields you want to include in your reports. If there are several fields with the same name that relate to different keys in the Google Display & Video 360 API format, the relevant key for each field is provided in square brackets. For example, the menu will display
Age [FILTER_TRUEVIEW_AGE]
forFILTER_TRUEVIEW_AGE
. TheDate
dimension is mandatory and must always be included.NOTE: Some combinations of selected dimensions and metrics may be invalid. In that case, the setup test will return an error description received from the Google Display & Video 360 API. Ensure the combination of selected dimensions and metrics is valid using your Google Display & Video 360 UI.
If you choose Reuse existing configuration:
In the Query drop-down menu, select the query containing the report configuration you want to reuse. The selected query must contain the
Date
dimension.NOTE:
ONE_TIME
queries cannot be selected for the Reuse existing configuration option.Keep Update Configuration Before Each Sync toggled on if you want to update the report configuration before each sync. This is required if you want to automatically apply the changes you make to the query in your Google Display & Video 360 account. If this option is disabled, the query configuration will only be updated when you save the connector settings.
NOTE: If an attempt to find the specified query is unsuccessful, the connector will throw a Reconnect Task.
In the Historical Sync Time Frame drop-down menu, select the number of months you want to include in your first sync.
NOTE: Selecting some particular dimensions or specifying some particular report types can impose limitations on the historical sync time frame. The time frame of the
TYPE_GENERAL
reports can't exceed 24 months. If the selected time frame is not compatible with the report configuration, Fivetran will adjust the time frame automatically.Click Save & Test. Fivetran will take it from here and sync your Google Display & Video 360 data.
Related articles
description Connector Overview
account_tree Schema Information
settings API Connector Configuration