Connect Bing Ads to Snowflake with

bing 1



Stream all your marketing data from Bing Ads to Snowflake

About Bing Ads

Bing Ads (also known as Microsoft ads) is a pay per click advertising platform. It offers advertisers both the Bing and Yahoo! search engines.

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 Bing Ads as a Data Source and Grant Access to

  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

Tableau Bing Ads Overview Dashboard Template

How to get your analytics, CRM and media data into BigQuery

Bing Ads metrics and dimensions available for streaming into Snowflake

Account IDTEXTThe account id
Account NameTEXTThe account name
Account NumberTEXTThe Microsoft Advertising assigned number of an account.
Account StatusTEXTThe account status
Ad group IDNUMERICThe ID of the AdGroup.
Ad groupTEXTThe name of the AdGroup.
Ad Network ConversionsNUMERICThe ad network reported conversions
Ad Network RevenueNUMERICThe ad network reported revenue
All Conversion RateNUMERICThe 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).
Average PositionNUMERICThe average position of the ad on a webpage.
CampaignTEXTThe campaign Name
Campaign IDTEXTThe campaign ID
ClicksNUMERICThe number of clicks
ConversionsNUMERICThe number of conversions
DateDATEThe date
Device TypeTEXTDevice type
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 Share PercentNUMERICThe estimated percentage of impressions, out of the total available impressions in the market you were targeting.
ImpressionsNUMERICThe number of impressions
KeywordTEXTThe keyword.
Ad group IDNUMERICThe keyword ID.
SpendNUMERICThe media spend
Top Impression Rate PercentNUMERICThe percentage of times your ad showed in the mainline, the top placement where ads appear above the search results, out of your total impressions.
Total CostNUMERICThe media spend (Duplicate)
RevenueNUMERICThe amount of revenue Easily connect Bing Ads 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.


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.