Display & Video 360

Renta exports Display & Video 360 statistics to your data warehouse, together with the campaigns, insertion orders, line items, creatives, and other objects behind them.

You assemble the statistics report yourself from Bid Manager dimensions and metrics, so one row covers one combination of the dimensions you grouped by.

The object report types describe the account as it looks right now: identifiers, names, statuses, budgets, flight dates, and bid strategies.

Authentication

Renta uses OAuth to authenticate with Google. You will be redirected to Google to grant Renta access to your Display & Video 360 account.

Google offers a single combined permission for entities and reports, so the consent screen mentions editing and deleting. Renta writes nothing to your campaign structure. It creates a temporary reporting query, downloads the result, and deletes the query afterwards.

Connect Display & Video 360 as a source

Go to the CatalogStep 1

1. In the Renta console, open Connections > Catalog in the left sidebar.
2. Open the Advertising category and click the Display & Video 360 card.

Start the authorizationStep 2

Click Log in to your Display & Video 360 account. Renta hands you over to Google, where you pick the account that has access to the partners and advertisers you need.

Grant accessStep 3

Google lists the two permissions Renta asks for: your Display & Video 360 entities and reports, and your reports in DoubleClick Bid Manager. Click Allow to return to Renta.

Name the connection and saveStep 4

Finish the setup:

1. Source name.
   A label for this connection, used only inside the Renta console.
2. Access granted.
   The email of the Google account the authorization came from.

Click Save to finish.

If the authorization later stops working, for example after the Google password changed or the app was removed from the account, click Re-authorize on this connection. It refreshes in place and the pipelines built on it keep running.

Verify the connectionStep 5

The connection appears in the Sources list with the Active status and is ready for pipelines.

Create a Display & Video 360 pipeline

Select Display & Video 360 as the sourceStep 1

In the left sidebar, click New pipeline. Keep the ETL tab selected, find Display & Video 360 under Already connected, and click Next step.

Select the connectionStep 2

Choose the Display & Video 360 connection you created and click Next step. The card shows the Google account behind it, which matters when several people connected different accounts.

Select a destinationStep 3

On the Destination step, pick the warehouse that receives the data and click Next step.

Select the destination connectionStep 4

Choose the destination connection and click Next step.

Pipeline configuration

The last step of the wizard holds every setting in one scrolling form.

Partners

Partners scope the pipeline to a part of your Display & Video 360 account.

The list holds the partners your authorized Google account can reach, each with its numeric identifier below the name. Pick at least one for every report type except Partners, which covers the whole account on its own.

Advertisers

Advertisers decide whose campaigns, entities and statistics the pipeline loads.

Tick as many as you need. They all land in one table. The Partners and Advertisers report types ignore this setting, every other report type requires it.

Report type

The report type decides what the pipeline extracts.

Parameters

Tick the Display & Video 360 fields that become columns of the destination table.

For Custom Report the picker holds the whole Bid Manager reference: dimensions to group the report by, then metrics to aggregate. The list runs into hundreds of entries, so the search field is the fastest way to a field you already know by name. A report needs at least one metric.

Date and Advertiser Currency arrive pre-selected and cannot be cleared. Date is what the destination table is partitioned by. Advertiser Currency is required by the API for every report that carries a cost or revenue metric.

Money metrics of the custom report arrive in the advertiser currency. Percentage metrics lose the percent sign on the way, so a click-through rate of 0.601% is stored as the number 0.601.

The entity report types keep the shape of the Display & Video 360 API. Money fields there come in micros, one millionth of the currency unit, so a daily pacing cap of 25 arrives as 25000000. Settings that the API returns as one of several possible objects, such as Bid Strategy and Integration Details, are stored as JSON, and repeating blocks such as Budget Segments and Partner Costs become arrays of records.

Integration and table name

Name the pipeline in Renta and the table in your destination.

1. Integration name.
   The display name of the pipeline in the Renta console.
2. Table name.
   The table in your destination. Keep the generated name or type your own.

Date range

The date range sets the history the pipeline loads on its first run.

1. Date start.
   The first day of statistics to load.
2. Date end.
   The last one, either a fixed date or a moving boundary such as Today.

Overwrite period

The overwrite period defines how far back each scheduled run reloads days it has already loaded.

Display & Video 360 keeps restating recent days while conversions get attributed and costs settle. The overwrite window is what carries those corrections into the table, so choose a window that covers your attribution lag. Without overwrite data loads only the days that appeared since the previous run.

Schedule

The schedule decides how often the pipeline runs. Renta reads the times you set here in UTC.

For Daily schedules, set the Update time (the exact time each run starts), then click Create pipeline.

Saving the pipeline takes a few seconds longer than usual, because Renta uses that moment to check your field selection against Display & Video 360. Once it passes, the pipeline appears in the Pipelines section under the ETL tab, together with the destination table name, run progress, and the number of extracted rows.

Sync strategy

The table below describes how Renta synchronizes each Display & Video 360 report type.