Display & Video 360 API Connector

🛠 Overview

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

Granularity
▪ Aggregate — one row per line‑item/creative/day
▪ TrueView — one row per YouTube ad group/ad/day

Purpose — Consolidate spend, revenue, display, and video KPIs for programmatic and YouTube inventory, enriched with DV360 object hierarchy.

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	Poll	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	Lookup Table	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

✅ Summary

This DV360 connector captures full‑funnel display, video, and YouTube metrics across two fact tables and five enriched dimension tables. Daily data loads (with look‑back) ensure accuracy while OAuth guarantees secure access. Robust schemas and joins empower granular pacing, cost‑efficiency, and creative performance reporting across the Google Marketing Platform stack.