WitCloud Docs

# Bing Ads

# Introduction

The Bing Ads module allows for automatic retrieval of campaign data (costs, clicks, sales) from the Microsoft advertising system (Bing).

# Example of operation

  1. We configure the module in the platform by granting access to Bing Ads.
  2. We set up the module on a schedule - data will be collected and stored in the witcloud dataset.
  3. After processing the table, we can use other reporting modules that are integrated with it.

# Data schema

After running the module, three new tables will appear in the dataset.

image alt text

  1. bing_account_performance
Expand for the data schema
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
Goal NULLABLE STRING
GoalType NULLABLE STRING
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
  1. bing_campaign_performance
Expand for the data schema
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
Goal NULLABLE STRING
GoalType NULLABLE STRING
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
  1. bing_product_dimension_performance
Expand for the data schema
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
Goal NULLABLE STRING
GoalType NULLABLE STRING
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

# Configuration

# Before you start

TIP

Make sure your user has access to the appropriate Bing Ads accounts.

# Begin module creation

From the menu on the left, select the Collect tab, then click the Add new data Collect button**

image alt text

From the list of available modules, choose Bing Ads

image alt text

# Initial settings

In the first step, we need to fill in two fields.

Collect name - the name of our module. It will be visible under this name in other places on the platform.

image alt text

# Authorization with Bing Ads

In the next step, we need to grant WitCloud access to Bing Ads. This is necessary for WitCloud to retrieve data.

To do this, click the Click here to authorize button.

image alt text

Fill out the login and access form for the WitCloud application.

After successful authorization, choose the appropriate advertising account and click the Next button.

image alt text

# Setting up the module on a schedule

Your Bing Ads module is now created in WitCloud 📊. The last step is to specify the time range for which you need to retrieve historical data. The schedule for retrieving current data will be created automatically.

Enter the appropriate range and click the Finish button.

image alt text

Last updated: 2023-03-24T19:12:06.000Z

← Ceneo →