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.

Integrations list with the Add integration button

Select Bing Ads from the list of available integrations.

Integration catalog with Bing Ads selected

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

Collect name field filled in with the example name 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.

Authorize button next to the Select Bing authorization field

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.

Select accounts drop-down open with example Bing Ads accounts

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").

Select accounts field with two example accounts selected

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.

Advanced settings open with the Tables to collect field

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.

Historical Data field filled in with 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.

Data collection settings with the Create button

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 NameModeType
DateNULLABLEDATE
AccountNameNULLABLESTRING
AccountIdNULLABLESTRING
AccountNumberNULLABLESTRING
CurrencyCodeNULLABLESTRING
ImpressionsNULLABLEINTEGER
ClicksNULLABLEINTEGER
CtrNULLABLEFLOAT
AverageCpcNULLABLEFLOAT
SpendNULLABLEFLOAT
AveragePositionNULLABLEFLOAT
ConversionsNULLABLEINTEGER
ConversionRateNULLABLEFLOAT
CostPerConversionNULLABLEFLOAT
LowQualityClicksNULLABLEINTEGER
LowQualityClicksPercentNULLABLEFLOAT
LowQualityImpressionsNULLABLEINTEGER
LowQualityImpressionsPercentNULLABLEFLOAT
LowQualityConversionsNULLABLEINTEGER
LowQualityConversionRateNULLABLEFLOAT
DeviceTypeNULLABLESTRING
DeviceOSNULLABLESTRING
PhoneImpressionsNULLABLEINTEGER
PhoneCallsNULLABLEINTEGER
PtrNULLABLEFLOAT
NetworkNULLABLESTRING
TopVsOtherNULLABLESTRING
BidMatchTypeNULLABLESTRING
DeliveredMatchTypeNULLABLESTRING
AssistsNULLABLEINTEGER
RevenueNULLABLEFLOAT
ReturnOnAdSpendNULLABLEFLOAT
CostPerAssistNULLABLEFLOAT
RevenuePerConversionNULLABLEFLOAT
RevenuePerAssistNULLABLEFLOAT
AccountStatusNULLABLESTRING
LowQualityGeneralClicksNULLABLEINTEGER
LowQualitySophisticatedClicksNULLABLEINTEGER
CustomerIdNULLABLESTRING
CustomerNameNULLABLESTRING
AllConversionsNULLABLEINTEGER
AllRevenueNULLABLEFLOAT
AllConversionRateNULLABLEFLOAT
AllCostPerConversionNULLABLEFLOAT
AllReturnOnAdSpendNULLABLEFLOAT
AllRevenuePerConversionNULLABLEFLOAT
ViewThroughConversionsNULLABLEINTEGER
AverageCpmNULLABLEFLOAT
ConversionsQualifiedNULLABLEFLOAT
LowQualityConversionsQualifiedNULLABLEFLOAT
AllConversionsQualifiedNULLABLEFLOAT
ViewThroughConversionsQualifiedNULLABLEFLOAT
ViewThroughRevenueNULLABLEFLOAT
VideoViewsNULLABLEINTEGER
ViewThroughRateNULLABLEFLOAT
AverageCPVNULLABLEFLOAT
VideoViewsAt25PercentNULLABLEINTEGER
VideoViewsAt50PercentNULLABLEINTEGER
VideoViewsAt75PercentNULLABLEINTEGER
CompletedVideoViewsNULLABLEINTEGER
VideoCompletionRateNULLABLEFLOAT
TotalWatchTimeInMSNULLABLEINTEGER
AverageWatchTimePerVideoViewNULLABLEFLOAT
AverageWatchTimePerImpressionNULLABLEFLOAT
Data schema for bing_campaign_performance
Field NameModeType
DateNULLABLEDATE
AccountNameNULLABLESTRING
AccountIdNULLABLESTRING
AccountNumberNULLABLESTRING
CampaignNameNULLABLESTRING
CampaignIdNULLABLESTRING
CampaignStatusNULLABLESTRING
BaseCampaignIdNULLABLESTRING
CampaignTypeNULLABLESTRING
CampaignLabelsNULLABLESTRING
CurrencyCodeNULLABLESTRING
ImpressionsNULLABLEINTEGER
ClicksNULLABLEINTEGER
CtrNULLABLEFLOAT
AverageCpcNULLABLEFLOAT
SpendNULLABLEFLOAT
AveragePositionNULLABLEFLOAT
ConversionsNULLABLEINTEGER
ConversionRateNULLABLEFLOAT
CostPerConversionNULLABLEFLOAT
LowQualityClicksNULLABLEINTEGER
LowQualityClicksPercentNULLABLEFLOAT
LowQualityImpressionsNULLABLEINTEGER
LowQualityImpressionsPercentNULLABLEFLOAT
LowQualityConversionsNULLABLEINTEGER
LowQualityConversionRateNULLABLEFLOAT
DeviceTypeNULLABLESTRING
DeviceOSNULLABLESTRING
PhoneImpressionsNULLABLEINTEGER
PhoneCallsNULLABLEINTEGER
PtrNULLABLEFLOAT
NetworkNULLABLESTRING
TopVsOtherNULLABLESTRING
BidMatchTypeNULLABLESTRING
DeliveredMatchTypeNULLABLESTRING
AssistsNULLABLEINTEGER
RevenueNULLABLEFLOAT
ReturnOnAdSpendNULLABLEFLOAT
CostPerAssistNULLABLEFLOAT
RevenuePerConversionNULLABLEFLOAT
RevenuePerAssistNULLABLEFLOAT
AccountStatusNULLABLESTRING
LowQualityGeneralClicksNULLABLEINTEGER
LowQualitySophisticatedClicksNULLABLEINTEGER
CustomerIdNULLABLESTRING
CustomerNameNULLABLESTRING
AllConversionsNULLABLEINTEGER
AllRevenueNULLABLEFLOAT
AllConversionRateNULLABLEFLOAT
AllCostPerConversionNULLABLEFLOAT
AllReturnOnAdSpendNULLABLEFLOAT
AllRevenuePerConversionNULLABLEFLOAT
ViewThroughConversionsNULLABLEINTEGER
AverageCpmNULLABLEFLOAT
ConversionsQualifiedNULLABLEFLOAT
LowQualityConversionsQualifiedNULLABLEFLOAT
AllConversionsQualifiedNULLABLEFLOAT
ViewThroughConversionsQualifiedNULLABLEFLOAT
ViewThroughRevenueNULLABLEFLOAT
VideoViewsNULLABLEINTEGER
ViewThroughRateNULLABLEFLOAT
AverageCPVNULLABLEFLOAT
VideoViewsAt25PercentNULLABLEINTEGER
VideoViewsAt50PercentNULLABLEINTEGER
VideoViewsAt75PercentNULLABLEINTEGER
CompletedVideoViewsNULLABLEINTEGER
VideoCompletionRateNULLABLEFLOAT
TotalWatchTimeInMSNULLABLEINTEGER
AverageWatchTimePerVideoViewNULLABLEFLOAT
AverageWatchTimePerImpressionNULLABLEFLOAT
Data schema for bing_product_dimension_performance
Field NameModeType
DateNULLABLEDATE
AccountNameNULLABLESTRING
AccountNumberNULLABLESTRING
AdGroupNameNULLABLESTRING
AdGroupIdNULLABLESTRING
CampaignStatusNULLABLESTRING
AccountStatusNULLABLESTRING
AdGroupStatusNULLABLESTRING
NetworkNULLABLESTRING
AdIdNULLABLESTRING
CampaignIdNULLABLESTRING
CampaignNameNULLABLESTRING
CurrencyCodeNULLABLESTRING
DeviceTypeNULLABLESTRING
LanguageNULLABLESTRING
MerchantProductIdNULLABLESTRING
TitleNULLABLESTRING
ConditionNULLABLESTRING
BrandNULLABLESTRING
PriceNULLABLEFLOAT
CustomLabel0NULLABLESTRING
CustomLabel1NULLABLESTRING
CustomLabel2NULLABLESTRING
CustomLabel3NULLABLESTRING
CustomLabel4NULLABLESTRING
ProductType1NULLABLESTRING
ProductType2NULLABLESTRING
ProductType3NULLABLESTRING
ProductType4NULLABLESTRING
ProductType5NULLABLESTRING
ProductCategory1NULLABLESTRING
ProductCategory2NULLABLESTRING
ProductCategory3NULLABLESTRING
ProductCategory4NULLABLESTRING
ProductCategory5NULLABLESTRING
ImpressionsNULLABLEINTEGER
ClicksNULLABLEINTEGER
CtrNULLABLEFLOAT
AverageCpcNULLABLEFLOAT
SpendNULLABLEFLOAT
ConversionsNULLABLEINTEGER
ConversionRateNULLABLEFLOAT
RevenueNULLABLEFLOAT
RevenuePerConversionNULLABLEFLOAT
SellerNameNULLABLESTRING
OfferLanguageNULLABLESTRING
CountryOfSaleNULLABLESTRING
AdStatusNULLABLESTRING
TopVsOtherNULLABLESTRING
AdDistributionNULLABLESTRING
ClickTypeIdNULLABLESTRING
TotalClicksOnAdElementsNULLABLEINTEGER
ClickTypeNULLABLESTRING
ReturnOnAdSpendNULLABLEFLOAT
BidStrategyTypeNULLABLESTRING
LocalStoreCodeNULLABLESTRING
StoreIdNULLABLESTRING
AssistedImpressionsNULLABLEINTEGER
AssistedClicksNULLABLEINTEGER
AssistedConversionsNULLABLEINTEGER
AllConversionsNULLABLEINTEGER
AllRevenueNULLABLEFLOAT
AllConversionRateNULLABLEFLOAT
AllCostPerConversionNULLABLEFLOAT
AllReturnOnAdSpendNULLABLEFLOAT
AllRevenuePerConversionNULLABLEFLOAT
CostPerConversionNULLABLEFLOAT
ViewThroughConversionsNULLABLEINTEGER
ProductBoughtNULLABLESTRING
QuantityBoughtNULLABLEINTEGER
AbsoluteTopImpressionRatePercentNULLABLEFLOAT
AverageCpmNULLABLEFLOAT
ConversionsQualifiedNULLABLEFLOAT
AssistedConversionsQualifiedNULLABLEFLOAT
AllConversionsQualifiedNULLABLEFLOAT
ViewThroughConversionsQualifiedNULLABLEFLOAT
ProductBoughtTitleNULLABLESTRING
GTINNULLABLESTRING
MPNNULLABLESTRING
ViewThroughRevenueNULLABLEFLOAT