Microsoft Advertising (Bing) data warehouse table groups

Prev Next

Table: CAMPAIGN

AccountId
AccountName
AccountNumber
Budget
CampaignId
CampaignLabels
CampaignName
Clicks
Conversions
CurrencyCode
dataSourceName
Date
Impressions
ImpressionsLostToAdRelevance
ImpressionsLostToBid
ImpressionsLostToBudget
ImpressionsLostToExpectedCtr
Revenue
Spend
Spend_eur
Spend_gbp
Spend_usd

Table: AD

AccountId
AccountName
AccountNumber
AdDescription
AdDistribution
AdGroupId
AdGroupLabels
AdGroupName
AdGroupStatus
AdId
AdLabels
AdPath1
AdPath2
AdStatus
AdTitle
AdTitlePart1
AdTitlePart2
AdType
BidMatchType
CampaignId
CampaignName
Clicks
Conversions
CurrencyCode
dataSourceName
Date
DeliveredMatchType
DestinationUrl
DeviceOS
DeviceType
FinalURL
Impressions
Network
Revenue
Spend
Spend_eur
Spend_gbp
Spend_usd
TopVsOther
utm_campaign
utm_content
utm_medium
utm_source
utm_term

Table: KEYWORD

AccountId
AccountName
AccountNumber
AdGroupId
AdGroupName
BidMatchType
BidStrategyType
CampaignId
CampaignName
Clicks
CurrencyCode
CurrentMaxCpc
dataSourceName
Date
DeliveredMatchType
Impressions
Keyword
KeywordId
KeywordLabels
KeywordStatus
Network
Spend
Spend_eur
Spend_gbp
Spend_usd
TopVsOther
TrackingTemplate

Table: GEO

AccountId
AccountName
AccountNumber
City
Clicks
Conversions
Country
dataSourceName
Date
Impressions
Spend
Spend_eur
Spend_gbp
Spend_usd

Table: AUDIENCE

AccountId
AccountName
AccountNumber
AdGroupId
AdGroupName
AssociationStatus
AudienceId
AudienceName
BidAdjustment
CampaignName
dataSourceName
Date
Impressions
Spend

Table: AGE_GENDER

AccountId
AccountName
AccountNumber
AdGroupId
AdGroupName
AgeGroup
CampaignName
dataSourceName
Date
Gender
Impressions