Connect DV360 to Google BigQuery

DV360 to bigquery

Analyze your DV360 data with Google BigQuery

Connect DV360 to Google BigQuery in 2023

It is very simple to connect DV360 to Google BigQuery, it can be done in a fast and easy manner with Windsor.ai.

 

First Step:

You need to select Display & Video 360 as a Data Source and Grant Access to Windsor.ai.

DV360 Integration

 

Second Step:

You will need to go to Google BigQuery as a Destination.

BigQuery Integration

 

Third Step:

Make sure you follow the instructions on the screen. Once you complete the setup your data will start streaming in the interval you specify. You can always come back and change the settings at a later stage.

BigQuery Integration

 (Don’t forget to grant access to bq-upload@windsor-ai-bigquery.iam.gserviceaccount.com)

 

Fourth Step:

As a connector URL, you can use any URL providing a JSON. Either from the connectors or for example a URL with cached and transformed data from Charts.Windsor.ai

Google Display & Video 360 metrics and dimensions available for streaming into Google BigQuery

Connect your data

 

NameTypeDescription
Account IDTEXTYour DV360 advertiser ID
Account NameTEXTYour DV360 advertiser name
Audio Mutes (Audio)NUMERICAudio Mutes (Audio)
Audio Unmutes (Audio)NUMERICAudio Unmutes (Audio)
CampaignTEXTThe Campaign Name
Campaign Budget IDTEXTThe unique ID of the campaign budget. Assigned by the system. Do not set for new budgets.
Campaign Budget NameTEXTThe display name of the budget.
Campaign Budget UnitTEXTSpecifies whether the budget is measured in currency or impressions.
Campaign Goal TypeTEXTThe type of the campaign goal.
Campaign IDTEXTThe Campaign ID
Campaign Performance Goal AmountNUMERICThe goal amount, in micros of the advertiser's currency.
Campaign Perfomance Goal PercentageNUMERICThe decimal representation of the goal percentage in micros.
Campaign Performance Goal TypeTEXTThe type of the campaign perfomance goal.
Campaign Planned End DateNUMERICEnd date that the campaign is expected to run. They are resolved relative to the parent advertiser's time zone.
Campaign Planned SpendNUMERICThe amount the campaign is expected to spend for its given plannedDates.
Campaign Planned Start DateNUMERICStart date that the campaign is expected to run. They are resolved relative to the parent advertiser's time zone.
Campaign Update TimeDATEThe timestamp when the campaign was last updated. Assigned by the system.
ClicksNUMERICThe Number of Clicks
Clicks Lead Conv PercentageNUMERICClicks Leading to Conversions %
CM Ad IDTEXTThe Campaign Manager 360 tracking ad associated with the creative.
CM Placement IDTEXTThe unique ID of the Campaign Manager 360 placement associated with the creative.
Companion Clicks (Audio)NUMERICCompanion Clicks (Audio)
Companion Views (Audio)NUMERICCompanion Views (Audio)
Complete Listens (Audio)NUMERICComplete Listens (Audio)
Complete Views (Video)NUMERICComplete Views (Video)
Completion Rate (Audio)NUMERICCompletion Rate (Audio)
ConversionsNUMERICTotal conversions
CreativeTEXTCreative
Creative Create TimeDATEThe timestamp when the creative was created. Assigned by the system.
Creative Hosting SourceTEXTIndicates where the creative is hosted.
Creative IDTEXTCreative ID
Creative Update TimeDATEThe timestamp when the creative was last updated. Assigned by the system.
Creative TypeTEXTThe type of the creative.
Advertiser CurrencyTEXTAdvertiser currency
Partner CurrencyTEXTPartner currency
DateDATEThe Date
First-Quartile (Audio)NUMERICFirst-Quartile (Audio)
First-Quartile Views (Video)NUMERICFirst-Quartile Views (Video)
Fullscreens (Video)NUMERICFullscreens (Video)
impressionsNUMERICThe Number of Impressions Served
Insertion OrderTEXTThe Insertion Order Name
Insertion Order IDTEXTThe Insertion Order ID
Line Item NameTEXTThe Line Item Name
Line Item IDTEXTThe Line Item ID
Midpoint (Audio)NUMERICMidpoint (Audio)
Midpoint Views (Video)NUMERICMidpoint Views (Video)
Pauses (Audio)NUMERICPauses (Audio)
Post-Click ConversionsNUMERICPost-Click Conversions
Post-View ConversionsNUMERICPost-View Conversions
Revenue (Advertiser Currency)NUMERICRevenue (Advertiser Currency)
Revenue (Partner Currency)NUMERICRevenue (Partner Currency)
Revenue (USD)NUMERICRevenue (USD)
Skips (Video)NUMERICSkips (Video)
Spend in Advertiser CurrencyNUMERICThe Media Spend in the Advertiser Currency
Spend in Partner CurrencyNUMERICThe Media Spend in the Partner Currency
Spend in USDNUMERICThe Media Spend in USD
Starts (Audio)NUMERICStarts (Audio)
Starts (Video)NUMERICStarts (Video)
Stops (Audio)NUMERICStops (Audio)
Third-Quartile (Audio)NUMERICThird-Quartile (Audio)
Third-Quartile Views (Video)NUMERICThird-Quartile Views (Video)
Total ConversionsNUMERICTotal Conversions
Total Display TimeNUMERICTotal Display Time
Total Cost in Advertiser CurrencyNUMERICThe Media Spend in the Advertiser Currency (Duplicate)
Total Cost USDNUMERICThe Media Spend in USD (Duplicate)

Windsor.ai: Easily connect DV360 to Google BigQuery

See the value and return on every marketing touchpoint

data warehouse

Providing 50+ marketing data streams, we make sure that all the data we integrate is fresh and accessible by marketeers, whenever they want.

insights

Spend less time on manual data loading and spreadsheets. Focus on delighting your customers.

Build your DV360 and Google BigQuery Integrations