Display&Video 360 Source

Renta supports data export from Display & Video 360 to the following destinations:

  • Snowflake

  • Google BigQuery

  • Amazon S3

  • Clickhouse

  • SQL Server

  • Google Spreadsheets

Integration creating in data warehouse

  1. Go to the integrations catalog;

  2. Select Display & Video 360;

  3. Add a Display & Video 360account that has the necessary data;

  4. Choose the added Display & Video 360account;

  5. Specify the destination you want to import the data into;

  6. Go to the settings screen and set the necessary configuration:

Partners

The account in Display & Video 360 has the necessary data.

Advertisers account

The account of the advertiser.

Parameters

Parameters are the dimensions and metrics that are available in Display & Video 360API. You should specify parameters that are necessary for inserting.
Renta will create the table, which will automatically update by the given update settings.
The order of the chosen parameters in the Rentas interface will be equal to the tables column sequence.

Data range type

Choose the inserting period. You can specify any historical time interval.
In order to choose the required time, enter the date you want to start uploading data from in the "From" field, then enter the end date in the "To" field.
If you want the data in the table to update daily and be complemented by new days, you can set "yesterday" in the "To" field.

Integration name

There is an auto-generated name for your integration and here you can edit it as much as you like.
Both Cyrillic and Latin are permitted, but not more than 100 symbols.

Table name

There is an auto-generated name for your table and here you can edit it as much as you like.
Only Latin is permitted, with numbers and “_” symbol.

Data Updating

Following updating settings are available for Display & Video 360:

Update time

You can specify any update time that you need. Users choose early morning integration updates most often, for example 5 AM.
In that case, your integration will update in the period from 5 AM to 6 AM.

Overwrite period

Overwrite period means rewriting historical data for a specified period of time.
For instance, if you choose the overwrite period “Last 7 days” - it means that all data for the last 7 days will be deleted and inserted once again with updated data.
Note: this tab appears only if parameters like Day/Date/Time Period etc have been chosen.