Integration of Bing Ads with BigQuery
Learn how to connect Bing Ads to Google BigQuery using WitCloud and automatically fetch account, campaign and product performance data.
Updated
Introduction
This integration connects Bing Ads (Microsoft Advertising) to Google Cloud BigQuery. It collects account, campaign and product performance reports, so you can analyze the results of your Bing campaigns next to the rest of your data in WitCloud.
Configuration guide
Follow the steps below to connect Bing Ads with BigQuery. Once the setup is complete, your Bing Ads data will be transferred to your BigQuery project.
Make sure you have admin access to your Bing Ads account before starting the configuration.
Module setup
Go to Integrations in the menu and click Add integration.

Select Bing Ads from the list of available integrations.

Enter the Collect name, e.g., "Bing Ads PL".

Authorization
If you have previously authorized the Bing module and do not require additional permissions, you can skip this step and pick the existing authorization from the Select Bing authorization drop-down.
If you run into issues granting access to Microsoft Advertising (Bing) in an Azure environment, ask your IT admin to grant tenant-wide admin consent for the Microsoft Advertising API in Azure AD. This will add the required delegated permissions. Once consent is granted, any user with at least the Viewer role in Microsoft Advertising will be able to connect their account in WitCloud without any additional approval.
Click Authorize.

Log in with your Microsoft account and grant the necessary permissions.
After you return to WitCloud, open Select accounts and choose the Bing Ads accounts you want to collect.

You can select several accounts at once — WitCloud creates a separate collect for each of them, named after the Collect name and the account name (for example "Bing Ads PL - Demo Store PL").

Optionally, click Show advanced settings. Tables to collect lets you filter the tables you want to collect; by default all of them are selected, and at least one table is required.

Click Next.
Historical data and scheduling
In Historical Data, enter the number of days for which you want to fetch historical data. You can enter up to 365 days.

A data synchronization schedule will be created automatically. More information on this topic can be found here.
Click Create to complete the configuration.

Done! Your Bing Ads data will now be synchronized with BigQuery.
Data schema
Expand the tables below to view the full data schema collected from Bing Ads.
Data schema for bing_account_performance
| Field Name | Mode | Type |
|---|---|---|
| Date | NULLABLE | DATE |
| AccountName | NULLABLE | STRING |
| AccountId | NULLABLE | STRING |
| AccountNumber | NULLABLE | STRING |
| CurrencyCode | NULLABLE | STRING |
| Impressions | NULLABLE | INTEGER |
| Clicks | NULLABLE | INTEGER |
| Ctr | NULLABLE | FLOAT |
| AverageCpc | NULLABLE | FLOAT |
| Spend | NULLABLE | FLOAT |
| AveragePosition | NULLABLE | FLOAT |
| Conversions | NULLABLE | INTEGER |
| ConversionRate | NULLABLE | FLOAT |
| CostPerConversion | NULLABLE | FLOAT |
| LowQualityClicks | NULLABLE | INTEGER |
| LowQualityClicksPercent | NULLABLE | FLOAT |
| LowQualityImpressions | NULLABLE | INTEGER |
| LowQualityImpressionsPercent | NULLABLE | FLOAT |
| LowQualityConversions | NULLABLE | INTEGER |
| LowQualityConversionRate | NULLABLE | FLOAT |
| DeviceType | NULLABLE | STRING |
| DeviceOS | NULLABLE | STRING |
| PhoneImpressions | NULLABLE | INTEGER |
| PhoneCalls | NULLABLE | INTEGER |
| Ptr | NULLABLE | FLOAT |
| Network | NULLABLE | STRING |
| TopVsOther | NULLABLE | STRING |
| BidMatchType | NULLABLE | STRING |
| DeliveredMatchType | NULLABLE | STRING |
| Assists | NULLABLE | INTEGER |
| Revenue | NULLABLE | FLOAT |
| ReturnOnAdSpend | NULLABLE | FLOAT |
| CostPerAssist | NULLABLE | FLOAT |
| RevenuePerConversion | NULLABLE | FLOAT |
| RevenuePerAssist | NULLABLE | FLOAT |
| AccountStatus | NULLABLE | STRING |
| LowQualityGeneralClicks | NULLABLE | INTEGER |
| LowQualitySophisticatedClicks | NULLABLE | INTEGER |
| CustomerId | NULLABLE | STRING |
| CustomerName | NULLABLE | STRING |
| AllConversions | NULLABLE | INTEGER |
| AllRevenue | NULLABLE | FLOAT |
| AllConversionRate | NULLABLE | FLOAT |
| AllCostPerConversion | NULLABLE | FLOAT |
| AllReturnOnAdSpend | NULLABLE | FLOAT |
| AllRevenuePerConversion | NULLABLE | FLOAT |
| ViewThroughConversions | NULLABLE | INTEGER |
| AverageCpm | NULLABLE | FLOAT |
| ConversionsQualified | NULLABLE | FLOAT |
| LowQualityConversionsQualified | NULLABLE | FLOAT |
| AllConversionsQualified | NULLABLE | FLOAT |
| ViewThroughConversionsQualified | NULLABLE | FLOAT |
| ViewThroughRevenue | NULLABLE | FLOAT |
| VideoViews | NULLABLE | INTEGER |
| ViewThroughRate | NULLABLE | FLOAT |
| AverageCPV | NULLABLE | FLOAT |
| VideoViewsAt25Percent | NULLABLE | INTEGER |
| VideoViewsAt50Percent | NULLABLE | INTEGER |
| VideoViewsAt75Percent | NULLABLE | INTEGER |
| CompletedVideoViews | NULLABLE | INTEGER |
| VideoCompletionRate | NULLABLE | FLOAT |
| TotalWatchTimeInMS | NULLABLE | INTEGER |
| AverageWatchTimePerVideoView | NULLABLE | FLOAT |
| AverageWatchTimePerImpression | NULLABLE | FLOAT |
Data schema for bing_campaign_performance
| Field Name | Mode | Type |
|---|---|---|
| Date | NULLABLE | DATE |
| AccountName | NULLABLE | STRING |
| AccountId | NULLABLE | STRING |
| AccountNumber | NULLABLE | STRING |
| CampaignName | NULLABLE | STRING |
| CampaignId | NULLABLE | STRING |
| CampaignStatus | NULLABLE | STRING |
| BaseCampaignId | NULLABLE | STRING |
| CampaignType | NULLABLE | STRING |
| CampaignLabels | NULLABLE | STRING |
| CurrencyCode | NULLABLE | STRING |
| Impressions | NULLABLE | INTEGER |
| Clicks | NULLABLE | INTEGER |
| Ctr | NULLABLE | FLOAT |
| AverageCpc | NULLABLE | FLOAT |
| Spend | NULLABLE | FLOAT |
| AveragePosition | NULLABLE | FLOAT |
| Conversions | NULLABLE | INTEGER |
| ConversionRate | NULLABLE | FLOAT |
| CostPerConversion | NULLABLE | FLOAT |
| LowQualityClicks | NULLABLE | INTEGER |
| LowQualityClicksPercent | NULLABLE | FLOAT |
| LowQualityImpressions | NULLABLE | INTEGER |
| LowQualityImpressionsPercent | NULLABLE | FLOAT |
| LowQualityConversions | NULLABLE | INTEGER |
| LowQualityConversionRate | NULLABLE | FLOAT |
| DeviceType | NULLABLE | STRING |
| DeviceOS | NULLABLE | STRING |
| PhoneImpressions | NULLABLE | INTEGER |
| PhoneCalls | NULLABLE | INTEGER |
| Ptr | NULLABLE | FLOAT |
| Network | NULLABLE | STRING |
| TopVsOther | NULLABLE | STRING |
| BidMatchType | NULLABLE | STRING |
| DeliveredMatchType | NULLABLE | STRING |
| Assists | NULLABLE | INTEGER |
| Revenue | NULLABLE | FLOAT |
| ReturnOnAdSpend | NULLABLE | FLOAT |
| CostPerAssist | NULLABLE | FLOAT |
| RevenuePerConversion | NULLABLE | FLOAT |
| RevenuePerAssist | NULLABLE | FLOAT |
| AccountStatus | NULLABLE | STRING |
| LowQualityGeneralClicks | NULLABLE | INTEGER |
| LowQualitySophisticatedClicks | NULLABLE | INTEGER |
| CustomerId | NULLABLE | STRING |
| CustomerName | NULLABLE | STRING |
| AllConversions | NULLABLE | INTEGER |
| AllRevenue | NULLABLE | FLOAT |
| AllConversionRate | NULLABLE | FLOAT |
| AllCostPerConversion | NULLABLE | FLOAT |
| AllReturnOnAdSpend | NULLABLE | FLOAT |
| AllRevenuePerConversion | NULLABLE | FLOAT |
| ViewThroughConversions | NULLABLE | INTEGER |
| AverageCpm | NULLABLE | FLOAT |
| ConversionsQualified | NULLABLE | FLOAT |
| LowQualityConversionsQualified | NULLABLE | FLOAT |
| AllConversionsQualified | NULLABLE | FLOAT |
| ViewThroughConversionsQualified | NULLABLE | FLOAT |
| ViewThroughRevenue | NULLABLE | FLOAT |
| VideoViews | NULLABLE | INTEGER |
| ViewThroughRate | NULLABLE | FLOAT |
| AverageCPV | NULLABLE | FLOAT |
| VideoViewsAt25Percent | NULLABLE | INTEGER |
| VideoViewsAt50Percent | NULLABLE | INTEGER |
| VideoViewsAt75Percent | NULLABLE | INTEGER |
| CompletedVideoViews | NULLABLE | INTEGER |
| VideoCompletionRate | NULLABLE | FLOAT |
| TotalWatchTimeInMS | NULLABLE | INTEGER |
| AverageWatchTimePerVideoView | NULLABLE | FLOAT |
| AverageWatchTimePerImpression | NULLABLE | FLOAT |
Data schema for bing_product_dimension_performance
| Field Name | Mode | Type |
|---|---|---|
| Date | NULLABLE | DATE |
| AccountName | NULLABLE | STRING |
| AccountNumber | NULLABLE | STRING |
| AdGroupName | NULLABLE | STRING |
| AdGroupId | NULLABLE | STRING |
| CampaignStatus | NULLABLE | STRING |
| AccountStatus | NULLABLE | STRING |
| AdGroupStatus | NULLABLE | STRING |
| Network | NULLABLE | STRING |
| AdId | NULLABLE | STRING |
| CampaignId | NULLABLE | STRING |
| CampaignName | NULLABLE | STRING |
| CurrencyCode | NULLABLE | STRING |
| DeviceType | NULLABLE | STRING |
| Language | NULLABLE | STRING |
| MerchantProductId | NULLABLE | STRING |
| Title | NULLABLE | STRING |
| Condition | NULLABLE | STRING |
| Brand | NULLABLE | STRING |
| Price | NULLABLE | FLOAT |
| CustomLabel0 | NULLABLE | STRING |
| CustomLabel1 | NULLABLE | STRING |
| CustomLabel2 | NULLABLE | STRING |
| CustomLabel3 | NULLABLE | STRING |
| CustomLabel4 | NULLABLE | STRING |
| ProductType1 | NULLABLE | STRING |
| ProductType2 | NULLABLE | STRING |
| ProductType3 | NULLABLE | STRING |
| ProductType4 | NULLABLE | STRING |
| ProductType5 | NULLABLE | STRING |
| ProductCategory1 | NULLABLE | STRING |
| ProductCategory2 | NULLABLE | STRING |
| ProductCategory3 | NULLABLE | STRING |
| ProductCategory4 | NULLABLE | STRING |
| ProductCategory5 | NULLABLE | STRING |
| Impressions | NULLABLE | INTEGER |
| Clicks | NULLABLE | INTEGER |
| Ctr | NULLABLE | FLOAT |
| AverageCpc | NULLABLE | FLOAT |
| Spend | NULLABLE | FLOAT |
| Conversions | NULLABLE | INTEGER |
| ConversionRate | NULLABLE | FLOAT |
| Revenue | NULLABLE | FLOAT |
| RevenuePerConversion | NULLABLE | FLOAT |
| SellerName | NULLABLE | STRING |
| OfferLanguage | NULLABLE | STRING |
| CountryOfSale | NULLABLE | STRING |
| AdStatus | NULLABLE | STRING |
| TopVsOther | NULLABLE | STRING |
| AdDistribution | NULLABLE | STRING |
| ClickTypeId | NULLABLE | STRING |
| TotalClicksOnAdElements | NULLABLE | INTEGER |
| ClickType | NULLABLE | STRING |
| ReturnOnAdSpend | NULLABLE | FLOAT |
| BidStrategyType | NULLABLE | STRING |
| LocalStoreCode | NULLABLE | STRING |
| StoreId | NULLABLE | STRING |
| AssistedImpressions | NULLABLE | INTEGER |
| AssistedClicks | NULLABLE | INTEGER |
| AssistedConversions | NULLABLE | INTEGER |
| AllConversions | NULLABLE | INTEGER |
| AllRevenue | NULLABLE | FLOAT |
| AllConversionRate | NULLABLE | FLOAT |
| AllCostPerConversion | NULLABLE | FLOAT |
| AllReturnOnAdSpend | NULLABLE | FLOAT |
| AllRevenuePerConversion | NULLABLE | FLOAT |
| CostPerConversion | NULLABLE | FLOAT |
| ViewThroughConversions | NULLABLE | INTEGER |
| ProductBought | NULLABLE | STRING |
| QuantityBought | NULLABLE | INTEGER |
| AbsoluteTopImpressionRatePercent | NULLABLE | FLOAT |
| AverageCpm | NULLABLE | FLOAT |
| ConversionsQualified | NULLABLE | FLOAT |
| AssistedConversionsQualified | NULLABLE | FLOAT |
| AllConversionsQualified | NULLABLE | FLOAT |
| ViewThroughConversionsQualified | NULLABLE | FLOAT |
| ProductBoughtTitle | NULLABLE | STRING |
| GTIN | NULLABLE | STRING |
| MPN | NULLABLE | STRING |
| ViewThroughRevenue | NULLABLE | FLOAT |
