Bing Ads report and Microsoft Ads dashboard: metrics, template and AI prompts
Quick answer: A Microsoft Ads dashboard needs 14 metrics on 5 panels: spend and results, efficiency, campaigns, search terms and keywords, and competitive position. Ryze AI is the best tool for pulling those numbers from several Microsoft Advertising accounts with a prompt, with one caveat: it saves no fixed layout, so each review is a set of prompts rather than a stored board.
Below: the metrics with Bing Ads Reporting API column names, a 5-panel template, the report request flow, data timing rules, Ryze AI prompts and a weekly routine.
Ryze AI · Paid Ads
Microsoft Ads reports from a prompt
- 7-day free trial, $89 a month flat
Used by 2,000+ marketers
Microsoft Ads dashboard at a glance
5 panels, read top to bottom once a week.
- 1Spend and resultsLast 7 days vs prior 7
Metrics: Spend, conversions, revenue, ROAS
Question it answers: What did the account cost and what came back?
- 2EfficiencyLast 7 days vs prior 7
Metrics: CTR, average CPC, conversion rate, cost per conversion
Question it answers: Are clicks getting dearer or weaker?
- 3CampaignsLast 7 days vs prior 7
Metrics: Impressions, clicks, spend and conversions per campaign
Question it answers: Which campaign moved the total?
- 4Search terms and keywordsLast 30 days
Metrics: Clicks, spend and conversions by search term and keyword
Question it answers: Which queries earn or waste money?
- 5Competitive positionLast 30 days
Metrics: Impression share, share lost to budget, share lost to rank, quality score
Question it answers: Is budget or ad rank the limit?
| # | Panel | Range | Metrics | Question it answers |
|---|---|---|---|---|
| 1 | Spend and results | Last 7 days vs prior 7 | Spend, conversions, revenue, ROAS | What did the account cost and what came back? |
| 2 | Efficiency | Last 7 days vs prior 7 | CTR, average CPC, conversion rate, cost per conversion | Are clicks getting dearer or weaker? |
| 3 | Campaigns | Last 7 days vs prior 7 | Impressions, clicks, spend and conversions per campaign | Which campaign moved the total? |
| 4 | Search terms and keywords | Last 30 days | Clicks, spend and conversions by search term and keyword | Which queries earn or waste money? |
| 5 | Competitive position | Last 30 days | Impression share, share lost to budget, share lost to rank, quality score | Is budget or ad rank the limit? |
The next section maps each metric to its Reporting API column name.
The 14 Bing Ads report metrics and their API column names
14 metrics answer 3 weekly questions: what did we pay, what did the click do, and how much of the market did we reach.
The column names come from the CampaignPerformanceReportColumn value set of the Microsoft Advertising API, which defines what each column means. The definitions below are plain-language readings of Microsoft's own formulas.
Spend
- Plain definition
- The cost per click summed for each click
- API column
- Spend
- How to read it
- The money number every other panel hangs on
Impressions
- Plain definition
- Times an ad was shown on search results pages
- API column
- Impressions
- How to read it
- No impressions, no clicks or conversions
Clicks
- Plain definition
- Clicks you pay for
- API column
- Clicks
- How to read it
- Microsoft notes some clicks can come from robots or test servers
CTR
- Plain definition
- Clicks divided by impressions, times 100
- API column
- Ctr
- How to read it
- Read it as a percent: 2.13 means 2.13%
Average CPC
- Plain definition
- Spend divided by clicks
- API column
- AverageCpc
- How to read it
- What you are actually charged per click
Conversions
- Plain definition
- Completed actions after an ad view, counted by conversion tracking
- API column
- Conversions
- How to read it
- Excludes goals set to ExcludeFromBidding; AllConversions includes them
Conversion rate
- Plain definition
- Conversions divided by clicks, times 100
- API column
- ConversionRate
- How to read it
- Same ExcludeFromBidding rule as Conversions
Cost per conversion
- Plain definition
- Spend divided by conversions
- API column
- CostPerConversion
- How to read it
- Inaccurate unless every campaign tracks conversions
Revenue
- Plain definition
- Revenue the advertiser reports for conversions
- API column
- Revenue
- How to read it
- Optional: empty if you never send values
ROAS
- Plain definition
- Revenue divided by spend
- API column
- ReturnOnAdSpend
- How to read it
- Needs revenue values on the conversion goals
Impression share
- Plain definition
- Estimated share of the impressions available in your targeted market
- API column
- ImpressionSharePercent
- How to read it
- Empty when the data is not available
Share lost to budget
- Plain definition
- Estimated impressions missed because of budget
- API column
- ImpressionLostToBudgetPercent
- How to read it
- Points at a budget fix
Share lost to rank
- Plain definition
- Estimated impressions missed because of ad ranking
- API column
- ImpressionLostToRankAggPercent
- How to read it
- Points at bids, quality or relevance
Quality score
- Plain definition
- 1 to 10 score from expected CTR, ad relevance and landing page experience
- API column
- QualityScore
- How to read it
- Only shown when available
| Metric | Plain definition | API column | How to read it |
|---|---|---|---|
| Spend | The cost per click summed for each click | Spend | The money number every other panel hangs on |
| Impressions | Times an ad was shown on search results pages | Impressions | No impressions, no clicks or conversions |
| Clicks | Clicks you pay for | Clicks | Microsoft notes some clicks can come from robots or test servers |
| CTR | Clicks divided by impressions, times 100 | Ctr | Read it as a percent: 2.13 means 2.13% |
| Average CPC | Spend divided by clicks | AverageCpc | What you are actually charged per click |
| Conversions | Completed actions after an ad view, counted by conversion tracking | Conversions | Excludes goals set to ExcludeFromBidding; AllConversions includes them |
| Conversion rate | Conversions divided by clicks, times 100 | ConversionRate | Same ExcludeFromBidding rule as Conversions |
| Cost per conversion | Spend divided by conversions | CostPerConversion | Inaccurate unless every campaign tracks conversions |
| Revenue | Revenue the advertiser reports for conversions | Revenue | Optional: empty if you never send values |
| ROAS | Revenue divided by spend | ReturnOnAdSpend | Needs revenue values on the conversion goals |
| Impression share | Estimated share of the impressions available in your targeted market | ImpressionSharePercent | Empty when the data is not available |
| Share lost to budget | Estimated impressions missed because of budget | ImpressionLostToBudgetPercent | Points at a budget fix |
| Share lost to rank | Estimated impressions missed because of ad ranking | ImpressionLostToRankAggPercent | Points at bids, quality or relevance |
| Quality score | 1 to 10 score from expected CTR, ad relevance and landing page experience | QualityScore | Only shown when available |
5 things that trip up a first Microsoft Ads dashboard
- Two conversion counts. Conversions, ConversionRate, CostPerConversion, Revenue and ReturnOnAdSpend leave out any conversion goal with ExcludeFromBidding set to true. The All versions of those columns include every goal. Pick one set and keep it.
- Impression share columns restrict the rest. In a campaign report you cannot mix impression share columns with attributes such as BidMatchType, BudgetName, BudgetStatus, Goal, GoalType or TopVsOther. That is why panel 5 is its own request.
- Impression share is late. The column docs say data for the lost-to-budget and lost-to-rank columns is typically updated 14 to 18 hours after the UTC day ends, and asking for them with Hourly or HourOfDay aggregation returns code 2053.
- Average position is gone. Microsoft deprecated AveragePosition on March 31, 2021, and performance reports now return 0. Do not put it on a board.
- Percent columns are plain numbers. Ctr and ConversionRate come as values such as 2.13. Report FormatVersion 2.0 trims several percent columns to 2 decimals and removes the thousands comma from revenue and cost columns.
The Microsoft Ads dashboard template: 5 panels
Put the 14 metrics on 5 panels, ordered from the money to the campaigns to the queries and the market.
1. Spend and results
- Tiles or chart
- Tiles: spend, conversions, revenue, ROAS; daily line of spend and conversions
- Date range
- Last 7 days, 30-day line
- Compare with
- The 7 days before
2. Efficiency
- Tiles or chart
- Tiles: CTR, average CPC, conversion rate, cost per conversion
- Date range
- Last 7 days
- Compare with
- The 7 days before
3. Campaigns
- Tiles or chart
- Table, highest spend first, with impressions, clicks, spend, conversions, cost per conversion
- Date range
- Last 7 days
- Compare with
- The 7 days before
4. Search terms and keywords
- Tiles or chart
- Two tables: search terms and keywords, with clicks, spend, conversions
- Date range
- Last 30 days
- Compare with
- Other rows in the same table
5. Competitive position
- Tiles or chart
- Table per campaign: impression share, lost to budget, lost to rank, quality score
- Date range
- Last 30 days
- Compare with
- The previous 30 days
| Panel | Tiles or chart | Date range | Compare with |
|---|---|---|---|
| 1. Spend and results | Tiles: spend, conversions, revenue, ROAS; daily line of spend and conversions | Last 7 days, 30-day line | The 7 days before |
| 2. Efficiency | Tiles: CTR, average CPC, conversion rate, cost per conversion | Last 7 days | The 7 days before |
| 3. Campaigns | Table, highest spend first, with impressions, clicks, spend, conversions, cost per conversion | Last 7 days | The 7 days before |
| 4. Search terms and keywords | Two tables: search terms and keywords, with clicks, spend, conversions | Last 30 days | Other rows in the same table |
| 5. Competitive position | Table per campaign: impression share, lost to budget, lost to rank, quality score | Last 30 days | The previous 30 days |
Read panel 1 first. If cost per conversion rose, panel 2 shows whether CPC or conversion rate moved, panel 3 names the campaign, panel 4 shows which queries and keywords carry the spend, and panel 5 tells you whether the fix is budget or rank.
Which report feeds which panel
1 and 2
- Report request type
- AccountPerformanceReportRequest
- Web application report name
- Account
3 and 5
- Report request type
- CampaignPerformanceReportRequest
- Web application report name
- Campaign
4 (search terms)
- Report request type
- SearchQueryPerformanceReportRequest
- Web application report name
- Search Term
4 (keywords)
- Report request type
- KeywordPerformanceReportRequest
- Web application report name
- Keyword
| Panel | Report request type | Web application report name |
|---|---|---|
| 1 and 2 | AccountPerformanceReportRequest | Account |
| 3 and 5 | CampaignPerformanceReportRequest | Campaign |
| 4 (search terms) | SearchQueryPerformanceReportRequest | Search Term |
| 4 (keywords) | KeywordPerformanceReportRequest | Keyword |
The request type names and the web application names come from the report types guide and the data retention table. The same table lists reports for ad groups, ads, audiences, geographic data and conversions if you want more panels.
These sketches list request elements named in Microsoft's Reports guide; the Reporting service itself is a SOAP service, so the exact wire format depends on your client library. Check each report request object before you build on it.
Data timing rules every Bing Ads report has
Most wrong numbers on a Microsoft Ads dashboard come from the time zone, from data that is not final yet, or from retention.
Report time zone
- What Microsoft documents
- Row data is always relative to UTC. ReportTimeZone only sets what today means, and defaults to Pacific Time (US and Canada) when omitted
- What to do
- Set the time zone to the account's own
Click and conversion delay
- What Microsoft documents
- A click can take up to 2 hours to reach reporting and a conversion up to 3 hours
- What to do
- Skip the current day in weekly numbers
Complete data flag
- What Microsoft documents
- ReturnOnlyCompleteData true returns error 2004 (NoCompleteDataAvaliable) until the data is processed; the default returns what is ready
- What to do
- Use true for yesterday, false for today
Late adjustments
- What Microsoft documents
- Invalid traffic can cause adjustments that take a week or more to settle
- What to do
- Re-read last week before you act on it
Retention, campaign and keyword reports
- What Microsoft documents
- 6 months hourly and 36 months for daily, weekly, monthly, yearly and summary data
- What to do
- Keep your own copy for longer trends
Retention, search term report
- What Microsoft documents
- 1 month hourly, 36 months for the other aggregations
- What to do
- Pull search terms on a schedule
Retention, geographic report
- What Microsoft documents
- 14 days hourly, 36 months for the other aggregations
- What to do
- Use daily for geography
Negative keyword conflict report
- What Microsoft documents
- No historical data: it reflects current settings
- What to do
- Treat it as a live check, not a trend
Report ids and files
- What Microsoft documents
- The report request id is valid for 2 days, the download link works for 5 minutes, and the file is compressed. Csv, Tsv and Xml formats exist
- What to do
- Download right after a poll returns Success
| Rule | What Microsoft documents | What to do |
|---|---|---|
| Report time zone | Row data is always relative to UTC. ReportTimeZone only sets what today means, and defaults to Pacific Time (US and Canada) when omitted | Set the time zone to the account's own |
| Click and conversion delay | A click can take up to 2 hours to reach reporting and a conversion up to 3 hours | Skip the current day in weekly numbers |
| Complete data flag | ReturnOnlyCompleteData true returns error 2004 (NoCompleteDataAvaliable) until the data is processed; the default returns what is ready | Use true for yesterday, false for today |
| Late adjustments | Invalid traffic can cause adjustments that take a week or more to settle | Re-read last week before you act on it |
| Retention, campaign and keyword reports | 6 months hourly and 36 months for daily, weekly, monthly, yearly and summary data | Keep your own copy for longer trends |
| Retention, search term report | 1 month hourly, 36 months for the other aggregations | Pull search terms on a schedule |
| Retention, geographic report | 14 days hourly, 36 months for the other aggregations | Use daily for geography |
| Negative keyword conflict report | No historical data: it reflects current settings | Treat it as a live check, not a trend |
| Report ids and files | The report request id is valid for 2 days, the download link works for 5 minutes, and the file is compressed. Csv, Tsv and Xml formats exist | Download right after a poll returns Success |
Microsoft's guide says most reports finish within minutes and suggests polling every 2 to 15 minutes. After 60 minutes of polling, it suggests saving the id and trying later. Request rate limits were not on a page opened for this guide, so check Microsoft's throttling documentation before you schedule many requests.
Option 1: the Microsoft Advertising web app and the Reporting API
Microsoft gives you 2 first-party routes: the reports in the Microsoft Advertising web application, and the Reporting API for code.
The retention table pairs each API report with a web application report name such as Account, Campaign, Keyword, Search Term, Geographic and Audiences, so the web app covers the same families of reports. The Microsoft Advertising help center did not load as text on the build day, so this page does not describe how the web app builds, schedules or exports its reports. Check that before you decide.
- Get a developer token. A Super Admin requests it in the Microsoft Advertising developer settings, and a universal token works with any user credentials.
- Register an app and get an OAuth access token for a user who can reach the accounts.
- Call SubmitGenerateReport with a report request object, then poll with PollGenerateReport using the same credentials.
- Download and unzip the file when the status is Success, then chart it with the template above.
Strength: the numbers come straight from Microsoft and you control storage and layout. Limits: you host the pipeline, handle tokens and refresh logic, and the developer token alone grants no account access, since the user's role on each account still applies. The get started guide lists the headers each call needs.
Option 2: the prompts that pull it through Ryze AI
Ryze AI runs Microsoft Advertising performance reports such as campaign, keyword, search query, geographic and audience performance, so each panel is one prompt.
Connect Microsoft Ads under Integrations, choose whether you sign in to Microsoft Advertising with a Microsoft account or a Google account, and approve every permission. Per the Ryze AI Microsoft Ads guide, Ryze AI then sees every ad account that login can reach; there is no ad account to pick. Then open a new chat and paste a prompt.
Behind these prompts sit read tools: microsoft_ads__listAccounts lists the accounts the login can access, microsoft_ads__getEntities reads campaigns, ad groups, ads or keywords, and microsoft_ads__report runs the performance report. microsoft_ads__adInsight returns keyword ideas, historical keyword performance, and bid and budget suggestions. microsoft_ads__rawCall runs any read operation of the Bing Ads API v13. The connection has 9 tools in all, with write and delete tools besides. Money values in tool responses are whole units of the account billing currency.
The same pulls in Claude or ChatGPT
The same tools load in Claude and ChatGPT through the Ryze AI connector at https://connector.get-ryze.ai/mcp. If the Microsoft Ads tools do not appear in a new chat, refresh the connector; in Claude, remove it under Customize > Connectors, add it again and start a new chat. For more on the tools, see the Microsoft Ads MCP page.
Check approvals first. In the Ryze AI chat, the Tool approvals setting starts on Skip all approvals; switch it in the chat composer to Approve write & delete. In Claude, set write and delete tools to Needs approval under Customize > Connectors > Ryze AI. Delete operations are irreversible, so every prompt here tells the agent to change nothing.
A weekly review routine for the dashboard
Spend 20 minutes on the same day each week, after the books for the last day have closed, and read the panels in order.
1
- Panel
- Spend and results
- What to check
- Spend vs plan; ROAS vs prior 7 days
- Action if off
- Open panels 2 and 3 to find the cause
2
- Panel
- Efficiency
- What to check
- Direction of CTR, average CPC and conversion rate
- Action if off
- Low CTR: ad copy. Low conversion rate: landing page or tracking
3
- Panel
- Campaigns
- What to check
- The campaign with the largest change in cost per conversion
- Action if off
- Review budget, bids and targeting of that campaign
4
- Panel
- Search terms and keywords
- What to check
- Terms with spend and no conversions
- Action if off
- Add negative keywords after a manual check
5
- Panel
- Competitive position
- What to check
- Share lost to budget vs share lost to rank
- Action if off
- Budget loss: budget or bid cap. Rank loss: bids, ads, landing page
| Step | Panel | What to check | Action if off |
|---|---|---|---|
| 1 | Spend and results | Spend vs plan; ROAS vs prior 7 days | Open panels 2 and 3 to find the cause |
| 2 | Efficiency | Direction of CTR, average CPC and conversion rate | Low CTR: ad copy. Low conversion rate: landing page or tracking |
| 3 | Campaigns | The campaign with the largest change in cost per conversion | Review budget, bids and targeting of that campaign |
| 4 | Search terms and keywords | Terms with spend and no conversions | Add negative keywords after a manual check |
| 5 | Competitive position | Share lost to budget vs share lost to rank | Budget loss: budget or bid cap. Rank loss: bids, ads, landing page |
Re-read last week too: Microsoft documents a 2-hour click delay, a 3-hour conversion delay and occasional invalid-traffic adjustments that take a week or more.
Scheduled version
The Ryze AI help center describes scheduled tasks. They run without an approval step, so keep the prompt read only.
Reporting API vs Ryze AI for a Bing Ads report
The Reporting API gives you the data and a build job. Ryze AI gives you answers to new questions across accounts.
Price
- Microsoft Reporting API
- No API fee is stated on the pages opened for this guide
- Ryze AI
- Paid Ads $89/mo, 7-day free trial
Set-up
- Microsoft Reporting API
- Developer token, OAuth app, polling code and unzip step
- Ryze AI
- Sign in with Microsoft or Google; no keys to copy
Accounts
- Microsoft Reporting API
- Scope of the report request names the accounts
- Ryze AI
- Every account the login reaches, with Agent default accounts to pick the first ones
Reports
- Microsoft Reporting API
- The full report type list, with column-level control
- Ryze AI
- Campaign, keyword, search query, geographic and audience performance reports
Saved fixed layout
- Microsoft Reporting API
- Whatever you build
- Ryze AI
- Prompts in chat; no layout is saved by this method
Acting on findings
- Microsoft Reporting API
- Campaign Management service, a separate API
- Ryze AI
- Write and delete tools, under your Tool approvals setting
| Question | Microsoft Reporting API | Ryze AI |
|---|---|---|
| Price | No API fee is stated on the pages opened for this guide | Paid Ads $89/mo, 7-day free trial |
| Set-up | Developer token, OAuth app, polling code and unzip step | Sign in with Microsoft or Google; no keys to copy |
| Accounts | Scope of the report request names the accounts | Every account the login reaches, with Agent default accounts to pick the first ones |
| Reports | The full report type list, with column-level control | Campaign, keyword, search query, geographic and audience performance reports |
| Saved fixed layout | Whatever you build | Prompts in chat; no layout is saved by this method |
| Acting on findings | Campaign Management service, a separate API | Write and delete tools, under your Tool approvals setting |
The Microsoft Advertising API pages opened on the build day mention no Microsoft-run MCP server, so none is offered here as a way to pull reports. Check Microsoft's docs for current details. The Ryze AI connector at https://connector.get-ryze.ai/mcp also covers the other platforms Ryze AI connects.
Which Microsoft Ads dashboard to use
Pick by whether you want a stored dataset or fast answers, and by how many accounts you read.
Own database or a custom chart
- Use
- The Reporting API, with the column names above
A quick look at one account
- Use
- The Microsoft Advertising web app reports
Several accounts or changing questions
- Use
- Ryze AI prompts
Acting on what the numbers show
- Use
- Ryze AI write tools, with approvals switched on
| Situation | Use |
|---|---|
| Own database or a custom chart | The Reporting API, with the column names above |
| A quick look at one account | The Microsoft Advertising web app reports |
| Several accounts or changing questions | Ryze AI prompts |
| Acting on what the numbers show | Ryze AI write tools, with approvals switched on |
You can use both: keep a pipeline for fixed numbers and ask Ryze AI for the why. The same template exists for Google Ads, Meta Ads and LinkedIn Ads. All dashboards are listed on the integrations hub.
Sources
- CampaignPerformanceReportColumn value setColumn names, definitions, formulas, impression share and AveragePosition notes. Opened Nov 21, 2026.
- Reports guideFile formats, time zones, data delay, column restrictions, FormatVersion. Opened Nov 21, 2026.
- Request and download a reportSubmit and poll flow, id and download link lifetimes. Opened Nov 21, 2026.
- Report typesReport request type names. Opened Nov 21, 2026.
- Reporting data retention time periodsRetention per aggregation and web application report names. Opened Nov 21, 2026.
- Get started with the Bing Ads APIDeveloper token, OAuth and request headers. Opened Nov 21, 2026.
- Ryze AI Microsoft Ads guideConnection, access and tools.
The verdict
A Microsoft Ads dashboard is 14 metrics on 5 panels read in the same order each week, with one conversion definition, a set time zone and the last day left out until its data settles. Build the stored version on the Reporting API if you need your own dataset.
Use Ryze AI when you read several accounts or want to ask new questions of the same data. Connect Microsoft Ads, paste the prompts above and keep them read only.
Frequently asked questions
What should a Microsoft Ads dashboard include?
How do I pull a Bing Ads report through the API?
Which time zone do Bing Ads reports use?
Why do my Microsoft Ads conversions differ between reports?
Show 7 more questionsShow fewer questions
Why is impression share empty or late?
Can Ryze AI build a Microsoft Ads dashboard?
Which Ryze AI tools read Microsoft Ads data?
Can I use several Microsoft Ads accounts in one chat?
Can the agent change my account while I build a dashboard?
Does Microsoft have its own MCP server for Microsoft Advertising?
How much does Ryze AI cost for this?
Related guides
Google Ads dashboard
14 Google Ads metrics with API field names and a 5-panel template.
Meta Ads dashboard
Meta Ads metrics with API field names and a panel template.
LinkedIn Ads dashboard
LinkedIn Ads metrics with API names and a panel template.
Microsoft Ads MCP server
The Ryze AI Microsoft Ads tools and how to connect them.





