Data Sources

Microsoft Ads

Metrics & Dimensions List


Updated: 2026-08-01

Important

Two reports are available, both at daily granularity:

  • microsoft_ads__ad_daily - one row per ad per day
  • microsoft_ads__keyword_daily - one row per keyword per day

Microsoft deprecated Conversions, AllConversions and ViewThroughConversions in 2022. They now return 0; use ConversionsQualified, AllConversionsQualified and ViewThroughConversionsQualified instead.

Ad Table

AccountIdText

The Microsoft Advertising assigned identifier of an account.

AccountNameText

The account name.

AccountNumberText

The Microsoft Advertising assigned number of an account.

AccountStatusText

The account status.

CurrencyCodeText

The account currency type. For possible values, see Currencies.

CampaignIdText

The Microsoft Advertising assigned identifier of a campaign.

CampaignNameText

The campaign name.

CampaignStatusText

The campaign status.

CampaignTypeText

The campaign type. Possible values include Audience, Dynamic search, Search & content, and Shopping.

AdGroupIdText

The Microsoft Advertising assigned identifier of an ad group.

AdGroupNameText

The ad group name.

AdGroupStatusText

The ad group status.

AdIdText

The Microsoft Advertising assigned identifier of an ad.

AdLabelsText

The labels applied to the ad. Labels are delimited by a semicolon (;) in the report download.

AdStatusText

The ad status.

AdStrengthText

The ad strength score of responsive search ads. Ad strength can be Poor, Average, Good, or Excellent. This score tells you how effective and relevant your responsive search ads are. If you see "pending," it means we are calculating your ad strength based on your latest responsive search ads update.

AdStrengthActionItemsText

The suggestion based on ad strength of your responsive search ads. To help ensure that you maximize ad performance and don't miss out on opportunities, we provide suggestions for improvement along with your ad strength score.

AdTitleText

The ad title.

AdTypeText

The ad type.

AdDescriptionText

The first ad description that appears below the path in your ad.

AdDescription2Text

The second ad description that appears below the path in your ad. Ad description 2 might not appear in your ad.

AdDistributionText

The network where you want your ads to show. This can be the entire Microsoft Advertising Network, Microsoft sites and select traffic, or only partner traffic (this network type is deprecated as of July 2024).

BaseCampaignIdText

The Microsoft Advertising assigned identifier of an experiment campaign. This will be the same value as the CampaignId if the campaign is not an experiment.

BidMatchTypeText

The keyword bid match type. This can be different from the DeliveredMatchType column, for example if you bid on a broad match and the search term was an exact match. The possible values are Broad, Exact, Phrase, and Unknown.

BusinessNameText

Depending on your responsive ad's placement, your business's name may appear in your ad. This column only applies to Audience campaigns.

CustomParametersText

The current custom parameters set of the ad, keyword, or criterion. Each custom parameter is a key and value pair. The list of custom parameters is semicolon-delimited and each key is enclosed by braces and a leading underscore, for example {_key1}=value1;{_key2}=value2.

DeliveredMatchTypeText

The match type used to deliver an ad. This can be different from the BidMatchType column, for example if you bid on a broad match and the search term was an exact match. The possible values are Broad, Exact, Phrase, and Unknown.

DestinationUrlText

The destination URL attribute of the ad, keyword, or ad group criterion. If the destination URL contains dynamic text substitution parameters (for example, {param1}), the report will contain the URL after substitution occurs.

DeviceOSText

The operating system of the device reported in the DeviceType column. The possible values include Android, Blackberry, iOS, Other, Unknown, and Windows. If the operating system of the device cannot be determined or is not one of the operating systems that you can target, the value in this column will be Unknown.

DeviceTypeText

The device name attribute of a device OS target bid. The type of device which showed ads. The possible values include Computer, Smartphone, Tablet, and Unknown.

LanguageText

The language of the publisher where the ad was shown. For possible values, see the Language column of Ad Languages. The language display name will be provided in the report e.g. English.

DisplayUrlText

The ad display URL.

FinalAppUrlText

Reserved for future use.

FinalMobileUrlText

The Final Mobile URL of the ad, keyword, or criterion. Only the first URL in the list is reported. If the URL contains dynamic text substitution parameters (for example, {param1}), the report will contain the URL before substitution.

FinalUrlText

The Final URL of the ad, keyword, or criterion. Only the first URL in the list is reported. If the URL contains dynamic text substitution parameters (for example, {param1}), the report will contain the URL before substitution.

FinalUrlSuffixText

A place in your final URL where you can add parameters that will be attached to the end of your landing page URL.

GoalText

The name of the goal you set for the conversions you want, meaning actions customers take after clicking your ad.

GoalIdText

The Microsoft Advertising assigned identifier of a conversion goal.

GoalTypeText

The type of conversion goal. Possible values include AppInstall, Duration, Event, InStoreTransaction, OfflineConversion, PagesViewedPerVisit, and Url.

HeadlineText

The shorter of two possible responsive ad headlines for Audience campaigns.

LongHeadlineText

The longer of two possible responsive ad headlines for Audience campaigns.

NetworkText

The entire Microsoft Advertising Network made up of Microsoft sites and select traffic, and only partner traffic (this network type is deprecated as of July 2024). Use this data to make the best decision on network selection for your ad groups. The possible values include AOL search, Audience, Microsoft sites and select traffic, Content, and Syndicated search partners. Note: Not everyone can use the value Microsoft sites and select traffic yet. If you can't, don't worry - it's coming soon!.

Path1Text

The path 1 attribute of an ad.

Path2Text

The path 2 attribute of an ad.

TitlePart1Text

The title part 1 attribute of an ad.

TitlePart2Text

The title part 2 attribute of an ad.

TitlePart3Text

The title part 3 attribute of an ad.

DateDate

The time period of each report row. You may not include this column if the Aggregation element of the request object is set to Summary.

SpendNumber

The cost per click (CPC) summed for each click.

ImpressionsNumber

The number of times an ad has been displayed on search results pages. Without impressions there are no clicks or conversions.

AbsoluteTopImpressionNumber

Number of impressions where the ad appeared in the first position of all results.

TopImpressionNumber

Number of impressions where the ad appeared in the mainline, the top placement above the search results.

ClicksNumber

Clicks are what you pay for. Clicks typically include a customer clicking an ad on a search results page or on a website on the search network. Clicks can also come from other sources (for example, spiders, robots, and test servers).

ConversionsNumber

The number of conversions. A conversion is the completion of an action by a customer after viewing your ad. The action could be purchasing your product, registering for your webinar, joining an organization, or whatever you consider your goal and best measure of the ad's success. Conversions are measured by adding a small bit of code to your website pages so that a visitor's progress through your site can be tracked. This column is deprecated as of 2022, so you should use the ConversionsQualified column instead. Going forward, performance reports will return "0" (zero) in this column. Historical data for time periods prior to the deprecation date will still be available according to the published data retention period.

ConversionsQualifiedNumber

The number of conversions. A conversion is the completion of an action by a customer after viewing your ad. The action could be purchasing your product, registering for your webinar, joining an organization, or whatever you consider your goal and best measure of the ad's success. Conversions are measured by adding a small bit of code to your website pages so that a visitor's progress through your site can be tracked. Not everyone has this feature yet. If you don't, don't worry - it's coming soon!.

RevenueNumber

The revenue optionally reported by the advertiser as a result of conversions.

AllConversionsNumber

The number of conversions. A conversion is the completion of an action by a customer after viewing your ad. The action could be purchasing your product, registering for your webinar, joining an organization, or whatever you consider your goal and best measure of the ad's success. Conversions are measured by adding a small bit of code to your website pages so that a visitor's progress through your site can be tracked. This column is deprecated as of 2022, so you should use the AllConversionsQualified column instead. Going forward, performance reports will return "0" (zero) in this column. Historical data for time periods prior to the deprecation date will still be available according to the published data retention period.

AllConversionsQualifiedNumber

The number of conversions counted across all conversion goals, including the goals that are not included in the Conversions column.

AllRevenueNumber

The revenue reported by the advertiser across all conversion goals, including the goals that are not included in the Revenue column.

AssistsNumber

The number of conversions from other ads within the same account that were preceded by one or more clicks from this ad. An ad is considered to have assisted the conversion if it was clicked before the most recently clicked ad that was credited with the conversion. Additionally, the click corresponding to the assist must occur within the conversion period of the goal.

TotalWatchTimeImpressionNumber

Total amount of time people spent watching the video across all impressions, in milliseconds.

TotalWatchTimeVideoViewNumber

Total amount of time people spent watching the video across all video views, in milliseconds.

VideoViewsNumber

The number of times the video was played and watched for at least two continuous seconds with more than 50% of the screen in view.

VideoViewsAt25PercentNumber

The number of times a person completed at least 25% of a video.

VideoViewsAt50PercentNumber

The number of times a person completed at least 50% of a video.

VideoViewsAt75PercentNumber

The number of times a person completed at least 75% of a video.

CompletedVideoViewsNumber

Number of times a person watched the entire video to completion.

TotalWatchTimeInMSText

Total amount of time a person spent watching the video in milliseconds.

TrackingTemplateText

The current tracking template of the ad, keyword, or criterion.

Keyword Table

AccountIdText

The Microsoft Advertising assigned identifier of an account.

AccountNameText

The account name.

AccountNumberText

The Microsoft Advertising assigned number of an account.

AccountStatusText

The account status.

CurrencyCodeText

The account currency type. For possible values, see Currencies.

CampaignIdText

The Microsoft Advertising assigned identifier of a campaign.

CampaignNameText

The campaign name.

CampaignStatusText

The campaign status.

AdGroupIdText

The Microsoft Advertising assigned identifier of an ad group.

AdGroupNameText

The ad group name.

AdGroupStatusText

The ad group status.

AdRelevanceText

How closely related your ads is to the customer's search query or other input. It tells you how relevant your ad and landing page are to potential customers. A score of 3 is Above Average; a score of 2 is Average; and a score of 1 is considered Below Average. The score is calculated only based on Search Traffic. The value in the report will be "--" (double dash) if the score was not computed. If you specify a time period that spans multiple days, the score will be the same for each day in the time period, and the value is the most recent calculated score. Data for this column is typically updated 14-18 hours after the UTC day ends.

AdIdText

The Microsoft Advertising assigned identifier of an ad.

AdTypeText

The ad type.

AdDistributionText

The network where you want your ads to show. This can be the entire Microsoft Advertising Network, Microsoft sites and select traffic, or only partner traffic (this network type is deprecated as of July 2024).

BaseCampaignIdText

The Microsoft Advertising assigned identifier of an experiment campaign. This will be the same value as the CampaignId if the campaign is not an experiment.

BidMatchTypeText

The keyword bid match type. This can be different from the DeliveredMatchType column, for example if you bid on a broad match and the search term was an exact match. The possible values are Broad, Exact, Phrase, and Unknown.

BidStrategyTypeText

The bid strategy type. Possible values include EnhancedCpc, ManualCpc, MaxClicks, MaxConversions, and TargetCpa. If the InheritFromParent strategy type is used, the report will include the inherited bid strategy type e.g. one of the supported values listed above.

CustomParametersText

The current custom parameters set of the ad, keyword, or criterion. Each custom parameter is a key and value pair. The list of custom parameters is semicolon-delimited and each key is enclosed by braces and a leading underscore, for example {_key1}=value1;{_key2}=value2.

DeliveredMatchTypeText

The match type used to deliver an ad. This can be different from the BidMatchType column, for example if you bid on a broad match and the search term was an exact match. The possible values are Broad, Exact, Phrase, and Unknown.

DestinationUrlText

The destination URL attribute of the ad, keyword, or ad group criterion. If the destination URL contains dynamic text substitution parameters (for example, {param1}), the report will contain the URL after substitution occurs.

DeviceOSText

The operating system of the device reported in the DeviceType column. The possible values include Android, Blackberry, iOS, Other, Unknown, and Windows. If the operating system of the device cannot be determined or is not one of the operating systems that you can target, the value in this column will be Unknown.

DeviceTypeText

The device name attribute of a device OS target bid. The type of device which showed ads. The possible values include Computer, Smartphone, Tablet, and Unknown.

LanguageText

The language of the publisher where the ad was shown. For possible values, see the Language column of Ad Languages. The language display name will be provided in the report e.g. English.

FinalAppUrlText

Reserved for future use.

FinalMobileUrlText

The Final Mobile URL of the ad, keyword, or criterion. Only the first URL in the list is reported. If the URL contains dynamic text substitution parameters (for example, {param1}), the report will contain the URL before substitution.

FinalUrlText

The Final URL of the ad, keyword, or criterion. Only the first URL in the list is reported. If the URL contains dynamic text substitution parameters (for example, {param1}), the report will contain the URL before substitution.

FinalUrlSuffixText

A place in your final URL where you can add parameters that will be attached to the end of your landing page URL.

GoalText

The name of the goal you set for the conversions you want, meaning actions customers take after clicking your ad.

GoalIdText

The Microsoft Advertising assigned identifier of a conversion goal.

GoalTypeText

The type of conversion goal. Possible values include AppInstall, Duration, Event, InStoreTransaction, OfflineConversion, PagesViewedPerVisit, and Url.

Mainline1BidText

Based on your campaign performance and marketplace dynamics, this estimate is the bid amount that Microsoft Advertising calculates will place your ad at the top of search results. These estimates are provided as a reference only. They are automatically generated by Microsoft Advertising and are not a guarantee of ad position.

MainlineBidText

Based on your campaign performance and marketplace dynamics, this estimate is the bid amount that Microsoft Advertising calculates for your ad to be placed on the first page in the search results. These estimates are provided as a reference only. They are automatically generated by Microsoft Advertising and are not a guarantee of ad position.

NetworkText

The entire Microsoft Advertising Network made up of Microsoft sites and select traffic, and only partner traffic (this network type is deprecated as of July 2024). Use this data to make the best decision on network selection for your ad groups. The possible values include AOL search, Audience, Microsoft sites and select traffic, Content, and Syndicated search partners. Note: Not everyone can use the value Microsoft sites and select traffic yet. If you can't, don't worry - it's coming soon!.

QualityImpactNumber

The numeric score that indicates the possible increase in the number of impressions that the keyword could receive if the corresponding QualityScore column would rise above underperforming:0 - Not available. Could be because the keyword is not underperforming.1 - Low impact. Improving the quality score could increase impressions by less than 100 additional impressions per day.2 - Medium impact. Improving the quality score could increase impressions by 100 to 500 additional impressions per day.3 - High impact. Improving the quality score could increase impressions by more than 500 additional impressions per day.

QualityScoreNumber

The numeric score shows you how competitive your ads are in the marketplace by measuring how relevant your keywords and landing pages are to customers' search terms. The quality score is calculated by Microsoft Advertising using the ExpectedCtr, AdRelevance, and LandingPageExperience sub scores. If available, the quality score can range from a low of 1 to a high of 10. Quality score is based on the last rolling 30 days for the owned and operated search traffic. A quality score can be assigned without any impressions, in the case where a keyword bid did not win any auctions. The score is calculated only based on Search Traffic. The value in the report will be "--" (double dash) if the score was not computed. This can occur if there have been no impressions for the keyword for 30 days or more. Quality score is typically updated 14-18 hours after the UTC day ends. Keywords in all time zones will be assigned a quality score for the corresponding UTC day.

KeywordText

The keyword text.

KeywordIdText

The Microsoft Advertising assigned identifier of a keyword.

KeywordLabelsText

The labels applied to the keyword. Labels are delimited by a semicolon (;) in the report download.

KeywordStatusText

The keyword status.

DateDate

The time period of each report row. You may not include this column if the Aggregation element of the request object is set to Summary.

SpendNumber

The cost per click (CPC) summed for each click.

ImpressionsNumber

The number of times an ad has been displayed on search results pages. Without impressions there are no clicks or conversions.

AbsoluteTopImpressionNumber

Number of impressions where the ad appeared in the first position of all results.

TopImpressionNumber

Number of impressions where the ad appeared in the mainline, the top placement above the search results.

ClicksNumber

Clicks are what you pay for. Clicks typically include a customer clicking an ad on a search results page or on a website on the search network. Clicks can also come from other sources (for example, spiders, robots, and test servers).

ConversionsNumber

The number of conversions. A conversion is the completion of an action by a customer after viewing your ad. The action could be purchasing your product, registering for your webinar, joining an organization, or whatever you consider your goal and best measure of the ad's success. Conversions are measured by adding a small bit of code to your website pages so that a visitor's progress through your site can be tracked. This column is deprecated as of 2022, so you should use the ConversionsQualified column instead. Going forward, performance reports will return "0" (zero) in this column. Historical data for time periods prior to the deprecation date will still be available according to the published data retention period.

ConversionsQualifiedNumber

The number of conversions. A conversion is the completion of an action by a customer after viewing your ad. The action could be purchasing your product, registering for your webinar, joining an organization, or whatever you consider your goal and best measure of the ad's success. Conversions are measured by adding a small bit of code to your website pages so that a visitor's progress through your site can be tracked. Not everyone has this feature yet. If you don't, don't worry - it's coming soon!.

RevenueNumber

The revenue optionally reported by the advertiser as a result of conversions.

AllConversionsNumber

The number of conversions. A conversion is the completion of an action by a customer after viewing your ad. The action could be purchasing your product, registering for your webinar, joining an organization, or whatever you consider your goal and best measure of the ad's success. Conversions are measured by adding a small bit of code to your website pages so that a visitor's progress through your site can be tracked. This column is deprecated as of 2022, so you should use the AllConversionsQualified column instead. Going forward, performance reports will return "0" (zero) in this column. Historical data for time periods prior to the deprecation date will still be available according to the published data retention period.

AllConversionsQualifiedNumber

The number of conversions counted across all conversion goals, including the goals that are not included in the Conversions column.

AllRevenueNumber

The revenue reported by the advertiser across all conversion goals, including the goals that are not included in the Revenue column.

AssistsNumber

The number of conversions from other ads within the same account that were preceded by one or more clicks from this ad. An ad is considered to have assisted the conversion if it was clicked before the most recently clicked ad that was credited with the conversion. Additionally, the click corresponding to the assist must occur within the conversion period of the goal.

TrackingTemplateText

The current tracking template of the ad, keyword, or criterion.