Connect Bing Ads to Snowflake

Snowflake Bing Ads Integration

Stream your marketing data from Bing Ads to Snowflake

Connect Bing Ads to Snowflake in 2023

It is very simple to connect Bing Ads 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. 
  2. Create the WINDSOR_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 required fields from Snowflake to use the Snowflake destination in Onboard Form
  • Get the username 
  • Get the password 
  • Get the account 
  • Get the warehouse 
  • Get the database 
  • Get the schema 
  • Get the table name 

 

Second step

1.You need to select Bing Ads as a Data Source and Grant Access to Windsor.ai.

bing ads onboarding

 

2. In Select Destination select Snowflake as destination

snowflake integration

 

3. Enter all the credentials required and click Save

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

Bing Ads metrics and dimensions available for streaming into Snowflake

Connect your data

 

nametypedescription
Absolute Top Impression Rate PercentPERCENTHow often your ad was in the first position of all results, as a percentage of your total impressions.
Absolute Top Impression Lost To BudgetNUMERICAbsolute Top Impression Lost To Budget
Absolute Top Impression Share Lost To Budget PercentPERCENTThe estimated percentage of how often your ad missed showing in the very top ad position, above search results, due to insufficient budget.
Absolute Top Impression Lost To RankNUMERICAbsolute Top Impression Lost To Rank
Absolute Top Impression Share Lost To Rank PercentPERCENTThe estimated percentage of how often poor ad rank kept your ad from showing in the first ad position at the top of search results.
Absolute Top Impression Share PercentPERCENTThe estimated percentage of times your ad was in the first position of all results, out of the estimated number of first position impressions you were eligible to receive.
Absolute Top ImpressionsNUMERICAbsolute Top Impressions
Account IDTEXTThe account id
Account NameTEXTThe account name
Account NumberTEXTThe Microsoft Advertising assigned number of an account.
Account StatusTEXTThe account status
Ad DistributionTEXTThe network where you want your ads to show. This can be the entire Microsoft Advertising Network, Microsoft sites and select traffic, or only partner traffic.
Ad group IDTEXTThe ID of the AdGroup.
Ad groupTEXTThe name of the AdGroup.
Ad IDTEXTThe ad id
Ad TitleTEXTThe ad title
Title Part 1TEXTThe title part 1 attribute of an ad.
Title Part 2TEXTThe title part 2 attribute of an ad.
Title Part 3TEXTThe title part 3 attribute of an ad.
Ad Network ConversionsNUMERICThe ad network reported conversions
Ad Network RevenueNUMERICThe ad network reported revenue
All Conversion RatePERCENTThe conversion rate as a percentage.
All ConversionsNUMERICThe number of conversions.
AllCostPerConversionNUMERICThe cost per conversion.
All RevenueNUMERICThe revenue optionally reported by the advertiser as a result of conversions.
All Revenue Per ConversionNUMERICThe revenue per conversion.The formula for calculating the revenue per conversion is (Revenue / Conversions).
AllReturnOnAdSpendNUMERICThe return on ad spend (ROAS).The formula for calculating the ROAS is (Revenue / Spend).
Average CPCNUMERICThe average cost per click (CPC). The total cost of all clicks on an ad divided by the number of clicks. This is the average amount you're actually charged each time your ad is clicked.
Average CPMNUMERICThe total advertising cost divided by the number of impressions (in thousands).
Bid Match TypeNUMERICThe keyword bid match type. This can be different from the DeliveredMatchType column, for example if you bid on a broad match and the search term was an exact match. For more information, see Budget and Bid Strategies. The possible values are Broad, Exact, Phrase, and Unknown.
CampaignTEXTThe campaign Name
Campaign IDTEXTThe campaign ID
CityCITYThe city where the user was physically located when they clicked the ad.
Click Share PercentPERCENTThe percentage of clicks that went to your ads. It is the share of the prospective customer's mindshare and buying intent you captured. You can use this performance metric to see where your growth opportunites are.
ClicksNUMERICThe number of clicks
Conversion RatePERCENTThe conversion rate as a percentage.
ConversionsNUMERICThe number of conversions
CostPerConversionNUMERICThe cost per conversion.
CountryCOUNTRYThe country where the user was physically located when they clicked the ad.
CountyTEXTThe county where the user was physically located when they clicked the ad.
CtrPERCENTThe number of clicks your ad receives (Clicks) divided by the number of times your ad is shown (Impressions).
CurrencyTEXTThe account currency type.
Currency CodeTEXTThe account currency type.
Daily SpendNUMERICThe average amount of campaign budget spent per day.
DateDATEThe date
Delivered Match TypeNUMERICThe match type used to deliver an ad. This can be different from the BidMatchType column, for example if you bid on a broad match and the search term was an exact match. For more information, see Budget and Bid Strategies. The possible values are Broad, Exact, Phrase, and Unknown.
Device TypeTEXTDevice type
Device OSTEXTThe operating system of the device reported in the DeviceType column. The possible values include Android, Blackberry, iOS, Other, Unknown, and Windows. If the operating system of the device cannot be determined or is not one of the operating systems that you can target, the value in this column will be Unknown.
Eligible Absolute Top ImpressionsNUMERICEligible Absolute Top Impressions
Eligible Top ImpressionsNUMERICEligible Top Impressions
The Final URL of the keywordTEXTOnly the first URL in the list is reported. If the URL contains dynamic text substitution parameters (for example, {param1}), the report will contain the URL before substitution.
Final Url SuffixTEXTA place in your final URL where you can add parameters that will be attached to the end of your landing page URL.
GoalTEXTThe name of the goal you set for the conversions you want, meaning actions customers take after clicking your ad.
Goal TypeTEXTThe type of conversion goal. Possible values include AppInstall, Duration, Event, InStoreTransaction, OfflineConversion, PagesViewedPerVisit, and Url.
Impression Lost To BudgetNUMERICImpression Lost To Budget
Impression Lost To Budget PercentPERCENTThe estimated percentage of impressions your ad did not receive due to issues with your daily or monthly budget.
Impression Share PercentPERCENTThe estimated percentage of impressions, out of the total available impressions in the market you were targeting.
ImpressionsNUMERICThe number of impressions
KeywordTEXTThe keyword.
The Keyword IDNUMERICThe keyword ID.
LanguageTEXTThe language of the publisher where the ad was shown. The language display name will be provided in the report e.g. English.
Location IdTEXTThe Microsoft Advertising identifier of the location where the user was physically located when they clicked the ad. For geographical location identifiers, see Geographical Location Codes. If the location ID is in the report but not found in the file downloaded via GetGeoLocationsFileUrl, it is not targetable.
Metro AreaTEXTThe metro area (Nielsen DMA in the United States) where the user was physically located when they clicked the ad.
Month to Date Budget SpendNUMERICThe amount of money spent to date for the month.
Monthly BudgetNUMERICThe anticipated maximum monthly budget amount that was calculated on the date of the most recent budget change.
NeighborhoodTEXTThe neighborhood where an ad was physically served, or the neighborhood that your customer had shown interest in through searches or content they had viewed. This helps you find out how your ads are doing in different locations, which can help you decide where to focus more of your advertising efforts.
Phone CallsNUMERICThe number of total calls to the tracked phone number that showed with your ad.
Postal CodeTEXTThe postal code where the user was physically located when they clicked the ad.
Potential ClicksNUMERICPotential Clicks
Proximity Target LocationTEXTThe radius target bid name. The name of the geographic radius where the user was physically located when they clicked the ad. The Radius attribute column contains the distance of the radius.
Query Intent CityCITYThe name of a city if the user's geographical intent can be determined. The city is set if the user's intent is a city, and not necessarily if they are physically located in the city.
Query Intent CountryTEXTThe name of a country if the user's geographical intent can be determined. The country is set if the user's intent is related to a country, and not necessarily if they are physically located in the county.
Query Intent CountyTEXTThe name of a county if the user's geographical intent can be determined. The county is set if the user's intent is related to a county, and not necessarily if they are physically located in the county.
Query Intent DMATEXTThe name of a metro area (Nielsen DMA in the United States) if the user's geographical intent can be determined. The metro area is set if the user's intent is a metro area or city within the metro area, and not necessarily if they are physically located in the metro area.
Query Intent Location IdTEXTThe location identifier if the user's geographical intent can be determined.
Query Intent NeighborhoodTEXTThe name of a neighborhood if the user's geographical intent can be determined. The neighborhood is set if the user's intent is related to a neighborhood, and not necessarily if they are physically located in the neighborhood. For example, the user's search query was rental cars in Encino.
Query Intent Postal CodeTEXTThe name of a postal code if the user's geographical intent can be determined. The postal code is set if the user's intent is a postal code, and not necessarily if they are physically located in the postal code.
Query Intent StateTEXTThe name of a state if the user's geographical intent can be determined. The state is set if the user's intent is a state or sub geography of the state, and not necessarily if they are physically located in the state.
RadiusNUMERICThe radius of a radius target bid. The geographic radius where the user was physically located when they clicked the ad. The ProximityTargetLocation attribute column contains the address or landmark name of the radius.
RevenueNUMERICThe amount of revenue
SpendNUMERICThe media spend
StateTEXTThe state where the user was physically located when they clicked the ad.
Top Impression Rate PercentPERCENTThe percentage of times your ad showed in the mainline, the top placement where ads appear above the search results, out of your total impressions.
Top Impression Lost To BudgetNUMERICTop Impression Lost To Budget
Top Impression Share Lost To Budget PercentPERCENTThe estimated percentage of mainline impressions, where ads appear above the search results, that were lost due to insufficient budget.
Top Impression Share Lost To RankNUMERICTop Impression Share Lost To Rank
Top Impression Share Lost To Rank PercentPERCENTA percentage estimate of how often poor ad rank kept your ad from showing in the mainline, the top ad placements above the search results.
Top Impression Share PercentPERCENTThe percentage of impressions for your ad in the mainline, the top ad placements above the search results, out of the estimated number of mainline impressions you were eligible to receive.
Top ImpressionsNUMERICTop Impressions
Top vs OtherTEXTIndicates whether the ad impression appeared in a top position or elsewhere. The possible values include AOL search - Top, AOL search - Other, Audience network, Bing and Yahoo! search - Top, Bing and Yahoo! search - Other, Syndicated search partners - Top, Syndicated search partners - Other, Content network, and Unknown.of your total impressions.
Total CostNUMERICThe media spend (Duplicate)
Transaction RevenueNUMERICThe amount of revenue
View Through RevenueNUMERICThe revenue optionally reported by the advertiser as a result of view-through conversions.
TodayDATEToday's date

Easily connect Bing Ads to Snowflake

See the value and return on every marketing touchpoint

data warehouse

Providing 70+ 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 Bing Ads and Snowflake Integrations