Skip to main content

Overview

This source syncs entity metadata from Display & Video 360 using the Display Video API v4 and performance report data using the DoubleClick Bid Manager API v2. Entity streams cover the full DV360 resource hierarchy: partners → advertisers → campaigns, insertion orders, line items, creatives, channels, ad groups, and more, including nested resources such as assigned targeting options and YouTube asset associations. Bid Manager streams (bid_manager_queries, bid_manager_reports, bid_manager_report_rows) list saved queries and their completed reports, and download CSV report data directly from the GCS path returned by the Bid Manager API. Authentication uses a Google Cloud service account JSON key (not user OAuth). Domain-wide delegation is supported via the optional email field. All streams use full table replication. Each entity row includes entity_id, _raw (full API object as JSON), and flattened top-level fields.

Configuration


Sample configs

DV360 entity streams only (no Bid Manager):
Scoped to specific advertisers (partner_id not required for advertiser-scoped streams):
Bid Manager streams with explicit query IDs (disable entity streams in catalog):
Full config — DV360 entities + Bid Manager + domain-wide delegation:

Streams

DV360 entity streams

Bid Manager streams

Sample data limits: bid_manager_queries returns at most 25 rows; bid_manager_reports uses only the first query and one report; bid_manager_report_rows returns at most 25 CSV rows from a single report.

Prerequisites

  1. Enable the Display & Video 360 API (displayvideo.googleapis.com) in Google Cloud Console.
  2. For Bid Manager streams, also enable the DoubleClick Bid Manager API (doubleclickbidmanager.googleapis.com) and grant the service account read access to the GCS buckets where report files are delivered.
  3. Create a service account and download its JSON key. Set path_to_credentials_json_file to the local path.
  4. In the DV360 UI, grant the service account access at the partner or advertiser level as appropriate.
  5. If your organization uses domain-wide delegation: configure it in Google Workspace Admin for the service account, include the DV360 and Bid Manager scopes, and set email to the user to impersonate.

OAuth scopes used