Connect CM360 to Snowflake

Google Campaign Manager 360 / DCM Field Reference logo
+
snowflake

Stream all your data from CM360 to Snowflake

Connect CM360 to Snowflake in 2023

It is very simple to connect Google Campaign Manager 360 (CM360) 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 Campaign Manager 360 as a Data Source and Grant Access to Windsor.ai.

Campaign Manager 360 Windsor.ai Onboarding Screen

 

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 Campaign Manager 360 to Snowflake. In case there is an error you will be notified.

CM360 metrics and dimensions available for streaming into Snowflake

Connect your data

 

nametypedescription
Account Country IDTEXTAccount country ID.
Account Country NameTEXTAccount country name.
Account Currency CodeTEXTAccount currency code.
Account Currency IdTEXTAccount currency id
Account IDTEXTCampaign Manager 360 account ID.
Account NameTEXTAn organization that creates and distributes a commercial message.
Account ID (Duplicate)TEXTCampaign Manager 360 account ID.
Active View 15sec Measurable ImpressionsNUMERICActive View: Audible & Fully On-Screen for Half of Duration (15 sec. cap) Measurable Impressions
Active View 15sec Viewable ImpressionsNUMERICActive View: Audible & Fully On-Screen for Half of Duration (15 sec. cap) Impressions
Active View Avg View Time SecondsNUMERICActive View: Average Viewable Time (Seconds)
Active View: Custom Metric Measurable ImpressionsNUMERICActive View: Custom Metric Measurable Impressions
Active View: Custom Metric Viewable ImpressionsNUMERICActive View: Custom Metric Viewable Impressions
Active View: Custom Metric Viewable RateNUMERICActive View: Custom Metric Viewable Rate
Active View: Eligible ImpressionsNUMERICActive View: Eligible Impressions
Active View Impression Distribution Not MesurableNUMERICActive View: Impression Distribution (Not Measurable)
Active View: Impression Distribution (Not Viewable)NUMERICActive View: Impression Distribution (Not Viewable)
Active View: Impression Distribution (Viewable)NUMERICActive View: Impression Distribution (Viewable)
Active View: Impressions Audible and Visible at CompletionNUMERICActive View: Impressions Audible and Visible at Completion
Active View: Impressions Visible 10 SecondsNUMERICActive View: Impressions Visible 10 Seconds
Active View: Measurable ImpressionsNUMERICActive View: Measurable Impressions
Active View: Not Measurable ImpressionsNUMERICActive View: Not Measurable Impressions
Active View: Not Viewable ImpressionsNUMERICActive View: Not Viewable Impressions
Active View: % Audible and Visible at CompletionNUMERICActive View: % Audible and Visible at Completion
Active View: % Audible and Visible at First QuartileNUMERICActive View: % Audible and Visible at First Quartile
Active View: % Audible and Visible at MidpointNUMERICActive View: % Audible and Visible at Midpoint
Active View: % Audible and Visible at Third QuartileNUMERICActive View: % Audible and Visible at Third Quartile
Active View: % Audible and Visible at StartNUMERICActive View: % Audible and Visible at Start
Active View: % Audible ImpressionsNUMERICActive View: % Audible Impressionse
Active View: % Play Time AudibleNUMERICActive View: % Play Time Audible
Active View: % Play Time Audible and VisibleNUMERICActive View: % Play Time Audible and Visible
Active View: % In BackgroundNUMERICActive View: % In Background
Active View: % Full-ScreenNUMERICActive View: % Full-Screen
Active View: Audible & Fully On-Screen for Half of Duration (15 sec. cap) RateNUMERICActive View: Audible & Fully On-Screen for Half of Duration (15 sec. cap) Rate
Active View: Audible & Fully On-Screen for Half of Duration (TrueView) RateNUMERICActive View: Audible & Fully On-Screen for Half of Duration (TrueView) Rate
Active View: % of Completed Impressions Audible and VisibleNUMERICActive View: % of Completed Impressions Audible and Visible
Active View: % of First Quartile Impressions Audible and VisibleNUMERICActive View: % of First Quartile Impressions Audible and Visible
Active View: % of Midpoint Impressions Audible and VisibleNUMERICActive View: % of Midpoint Impressions Audible and Visible
Active View: % of Third Quartile Impressions Audible and VisibleNUMERICActive View: % of Third Quartile Impressions Audible and Visible
Active View: % of Completed Impressions VisibleNUMERICActive View: % of Completed Impressions Visible
Active View: % of First Quartile Impressions VisibleNUMERICActive View: % of First Quartile Impressions Visible
Active View: % of Midpoint Impressions VisibleNUMERICActive View: % of Midpoint Impressions Visible
Active View: % of Third Quartile Impressions VisibleNUMERICActive View: % of Third Quartile Impressions Visible
Active View: % Measurable ImpressionsNUMERICActive View: % Measurable Impressions
Active View Pecentage PlayedNUMERICActive View: % of Ad Played
Active View: % Viewable ImpressionsNUMERICActive View: % Viewable Impressions
Active View: % Visible at CompletionNUMERICActive View: % Visible at Completion
Active View: % Visible 10 SecondsNUMERICActive View: % Visible 10 Seconds
Active View: % Visible at First QuartileNUMERICActive View: % Visible at First Quartile
Active View: % Visible at MidpointNUMERICActive View: % Visible at Midpoint
Active View: % Visible at Third QuartileNUMERICActive View: % Visible at Third Quartile
Active View: % Play Time VisibleNUMERICActive View: % Play Time Visible
Active View: % Visible at StartNUMERICActive View: % Visible at Start
Active View TV Measurable ImpressionsNUMERICActive View: Audible & Fully On-Screen for Half of Duration (TrueView) Measurable Impressions
Active View TV Viewable ImpressionsNUMERICActive View: Audible & Fully On-Screen for Half of Duration (TrueView) Impressions
NUMERICActive View: Viewable Impression Cookie Reach
Active View: Viewable ImpressionsNUMERICThe number of impressions on the site that were viewable out of all measurable impressions.
ActivityTEXTA single Floodlight tracking element used to track any action (such as a click, download, lead, or sale) performed by a user in an advertiser's app or website after that user has clicked on or seen the advertiser's ad.
Activity IDTEXTThe ID associated with an activity.
Ad Browser Targeting Major VersionTEXTMajor version number of browsers targeted by this ad
Ad Browser Targeting Minor VersionTEXTMinor version number of browsers targeted by this ad
Ad Browser TargetingTEXTBrowser names to target by the ad
Ad CompatibilityTEXTCompatibility of this ad.
Ad Targeting Connection TypeTEXTContains information about an internet connection type that can be targeted by ads.
Ad Creative Rotation TypeTEXTType of creative rotation. Can be used to specify whether to use sequential or random rotation.
Ad Creative Rotation Weight StartegyTEXTStrategy for calculating weights. Used with CREATIVE_ROTATION_TYPE_RANDOM
Ad Days SchedulingTEXTDays of the week when the ad will serve.
Ad End TimeDATEDate and time that this ad should stop serving. Must be later than the start time.
Ad Frequency Cap DurationNUMERICDuration of time, in seconds, for this frequency cap. The maximum duration is 90 days
Ad Frequency Cap ImpressionsNUMERICNumber of times an individual user can be served the ad within the specified duration.
AD IDTEXTThe ID associated with an ad.
Ad Impressions RatioNUMERICImpression ratio for this ad. This ratio determines how often each ad is served relative to the others.
Ad Is Dynamic Click TrackerTEXTWhether this ad is a dynamic click tracker. Applicable when type is AD_SERVING_CLICK_TRACKER.
Ad Targeting Mobile CarrierTEXTMobile carriers that this ad targets
Ad Targeting Mobile Carrier CountryTEXTCountry code of the country to which this mobile carrier belongs.
AD nameTEXTA commercial message that's delivered to a user. In Campaign Manager 360, an ad generally contains one or more creatives and is where you set the run dates and targeting criteria. To run, an ad must be assigned to a placement.
Ad Targeting OS Major VersionTEXTOperating system major version that this ad targets.
Ad Targeting OS Minor VersionTEXTOperating system minor version that this ad targets.
Ad Targeting OSTEXTOperating systems that this ad targets. Applicable when type is AD_SERVING_STANDARD_AD.
Ad Targeting OS is DesktopTEXTWhether this operating system is for desktop.
Ad Targeting OS is MobileTEXTWhether this operating system is for mobile.
Ad Platform TargetingTEXTThe hardware platform to which ads were delivered or on which a conversion took place (desktop, tablet, or smartphone).
Ad PriorityTEXTServing priority of an ad, with respect to other ads. The lower the priority number, the greater the priority with which it is served.
Ad Start TimeDATEDate and time that this ad should start serving. If creating an ad, this field must be a time in the future.
Ad Time SchedulingTEXTHours of the day when the ad will serve.
AD TypeTEXTThe type of ad
AdvertiserTEXTAn organization that creates and distributes a commercial message.
Advertiser Group IDTEXTThe group ID associated with an advertiser.
Advertiser Group NameTEXTThe group name associated with an advertiser.
Advertiser IDTEXTThe ID associated with an advertiser.
Average Display TimeNUMERICThe average amount of time, in seconds, that Rich Media creatives were displayed to users during the specified date range.
Audio CompletionsNUMERICThe number of impressions for which an audio clip played to completion.
Audio MutesNUMERICThe average amount of time, in seconds, that each user interaction with a Rich Media creative lasted.
Audio PausesNUMERICThe number of impressions for which the user paused the audio clip in the ad.
Audio First Quartile CompletionsNUMERICIn-stream audio. The number of impressions for which an ad clip played to the end of the first quarter of the audio content’s total length.
Audio MidpointsNUMERICIn-stream audio. The number of impressions for which an ad clip played to the midpoint of the audio content’s total length.
Audio Third Quartile CompletionsNUMERICThe number of impressions for which an ad clip played to the end of the third quarter of the audio content’s total length
Audio PlaysNUMERICThe number of served audio impressions, counted when the audio clip was played or started by the user.
Audio ReplaysNUMERICThe number of impressions for which a user restarted an audio clip after it was stopped or paused.
Audio UnutesNUMERICThe number of impressions for which mute was turned off to allow the audio’s sound to be played.
Average Interaction TimeNUMERICThe average amount of time, in seconds, that each user interaction with a Rich Media creative lasted.
CampaignTEXTAssociated with an advertiser, a campaign is a basic framework for managing your advertising.
Campaign End DateDATEThe end date of a campaign.
Campaign Optimization ModelTEXTOptimization model for this configuration. Possible values: CLICK, POST_CLICK, POST_IMPRESSION, POST_CLICK_AND_IMPRESSION, VIDEO_COMPLETION.
Campaign Start DateDATEThe start date of a campaign.
Campaign ID (duplicate)TEXTThe ID associated with a campaign. (duplicate)
ClicksNUMERICThe number of times that users clicked on a creative during the specified date range.
Total ConversionsNUMERICThe number of conversions
NUMERICThe number of impressions that didn't have consent for the use of cookies or other local identifiers and were therefore served by the publisher as limited ads.
CountryCOUNTRYA geographical area, used for targeting and geographic reporting.
Cost Per ActivityNUMERICFor each Floodlight activity, the media cost per user activity (conversion)
CPCNUMERICThe media cost per user click.
CPMNUMERICThe amount of revenue per 1000 impressions that is generated by your ads
Cost Per ActivityNUMERICMedia Cost The media cost for each unit of revenue recorded
CreativeTEXTThe media package that's delivered to users to convey your advertising message. Generally, each creative consists of at least one asset, such as an image file.
Creative Background colorTEXTThe 6-character HTML color code, beginning with `#`, for the background of the window area where the Flash file is displayed. Default is white.
Creative Backup Image Window TypeTEXTType of browser window for which the backup image of the flash creative can be displayed.
Creative HeightNUMERICCreative height
Creative IDTEXTThe ID associated with a creative.
Creative Last Modified TimeDATETimestamp of the last change
Creative Media DescriptionTEXTDescription of the audio or video ad.
Creative Media DurationNUMERICCreative audio or video duration in seconds.
Creative Min Flash VersionTEXTThe minimum required Flash plugin version for this creative. For example, 11.2.202.235.
Creative Redicrect URLTEXTURL of hosted image or hosted video or another ad ta
Creative SkippableTEXTWhether the user can choose to skip the creative.
Creative Video Skip Offset PercentageTEXTAmount of time (in percentage) to play the video before the skip button appears.
Creative Video Skip Offset SecTEXTAmount of time (in seconds) to play the video before the skip button appears.
Creative Video View Offset (In Percentage)TEXTAmount of time (in percentage) to play the video before counting a view.
Creative Video View Offset (In Seconds)TEXTAmount of time (in seconds) to play the video before counting a view.
Creative WidthNUMERICCreative width
Creative TypeTEXTThe type of creative that was delivered, such as Display, In-stream video, rich media, and so on.
Click-through Conversions + Cross-EnvironmentNUMERICClick-through Conversions + Cross-Environment
Click-through Conversion Events + Cross-EnvironmentNUMERICClick-through Conversion Events + Cross-Environment
Click-through Revenue + Cross-EnvironmentNUMERICClick-through Revenue + Cross-Environment
Total Conversions + Cross-EnvironmentNUMERICTotal Conversions + Cross-Environment
Total Conversion Events + Cross-EnvironmentNUMERICTotal Conversion Events + Cross-Environment
Total Revenue + Cross-EnvironmentNUMERICTotal Revenue + Cross-Environment
CTRPERCENTThe percentage of impressions that result in users clicking an ad.
Account Currency CodeTEXTAccount currency code.
DateDATEThe date when the reported events took place.
EngagementsNUMERICThe number of times that users engaged with an interactive element in a rich media creative.
Feed 1 Reporting LabelTEXTOne of the possible options in a feed.
Floodlight Attribution TypeTEXTFloodlight Attribution Type.
Floodlight Config IDTEXTFloodlight Configuration.
Floodlight ImpressionsNUMERICFloodlight Impressions
ImpressionsNUMERICThe number of times that a user’s client (browser or mobile device) sent a ping to our ad server that creative content was requested and has started to download during the specified date range.
Invalid ClicksNUMERICThe number of clicks that were proactively removed by traffic quality filtering.
Invalid Clicks %NUMERICThe percent of total clicks that were proactively removed by traffic quality filtering.
Invalid ImpressionsNUMERICThe number of impressions that were proactively removed by traffic quality filtering.
Invalid Impressions %NUMERICThe percent of total impressions that were proactively removed by traffic quality filtering.
Landing Page URLTEXTThe URL a user is sent to when they click on an ad. Usually the landing page URL points to a webpage in the advertiser’s website. If the creative served has multiple exits, each exit will be displayed as its own row.
Media CostNUMERICThe cost of all impressions, clicks, and activities during the specified date range, based on the schedule and pricing information that was entered for each placement.
NUMERICNatural search actions
NUMERICNatural search clicks
NUMERICNatural search revenue
NUMERICNatural search transactions
NUMERICThe average amount of money per transaction (that is, conversion) that is recorded by a Floodlight sales activity and attributed to a paid search click.
NUMERICThe average cost per transaction (CPT) of paid search, which is the amount you spend on paid search clicks per transaction that a customer performs.
NUMERICThe average position (or rank) of a paid search ad, which describes how the ad ranks against other ads in terms of where they appear on the search results page.
NUMERICThe number of actions divided by the number of paid search clicks.
NUMERICThe total fees for clicks on paid search ads during the specified date range.
NUMERICThe percentage of paid search impressions that result in users clicking an ad.
NUMERICThe number of times a paid search ad was shown.
NUMERICThe amount of revenue recorded from Floodlight conversions attributed to paid search ads.
NUMERICThe ratio of paid search cost to paid search revenue
NUMERICThe number of transactions (conversions) recorded by Floodlight sales activities divided by paid search clicks.
NUMERICThe ratio of paid search revenue to paid search cost
NUMERICThe number of sales conversions attributed to paid search ads, as recorded by Floodlight sales activities.
NUMERICPaid search visits
NUMERICPaid social clicks
NUMERICPaid social cost
NUMERICPaid social impressions
PlacementTEXTA Placement resource represents a fixed block of ad space on a site. It defines where an advertisement can serve, its physical dimensions, pricing information, and other key properties. One or more ads are linked to each placement.
Placement CompatibilityTEXTCompatibility of this placement.
Placement Conetnt Category IDTEXTThe ID of this content category
Placement Conetnt Category NameTEXTName of this content category.
Placement Group IDTEXTThe ID associated with a placement group.
Placement Group NameTEXTThe placement group name.
Placement Group TypeTEXTType of this placement group. A package is a simple group of placements that acts as a single pricing point for a group of tags.
Placement IDTEXTThe ID associated with a placement.
Placement Strategy IDTEXTThe placement stragedy ID.
Planned Media CostNUMERICThe sum of the cost of all pricing flights over the entire lifetime of a placement.
Profile IDTEXTID of CM360 user that provides access to the account.
Profile nameTEXTName of CM360 user that provides access to the account..
Profile ID (alias)TEXTID of CM360 user that provides access to the account.
Profile name (alias)TEXTName of CM360 user that provides access to the account..
RevenueNUMERICThe total amount of revenue
Revenue Per ClickNUMERICFor each user click, the average amount of revenue recorded by each Floodlight sales activity
Revenue Per Thousand ImpressionsNUMERICFor each user click, the average amount of revenue recorded by each Floodlight sales activity
Rich Media ScrollsNUMERICThe number of times that a user has scrolled through a rich media creative.
Site (CM360)TEXTA representation in your Campaign Manager 360 account of a website, part of a website, or group of websites from which an advertiser or agency has purchased ad space.
Site ID (CM360)TEXTThe ID associated with a Campaign Manager 360 site.
Social Engagement RateNUMERICTotal engagements on your Twitter ad divided by the number of times the ad was shown.
Social FollowsNUMERICThe number of Twitter users that clicked follow, in order to receive Tweets/ updates from your promoted account.
Social Lead SubmissionsNUMERICThe number of times Twitter users shared their name and email address with you by clicking through a lead generation card in your Tweets.
Social LikesNUMERICThe number of times Twitter users liked your Tweet by clicking the heart icon.
Social Offer AcceptsNUMERICThe number of times Twitter users added your Tweeted offer to their registered credit/debit card.
Social Other InteractionsNUMERICThe total number of other interactions a social network user had with your content.
Social RepliesNUMERICThe number of times Twitter users Tweeted in response to your message, usually done by clicking the reply button.
Social Shares (External)NUMERICThe number of times a social network user shared your content outside of the platform.
Social Shares (Internal)NUMERICThe number of times a social network user shared your content within the platform.
Social Total Social EngagementsNUMERICThe total number of Clicks, Retweets, Likes, Replies, and Follows because of your Twitter campaign.
SourceTEXTAlias for Site (CM360).
SpendNUMERICSpend (alias for DBM (DV360) Cost)
Video Plays at 100 percentNUMERICThe number of impressions for which an ad clip played to completion.
Video Plays at 25 percentNUMERICThe number of impressions for which an ad clip played to the end of the first quarter of the video's total length.
Video Plays at 50 percentNUMERICThe number of impressions for which an ad clip played to the midpoint of the video's total length.
Video Plays at 75 percentNUMERICThe number of impressions for which an ad clip played to the end of the third quarter of the video's total length.
Total CostNUMERICTotal Cost (alias for DBM (DV360) Cost)
Twitter App Install ClicksNUMERICThe number of times Twitter users clicked through your Tweet(s) to download your app.
Twitter URL ClicksNUMERICThe number of times Twitter users clicked on URLs in your Tweets.
Twitter: Video 100% In View For 3 SecondsNUMERICFor Twitter campaigns, the number of times a video (with at least 100% of the video player on screen) was played for at least three seconds .
Twitter: Video 50% In View For 2 SecondsNUMERICFor Twitter campaigns, the number of times a video (with a least 50% of the video player on screen) was played for at least two seconds .
Vendor Blocked AdsNUMERICThe number of ads blocked by your third-party provider
Video Average View TimeNUMERICThe average amount of time that an ad clip was played.
Video Full-ScreenNUMERICThe number of impressions for which an ad clip was played in full-screen mode.
Video InteractionsNUMERICVideo Interactions.
Video Interaction RateNUMERICThe ratio of video interactions to video plays.
Video MutesNUMERICThe number of impressions for which the ad was muted. The action is counted even if the user mutes the ad before the video plays.
Video PausesNUMERICThe number of impressions for which the user paused the video clip in the ad.
Video ReplaysNUMERICThe number of impressions for which a user restarted a video clip after it was stopped or paused.
Video SkipsNUMERICThe number of times a user has skipped a video clip that was playing.
Video StartNUMERICAlias for Video Starts.
Video StartsNUMERICThe number of served video impressions, counted when the video clip was played or started by the user.
Video StopsNUMERICThe number of impressions for which a user stopped a video clip that was playing.
Video UnmutesNUMERICThe number of impressions for which mute was turned off to allow the video's sound to be played. An unmute is counted even if the user unmutes the ad before the video plays.
Video ViewsNUMERICThe number of impressions for which a video clip was played.
Video Views RateNUMERICThe percentage of the ad clip that was played.
View-through Conversions + Cross-EnvironmentNUMERICView-through Conversions + Cross-Environment
View-through Conversion Events + Cross-EnvironmentNUMERICView-through Conversion Events + Cross-Environment
View-through Revenue + Cross-EnvironmentNUMERICView-through Conversions + Cross-Environment

Easily connect CM360 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 CM360 and Snowflake Integrations