Connect Google Ad Manager to Snowflake

Google Ad Manager
+
snowflake

Stream all your data from Google Ad Manager to Snowflake

Connect Google Ad Manager to Snowflake in 2023

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

 

First Step

Follow the Tutorial Below:

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

 

  • Get the username Import Snowflake 1

 

  • Get the password Import Snowflake 2

 

  • Get the account Import Snowflake 3

 

  • Get the warehouse Import Snowflake 4

 

  • Get the database Import Snowflake 5

 

  • Get the schema Import Snowflake 6

 

  • Get the table name Import Snowflake 7

 

Second step

1. You need to select Google Ad Manager as a Data Source and Grant Access to Windsor.ai.

power bi google ad manager integration

 

2. In Select Destination select Snowflake as destination

snowflake integration

 

3. Enter all the credentials required and click Save
Snowflake connector

 

4. Your data will now be streamed from Google Ad Manager to Snowflake. In case there is an error you will be notified.

Google Ad Manager metrics and dimensions available for streaming into Snowflake

Connect your data

 

nametypedescription
Account idTEXTBreaks down reporting data by advertising company Company.id. Can be used to filter by Company.id. Compatible with any of the following report types: Historical, Future sell-through, Reach, Ad speed.
Account nameTEXTBreaks down reporting data by advertising company. Company.name and Company.id are automatically included as columns in the report. Can be used to filter by Company.name. Corresponds to "Advertiser" in the Ad Manager UI. Compatible with any of the following report types: Historical, Future sell-through, Reach, Ad speed.
Ad network idTEXTThe network that provided the ad for SDK ad mediation. If selected for a report, that report will include only SDK mediation ads and will not contain non-SDK mediation ads. SDK mediation ads are ads for mobile devices. They have a list of ad networks which can provide ads to serve. Not every ad network will have an ad to serve so the device will try each network one-by-one until it finds an ad network with an ad to serve. The ad network that ends up serving the ad will appear here. Note that this id does not correlate to anything in the companies table and is not the same id as is served by ADVERTISER_ID. Compatible with any of the following report types: Historical, Reach.
Ad network nameTEXTName of the ad network.
Ad server clicksNUMERICThe number of clicks delivered by the ad server.
Ad server CTRPERCENTThe CTR for an ad delivered by the ad server.
Ad server impressionsNUMERICThe number of impressions delivered by the ad server.
Ad server targeted impressionsNUMERICThe number of impressions delivered by the ad server by explicit custom criteria targeting.
Ad unit idTEXTThe id of the ad unit.
Ad unit nameTEXTThe name of the ad unit.
AdSense impressionsNUMERICThe number of impressions an AdSense ad delivered for line item-level dynamic allocation. Compatible with the "Historical" report type.
AdvertiserTEXTThe name of the advertiser company assigned to an order.
Advertiser idTEXTThe id of the advertiser company assigned to an order.
CampaignTEXTBreaks down reporting data by placement. Placement.name and Placement.id are automatically included as columns in the report. Can be used to filter by Placement.name. Corresponds to "Placement" in the Ad Manager UI. Compatible with any of the following report types: Historical, Future sell-through, Reach.
ClicksNUMERICThe number of clicks delivered by the ad server. Corresponds to "Ad server clicks" in the Ad Manager UI. Compatible with the "Historical" report type.
CountryCOUNTRYCountry associated to IP address from ad slot request
CreativeTEXTThe name of the Creative that served to the ad slot request.
Creative sizeTEXTSize of creative that served to the ad slot request. Creative size does not represent the actual size of a creative being served.
Creative typeTEXTType of creative that served to the ad slot request.
DateDATEBreaks down reporting data by date in the network time zone. Can be used to filter by date using ISO 8601's format 'YYYY-MM-DD'". Note: In v201802 and later, this dimension is compatible with the following time zone types: TimeZoneType.PUBLISHER TimeZoneType.PROPOSAL_LOCAL Corresponds to "Date" in the Ad Manager UI. Compatible with any of the following report types: Historical, Future sell-through, Reach, Ad speed.
ImpressionsNUMERICThe number of impressions an AdSense ad delivered for line item-level dynamic allocation. Corresponds to "AdSense impressions" in the Ad Manager UI. Compatible with the "Historical" report type.
Line item Delivery IndicatorTEXTIndicates the progress made for the delivery of the line item.
Line item Delivery pacingTEXTRepresents delivery rate type for the line item.
Line item idTEXTThe id of the line item associated to the Creative that served to the ad slot request.
Line item nameTEXTThe name of the line item associated to the Creative that served to the ad slot request.
Line item typeTEXTType of line item associated to the Creative that served to the ad slot request.
Month and yearTEXTBreaks down reporting data by month and year in the network time zone. Can be used to filter on month using ISO 4601 format 'YYYY-MM'. Note: In v201802 and later, this dimension is compatible with the following time zone types: TimeZoneType.PUBLISHER TimeZoneType.PROPOSAL_LOCAL Corresponds to "Month and year" in the Ad Manager UI. Compatible with any of the following report types: Historical, Future sell-through, Reach, Partner finance.
ORDER_DELIVERY_STATUSTEXTDelivery status of the order. Not available as a dimension to report on, but exists as a dimension in order to filter on it using PQL. Valid values are 'STARTED', 'NOT_STARTED' and 'COMPLETED'. Compatible with any of the following report types: Historical, Reach.
Order idTEXTThe id of the Order associated to the line item linked to the Creative that served to the ad slot request.
Order nameTEXTThe name of the Order associated to the line item linked to the Creative that served to the ad slot request.
Placement idTEXTThe id of the placement that currently includes an ad unit associated with an impression, click, or other event.
Placement nameTEXTName of the placement that currently includes an ad unit associated with an impression, click, or other event.
RegionREGIONRegion associated with the IP address included in the ad slot request.
SpendNUMERICThe total CPM and CPC revenue generated by the ad servers including line item-level dynamic allocation. Corresponds to "Total CPM and CPC revenue" in the Ad Manager UI. Compatible with the "Historical" report type.
Total ad requestsNUMERICThe total number of times that an ad request is sent to the ad server including dynamic allocation.
Total clicksNUMERICThe total number of clicks delivered including line item-level dynamic allocation.
Total CTRNUMERICThe ratio of total clicks on ads delivered by the ad servers to the total number of impressions delivered for an ad including line item-level dynamic allocation.
Total impressionsNUMERICThe total number of impressions delivered including line item-level dynamic allocation.
Total costNUMERICThe total CPM and CPC revenue generated by the ad servers including line item-level dynamic allocation. Corresponds to "Total CPM and CPC revenue" in the Ad Manager UI. Compatible with the "Historical" report type.
Video viewership Average view rateNUMERICAverage percentage of the video watched by users.
Video viewership Average view timeNUMERICAverage time(seconds) users watched the video.
Video viewership CompleteNUMERICThe number of times the video played to completion.
Video viewership Completion rateNUMERICPercentage of times the video played to the end.
Video viewership Engaged viewNUMERICThe number of engaged views i.e. ad is viewed to completion or for 30s, whichever comes first.
Video viewership First quartileNUMERICThe number of times the video played to 25% of its length.
Video viewership midpointNUMERICThe number of times the video reached its midpoint during play.
Video viewership StartNUMERICThe number of impressions where the video was played.
Video viewership third quartileNUMERICThe number of times the video played to 75% of its length.
Video viewership Video lengthNUMERICDuration of the video creative.
Video viewership View-through rateNUMERICView-through rate represented as a percentage.

Easily connect Google Ad Manager 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 marketers, whenever they want.

insights

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

Build your Google Ad Manager and Snowflake Integrations