Columns and primary key of report configuration presets
Look up the columns and primary key of each Microsoft Advertising (Bing Ads) report preset, for daily and hourly aggregation.
These are the columns and the primary key that each report preset of the Microsoft Advertising (Bing Ads) connector uses, for daily and for hourly aggregation.
AccountPerformance Report Presets
Section titled “AccountPerformance Report Presets”Daily aggregation
Section titled “Daily aggregation”Columns
Section titled “Columns”TimePeriod, CurrencyCode, AdDistribution, DeviceType, Network, AccountId, AccountName, DeliveredMatchType, BidMatchType, DeviceOS, Goal, GoalType, TopVsOther, Impressions, Clicks, Ctr, Spend, ReturnOnAdSpend, AllConversionsQualified, ViewThroughConversionsQualified, PhoneImpressions, PhoneCalls, CostPerConversion, Ptr, Assists, CostPerAssist, AverageCpc, AverageCpm, AveragePosition, ConversionRate, ConversionsQualified, LowQualityClicks, LowQualityClicksPercent, LowQualityConversionRate, LowQualityConversions, LowQualityConversionsQualified, LowQualityGeneralClicks, LowQualityImpressions, LowQualityImpressionsPercent, LowQualitySophisticatedClicks, Revenue, RevenuePerConversion, RevenuePerAssistPrimary key
Section titled “Primary key”TimePeriod, CurrencyCode, AdDistribution, DeviceType, Network, AccountId, DeliveredMatchType, BidMatchType, DeviceOS, Goal, GoalType, TopVsOtherHourly aggregation
Section titled “Hourly aggregation”Columns
Section titled “Columns”TimePeriod, CurrencyCode, AdDistribution, DeviceType, Network, AccountId, AccountName, DeliveredMatchType, BidMatchType, DeviceOS, Goal, GoalType, TopVsOther, Impressions, Clicks, Ctr, Spend, ReturnOnAdSpend, AllConversionsQualified, ViewThroughConversionsQualified, PhoneImpressions, PhoneCalls, CostPerConversion, Ptr, Assists, CostPerAssist, AverageCpc, AverageCpm, AveragePosition, ConversionRate, ConversionsQualified, LowQualityClicks, LowQualityClicksPercent, LowQualityConversionRate, LowQualityConversions, LowQualityConversionsQualified, LowQualityGeneralClicks, LowQualityImpressions, LowQualityImpressionsPercent, LowQualitySophisticatedClicks, Revenue, RevenuePerConversion, RevenuePerAssistPrimary key
Section titled “Primary key”TimePeriod, CurrencyCode, AdDistribution, DeviceType, Network, AccountId, DeliveredMatchType, BidMatchType, DeviceOS, Goal, GoalType, TopVsOtherAccountImpressionPerformance Report Presets
Section titled “AccountImpressionPerformance Report Presets”Daily aggregation
Section titled “Daily aggregation”Columns
Section titled “Columns”TimePeriod, CurrencyCode, AdDistribution, DeviceType, Network, AccountId, AccountName, DeliveredMatchType, Impressions, Clicks, Ctr, Spend, ReturnOnAdSpend, AllConversionsQualified, ViewThroughConversionsQualified, PhoneImpressions, PhoneCalls, CostPerConversion, Ptr, Assists, CostPerAssist, AbsoluteTopImpressionRatePercent, AbsoluteTopImpressionShareLostToBudgetPercent, AbsoluteTopImpressionShareLostToRankPercent, AbsoluteTopImpressionSharePercent, ClickSharePercent, ExactMatchImpressionSharePercent, ImpressionLostToBudgetPercent, ImpressionLostToRankAggPercent, AverageCpc, AverageCpm, AveragePosition, ConversionRate, ConversionsQualified, LowQualityClicks, LowQualityClicksPercent, LowQualityConversionRate, LowQualityConversions, LowQualityConversionsQualified, LowQualityGeneralClicks, LowQualityImpressions, LowQualityImpressionsPercent, LowQualitySophisticatedClicks, Revenue, RevenuePerConversion, RevenuePerAssist, ImpressionSharePercentPrimary key
Section titled “Primary key”TimePeriod, CurrencyCode, AdDistribution, DeviceType, Network, AccountId, DeliveredMatchTypeHourly aggregation
Section titled “Hourly aggregation”Columns
Section titled “Columns”TimePeriod, CurrencyCode, AdDistribution, DeviceType, Network, AccountId, AccountName, DeliveredMatchType, Impressions, Clicks, Ctr, Spend, ReturnOnAdSpend, AllConversionsQualified, ViewThroughConversionsQualified, PhoneImpressions, PhoneCalls, CostPerConversion, Ptr, Assists, CostPerAssist, AverageCpc, AverageCpm, AveragePosition, ConversionRate, ConversionsQualified, LowQualityClicks, LowQualityClicksPercent, LowQualityConversionRate, LowQualityConversions, LowQualityConversionsQualified, LowQualityGeneralClicks, LowQualityImpressions, LowQualityImpressionsPercent, LowQualitySophisticatedClicks, Revenue, RevenuePerConversion, RevenuePerAssistPrimary key
Section titled “Primary key”TimePeriod, CurrencyCode, AdDistribution, DeviceType, Network, AccountId, DeliveredMatchTypeAdGroupPerformance Report Presets
Section titled “AdGroupPerformance Report Presets”Daily aggregation
Section titled “Daily aggregation”Columns
Section titled “Columns”TimePeriod, CurrencyCode, AdDistribution, DeviceType, Network, AccountId, AccountName, DeliveredMatchType, CampaignId, CampaignName, AdGroupId, AdGroupName, Language, Impressions, Clicks, Ctr, Spend, ReturnOnAdSpend, AllConversionsQualified, ViewThroughConversionsQualified, PhoneImpressions, PhoneCalls, CostPerConversion, Ptr, Assists, CostPerAssist, QualityScore, ExpectedCtr, AdRelevance, LandingPageExperience, CampaignStatus, CustomParameters, FinalUrlSuffix, AllRevenue, AllRevenuePerConversion, AverageCpc, AverageCpm, AveragePosition, ConversionRate, ConversionsQualified, Revenue, RevenuePerConversion, RevenuePerAssist, BidMatchType, DeviceOS, Goal, GoalType, TopVsOther, HistoricalAdRelevance, HistoricalExpectedCtr, HistoricalLandingPageExperience, HistoricalQualityScorePrimary key
Section titled “Primary key”TimePeriod, CurrencyCode, AdDistribution, DeviceType, Network, AccountId, DeliveredMatchType, CampaignId, AdGroupId, Language, BidMatchType, DeviceOS, Goal, GoalType, TopVsOtherHourly aggregation
Section titled “Hourly aggregation”Columns
Section titled “Columns”TimePeriod, CurrencyCode, AdDistribution, DeviceType, Network, AccountId, AccountName, DeliveredMatchType, CampaignId, CampaignName, AdGroupId, AdGroupName, Language, Impressions, Clicks, Ctr, Spend, ReturnOnAdSpend, AllConversionsQualified, ViewThroughConversionsQualified, PhoneImpressions, PhoneCalls, CostPerConversion, Ptr, Assists, CostPerAssist, QualityScore, ExpectedCtr, AdRelevance, LandingPageExperience, CampaignStatus, CustomParameters, FinalUrlSuffix, AllRevenue, AllRevenuePerConversion, AverageCpc, AverageCpm, AveragePosition, ConversionRate, ConversionsQualified, Revenue, RevenuePerConversion, RevenuePerAssist, BidMatchType, DeviceOS, Goal, GoalType, TopVsOtherPrimary key
Section titled “Primary key”TimePeriod, CurrencyCode, AdDistribution, DeviceType, Network, AccountId, DeliveredMatchType, CampaignId, AdGroupId, Language, BidMatchType, DeviceOS, Goal, GoalType, TopVsOtherAdGroupImpressionPerformance Report Presets
Section titled “AdGroupImpressionPerformance Report Presets”Daily aggregation
Section titled “Daily aggregation”Columns
Section titled “Columns”TimePeriod, CurrencyCode, AdDistribution, DeviceType, Network, AccountId, AccountName, DeliveredMatchType, CampaignId, CampaignName, AdGroupId, AdGroupName, Language, Impressions, Clicks, Ctr, Spend, ReturnOnAdSpend, AllConversionsQualified, ViewThroughConversionsQualified, PhoneImpressions, PhoneCalls, CostPerConversion, Ptr, Assists, CostPerAssist, QualityScore, ExpectedCtr, AdRelevance, LandingPageExperience, CampaignStatus, CustomParameters, FinalUrlSuffix, AllRevenue, AllRevenuePerConversion, AverageCpc, AverageCpm, AveragePosition, ConversionRate, ConversionsQualified, Revenue, RevenuePerConversion, RevenuePerAssist, AbsoluteTopImpressionRatePercent, AbsoluteTopImpressionShareLostToBudgetPercent, AbsoluteTopImpressionShareLostToRankPercent, AbsoluteTopImpressionSharePercent, ClickSharePercent, ExactMatchImpressionSharePercent, ImpressionLostToBudgetPercent, ImpressionLostToRankAggPercent, ImpressionSharePercent, HistoricalAdRelevance, HistoricalExpectedCtr, HistoricalLandingPageExperience, HistoricalQualityScorePrimary key
Section titled “Primary key”TimePeriod, CurrencyCode, AdDistribution, DeviceType, Network, AccountId, DeliveredMatchType, CampaignId, AdGroupId, LanguageHourly aggregation
Section titled “Hourly aggregation”Columns
Section titled “Columns”TimePeriod, CurrencyCode, AdDistribution, DeviceType, Network, AccountId, AccountName, DeliveredMatchType, CampaignId, CampaignName, AdGroupId, AdGroupName, Language, Impressions, Clicks, Ctr, Spend, ReturnOnAdSpend, AllConversionsQualified, ViewThroughConversionsQualified, PhoneImpressions, PhoneCalls, CostPerConversion, Ptr, Assists, CostPerAssist, QualityScore, ExpectedCtr, AdRelevance, LandingPageExperience, CampaignStatus, CustomParameters, FinalUrlSuffix, AllRevenue, AllRevenuePerConversion, AverageCpc, AverageCpm, AveragePosition, ConversionRate, ConversionsQualified, Revenue, RevenuePerConversion, RevenuePerAssistPrimary key
Section titled “Primary key”TimePeriod, CurrencyCode, AdDistribution, DeviceType, Network, AccountId, DeliveredMatchType, CampaignId, AdGroupId, LanguageCampaignPerformance Report Presets
Section titled “CampaignPerformance Report Presets”Daily aggregation
Section titled “Daily aggregation”Columns
Section titled “Columns”TimePeriod, CurrencyCode, AdDistribution, DeviceType, Network, AccountId, AccountName, DeliveredMatchType, CampaignId, CampaignName, CampaignStatus, CustomParameters, QualityScore, ExpectedCtr, AdRelevance, LandingPageExperience, Impressions, Clicks, Ctr, Spend, ReturnOnAdSpend, AllConversionsQualified, ViewThroughConversionsQualified, PhoneImpressions, PhoneCalls, CostPerConversion, Ptr, Assists, CostPerAssist, AllRevenue, AllRevenuePerConversion, AverageCpc, AverageCpm, AveragePosition, ConversionRate, ConversionsQualified, LowQualityClicks, LowQualityClicksPercent, LowQualityConversionRate, LowQualityConversions, LowQualityConversionsQualified, LowQualityGeneralClicks, LowQualityImpressions, LowQualityImpressionsPercent, LowQualitySophisticatedClicks, Revenue, RevenuePerConversion, RevenuePerAssist, BidMatchType, DeviceOS, Goal, GoalType, TopVsOther, BudgetName, BudgetStatus, BudgetAssociationStatus, HistoricalAdRelevance, HistoricalExpectedCtr, HistoricalLandingPageExperience, HistoricalQualityScorePrimary key
Section titled “Primary key”TimePeriod, CurrencyCode, AdDistribution, DeviceType, Network, AccountId, DeliveredMatchType, CampaignId, BidMatchType, DeviceOS, Goal, GoalType, TopVsOtherHourly aggregation
Section titled “Hourly aggregation”Columns
Section titled “Columns”TimePeriod, CurrencyCode, AdDistribution, DeviceType, Network, AccountId, AccountName, DeliveredMatchType, CampaignId, CampaignName, CampaignStatus, CustomParameters, QualityScore, ExpectedCtr, AdRelevance, LandingPageExperience, Impressions, Clicks, Ctr, Spend, ReturnOnAdSpend, AllConversionsQualified, ViewThroughConversionsQualified, PhoneImpressions, PhoneCalls, CostPerConversion, Ptr, Assists, CostPerAssist, AllRevenue, AllRevenuePerConversion, AverageCpc, AverageCpm, AveragePosition, ConversionRate, ConversionsQualified, LowQualityClicks, LowQualityClicksPercent, LowQualityConversionRate, LowQualityConversions, LowQualityConversionsQualified, LowQualityGeneralClicks, LowQualityImpressions, LowQualityImpressionsPercent, LowQualitySophisticatedClicks, Revenue, RevenuePerConversion, RevenuePerAssist, BidMatchType, DeviceOS, Goal, GoalType, TopVsOther, BudgetName, BudgetStatus, BudgetAssociationStatusPrimary key
Section titled “Primary key”TimePeriod, CurrencyCode, AdDistribution, DeviceType, Network, AccountId, DeliveredMatchType, CampaignId, BidMatchType, DeviceOS, Goal, GoalType, TopVsOtherCampaignImpressionPerformance Report Presets
Section titled “CampaignImpressionPerformance Report Presets”Daily aggregation
Section titled “Daily aggregation”Columns
Section titled “Columns”TimePeriod, CurrencyCode, AdDistribution, DeviceType, Network, AccountId, AccountName, DeliveredMatchType, CampaignId, CampaignName, CampaignStatus, CustomParameters, QualityScore, ExpectedCtr, AdRelevance, LandingPageExperience, Impressions, Clicks, Ctr, Spend, ReturnOnAdSpend, AllConversionsQualified, ViewThroughConversionsQualified, PhoneImpressions, PhoneCalls, CostPerConversion, Ptr, Assists, CostPerAssist, AllRevenue, AllRevenuePerConversion, AverageCpc, AverageCpm, AveragePosition, ConversionRate, ConversionsQualified, LowQualityClicks, LowQualityClicksPercent, LowQualityConversionRate, LowQualityConversions, LowQualityConversionsQualified, LowQualityGeneralClicks, LowQualityImpressions, LowQualityImpressionsPercent, LowQualitySophisticatedClicks, Revenue, RevenuePerConversion, RevenuePerAssist, AbsoluteTopImpressionRatePercent, AbsoluteTopImpressionShareLostToBudgetPercent, AbsoluteTopImpressionShareLostToRankPercent, AbsoluteTopImpressionSharePercent, ClickSharePercent, ExactMatchImpressionSharePercent, ImpressionLostToBudgetPercent, ImpressionLostToRankAggPercent, ImpressionSharePercent, HistoricalAdRelevance, HistoricalExpectedCtr, HistoricalLandingPageExperience, HistoricalQualityScorePrimary key
Section titled “Primary key”TimePeriod, CurrencyCode, AdDistribution, DeviceType, Network, AccountId, DeliveredMatchType, CampaignIdHourly aggregation
Section titled “Hourly aggregation”Columns
Section titled “Columns”TimePeriod, CurrencyCode, AdDistribution, DeviceType, Network, AccountId, AccountName, DeliveredMatchType, CampaignId, CampaignName, CampaignStatus, CustomParameters, QualityScore, ExpectedCtr, AdRelevance, LandingPageExperience, Impressions, Clicks, Ctr, Spend, ReturnOnAdSpend, AllConversionsQualified, ViewThroughConversionsQualified, PhoneImpressions, PhoneCalls, CostPerConversion, Ptr, Assists, CostPerAssist, AllRevenue, AllRevenuePerConversion, AverageCpc, AverageCpm, AveragePosition, ConversionRate, ConversionsQualified, LowQualityClicks, LowQualityClicksPercent, LowQualityConversionRate, LowQualityConversions, LowQualityConversionsQualified, LowQualityGeneralClicks, LowQualityImpressions, LowQualityImpressionsPercent, LowQualitySophisticatedClicks, Revenue, RevenuePerConversion, RevenuePerAssistPrimary key
Section titled “Primary key”TimePeriod, CurrencyCode, AdDistribution, DeviceType, Network, AccountId, DeliveredMatchType, CampaignIdProductDimensionPerformance Report Presets
Section titled “ProductDimensionPerformance Report Presets”Daily aggregation
Section titled “Daily aggregation”Columns
Section titled “Columns”TimePeriod, CurrencyCode, AdDistribution, DeviceType, Network, CampaignId, CampaignName, AdGroupId, AdGroupName, AdId, Language, TopVsOther, MerchantProductId, Condition, Price, ClickTypeId, BidStrategyType, StoreId, Brand, LocalStoreCode, ClickType, Title, SellerName, OfferLanguage, CountryOfSale, TotalClicksOnAdElements, CustomLabel0, CustomLabel1, CustomLabel2, CustomLabel3, CustomLabel4, ProductCategory1, ProductCategory2, ProductCategory3, ProductCategory4, ProductCategory5, ProductType1, ProductType2, ProductType3, ProductType4, ProductType5, Impressions, Clicks, Ctr, Spend, ReturnOnAdSpend, AllConversionsQualified, ViewThroughConversionsQualified, ConversionRate, ConversionsQualified, Revenue, RevenuePerConversion, AssistedImpressions, AssistedClicks, AverageCpc, AverageCpmPrimary key
Section titled “Primary key”TimePeriod, CurrencyCode, AdDistribution, DeviceType, Network, CampaignId, AdGroupId, AdId, Language, TopVsOther, MerchantProductId, Condition, Price, ClickTypeId, BidStrategyType, StoreIdHourly aggregation
Section titled “Hourly aggregation”Columns
Section titled “Columns”TimePeriod, CurrencyCode, AdDistribution, DeviceType, Network, CampaignId, CampaignName, AdGroupId, AdGroupName, AdId, Language, TopVsOther, MerchantProductId, Condition, Price, ClickTypeId, BidStrategyType, StoreId, Brand, LocalStoreCode, ClickType, Title, SellerName, OfferLanguage, CountryOfSale, TotalClicksOnAdElements, CustomLabel0, CustomLabel1, CustomLabel2, CustomLabel3, CustomLabel4, ProductCategory1, ProductCategory2, ProductCategory3, ProductCategory4, ProductCategory5, ProductType1, ProductType2, ProductType3, ProductType4, ProductType5, Impressions, Clicks, Ctr, Spend, ReturnOnAdSpend, AllConversionsQualified, ViewThroughConversionsQualified, ConversionRate, ConversionsQualified, Revenue, RevenuePerConversion, AssistedImpressions, AssistedClicks, AverageCpc, AverageCpmPrimary key
Section titled “Primary key”TimePeriod, CurrencyCode, AdDistribution, DeviceType, Network, CampaignId, AdGroupId, AdId, Language, TopVsOther, MerchantProductId, Condition, Price, ClickTypeId, BidStrategyType, StoreIdKeywordPerformance Report Presets
Section titled “KeywordPerformance Report Presets”Daily aggregation
Section titled “Daily aggregation”Columns
Section titled “Columns”AccountId, AccountName, CampaignId, CampaignName, AdGroupId, AdGroupName, KeywordId, Keyword, AdId, TimePeriod, CurrencyCode, DeliveredMatchType, AdDistribution, DeviceType, Language, Network, DeviceOS, TopVsOther, BidMatchType, KeywordStatus, Impressions, Clicks, Ctr, CurrentMaxCpc, AverageCpc, Spend, AveragePosition, Conversions, ConversionsQualified, ConversionRate, CostPerConversion, QualityScore, ExpectedCtr, AdRelevance, LandingPageExperience, QualityImpact, Assists, ReturnOnAdSpend, CostPerAssist, CustomParameters, FinalAppUrl, Mainline1Bid, MainlineBid, FirstPageBid, FinalUrlSuffix, ViewThroughConversions, ViewThroughConversionsQualified, AllCostPerConversion, AllReturnOnAdSpend, AllConversionsQualified, AllRevenue, AllRevenuePerConversion, HistoricalAdRelevance, HistoricalExpectedCtr, HistoricalLandingPageExperience, HistoricalQualityScore, Revenue, RevenuePerAssist, RevenuePerConversionPrimary key
Section titled “Primary key”AccountId, CampaignId, AdGroupId, KeywordId, AdId, TimePeriod, CurrencyCode, DeliveredMatchType, AdDistribution, DeviceType, Language, Network, DeviceOS, TopVsOther, BidMatchTypeHourly aggregation
Section titled “Hourly aggregation”Columns
Section titled “Columns”AccountId, AccountName, CampaignId, CampaignName, AdGroupId, AdGroupName, KeywordId, Keyword, AdId, TimePeriod, CurrencyCode, DeliveredMatchType, AdDistribution, DeviceType, Language, Network, DeviceOS, TopVsOther, BidMatchType, KeywordStatus, Impressions, Clicks, Ctr, CurrentMaxCpc, AverageCpc, Spend, AveragePosition, Conversions, ConversionRate, CostPerConversion, QualityScore, ExpectedCtr, AdRelevance, LandingPageExperience, QualityImpact, Assists, ReturnOnAdSpend, CostPerAssist, CustomParameters, FinalAppUrl, FinalUrlSuffix, Mainline1Bid, MainlineBid, FirstPageBid, ViewThroughConversions, AllCostPerConversion, AllReturnOnAdSpend, AllConversionsQualified, AllRevenue, AllRevenuePerConversion, Revenue, RevenuePerAssist, RevenuePerConversionPrimary key
Section titled “Primary key”AccountId, CampaignId, AdGroupId, KeywordId, AdId, TimePeriod, CurrencyCode, DeliveredMatchType, AdDistribution, DeviceType, Language, Network, DeviceOS, TopVsOther, BidMatchTypeGeographicPerformance Report Presets
Section titled “GeographicPerformance Report Presets”Daily aggregation
Section titled “Daily aggregation”Columns
Section titled “Columns”TimePeriod, CurrencyCode, AdDistribution, DeviceType, Network, AccountId, DeliveredMatchType, CampaignId, CampaignName, AccountName, BidMatchType, DeviceOS, Goal, GoalType, TopVsOther, LocationType, Country, State, County, MetroArea, City, Neighborhood, MostSpecificLocation, LocationId, ProximityTargetLocation, Impressions, Clicks, Ctr, Spend, ReturnOnAdSpend, AllConversionsQualified, ViewThroughConversionsQualified, Radius, CostPerConversion, CostPerAssist, Assists, ConversionRate, ConversionsQualifiedPrimary key
Section titled “Primary key”TimePeriod, CurrencyCode, AdDistribution, DeviceType, Network, AccountId, DeliveredMatchType, CampaignId, BidMatchType, DeviceOS, Goal, GoalType, TopVsOther, LocationType, Country, State, County, MetroArea, City, Neighborhood, MostSpecificLocation, LocationId, ProximityTargetLocationHourly aggregation
Section titled “Hourly aggregation”Columns
Section titled “Columns”TimePeriod, CurrencyCode, AdDistribution, DeviceType, Network, AccountId, DeliveredMatchType, CampaignId, CampaignName, AccountName, BidMatchType, DeviceOS, Goal, GoalType, TopVsOther, LocationType, Country, State, County, MetroArea, City, Neighborhood, MostSpecificLocation, LocationId, ProximityTargetLocation, Impressions, Clicks, Ctr, Spend, ReturnOnAdSpend, AllConversionsQualified, ViewThroughConversionsQualified, Radius, CostPerConversion, CostPerAssist, Assists, ConversionRate, ConversionsQualifiedPrimary key
Section titled “Primary key”TimePeriod, CurrencyCode, AdDistribution, DeviceType, Network, AccountId, DeliveredMatchType, CampaignId, BidMatchType, DeviceOS, Goal, GoalType, TopVsOther, LocationType, Country, State, County, MetroArea, City, Neighborhood, MostSpecificLocation, LocationId, ProximityTargetLocation