Bing Ads (also known as Microsoft ads) is a pay per click advertising platform. It offers advertisers both the Bing and Yahoo! search engines.
Connect Bing Ads to Google BigQuery with Windsor.ai
+
Stream all your marketing data from Bing Ads to Google BigQuery
About Google BigQuery
Google BigQuery is a cloud based data warehouse. It allows flexible scaling and is a commonly used Platform as a Service solution.
Bing Ads metrics and dimensions available for streaming into Google BigQuery
| Name | Type | Description |
|---|---|---|
| Account Id | TEXT | The account id |
| Account Name | TEXT | The account name |
| Account Number | TEXT | The Microsoft Advertising assigned number of an account. |
| Account Status | TEXT | The account status |
| Ad group ID | NUMERIC | The ID of the AdGroup. |
| Ad group | TEXT | The name of the AdGroup. |
| Ad Network Conversions | NUMERIC | The ad network reported conversions |
| Ad Network Revenue | NUMERIC | The ad network reported revenue |
| All Conversion Rate | NUMERIC | The conversion rate as a percentage. |
| All Conversions | NUMERIC | The number of conversions. |
| AllCostPerConversion | NUMERIC | The cost per conversion. |
| All Revenue | NUMERIC | The revenue optionally reported by the advertiser as a result of conversions. |
| All Revenue Per Conversion | NUMERIC | The revenue per conversion.The formula for calculating the revenue per conversion is (Revenue / Conversions). |
| AllReturnOnAdSpend | NUMERIC | The return on ad spend (ROAS).The formula for calculating the ROAS is (Revenue / Spend). |
| Average Cpc | NUMERIC | The 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 Cpm | NUMERIC | The total advertising cost divided by the number of impressions (in thousands). |
| Average Position | NUMERIC | The average position of the ad on a webpage. |
| Campaign | TEXT | The campaign Name |
| Campaign ID | TEXT | The campaign ID |
| Clicks | NUMERIC | The number of clicks |
| Date | DATE | The date |
| Device Type | TEXT | Device type |
| The Final URL of the keyword | TEXT | Only 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 Suffix | TEXT | A place in your final URL where you can add parameters that will be attached to the end of your landing page URL. |
| Impression Share Percent | NUMERIC | The estimated percentage of impressions, out of the total available impressions in the market you were targeting. |
| Impressions | NUMERIC | The number of impressions |
| Keyword | TEXT | The keyword. |
| Ad group ID | NUMERIC | The keyword ID. |
| Spend | NUMERIC | The media spend |
| Top Impression Rate Percent | NUMERIC | The 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 Cost | NUMERIC | The media spend (Duplicate) |
| Revenue | NUMERIC | The amount of revenue |
| Conversions | NUMERIC | The number of conversions |
Windsor.ai: Easily connect Bing Ads to Google BigQuery
See the value and return on every marketing touchpoint
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.