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 daymicrosoft_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
The Microsoft Advertising assigned identifier of an account.
The account name.
The Microsoft Advertising assigned number of an account.
The account status.
The account currency type. For possible values, see Currencies.
The Microsoft Advertising assigned identifier of a campaign.
The campaign name.
The campaign status.
The campaign type. Possible values include Audience, Dynamic search, Search & content, and Shopping.
The Microsoft Advertising assigned identifier of an ad group.
The ad group name.
The ad group status.
The Microsoft Advertising assigned identifier of an ad.
The labels applied to the ad. Labels are delimited by a semicolon (;) in the report download.
The ad status.
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.
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.
The ad title.
The ad type.
The first ad description that appears below the path in your ad.
The second ad description that appears below the path in your ad. Ad description 2 might not appear in your ad.
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).
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.
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.
Depending on your responsive ad's placement, your business's name may appear in your ad. This column only applies to Audience campaigns.
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.
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.
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.
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.
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.
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.
The ad display URL.
Reserved for future use.
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.
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.
A place in your final URL where you can add parameters that will be attached to the end of your landing page URL.
The name of the goal you set for the conversions you want, meaning actions customers take after clicking your ad.
The Microsoft Advertising assigned identifier of a conversion goal.
The type of conversion goal. Possible values include AppInstall, Duration, Event, InStoreTransaction, OfflineConversion, PagesViewedPerVisit, and Url.
The shorter of two possible responsive ad headlines for Audience campaigns.
The longer of two possible responsive ad headlines for Audience campaigns.
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!.
The path 1 attribute of an ad.
The path 2 attribute of an ad.
The title part 1 attribute of an ad.
The title part 2 attribute of an ad.
The title part 3 attribute of an ad.
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.
The cost per click (CPC) summed for each click.
The number of times an ad has been displayed on search results pages. Without impressions there are no clicks or conversions.
Number of impressions where the ad appeared in the first position of all results.
Number of impressions where the ad appeared in the mainline, the top placement above the search results.
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).
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.
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!.
The revenue optionally reported by the advertiser as a result of conversions.
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.
The number of conversions counted across all conversion goals, including the goals that are not included in the Conversions column.
The revenue reported by the advertiser across all conversion goals, including the goals that are not included in the Revenue column.
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.
Total amount of time people spent watching the video across all impressions, in milliseconds.
Total amount of time people spent watching the video across all video views, in milliseconds.
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.
The number of times a person completed at least 25% of a video.
The number of times a person completed at least 50% of a video.
The number of times a person completed at least 75% of a video.
Number of times a person watched the entire video to completion.
Total amount of time a person spent watching the video in milliseconds.
The current tracking template of the ad, keyword, or criterion.
Keyword Table
The Microsoft Advertising assigned identifier of an account.
The account name.
The Microsoft Advertising assigned number of an account.
The account status.
The account currency type. For possible values, see Currencies.
The Microsoft Advertising assigned identifier of a campaign.
The campaign name.
The campaign status.
The Microsoft Advertising assigned identifier of an ad group.
The ad group name.
The ad group status.
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.
The Microsoft Advertising assigned identifier of an ad.
The ad type.
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).
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.
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.
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.
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.
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.
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.
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.
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.
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.
Reserved for future use.
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.
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.
A place in your final URL where you can add parameters that will be attached to the end of your landing page URL.
The name of the goal you set for the conversions you want, meaning actions customers take after clicking your ad.
The Microsoft Advertising assigned identifier of a conversion goal.
The type of conversion goal. Possible values include AppInstall, Duration, Event, InStoreTransaction, OfflineConversion, PagesViewedPerVisit, and Url.
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.
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.
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!.
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.
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.
The keyword text.
The Microsoft Advertising assigned identifier of a keyword.
The labels applied to the keyword. Labels are delimited by a semicolon (;) in the report download.
The keyword status.
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.
The cost per click (CPC) summed for each click.
The number of times an ad has been displayed on search results pages. Without impressions there are no clicks or conversions.
Number of impressions where the ad appeared in the first position of all results.
Number of impressions where the ad appeared in the mainline, the top placement above the search results.
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).
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.
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!.
The revenue optionally reported by the advertiser as a result of conversions.
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.
The number of conversions counted across all conversion goals, including the goals that are not included in the Conversions column.
The revenue reported by the advertiser across all conversion goals, including the goals that are not included in the Revenue column.
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.
The current tracking template of the ad, keyword, or criterion.