Display & Video 360 API Connector

Overview

Display & Video 360 (DV360), part of the Google Marketing Platform, is a programmatic advertising solution used for planning, buying, optimizing, and measuring digital media across display, video, audio, CTV, native, and third-party inventory sources. The DV360 API provides programmatic access to advertisers, campaigns, insertion orders, line items, targeting, creatives, inventory deals, and performance reporting.

The DV360 connector automates ingestion of two performance reports and five metadata endpoints from Google Display & Video 360:

Delivery / Aggregate report → dv360_data_aggregate
TrueView / YouTube report → dv360_data_trueview
Metadata → Advertiser, Campaign, Insertion Order, Line Item, and Creative lookup tables

The DV360 API exposes planning, buying, trafficking, and measurement data across:

Advertiser & Campaign Structure

Partners
Advertisers
Campaigns
Insertion orders (IOs)
Line items (bidding, pacing, budgets, strategies)
Ad groups and assigned creatives
Frequency caps

Creative & Asset Data

Display, video, native, and audio creatives
Creative approval & review status
Assets, transcodes, click tags, rendering information
Third-party tag metadata

Inventory, Deals, and Targeting

Deals (PMPs, PG deals, Programmatic Guaranteed, Preferred Deals)
Exchanges, inventory sources, publisher IDs
Audience targeting (first party, third party, Google audiences)
Geo, device, browser, OS
Brand safety + verification settings
Environment and placement types (web, app, video, CTV, audio)

Performance & Measurement Data

Impressions, clicks, conversions
Viewability metrics
Video metrics (quartiles, completion rate)
Reach & frequency
Cost, CPM, CPC, CPA
Floodlight conversions (if linked)

Metadata & Reference Tables

Targeting option lists
Creative types and approval statuses
Inventory source metadata
Geography tables
Device types
Browser & OS taxonomies

Granularity

This integration retrieves DV360 data at the following levels: Partner, Advertiser, Campaign, Insertion order, Line item, Creative, which can be broken down by geo, device type and audience.

Purpose

Sync programmatic trafficking structure into external platforms
Automate workflows such as line-item creation, pacing updates, creative assignment
Monitor delivery, optimisation goals, and brand-safety performance
Provide visibility into inventory sources, audiences, and cross-device delivery

Refresh cadence

Fact tables append daily (5‑day look‑back). Metadata tables refresh daily.

For more information on this integration please follow the link here.

Connection Setup

Key	Description	Required	Type
`dv360_advertisers`	Comma‑separated advertiser IDs	✅	Text
`google_client_secret`	Google OAuth Client Secret (hidden)	✅	Hidden
`google_client_id`	Google OAuth Client ID (hidden)	✅	Hidden
`google_client_scopes`	DV360, DBM & GCS read scopes (hidden)	✅	Hidden

Auth – OAuth 2.0 (installed app). Refresh token stored securely after first grant.

Jobs & Scheduling

Job Label	Feed	Look - back	Pull	Targets
DV360 Data Import	`dbm_report_import`	5 days	24h	`dv360_data_aggregate`, `dv360_data_trueview`
DV360 Meta Refresh	`dbm_report_import`	1 day	24h	5 metadata tables

Each data target requires hidden option dv360_report_id (saved Query ID in DV360 UI).

Tables & Schemas (all fields)

1 · `dv360_data_aggregate`

Field	Description
`date`	Report date (YYYY‑MM‑DD)
`advertiser_id`	DV360 advertiser ID
`campaign_id`	Campaign ID
`insertion_order_id`	Insertion Order ID
`line_item_id`	Line item ID
`creative_id`	Creative ID
`impressions`	Total impressions
`clicks`	Total clicks
`media_cost_advertiser_currency`	Cost in advertiser currency
`revenue_adv_currency`	Revenue in advertiser currency
`first_quartile_views_video`	Views reaching 25 %
`midpoint_views_video`	Views reaching 50 %
`third_quartile_views_video`	Views reaching 75 %
`complete_views_video`	Video completes (100 %)

2 · `dv360_data_trueview` (YouTube)

Field	Description
`date`	Report date
`advertiser_id`	Advertiser ID
`campaign_id`	Campaign ID
`insertion_order_id`	Insertion Order ID
`line_item_id`	Line item ID
`creative_id`	Creative ID
`youtube_ad_group`	YouTube Ad Group name/ID
`youtube_ad`	YouTube Ad (creative) name/ID
`impressions`	Impressions
`clicks`	Clicks
`media_cost_advertiser_currency`	Cost
`revenue_adv_currency`	Revenue
`first_quartile_views_video`	25 % views
`midpoint_views_video`	50 % views
`third_quartile_views_video`	75 % views
`complete_views_video`	Video completes

Metadata Lookup Tables

Table	Key Column	Core Fields (examples)
`dv360_meta_advertiser`	`advertiserId`	`displayName`, `entityStatus`
`dv360_meta_campaign`	`campaignId`	`displayName`, `advertiserId`
`dv360_meta_order`	`insertionOrderId`	`displayName`, `campaignId`
`dv360_meta_lineitem`	`lineItemId`	`displayName`, `insertionOrderId`
`dv360_meta_creative`	`creativeId`	`displayName`, `creativeType`

Dimensions

Dimension Name	Mapping Source
Advertiser [DV360]	`dv360_meta_advertiser.displayName`
Campaign [DV360]	`dv360_meta_campaign.displayName`
Insertion Order [DV360]	`dv360_meta_order.displayName`
Line Item [DV360]	`dv360_meta_lineitem.displayName`
Creative [DV360]	`dv360_meta_creative.displayName`
YouTube AdGroup [DV360]	`dv360_data_trueview.youtube_ad_group`
YouTube Ad [DV360]	`dv360_data_trueview.youtube_ad`

Base Metrics

Metric	Formula (Aggregate + TrueView)	Round	Prefix
Media Cost [DV360]	`SUM(media_cost_advertiser_currency)`	2	£
Revenue [DV360]	`SUM(revenue_adv_currency)`	0
Impressions [DV360]	`SUM(impressions)`	0
Clicks [DV360]	`SUM(clicks)`	0
25 % Views [DV360]	`SUM(first_quartile_views_video)`	0
50 % Views [DV360]	`SUM(midpoint_views_video)`	0
75 % Views [DV360]	`SUM(third_quartile_views_video)`	0
Video Completes [DV360]	`SUM(complete_views_video)`	0

Composite Metrics

Name	Formula	Round	Format
CTR [DV360]	`(Clicks / Impressions) * 100`	2	%
CPC [DV360]	`Media Cost / Clicks`	2	£
CPM [DV360]	`(Media Cost / Impressions) * 1000`	2	£
VTR [DV360]	`(Video Completes / Impressions) * 100`	2	%
CPCV [DV360]	`Media Cost / Video Completes`	2	£

Joins

Fact Table	FK Field	Table Name	Key
Aggregate & TrueView	advertiser_id	dv360_meta_advertiser	advertiserId
	campaign_id	dv360_meta_campaign	campaignId
	insertion_order_id	dv360_meta_order	insertionOrderId
	line_item_id	dv360_meta_lineitem	lineItemId
	creative_id	dv360_meta_creative	creativeId