Connect Google Display & Video 360 (DV360) to Snowflake with Windsor.ai

dv360

+

snowflake

Stream all your programmatic and inventory data from Google DV360 to Snowflake

About Google DV360

Google Display & Video 360 or DV360, formerly known as DoubleClick Bid Manager (DBM) is part of Googles Marketing Platform and allows marketers to buy and manage programmatic advertising across display, video, TV, audio and other channels.

About Snowflake

Snowflake is a cloud data warehouse. Contrary to on premise data bases it eliminates the need to maintain hardware infrastructure. I’s architecture allow it to scale dynamically depending on the resource consumption needed by the users. The outcome of working with a cloud data warehouse like Snowflake is a greatly increased productivity of end users working with Snowflake data.

First Step:

Follow the Tutorial Below:

  1. Add all the columns that are returned by your connector’s URL. 
  2. Create the WINDOSR_UPLOAD role (name has no importance) 
  3. Create a user and add the previously created role to that user 
  4. Grant rights to the DATABASE to the created user 
  5. Grand the rights to the destination table 
  6. Get the rerquired fields from Snowflake to use the Snowflake destination in Onboard Form
  1. Get the username 
  2. Get the password 
  3. Get the account 
  4. Get the warehouse 
  5. Get the database 
  6. Get the schema 
  7. Get the table name 

Second step:

1.You need to select Google Display video 360 “DV360”  as a Data Source and Grant Access to Windsor.ai.

  1. In Select Destination select Snowflake as destination
  2. Enter all the credentials required and click Save
  3. Your data will now be streamed to Snowflake. In case there is an error you will be notified.

You should also read:

Stream Your Data to Snowflake

Data Studio Google Display & Video 360 (DV 360) Overview Report

7 Examples of Google Data Studio Marketing Dashboards for Paid Campaigns

Google DV360 metrics and dimensions available for streaming into Snowflake

NameTypeDescription
Account IDTEXTYour DV360 advertiser ID
Account NameTEXTYour DV360 advertiser name
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.
Complete Views (Video)NUMERICComplete Views (Video)
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.
DateDATEThe Date
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 Views (Video)NUMERICMidpoint Views (Video)
Post-Click ConversionsNUMERICPost-Click Conversions
Post-View ConversionsNUMERICPost-View Conversions
Revenue (USD)NUMERICRevenue (USD)
Skips (Video)NUMERICSkips (Video)
SpendNUMERICThe Media Spend in USD
Starts (Video)NUMERICStarts (Video)
Third-Quartile Views (Video)NUMERICThird-Quartile Views (Video)
Total ConversionsNUMERICTotal Conversions
Total Display TimeNUMERICTotal Display Time
Total CostNUMERICThe Media Spend in USD (Duplicate)

Windsor.ai: Easily connect Google DV360 to Snowflake

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.

Start a free trial today.

Integrate all your data and measure what matters.