Microsoft Advertising

Account

report_type: account · 34 metrics · 34 dimensions · showing 34 of 34 metrics and 20 of 34 dims · showing 20 of 34 retrievable via API

Metrics

Field name	Label	Type
`CPC`	Average Cost-per-Click (CPC)formula	NUMBER
`CTR`	CTRformula	NUMBER
`ConversionRate`	Conversion rateformula	NUMBER
`CPM`	Average cost per 1,000 impressions (CPM)formula	NUMBER
`CostPerConversion`	Cost per acquisition (CPA)formula	NUMBER
`CostPerAssist`	Cost per assistformula	NUMBER
`RevenuePerConversion`	Revenue per conversionformula	NUMBER
`RevenuePerAssist`	Revenue per assistformula	NUMBER
`ROAS`	ROASformula	NUMBER
`ImpressionSharePercent`	Impression share	NUMBER
`ClickSharePercent`	Click share percent	NUMBER
`ImpressionLostToBudgetPercent`	Impression share lost to budget	NUMBER
`ImpressionLostToRankAggPercent`	Impression share lost to rank	NUMBER
`ExactMatchImpressionSharePercent`	Exact match impression share	NUMBER
`AbsoluteTopImpressionSharePercent`	Absolute top impression share	NUMBER
`TopImpressionShareLostToRankPercent`	Top impression share lost to rank (%)	NUMBER
`TopImpressionShareLostToBudgetPercent`	Top impression share lost to budget (%)	NUMBER
`AbsoluteTopImpressionShareLostToRankPercent`	Absolute top impression share lost to rank (%)	NUMBER
`AbsoluteTopImpressionShareLostToBudgetPercent`	Absolute top impression share lost to budget (%)	NUMBER
`TopImpressionSharePercent`	Top impression share percent	NUMBER
`AbsoluteTopImpressionRatePercent`	Absolute top impression rate (%)	NUMBER
`TopImpressionRatePercent`	Top impression rate (%)	NUMBER
`AudienceImpressionSharePercent`	Audience impression share percent	NUMBER
`AudienceImpressionLostToRankPercent`	Audience network impression share lost to rank (%)	NUMBER
`AudienceImpressionLostToBudgetPercent`	Audience network impression share lost to budget (%)	NUMBER
`AllConversions`	All conversions	NUMBER
`Assists`	Assists	NUMBER
`Clicks`	Clicks	NUMBER
`Conversions`	Conversions	NUMBER
`Impressions`	Impressions	NUMBER
`PhoneCalls`	Phone calls	NUMBER
`PhoneImpressions`	Phone impressions	NUMBER
`Revenue`	Revenue	NUMBER
`Spend`	Spend	NUMBER

Dimensions

Field name	Label	Type
`configName`	Account	STRING
`account`	Account ID	STRING
`TimePeriod`	Date	STRING
`AdDistribution`	Ad distribution	STRING
`BidMatchType`	Bid match type	STRING
`CurrencyCode`	Currency code	STRING
`CustomerId`	Customer ID	STRING
`CustomerName`	Customer name	STRING
`DeliveredMatchType`	Delivered match type	STRING
`DeviceOS`	Device OS	STRING
`DeviceType`	Device type	STRING
`Network`	Network	STRING
`TopVsOther`	Top vs other	STRING
`dataFreshness`	Data freshness	STRING
`year`	Yearformula	STRING
`quarter`	Quarterformula	STRING
`year_quarter`	Year quarterformula	STRING
`month`	Year monthformula	STRING
`week`	Weekformula	STRING
`isInterpolated`	PMA is interpolated?	BOOLEAN

Campaigns

report_type: campaigns · 32 metrics · 25 dimensions · showing 20 of 25 dimensions retrievable via API

Metrics

Field name	Label	Type
`CPC`	Average Cost-per-Click (CPC)formula	NUMBER
`CTR`	CTRformula	NUMBER
`ConversionRate`	Conversion rateformula	NUMBER
`CPM`	Average cost per 1,000 impressions (CPM)formula	NUMBER
`CostPerConversion`	Cost per acquisition (CPA)formula	NUMBER
`CostPerAssist`	Cost per assistformula	NUMBER
`RevenuePerConversion`	Revenue per conversionformula	NUMBER
`RevenuePerAssist`	Revenue per assistformula	NUMBER
`ROAS`	ROASformula	NUMBER
`ImpressionSharePercent`	Impression share	NUMBER
`ClickSharePercent`	Click share percent	NUMBER
`ImpressionLostToBudgetPercent`	Impression share lost to budget	NUMBER
`ImpressionLostToRankAggPercent`	Impression share lost to rank	NUMBER
`ExactMatchImpressionSharePercent`	Exact match impression share	NUMBER
`AbsoluteTopImpressionSharePercent`	Absolute top impression share	NUMBER
`TopImpressionShareLostToRankPercent`	Top impression share lost to rank (%)	NUMBER
`TopImpressionShareLostToBudgetPercent`	Top impression share lost to budget (%)	NUMBER
`AbsoluteTopImpressionShareLostToRankPercent`	Absolute top impression share lost to rank (%)	NUMBER
`AbsoluteTopImpressionShareLostToBudgetPercent`	Absolute top impression share lost to budget (%)	NUMBER
`TopImpressionSharePercent`	Top impression share percent	NUMBER
`AbsoluteTopImpressionRatePercent`	Absolute top impression rate (%)	NUMBER
`TopImpressionRatePercent`	Top impression rate (%)	NUMBER
`AudienceImpressionSharePercent`	Audience impression share percent	NUMBER
`AudienceImpressionLostToRankPercent`	Audience network impression share lost to rank (%)	NUMBER
`AudienceImpressionLostToBudgetPercent`	Audience network impression share lost to budget (%)	NUMBER
`AllConversions`	All conversions	NUMBER
`Assists`	Assists	NUMBER
`Clicks`	Clicks	NUMBER
`Conversions`	Conversions	NUMBER
`Impressions`	Impressions	NUMBER
`Revenue`	Revenue	NUMBER
`Spend`	Spend	NUMBER

Dimensions

Field name	Label	Type
`configName`	Account	STRING
`CampaignId`	Campaign ID	STRING
`TimePeriod`	Date	STRING
`account`	Account ID	STRING
`dataFreshness`	Data freshness	STRING
`year`	Yearformula	STRING
`quarter`	Quarterformula	STRING
`year_quarter`	Year quarterformula	STRING
`month`	Year monthformula	STRING
`week`	Weekformula	STRING
`isInterpolated`	PMA is interpolated?	BOOLEAN
`dataSource`	Data source	STRING
`dataSourceLogo`	Data source logo	STRING
`executionId`	Function execution ID	STRING
`dataPlatform`	Data platform	STRING
`Subscription`	PMA subscription ID	STRING
`Trial`	PMA trial status	STRING
`Payment`	PMA payment URL	STRING
`MinDate`	PMA minimum cached data date	STRING
`MaxDate`	PMA maximum cached data date	STRING

Ad groups

report_type: adgroups · 39 metrics · 46 dimensions · showing 20 of 46 dimensions retrievable via API

Metrics

Field name	Label	Type
`CPC`	Average Cost-per-Click (CPC)formula	NUMBER
`CTR`	CTRformula	NUMBER
`ConversionRate`	Conversion rateformula	NUMBER
`CPM`	Average cost per 1,000 impressions (CPM)formula	NUMBER
`CostPerConversion`	Cost per acquisition (CPA)formula	NUMBER
`CostPerAssist`	Cost per assistformula	NUMBER
`RevenuePerConversion`	Revenue per conversionformula	NUMBER
`RevenuePerAssist`	Revenue per assistformula	NUMBER
`ROAS`	ROASformula	NUMBER
`AveragePosition`	(Deprecated) Average positionformula	NUMBER
`ImpressionSharePercent`	Impression share	NUMBER
`ClickSharePercent`	Click share percent	NUMBER
`ImpressionLostToBudgetPercent`	Impression share lost to budget	NUMBER
`ImpressionLostToRankAggPercent`	Impression share lost to rank	NUMBER
`ExactMatchImpressionSharePercent`	Exact match impression share	NUMBER
`AbsoluteTopImpressionSharePercent`	Absolute top impression share	NUMBER
`TopImpressionShareLostToRankPercent`	Top impression share lost to rank (%)	NUMBER
`TopImpressionShareLostToBudgetPercent`	Top impression share lost to budget (%)	NUMBER
`AbsoluteTopImpressionShareLostToRankPercent`	Absolute top impression share lost to rank (%)	NUMBER
`AbsoluteTopImpressionShareLostToBudgetPercent`	Absolute top impression share lost to budget (%)	NUMBER
`TopImpressionSharePercent`	Top impression share percent	NUMBER
`AbsoluteTopImpressionRatePercent`	Absolute top impression rate (%)	NUMBER
`TopImpressionRatePercent`	Top impression rate (%)	NUMBER
`AudienceImpressionSharePercent`	Audience impression share percent	NUMBER
`AudienceImpressionLostToRankPercent`	Audience network impression share lost to rank (%)	NUMBER
`AudienceImpressionLostToBudgetPercent`	Audience network impression share lost to budget (%)	NUMBER
`AllConversions`	All conversions	NUMBER
`Assists`	Assists	NUMBER
`ClickCalls`	Click calls	NUMBER
`Clicks`	Clicks	NUMBER
`Conversions`	Conversions	NUMBER
`FullPosition`	Full position	NUMBER
`Impressions`	Impressions	NUMBER
`ManualCalls`	Manual calls	NUMBER
`PhoneCalls`	Phone calls	NUMBER
`PhoneImpressions`	Phone impressions	NUMBER
`Ptr`	Phone-through rate	NUMBER
`Revenue`	Revenue	NUMBER
`Spend`	Spend	NUMBER

Dimensions

Field name	Label	Type
`configName`	Account	STRING
`AdGroupId`	Ad group ID	STRING
`CampaignId`	Campaign ID	STRING
`AdDistribution`	Ad distribution	STRING
`AdRelevance`	Ad relevance	STRING
`AverageCpp`	Average CPP	STRING
`BidMatchType`	Bid match type	STRING
`CurrencyCode`	Currency code	STRING
`CustomerId`	Customer ID	STRING
`CustomerName`	Customer name	STRING
`DeliveredMatchType`	Delivered match type	STRING
`DeviceOS`	Device OS	STRING
`DeviceType`	Device type	STRING
`ExpectedCtr`	Expected CTR	STRING
`HistoricalAdRelevance`	Historical ad relevance	STRING
`HistoricalExpectedCtr`	Historical expected CTR	STRING
`HistoricalLandingPageExperience`	Historical landing page experience	STRING
`HistoricalQualityScore`	Historical quality score	STRING
`LandingPageExperience`	Landing page experience	STRING
`Language`	Language	STRING

Ads

report_type: ads · 18 metrics · 45 dimensions · showing 20 of 45 dimensions retrievable via API

Metrics

Field name	Label	Type
`CPC`	Average Cost-per-Click (CPC)formula	NUMBER
`CTR`	CTRformula	NUMBER
`ConversionRate`	Conversion rateformula	NUMBER
`CPM`	Average cost per 1,000 impressions (CPM)formula	NUMBER
`CostPerConversion`	Cost per acquisition (CPA)formula	NUMBER
`CostPerAssist`	Cost per assistformula	NUMBER
`RevenuePerConversion`	Revenue per conversionformula	NUMBER
`RevenuePerAssist`	Revenue per assistformula	NUMBER
`ROAS`	ROASformula	NUMBER
`AveragePosition`	(Deprecated) Average positionformula	NUMBER
`AllConversions`	All conversions	NUMBER
`Assists`	Assists	NUMBER
`Clicks`	Clicks	NUMBER
`Conversions`	Conversions	NUMBER
`FullPosition`	Full position	NUMBER
`Impressions`	Impressions	NUMBER
`Revenue`	Revenue	NUMBER
`Spend`	Spend	NUMBER

Dimensions

Field name	Label	Type
`configName`	Account	STRING
`AdId`	Ad ID	STRING
`AdGroupId`	Ad group ID	STRING
`CampaignId`	Campaign ID	STRING
`AdDistribution`	Ad distribution	STRING
`BidMatchType`	Bid match type	STRING
`CurrencyCode`	Currency code	STRING
`DeliveredMatchType`	Delivered match type	STRING
`DestinationUrl`	Destination URL	STRING
`DestinationUrl_utm_campaign`	Destination URL UTM campaign	STRING
`DestinationUrl_utm_content`	Destination URL UTM content	STRING
`DestinationUrl_utm_medium`	Destination URL UTM medium	STRING
`DestinationUrl_utm_source`	Destination URL UTM source	STRING
`DestinationUrl_utm_term`	Destination URL UTM term	STRING
`DeviceOS`	Device OS	STRING
`DeviceType`	Device type	STRING
`DisplayUrl`	Display URL	STRING
`FinalUrl`	Final URL	STRING
`Headline`	Headline	STRING
`Language`	Language	STRING

Keywords

report_type: keywords · 22 metrics · 56 dimensions · showing 20 of 56 dimensions retrievable via API

Metrics

Field name	Label	Type
`CPC`	Average Cost-per-Click (CPC)formula	NUMBER
`CTR`	CTRformula	NUMBER
`ConversionRate`	Conversion rateformula	NUMBER
`CPM`	Average cost per 1,000 impressions (CPM)formula	NUMBER
`CostPerConversion`	Cost per acquisition (CPA)formula	NUMBER
`CostPerAssist`	Cost per assistformula	NUMBER
`RevenuePerConversion`	Revenue per conversionformula	NUMBER
`RevenuePerAssist`	Revenue per assistformula	NUMBER
`ROAS`	ROASformula	NUMBER
`AveragePosition`	(Deprecated) Average positionformula	NUMBER
`AllConversions`	All conversions	NUMBER
`Assists`	Assists	NUMBER
`Clicks`	Clicks	NUMBER
`Conversions`	Conversions	NUMBER
`CurrentMaxCpc`	Current max CPC	NUMBER
`FirstPageBid`	First page bid	NUMBER
`FullPosition`	Full position	NUMBER
`Impressions`	Impressions	NUMBER
`MainlineBid`	Mainline bid	NUMBER
`QualityImpact`	Quality impact	NUMBER
`Revenue`	Revenue	NUMBER
`Spend`	Spend	NUMBER

Dimensions

Field name	Label	Type
`configName`	Account	STRING
`AdGroupId`	Ad group ID	STRING
`AdId`	Ad ID	STRING
`AdRelevance`	Ad relevance	STRING
`BidMatchType`	Bid match type	STRING
`BidStrategyType`	Bid strategy type	STRING
`CampaignId`	Campaign ID	STRING
`CurrencyCode`	Currency code	STRING
`DeliveredMatchType`	Delivered match type	STRING
`DestinationUrl`	Destination URL	STRING
`DestinationUrl_utm_campaign`	Destination URL UTM campaign	STRING
`DestinationUrl_utm_content`	Destination URL UTM content	STRING
`DestinationUrl_utm_medium`	Destination URL UTM medium	STRING
`DestinationUrl_utm_source`	Destination URL UTM source	STRING
`DestinationUrl_utm_term`	Destination URL UTM term	STRING
`DeviceOS`	Device OS	STRING
`DeviceType`	Device type	STRING
`ExpectedCtr`	Expected CTR	STRING
`FinalUrl`	Final URL	STRING
`Language`	Language	STRING

Search terms

report_type: search · 18 metrics · 44 dimensions · showing 20 of 44 dimensions retrievable via API

Metrics

Field name	Label	Type
`CPC`	Average Cost-per-Click (CPC)formula	NUMBER
`CTR`	CTRformula	NUMBER
`ConversionRate`	Conversion rateformula	NUMBER
`CPM`	Average cost per 1,000 impressions (CPM)formula	NUMBER
`CostPerConversion`	Cost per acquisition (CPA)formula	NUMBER
`CostPerAssist`	Cost per assistformula	NUMBER
`RevenuePerConversion`	Revenue per conversionformula	NUMBER
`RevenuePerAssist`	Revenue per assistformula	NUMBER
`ROAS`	ROASformula	NUMBER
`AveragePosition`	(Deprecated) Average positionformula	NUMBER
`AllConversions`	All conversions	NUMBER
`Assists`	Assists	NUMBER
`Clicks`	Clicks	NUMBER
`Conversions`	Conversions	NUMBER
`FullPosition`	Full position	NUMBER
`Impressions`	Impressions	NUMBER
`Revenue`	Revenue	NUMBER
`Spend`	Spend	NUMBER

Dimensions

Field name	Label	Type
`configName`	Account	STRING
`SearchQuery`	Search query	STRING
`AdGroupId`	Ad group ID	STRING
`AdId`	Ad ID	STRING
`BidMatchType`	Bid match type	STRING
`CampaignId`	Campaign ID	STRING
`CustomerId`	Customer ID	STRING
`CustomerName`	Customer name	STRING
`DeliveredMatchType`	Delivered match type	STRING
`DestinationUrl`	Destination URL	STRING
`DestinationUrl_utm_campaign`	Destination URL UTM campaign	STRING
`DestinationUrl_utm_content`	Destination URL UTM content	STRING
`DestinationUrl_utm_medium`	Destination URL UTM medium	STRING
`DestinationUrl_utm_source`	Destination URL UTM source	STRING
`DestinationUrl_utm_term`	Destination URL UTM term	STRING
`DeviceOS`	Device OS	STRING
`DeviceType`	Device type	STRING
`KeywordId`	Keyword ID	STRING
`Language`	Language	STRING
`Network`	Network	STRING

Goals

report_type: goals · 10 metrics · 32 dimensions · showing 20 of 32 dimensions retrievable via API

Metrics

Field name	Label	Type
`ConversionRate`	Conversion rateformula	NUMBER
`CostPerConversion`	Cost per acquisition (CPA)formula	NUMBER
`CostPerAssist`	Cost per assistformula	NUMBER
`RevenuePerConversion`	Revenue per conversionformula	NUMBER
`RevenuePerAssist`	Revenue per assistformula	NUMBER
`ROAS`	ROASformula	NUMBER
`AllConversions`	All conversions	NUMBER
`Assists`	Assists	NUMBER
`Conversions`	Conversions	NUMBER
`Revenue`	Revenue	NUMBER

Dimensions

Field name	Label	Type
`configName`	Account	STRING
`Goal`	Goal	STRING
`GoalId`	Goal ID	STRING
`GoalType`	Goal type	STRING
`AdGroupId`	Ad group ID	STRING
`CampaignId`	Campaign ID	STRING
`KeywordId`	Keyword ID	STRING
`DeviceOS`	Device OS	STRING
`DeviceType`	Device type	STRING
`TimePeriod`	Date	STRING
`account`	Account ID	STRING
`dataFreshness`	Data freshness	STRING
`isInterpolated`	PMA is interpolated?	BOOLEAN
`dataSource`	Data source	STRING
`dataSourceLogo`	Data source logo	STRING
`executionId`	Function execution ID	STRING
`dataPlatform`	Data platform	STRING
`Subscription`	PMA subscription ID	STRING
`Trial`	PMA trial status	STRING
`MinDate`	PMA minimum cached data date	STRING

Products (Shopping)

report_type: products · 14 metrics · 52 dimensions · showing 20 of 52 dimensions retrievable via API

Metrics

Field name	Label	Type
`CPC`	Average Cost-per-Click (CPC)formula	NUMBER
`CTR`	CTRformula	NUMBER
`ConversionRate`	Conversion rateformula	NUMBER
`CPM`	Average cost per 1,000 impressions (CPM)formula	NUMBER
`CostPerConversion`	Cost per acquisition (CPA)formula	NUMBER
`RevenuePerConversion`	Revenue per conversionformula	NUMBER
`ROAS`	ROASformula	NUMBER
`AllConversions`	All conversions	NUMBER
`Clicks`	Clicks	NUMBER
`Conversions`	Conversions	NUMBER
`Impressions`	Impressions	NUMBER
`Price`	Price	NUMBER
`Revenue`	Revenue	NUMBER
`Spend`	Spend	NUMBER

Dimensions

Field name	Label	Type
`configName`	Account	STRING
`MerchantProductId`	Merchant product ID	STRING
`AdGroupId`	Ad group ID	STRING
`AdId`	Ad ID	STRING
`BidStrategyType`	Bid strategy type	STRING
`Brand`	Brand	STRING
`CampaignId`	Campaign ID	STRING
`Condition`	Condition	STRING
`CountryOfSale`	Country of sale	STRING
`CurrencyCode`	Currency code	STRING
`CustomLabel0`	Custom label 0	STRING
`CustomLabel1`	Custom label 1	STRING
`CustomLabel2`	Custom label 2	STRING
`CustomLabel3`	Custom label 3	STRING
`CustomLabel4`	Custom label 4	STRING
`DeviceType`	Device type	STRING
`Language`	Language	STRING
`ProductCategory1`	Product category 1	STRING
`ProductCategory2`	Product category 2	STRING
`ProductCategory3`	Product category 3	STRING

Ad extensions

report_type: adextension · 16 metrics · 38 dimensions · showing 20 of 38 dimensions retrievable via API

Metrics

Field name	Label	Type
`CPC`	Average Cost-per-Click (CPC)formula	NUMBER
`CTR`	CTRformula	NUMBER
`ConversionRate`	Conversion rateformula	NUMBER
`CPM`	Average cost per 1,000 impressions (CPM)formula	NUMBER
`CostPerConversion`	Cost per acquisition (CPA)formula	NUMBER
`CostPerAssist`	Cost per assistformula	NUMBER
`RevenuePerConversion`	Revenue per conversionformula	NUMBER
`RevenuePerAssist`	Revenue per assistformula	NUMBER
`ROAS`	ROASformula	NUMBER
`AllConversions`	All conversions	NUMBER
`Assists`	Assists	NUMBER
`Clicks`	Clicks	NUMBER
`Conversions`	Conversions	NUMBER
`Impressions`	Impressions	NUMBER
`Revenue`	Revenue	NUMBER
`Spend`	Spend	NUMBER

Dimensions

Field name	Label	Type
`configName`	Account	STRING
`AdExtensionId`	Ad extension ID	STRING
`AdExtensionPropertyValue`	Ad extension property value	STRING
`AdExtensionType`	Ad extension type	STRING
`AdExtensionTypeId`	Ad extension type ID	STRING
`AdExtensionVersion`	Ad extension version	STRING
`AdGroupId`	Ad group ID	STRING
`AdId`	Ad ID	STRING
`BidMatchType`	Bid match type	STRING
`CampaignId`	Campaign ID	STRING
`DeliveredMatchType`	Delivered match type	STRING
`DeviceOS`	Device OS	STRING
`DeviceType`	Device type	STRING
`Network`	Network	STRING
`TimePeriod`	Date	STRING
`TopVsOther`	Top vs other	STRING
`account`	Account ID	STRING
`dataFreshness`	Data freshness	STRING
`isInterpolated`	PMA is interpolated?	BOOLEAN
`dataSource`	Data source	STRING

Dynamic search ads (DSA)

report_type: dsa · 18 metrics · 37 dimensions · showing 20 of 37 dimensions retrievable via API

Metrics

Field name	Label	Type
`CPC`	Average Cost-per-Click (CPC)formula	NUMBER
`CTR`	CTRformula	NUMBER
`ConversionRate`	Conversion rateformula	NUMBER
`CPM`	Average cost per 1,000 impressions (CPM)formula	NUMBER
`CostPerConversion`	Cost per acquisition (CPA)formula	NUMBER
`CostPerAssist`	Cost per assistformula	NUMBER
`RevenuePerConversion`	Revenue per conversionformula	NUMBER
`RevenuePerAssist`	Revenue per assistformula	NUMBER
`ROAS`	ROASformula	NUMBER
`AveragePosition`	(Deprecated) Average positionformula	NUMBER
`AllConversions`	All conversions	NUMBER
`Assists`	Assists	NUMBER
`Clicks`	Clicks	NUMBER
`Conversions`	Conversions	NUMBER
`FullPosition`	Full position	NUMBER
`Impressions`	Impressions	NUMBER
`Revenue`	Revenue	NUMBER
`Spend`	Spend	NUMBER

Dimensions

Field name	Label	Type
`configName`	Account	STRING
`DynamicAdTarget`	Dynamic ad target	STRING
`DynamicAdTargetId`	Dynamic ad target ID	STRING
`DynamicAdTargetStatus`	Dynamic ad target status	STRING
`AdGroupId`	Ad group ID	STRING
`AdGroupStatus`	Ad group status	STRING
`BidStrategyType`	Bid strategy type	STRING
`CampaignId`	Campaign ID	STRING
`DeviceOS`	Device OS	STRING
`DeviceType`	Device type	STRING
`Language`	Language	STRING
`Network`	Network	STRING
`TimePeriod`	Date	STRING
`TopVsOther`	Top vs other	STRING
`account`	Account ID	STRING
`AdDistribution`	Ad distribution	STRING
`dataFreshness`	Data freshness	STRING
`isInterpolated`	PMA is interpolated?	BOOLEAN
`dataSource`	Data source	STRING
`dataPlatform`	Data platform	STRING

Demographics

report_type: demographics · 15 metrics · 29 dimensions · showing 20 of 29 dimensions retrievable via API

Metrics

Field name	Label	Type
`CPC`	Average Cost-per-Click (CPC)formula	NUMBER
`CTR`	CTRformula	NUMBER
`ConversionRate`	Conversion rateformula	NUMBER
`CPM`	Average cost per 1,000 impressions (CPM)formula	NUMBER
`CostPerConversion`	Cost per acquisition (CPA)formula	NUMBER
`CostPerAssist`	Cost per assistformula	NUMBER
`RevenuePerConversion`	Revenue per conversionformula	NUMBER
`RevenuePerAssist`	Revenue per assistformula	NUMBER
`ROAS`	ROASformula	NUMBER
`Assists`	Assists	NUMBER
`Clicks`	Clicks	NUMBER
`Conversions`	Conversions	NUMBER
`Impressions`	Impressions	NUMBER
`Revenue`	Revenue	NUMBER
`Spend`	Spend	NUMBER

Dimensions

Field name	Label	Type
`configName`	Account	STRING
`AgeGroup`	Age group	STRING
`Gender`	Gender	STRING
`AdGroupId`	Ad group ID	STRING
`AdGroupName`	Ad group	STRING
`CampaignId`	Campaign ID	STRING
`TimePeriod`	Date	STRING
`account`	Account ID	STRING
`dataFreshness`	Data freshness	STRING
`year`	Yearformula	STRING
`quarter`	Quarterformula	STRING
`year_quarter`	Year quarterformula	STRING
`month`	Year monthformula	STRING
`isInterpolated`	PMA is interpolated?	BOOLEAN
`dataSource`	Data source	STRING
`dataSourceLogo`	Data source logo	STRING
`executionId`	Function execution ID	STRING
`dataPlatform`	Data platform	STRING
`Subscription`	PMA subscription ID	STRING
`MinDate`	PMA minimum cached data date	STRING

Professional demographics

report_type: demographics_professional · 15 metrics · ~29 dimensions

Metrics

Field name	Label	Type
`CPC`	Average Cost-per-Click (CPC)formula	NUMBER
`CTR`	CTRformula	NUMBER
`ConversionRate`	Conversion rateformula	NUMBER
`CPM`	Average cost per 1,000 impressions (CPM)formula	NUMBER
`CostPerConversion`	Cost per acquisition (CPA)formula	NUMBER
`CostPerAssist`	Cost per assistformula	NUMBER
`RevenuePerConversion`	Revenue per conversionformula	NUMBER
`RevenuePerAssist`	Revenue per assistformula	NUMBER
`ROAS`	ROASformula	NUMBER
`Assists`	Assists	NUMBER
`Clicks`	Clicks	NUMBER
`Conversions`	Conversions	NUMBER
`Impressions`	Impressions	NUMBER
`Revenue`	Revenue	NUMBER
`Spend`	Spend	NUMBER

Dimensions (key)

Field name	Label	Type
`configName`	Account	STRING
`Company`	Company	STRING
`Industry`	Industry	STRING
`JobFunction`	Job function	STRING
`CampaignId`	Campaign ID	STRING
`AdGroupId`	Ad group ID	STRING
`TimePeriod`	Date	STRING
`account`	Account ID	STRING
`dataFreshness`	Data freshness	STRING
`isInterpolated`	PMA is interpolated?	BOOLEAN

Geographic

report_type: geographic · 15 metrics · 32 dimensions · showing 20 of 32 dimensions retrievable via API

Metrics

Field name	Label	Type
`CPC`	Average Cost-per-Click (CPC)formula	NUMBER
`CTR`	CTRformula	NUMBER
`ConversionRate`	Conversion rateformula	NUMBER
`CPM`	Average cost per 1,000 impressions (CPM)formula	NUMBER
`CostPerConversion`	Cost per acquisition (CPA)formula	NUMBER
`CostPerAssist`	Cost per assistformula	NUMBER
`RevenuePerConversion`	Revenue per conversionformula	NUMBER
`RevenuePerAssist`	Revenue per assistformula	NUMBER
`ROAS`	ROASformula	NUMBER
`Assists`	Assists	NUMBER
`Clicks`	Clicks	NUMBER
`Conversions`	Conversions	NUMBER
`Impressions`	Impressions	NUMBER
`Revenue`	Revenue	NUMBER
`Spend`	Spend	NUMBER

Dimensions

Field name	Label	Type
`configName`	Account	STRING
`City`	City	STRING
`Country`	Country	STRING
`County`	County	STRING
`LocationType`	Location type	STRING
`MetroArea`	Metro area	STRING
`State`	State	STRING
`AdGroupId`	Ad group ID	STRING
`CampaignId`	Campaign ID	STRING
`TimePeriod`	Date	STRING
`account`	Account ID	STRING
`dataFreshness`	Data freshness	STRING
`isInterpolated`	PMA is interpolated?	BOOLEAN
`dataSource`	Data source	STRING
`dataSourceLogo`	Data source logo	STRING
`executionId`	Function execution ID	STRING
`dataPlatform`	Data platform	STRING
`Subscription`	PMA subscription ID	STRING
`MinDate`	PMA minimum cached data date	STRING
`MaxDate`	PMA maximum cached data date	STRING

Competition (auction insights)

report_type: competition · 6 metrics · 24 dimensions

Metrics

Field name	Label	Type
`AboveRate`	Position above rate (competition)	NUMBER
`ImpressionShare`	Impression share (competition)	NUMBER
`OutrankingShare`	Outranking share (competition)	NUMBER
`OverlapRate`	Overlap rate (competition)	NUMBER
`TopOfPageRate`	Top of page rate (competition)	NUMBER
`competitionAveragePosition`	Average position (competition)	NUMBER

Dimensions

Field name	Label	Type
`configName`	Account	STRING
`domain`	Display URL domain (competition)	STRING
`TimePeriod`	Date	STRING
`account`	Account ID	STRING
`year`	Yearformula	STRING
`quarter`	Quarterformula	STRING
`year_quarter`	Year quarterformula	STRING
`month`	Year monthformula	STRING
`week`	Weekformula	STRING
`year_week`	Year weekformula	STRING
`isInterpolated`	PMA is interpolated?	BOOLEAN
`dataSource`	Data source	STRING
`dataSourceLogo`	Data source logo	STRING
`executionId`	Function execution ID	STRING
`dataPlatform`	Data platform	STRING
`Subscription`	PMA subscription ID	STRING
`Trial`	PMA trial status	STRING
`Payment`	PMA payment URL	STRING
`MinDate`	PMA minimum cached data date	STRING
`MaxDate`	PMA maximum cached data date	STRING

Dimension tables

report_type: campaigns_dimensions · adgroups_dimensions · ads_dimensions · keywords_dimensions · 0 metrics each · dimension-only lookup tables

These four report types contain no metrics — they are dimension-only tables providing name, status, and structural attributes for campaigns, ad groups, ads, and keywords. Use them for JOIN lookups when querying performance reports.

Full Bing Ads performance in one warehouse

No native MCP

No native MCP

Every queryable field in PMA

Account

Campaigns

Ad groups

Ads

Keywords

Search terms

Goals

Products (Shopping)

Ad extensions

Dynamic search ads (DSA)

Demographics

Professional demographics

Geographic

Competition (auction insights)

Dimension tables