Microsoft Advertising data source

Microsoft Advertising (formerly Bing Ads, Microsoft adCenter and MSN adCenter) is a service that provides pay per click advertising on both the Bing and Yahoo! search engines. Visit Website ▸

Getting started

  1. Inside the admin panel go to Google BigQuery ▸ Data Sources page and click Add data source.
  2. Choose Microsoft Advertising from the list.
  3. Click Authenticate with Microsoft and go through the authentication flow.
  4. Select advertising account you would like to connect.
  5. Enable required reports.
  6. Click Save.

Available reports

SegmentStream allows to import the following reports from Microsoft Advertising.

Campaign performance

https://docs.microsoft.com/en-us/advertising/reporting-service/campaignperformancereportcolumn?view=bingads-13

Table name

microsoftAdsCampaignPerformance_{ACCOUNT_ID}_{YYYYMMDD}

Table schema

Field name Type Mode
AccountName STRING NULLABLE
AccountNumber STRING NULLABLE
AccountId STRING NULLABLE
TimePeriod STRING NULLABLE
CampaignName STRING NULLABLE
CampaignId STRING NULLABLE
AdGroupName STRING NULLABLE
AdGroupId STRING NULLABLE
Country STRING NULLABLE
State STRING NULLABLE
MetroArea STRING NULLABLE
City STRING NULLABLE
CurrencyCode STRING NULLABLE
AdDistribution STRING NULLABLE
Impressions STRING NULLABLE
Clicks STRING NULLABLE
Ctr STRING NULLABLE
AverageCpc STRING NULLABLE
Spend STRING NULLABLE
AveragePosition STRING NULLABLE
ProximityTargetLocation STRING NULLABLE
Radius STRING NULLABLE
Language STRING NULLABLE
BidMatchType STRING NULLABLE
DeliveredMatchType STRING NULLABLE
Network STRING NULLABLE
TopVsOther STRING NULLABLE
DeviceType STRING NULLABLE
DeviceOS STRING NULLABLE
Assists STRING NULLABLE
Conversions STRING NULLABLE
ConversionRate STRING NULLABLE
Revenue STRING NULLABLE
ReturnOnAdSpend STRING NULLABLE
CostPerConversion STRING NULLABLE
CostPerAssist STRING NULLABLE
RevenuePerConversion STRING NULLABLE
RevenuePerAssist STRING NULLABLE
LocationType STRING NULLABLE
MostSpecificLocation STRING NULLABLE
AccountStatus STRING NULLABLE
CampaignStatus STRING NULLABLE
AdGroupStatus STRING NULLABLE
County STRING NULLABLE
PostalCode STRING NULLABLE
LocationId STRING NULLABLE
BaseCampaignId STRING NULLABLE
AllConversions STRING NULLABLE
AllRevenue STRING NULLABLE
AllConversionRate STRING NULLABLE
AllCostPerConversion STRING NULLABLE
AllReturnOnAdSpend STRING NULLABLE
AllRevenuePerConversion STRING NULLABLE
ViewThroughConversions STRING NULLABLE

Ad group performance

https://docs.microsoft.com/en-us/advertising/reporting-service/adgroupperformancereportcolumn?view=bingads-13

Table name

microsoftAdsAdGroupPerformance_{ACCOUNT_ID}_{YYYYMMDD}

Table schema

Field name Type Mode
AccountName STRING NULLABLE
AccountNumber STRING NULLABLE
AccountId STRING NULLABLE
TimePeriod STRING NULLABLE
Status STRING NULLABLE
CampaignName STRING NULLABLE
CampaignId STRING NULLABLE
AdGroupName STRING NULLABLE
AdGroupId STRING NULLABLE
CurrencyCode STRING NULLABLE
AdDistribution STRING NULLABLE
Impressions STRING NULLABLE
Clicks STRING NULLABLE
Ctr STRING NULLABLE
AverageCpc STRING NULLABLE
Spend STRING NULLABLE
AveragePosition STRING NULLABLE
Conversions STRING NULLABLE
ConversionRate STRING NULLABLE
CostPerConversion STRING NULLABLE
DeviceType STRING NULLABLE
Language STRING NULLABLE
DeviceOS STRING NULLABLE
ImpressionSharePercent STRING NULLABLE
ImpressionLostToBudgetPercent STRING NULLABLE
ImpressionLostToRankAggPercent STRING NULLABLE
QualityScore STRING NULLABLE
ExpectedCtr STRING NULLABLE
AdRelevance STRING NULLABLE
LandingPageExperience STRING NULLABLE
HistoricalQualityScore STRING NULLABLE
HistoricalExpectedCtr STRING NULLABLE
HistoricalAdRelevance STRING NULLABLE
HistoricalLandingPageExperience STRING NULLABLE
PhoneImpressions STRING NULLABLE
PhoneCalls STRING NULLABLE
Ptr STRING NULLABLE
Network STRING NULLABLE
TopVsOther STRING NULLABLE
BidMatchType STRING NULLABLE
DeliveredMatchType STRING NULLABLE
Assists STRING NULLABLE
Revenue STRING NULLABLE
ReturnOnAdSpend STRING NULLABLE
CostPerAssist STRING NULLABLE
RevenuePerConversion STRING NULLABLE
RevenuePerAssist STRING NULLABLE
TrackingTemplate STRING NULLABLE
CustomParameters STRING NULLABLE
AccountStatus STRING NULLABLE
CampaignStatus STRING NULLABLE
AdGroupLabels STRING NULLABLE
ExactMatchImpressionSharePercent STRING NULLABLE
CustomerId STRING NULLABLE
CustomerName STRING NULLABLE
ClickSharePercent STRING NULLABLE
AbsoluteTopImpressionSharePercent STRING NULLABLE
FinalUrlSuffix STRING NULLABLE
CampaignType STRING NULLABLE
TopImpressionShareLostToRankPercent STRING NULLABLE
TopImpressionShareLostToBudgetPercent STRING NULLABLE
AbsoluteTopImpressionShareLostToRankPercent STRING NULLABLE
AbsoluteTopImpressionShareLostToBudgetPercent STRING NULLABLE
TopImpressionSharePercent STRING NULLABLE
AbsoluteTopImpressionRatePercent STRING NULLABLE
TopImpressionRatePercent STRING NULLABLE
BaseCampaignId STRING NULLABLE
AllConversions STRING NULLABLE
AllRevenue STRING NULLABLE
AllConversionRate STRING NULLABLE
AllCostPerConversion STRING NULLABLE
AllReturnOnAdSpend STRING NULLABLE
AllRevenuePerConversion STRING NULLABLE
ViewThroughConversions STRING NULLABLE

Ad performance

https://docs.microsoft.com/en-us/advertising/reporting-service/adperformancereportcolumn?view=bingads-13

Table name

microsoftAdsAdPerformance_{ACCOUNT_ID}_{YYYYMMDD}

Table schema

Field name Type Mode
AccountName STRING NULLABLE
AccountNumber STRING NULLABLE
AccountId STRING NULLABLE
TimePeriod STRING NULLABLE
CampaignName STRING NULLABLE
CampaignId STRING NULLABLE
AdGroupName STRING NULLABLE
AdId STRING NULLABLE
AdGroupId STRING NULLABLE
AdTitle STRING NULLABLE
AdDescription STRING NULLABLE
AdDescription2 STRING NULLABLE
AdType STRING NULLABLE
CurrencyCode STRING NULLABLE
AdDistribution STRING NULLABLE
Impressions STRING NULLABLE
Clicks STRING NULLABLE
Ctr STRING NULLABLE
AverageCpc STRING NULLABLE
Spend STRING NULLABLE
AveragePosition STRING NULLABLE
Conversions STRING NULLABLE
ConversionRate STRING NULLABLE
CostPerConversion STRING NULLABLE
DestinationUrl STRING NULLABLE
DeviceType STRING NULLABLE
Language STRING NULLABLE
DisplayUrl STRING NULLABLE
AdStatus STRING NULLABLE
Network STRING NULLABLE
TopVsOther STRING NULLABLE
BidMatchType STRING NULLABLE
DeliveredMatchType STRING NULLABLE
DeviceOS STRING NULLABLE
Assists STRING NULLABLE
Revenue STRING NULLABLE
ReturnOnAdSpend STRING NULLABLE
CostPerAssist STRING NULLABLE
RevenuePerConversion STRING NULLABLE
RevenuePerAssist STRING NULLABLE
TrackingTemplate STRING NULLABLE
CustomParameters STRING NULLABLE
FinalUrl STRING NULLABLE
FinalMobileUrl STRING NULLABLE
FinalAppUrl STRING NULLABLE
AccountStatus STRING NULLABLE
CampaignStatus STRING NULLABLE
AdGroupStatus STRING NULLABLE
TitlePart1 STRING NULLABLE
TitlePart2 STRING NULLABLE
TitlePart3 STRING NULLABLE
Headline STRING NULLABLE
LongHeadline STRING NULLABLE
BusinessName STRING NULLABLE
Path1 STRING NULLABLE
Path2 STRING NULLABLE
AdLabels STRING NULLABLE
CustomerId STRING NULLABLE
CustomerName STRING NULLABLE
CampaignType STRING NULLABLE
BaseCampaignId STRING NULLABLE
AllConversions STRING NULLABLE
AllRevenue STRING NULLABLE
AllConversionRate STRING NULLABLE
AllCostPerConversion STRING NULLABLE
AllReturnOnAdSpend STRING NULLABLE
AllRevenuePerConversion STRING NULLABLE
FinalUrlSuffix STRING NULLABLE
ViewThroughConversions STRING NULLABLE

Keyword performance

https://docs.microsoft.com/en-us/advertising/reporting-service/keywordperformancereportcolumn?view=bingads-13

Table name

microsoftAdsKeywordPerformance_{ACCOUNT_ID}_{YYYYMMDD}

Table schema

Field name Type Mode
AccountName STRING NULLABLE
AccountNumber STRING NULLABLE
AccountId STRING NULLABLE
TimePeriod STRING NULLABLE
CampaignName STRING NULLABLE
CampaignId STRING NULLABLE
AdGroupName STRING NULLABLE
AdGroupId STRING NULLABLE
Keyword STRING NULLABLE
KeywordId STRING NULLABLE
AdId STRING NULLABLE
AdType STRING NULLABLE
DestinationUrl STRING NULLABLE
CurrentMaxCpc STRING NULLABLE
CurrencyCode STRING NULLABLE
DeliveredMatchType STRING NULLABLE
AdDistribution STRING NULLABLE
Impressions STRING NULLABLE
Clicks STRING NULLABLE
Ctr STRING NULLABLE
AverageCpc STRING NULLABLE
Spend STRING NULLABLE
AveragePosition STRING NULLABLE
Conversions STRING NULLABLE
ConversionRate STRING NULLABLE
CostPerConversion STRING NULLABLE
BidMatchType STRING NULLABLE
DeviceType STRING NULLABLE
QualityScore STRING NULLABLE
ExpectedCtr STRING NULLABLE
AdRelevance STRING NULLABLE
LandingPageExperience STRING NULLABLE
Language STRING NULLABLE
HistoricalQualityScore STRING NULLABLE
HistoricalExpectedCtr STRING NULLABLE
HistoricalAdRelevance STRING NULLABLE
HistoricalLandingPageExperience STRING NULLABLE
QualityImpact STRING NULLABLE
CampaignStatus STRING NULLABLE
AccountStatus STRING NULLABLE
AdGroupStatus STRING NULLABLE
KeywordStatus STRING NULLABLE
Network STRING NULLABLE
TopVsOther STRING NULLABLE
DeviceOS STRING NULLABLE
Assists STRING NULLABLE
Revenue STRING NULLABLE
ReturnOnAdSpend STRING NULLABLE
CostPerAssist STRING NULLABLE
RevenuePerConversion STRING NULLABLE
RevenuePerAssist STRING NULLABLE
TrackingTemplate STRING NULLABLE
CustomParameters STRING NULLABLE
FinalUrl STRING NULLABLE
FinalMobileUrl STRING NULLABLE
FinalAppUrl STRING NULLABLE
BidStrategyType STRING NULLABLE
KeywordLabels STRING NULLABLE
Mainline1Bid STRING NULLABLE
MainlineBid STRING NULLABLE
FirstPageBid STRING NULLABLE
FinalUrlSuffix STRING NULLABLE
BaseCampaignId STRING NULLABLE
AllConversions STRING NULLABLE
AllRevenue STRING NULLABLE
AllConversionRate STRING NULLABLE
AllCostPerConversion STRING NULLABLE
AllReturnOnAdSpend STRING NULLABLE
AllRevenuePerConversion STRING NULLABLE
ViewThroughConversions STRING NULLABLE

Search query performance

https://docs.microsoft.com/en-us/advertising/reporting-service/searchqueryperformancereportcolumn?view=bingads-13

Table name

microsoftAdsSearchQueryPerformance_{ACCOUNT_ID}_{YYYYMMDD}

Table schema

Field name Type Mode
AccountName STRING NULLABLE
AccountNumber STRING NULLABLE
AccountId STRING NULLABLE
TimePeriod STRING NULLABLE
CampaignName STRING NULLABLE
CampaignId STRING NULLABLE
AdGroupName STRING NULLABLE
AdGroupId STRING NULLABLE
AdId STRING NULLABLE
AdType STRING NULLABLE
DestinationUrl STRING NULLABLE
BidMatchType STRING NULLABLE
DeliveredMatchType STRING NULLABLE
CampaignStatus STRING NULLABLE
AdStatus STRING NULLABLE
Impressions STRING NULLABLE
Clicks STRING NULLABLE
Ctr STRING NULLABLE
AverageCpc STRING NULLABLE
Spend STRING NULLABLE
AveragePosition STRING NULLABLE
SearchQuery STRING NULLABLE
Keyword STRING NULLABLE
AdGroupCriterionId STRING NULLABLE
Conversions STRING NULLABLE
ConversionRate STRING NULLABLE
CostPerConversion STRING NULLABLE
Language STRING NULLABLE
KeywordId STRING NULLABLE
Network STRING NULLABLE
TopVsOther STRING NULLABLE
DeviceType STRING NULLABLE
DeviceOS STRING NULLABLE
Assists STRING NULLABLE
Revenue STRING NULLABLE
ReturnOnAdSpend STRING NULLABLE
CostPerAssist STRING NULLABLE
RevenuePerConversion STRING NULLABLE
RevenuePerAssist STRING NULLABLE
AccountStatus STRING NULLABLE
AdGroupStatus STRING NULLABLE
KeywordStatus STRING NULLABLE
CampaignType STRING NULLABLE
CustomerId STRING NULLABLE
CustomerName STRING NULLABLE
AllConversions STRING NULLABLE
AllRevenue STRING NULLABLE
AllConversionRate STRING NULLABLE
AllCostPerConversion STRING NULLABLE
AllReturnOnAdSpend STRING NULLABLE
AllRevenuePerConversion STRING NULLABLE

Share of voice

https://docs.microsoft.com/en-us/advertising/reporting-service/shareofvoicereportcolumn?view=bingads-13

Table name

microsoftAdsShareOfVoice_{ACCOUNT_ID}_{YYYYMMDD}

Table schema

Field name Type Mode
AccountName STRING NULLABLE
TimePeriod STRING NULLABLE
CampaignName STRING NULLABLE
AdGroupName STRING NULLABLE
Keyword STRING NULLABLE
DeliveredMatchType STRING NULLABLE
BidMatchType STRING NULLABLE
Language STRING NULLABLE
AccountNumber STRING NULLABLE
AccountId STRING NULLABLE
KeywordId STRING NULLABLE
AdGroupId STRING NULLABLE
CampaignId STRING NULLABLE
Impressions STRING NULLABLE
Clicks STRING NULLABLE
Ctr STRING NULLABLE
AverageCpc STRING NULLABLE
Spend STRING NULLABLE
AveragePosition STRING NULLABLE
ImpressionSharePercent STRING NULLABLE
ImpressionLostToBudgetPercent STRING NULLABLE
ImpressionLostToRankAggPercent STRING NULLABLE
CurrentMaxCpc STRING NULLABLE
QualityScore STRING NULLABLE
ExpectedCtr STRING NULLABLE
AdRelevance STRING NULLABLE
LandingPageExperience STRING NULLABLE
Conversions STRING NULLABLE
ConversionRate STRING NULLABLE
CostPerConversion STRING NULLABLE
AdDistribution STRING NULLABLE
ClickSharePercent STRING NULLABLE
DeviceType STRING NULLABLE
Network STRING NULLABLE
AccountStatus STRING NULLABLE
CampaignStatus STRING NULLABLE
AdGroupStatus STRING NULLABLE
KeywordStatus STRING NULLABLE
BidStrategyType STRING NULLABLE
KeywordLabels STRING NULLABLE
ExactMatchImpressionSharePercent STRING NULLABLE
TopImpressionShareLostToRankPercent STRING NULLABLE
TopImpressionShareLostToBudgetPercent STRING NULLABLE
AbsoluteTopImpressionShareLostToRankPercent STRING NULLABLE
AbsoluteTopImpressionShareLostToBudgetPercent STRING NULLABLE
AbsoluteTopImpressionSharePercent STRING NULLABLE
TopImpressionSharePercent STRING NULLABLE
AbsoluteTopImpressionRatePercent STRING NULLABLE
TopImpressionRatePercent STRING NULLABLE
BaseCampaignId STRING NULLABLE
AllConversions STRING NULLABLE
AllConversionRate STRING NULLABLE
AllCostPerConversion STRING NULLABLE
ViewThroughConversions STRING NULLABLE

Audience performance

https://docs.microsoft.com/en-us/advertising/reporting-service/audienceperformancereportcolumn?view=bingads-13

Table name

microsoftAdsAudiencePerformance_{ACCOUNT_ID}_{YYYYMMDD}

Table schema

Field name Type Mode
AccountName STRING NULLABLE
AccountNumber STRING NULLABLE
AccountId STRING NULLABLE
TimePeriod STRING NULLABLE
CampaignName STRING NULLABLE
CampaignId STRING NULLABLE
AdGroupName STRING NULLABLE
AdGroupId STRING NULLABLE
AudienceId STRING NULLABLE
AudienceName STRING NULLABLE
AssociationStatus STRING NULLABLE
BidAdjustment STRING NULLABLE
TargetingSetting STRING NULLABLE
Impressions STRING NULLABLE
Clicks STRING NULLABLE
Ctr STRING NULLABLE
AverageCpc STRING NULLABLE
Spend STRING NULLABLE
AveragePosition STRING NULLABLE
Conversions STRING NULLABLE
ConversionRate STRING NULLABLE
CostPerConversion STRING NULLABLE
Revenue STRING NULLABLE
ReturnOnAdSpend STRING NULLABLE
RevenuePerConversion STRING NULLABLE
AccountStatus STRING NULLABLE
CampaignStatus STRING NULLABLE
AdGroupStatus STRING NULLABLE
AudienceType STRING NULLABLE
BaseCampaignId STRING NULLABLE
AllConversions STRING NULLABLE
AllRevenue STRING NULLABLE
AllConversionRate STRING NULLABLE
AllCostPerConversion STRING NULLABLE
AllReturnOnAdSpend STRING NULLABLE
AllRevenuePerConversion STRING NULLABLE
AssociationId STRING NULLABLE
AssociationLevel STRING NULLABLE
ViewThroughConversions STRING NULLABLE

Geographic performance

https://docs.microsoft.com/en-us/advertising/reporting-service/geographicperformancereportcolumn?view=bingads-13

Table name

microsoftAdsGeographicPerformance_{ACCOUNT_ID}_{YYYYMMDD}

Table schema

Field name Type Mode
AccountName STRING NULLABLE
AccountNumber STRING NULLABLE
AccountId STRING NULLABLE
TimePeriod STRING NULLABLE
CampaignName STRING NULLABLE
CampaignId STRING NULLABLE
AdGroupName STRING NULLABLE
AdGroupId STRING NULLABLE
Country STRING NULLABLE
State STRING NULLABLE
MetroArea STRING NULLABLE
City STRING NULLABLE
CurrencyCode STRING NULLABLE
AdDistribution STRING NULLABLE
Impressions STRING NULLABLE
Clicks STRING NULLABLE
Ctr STRING NULLABLE
AverageCpc STRING NULLABLE
Spend STRING NULLABLE
AveragePosition STRING NULLABLE
ProximityTargetLocation STRING NULLABLE
Radius STRING NULLABLE
Language STRING NULLABLE
BidMatchType STRING NULLABLE
DeliveredMatchType STRING NULLABLE
Network STRING NULLABLE
TopVsOther STRING NULLABLE
DeviceType STRING NULLABLE
DeviceOS STRING NULLABLE
Assists STRING NULLABLE
Conversions STRING NULLABLE
ConversionRate STRING NULLABLE
Revenue STRING NULLABLE
ReturnOnAdSpend STRING NULLABLE
CostPerConversion STRING NULLABLE
CostPerAssist STRING NULLABLE
RevenuePerConversion STRING NULLABLE
RevenuePerAssist STRING NULLABLE
LocationType STRING NULLABLE
MostSpecificLocation STRING NULLABLE
AccountStatus STRING NULLABLE
CampaignStatus STRING NULLABLE
AdGroupStatus STRING NULLABLE
County STRING NULLABLE
PostalCode STRING NULLABLE
LocationId STRING NULLABLE
BaseCampaignId STRING NULLABLE
AllConversions STRING NULLABLE
AllRevenue STRING NULLABLE
AllConversionRate STRING NULLABLE
AllCostPerConversion STRING NULLABLE
AllReturnOnAdSpend STRING NULLABLE
AllRevenuePerConversion STRING NULLABLE
ViewThroughConversions STRING NULLABLE

Age and gender audience

https://docs.microsoft.com/en-us/advertising/reporting-service/agegenderaudiencereportcolumn?view=bingads-13

Table name

microsoftAdsAgeGenderAudience_{ACCOUNT_ID}_{YYYYMMDD}

Table schema

Field name Type Mode
AccountName STRING NULLABLE
AccountNumber STRING NULLABLE
AccountId STRING NULLABLE
TimePeriod STRING NULLABLE
CampaignName STRING NULLABLE
CampaignId STRING NULLABLE
AdGroupName STRING NULLABLE
AdGroupId STRING NULLABLE
AdDistribution STRING NULLABLE
AgeGroup STRING NULLABLE
Gender STRING NULLABLE
Impressions STRING NULLABLE
Clicks STRING NULLABLE
Conversions STRING NULLABLE
Spend STRING NULLABLE
Revenue STRING NULLABLE
ExtendedCost STRING NULLABLE
Assists STRING NULLABLE
Language STRING NULLABLE
AccountStatus STRING NULLABLE
CampaignStatus STRING NULLABLE
AdGroupStatus STRING NULLABLE
BaseCampaignId STRING NULLABLE
AllConversions STRING NULLABLE
AllRevenue STRING NULLABLE
ViewThroughConversions STRING NULLABLE

This document was last updated on July 27, 2020. If you notice any gaps, outdated information or simply want to leave some feedback to help us improve our documentation, please let us know!