1. Home
  2. Docs
  3. Fields Reference
  4. Microsoft Ads fields list

Microsoft Ads fields list

Fields reference

Id Name Type DataType
dateDatedimensionstring
isoweekWeek (Mon-Sun)dimensionstring
weekWeek (Sun-Sat)dimensionstring
nth_isoweekNth Week (Mon-Sun)dimensionstring
nth_weekNth Week (Sun-Sat)dimensionstring
monthMonthdimensionstring
month_nameMonth namedimensionstring
day_of_monthDay of monthdimensionstring
day_of_weekDay of weekdimensionstring
day_of_week_nameDay of week (name)dimensionstring
yearYeardimensionstring
quarterQuarterdimensionstring
date_rangeDate rangedimensionstring
TitlePart1Ad Title Part1dimensionstring
TitlePart2Ad Title Part2dimensionstring
FinalUrlFinal URLdimensionstring
QueryIntentStateQuery Intent Statedimensionstring
CurrencyCodeCurrency Codedimensionstring
BusinessCategoryNameBusiness Category Namedimensionstring
BidMatchTypeBid Match Typedimensionstring
NetworkNetworkdimensionstring
Path2Ad Path2dimensionstring
Path1Ad Path1dimensionstring
QueryIntentDMAQuery Intent DMAdimensionstring
StatusStatusdimensionstring
DisplayUrlDisplay Urldimensionstring
HistoricQualityScoreHistoric Quality Scoredimensionstring
BudgetAssociationStatusBudget Association Statusdimensionstring
DeviceOSDevice OSdimensionstring
CountryCountrydimensionstring
AdGroupIdAd Group Iddimensionstring
BudgetNameBudget Namedimensionstring
AccountNameAccount Namedimensionstring
CampaignStatusCampaign Statusdimensionstring
AdGroupStatusAd Group Statusdimensionstring
CurrentMaxCpcCurrent Max Cpcdimensionstring
FinalAppUrlFinal App URLdimensionstring
AdGroupLabelsAd Group Labelsdimensionstring
CampaignLabelsCampaign Labelsdimensionstring
BudgetStatusBudget Statusdimensionstring
QueryIntentCountyQuery Intent Countydimensionstring
QueryIntentPostalCodeQuery Intent Postal Codedimensionstring
SidebarBidSidebar Biddimensionstring
CampaignIdCampaign Iddimensionstring
AdGroupCriterionIdAd Group Criterion Iddimensionstring
AdStatusAd Statusdimensionstring
CustomParametersCustom Parametersdimensionstring
SearchQuerySearch Querydimensionstring
KeywordKeyworddimensionstring
LocationIdLocation Iddimensionstring
AdGroupNameAd Group Namedimensionstring
AdLabelsAd Labelsdimensionstring
AdDistributionAd Distributiondimensionstring
QueryIntentCountryQuery Intent Countrydimensionstring
AccountIdAccount Iddimensionstring
AdTypeAd Typedimensionstring
MainlineBidMainline Biddimensionstring
AccountStatusAccount Statusdimensionstring
BusinessListingIdBusiness Listing Iddimensionstring
CampaignTypeCampaign Typedimensionstring
AdIdAd Iddimensionstring
QueryIntentLocationIdQuery Intent Location Iddimensionstring
MetroAreaMetro Areadimensionstring
QualityScoreQuality Scoredimensionstring
HistoricLandingPageExperienceHistoric Landing Page Experiencedimensionstring
CityCitydimensionstring
DeviceTypeDevice Typedimensionstring
FinalMobileUrlFinal Mobile URLdimensionstring
StateStatedimensionstring
Mainline1BidMainline1 Biddimensionstring
RadiusRadiusdimensionstring
ProximityTargetLocationProximity Target Locationdimensionstring
BusinessListingNameBusiness Listing Namedimensionstring
CampaignNameCampaign Namedimensionstring
PostalCodePostal Codedimensionstring
CountyCountydimensionstring
BidStrategyTypeBid Strategy Typedimensionstring
DeliveredMatchTypeDelivered Match Typedimensionstring
KeywordStatusKeyword Statusdimensionstring
KeywordIdKeyword Iddimensionstring
LanguageLanguagedimensionstring
BusinessCategoryIdBusiness Category Iddimensionstring
LandingPageExperienceLanding Page Experiencedimensionstring
KeywordLabelsKeyword Labelsdimensionstring
AccountNumberAccount Numberdimensionstring
TrackingTemplateTracking Templatedimensionstring
AdDescriptionAd Descriptiondimensionstring
QueryIntentCityQuery Intent Citydimensionstring
AdRelevanceAd Relevancedimensionstring
QualityImpactQuality Impactdimensionstring
MerchantProductIdMerchant Product Iddimensionstring
PartitionTypePartition Typedimensionstring
ProductGroupProduct Groupdimensionstring
TitleProduct Titledimensionstring
ConditionProduct Conditiondimensionstring
BrandProduct Branddimensionstring
PriceProduct Pricedimensionstring
SellerNameSeller Namedimensionstring
StoreIdStore Iddimensionstring
AgeGroupAge Groupdimensionstring
GenderGenderdimensionstring
ExtendedCostExtended Costdimensionstring
GoalGoaldimensionstring
GoalIdGoal Iddimensionstring
GoalTypeGoal Typedimensionstring
LocationTypeLocation Typedimensionstring
MostSpecificLocationMost Specific Locationdimensionstring
CustomerIdCustomer Iddimensionstring
CustomerNameCustomer Namedimensionstring
MatchedProductsAtCampaignMatchedProductsAtCampaigndimensionstring
MatchedProductsAtAdGroupMatchedProductsAtAdGroupdimensionstring
MatchedProductsAtProductGroupMatchedProductsAtProductGroupdimensionstring
DestinationUrlDestination Urldimensionstring
ClickTypeIdClick Type Iddimensionstring
ClickTypeClick Typedimensionstring
OfferLanguageOffer Languagedimensionstring
CountryOfSaleCountry Of Saledimensionstring
BenchmarkBidBenchmark Biddimensionstring
BenchmarkCtrBenchmark Ctrdimensionstring
LocalStoreCodeLocal Store Codedimensionstring
HistoricalQualityScoreHistorical Quality Scoredimensionstring
HistoricalAdRelevanceHistorical AdRelevancedimensionstring
HistoricalLandingPageExperienceHistorical LandingPage Experiencedimensionstring
FinalUrlSuffixFinalUrlSuffixdimensionstring
FirstPageBidFirstPageBiddimensionstring
AdTitleAd Titledimensionstring
AdDescription2Ad Description2dimensionstring
TitlePart3Ad Title Part3dimensionstring
HeadlineAd Headlinedimensionstring
LongHeadlineAd Long Headlinedimensionstring
BusinessNameBusiness Namedimensionstring
CustomLabel0CustomLabel0dimensionstring
CustomLabel1CustomLabel1dimensionstring
CustomLabel2CustomLabel2dimensionstring
CustomLabel3CustomLabel3dimensionstring
CustomLabel4CustomLabel4dimensionstring
ProductType1ProductType1dimensionstring
ProductType2ProductType2dimensionstring
ProductType3ProductType3dimensionstring
ProductType4ProductType4dimensionstring
ProductType5ProductType5dimensionstring
ProductCategory1ProductCategory1dimensionstring
ProductCategory2ProductCategory2dimensionstring
ProductCategory3ProductCategory3dimensionstring
ProductCategory4ProductCategory4dimensionstring
ProductCategory5ProductCategory5dimensionstring
CtrCtrmetricpercent
ImpressionSharePercentImpression Share Percentmetricpercent
ImpressionLostToBudgetPercentImpression Lost To Budget Percentmetricpercent
RevenuePerAssistRevenue Per Assistmetricpercent
ImpressionLostToAdRelevancePercentImpression Lost To Ad Relevance Percentmetricpercent
AveragePositionAverage Positionmetricstring
CostPerConversionCost Per Conversionmetricfloat
ImpressionsImpressionsmetricinteger
AssistsAssistsmetricinteger
TopVsOtherTop Vs Othermetricstring
ConversionsConversionsmetricinteger
RevenuePerConversionRevenue Per Conversionmetricfloat
RevenueRevenuemetricinteger
HistoricExpectedCtrHistoric Expected Ctrmetricpercent
HistoricAdRelevanceHistoric Ad Relevancemetricstring
LowQualityImpressionsLow Quality Impressionsmetricinteger
ExactMatchImpressionSharePercentExact Match Impression Share Percentmetricpercent
ImpressionLostToExpectedCtrPercentImpression Lost To Expected Ctr Percentmetricpercent
LowQualityConversionsLow Quality Conversionsmetricinteger
ConversionRateConversion Ratemetricpercent
LowQualityConversionRateLow Quality Conversion Ratemetricpercent
ClicksClicksmetricinteger
LowQualityImpressionsPercentLow Quality Impressions Percentmetricpercent
LowQualityGeneralClicksLow Quality General Clicksmetricinteger
AverageCppAverage Cppmetricfloat
PhoneCallsPhone Callsmetricinteger
LowQualityClicksPercentLow Quality Clicks Percentmetricpercent
AverageCpcAverage Cpcmetricfloat
ExpectedCtrExpected Ctrmetricpercent
ClickCallsClick Callsmetricinteger
LowQualitySophisticatedClicksLow Quality Sophisticated Clicksmetricinteger
LowQualityClicksLow Quality Clicksmetricfloat
ImpressionLostToBidPercentImpression Lost To Bid Percentmetricpercent
PhoneImpressionsPhone Impressionsmetricinteger
PtrPtrmetricinteger
ReturnOnAdSpendReturn On Ad Spendmetricfloat
ManualCallsManual Callsmetricinteger
CostPerAssistCost Per Assistmetricfloat
ImpressionLostToRankPercentImpression Lost To Rank Percentmetricpercent
SpendSpendmetricfloat
AllConversionsAll Conversionsmetricinteger
AllRevenueAll Revenuemetricinteger
TotalClicksOnAdElementsTotal Clicks On AdElementsmetricinteger
AssistedImpressionsProduct Assisted Impressionsmetricinteger
AssistedClicksProduct Assisted Clicksmetricinteger
AssistedConversionsProduct Assisted Conversionsmetricinteger
ClickSharePercentClick Share Percentmetricpercent
AbsoluteTopImpressionSharePercentAbsolute Top ImpressionShare Percentmetricpercent
ImpressionLostToRankAggPercentImpressionLostToRankAggPercentmetricpercent
ClickSharePercentClickSharePercentmetricpercent
AbsoluteTopImpressionSharePercentAbsoluteTopImpressionSharePercentmetricpercent
ImpressionLostToRankAggPercentImpressionLostToRankAggPercentmetricpercent
HistoricalExpectedCtrHistorical Expected Ctrmetricpercent
ClickSharePercentClick Share Percentmetricpercent
AbsoluteTopImpressionSharePercentAbsolute Top ImpressionShare Percentmetricpercent

Leave a Reply

Your email address will not be published. Required fields are marked *