Ira Bodnar··Updated ·10 min read

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

Uber Eats logoadidas logoDuolingo logoMGM Resorts logoWharton logoLendingClub logoNorton logoEventbrite logoHuel logoTogether AI logoghd logoHack The Box logo

Microsoft Ads dashboard at a glance

5 panels, read top to bottom once a week.

  1. 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?

  2. 2EfficiencyLast 7 days vs prior 7

    Metrics: CTR, average CPC, conversion rate, cost per conversion

    Question it answers: Are clicks getting dearer or weaker?

  3. 3CampaignsLast 7 days vs prior 7

    Metrics: Impressions, clicks, spend and conversions per campaign

    Question it answers: Which campaign moved the total?

  4. 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?

  5. 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?

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.

  1. 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
  2. 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
  3. 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
  4. 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%
  5. Average CPC

    Plain definition
    Spend divided by clicks
    API column
    AverageCpc
    How to read it
    What you are actually charged per click
  6. 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
  7. Conversion rate

    Plain definition
    Conversions divided by clicks, times 100
    API column
    ConversionRate
    How to read it
    Same ExcludeFromBidding rule as Conversions
  8. Cost per conversion

    Plain definition
    Spend divided by conversions
    API column
    CostPerConversion
    How to read it
    Inaccurate unless every campaign tracks conversions
  9. Revenue

    Plain definition
    Revenue the advertiser reports for conversions
    API column
    Revenue
    How to read it
    Optional: empty if you never send values
  10. ROAS

    Plain definition
    Revenue divided by spend
    API column
    ReturnOnAdSpend
    How to read it
    Needs revenue values on the conversion goals
  11. 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
  12. Share lost to budget

    Plain definition
    Estimated impressions missed because of budget
    API column
    ImpressionLostToBudgetPercent
    How to read it
    Points at a budget fix
  13. 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
  14. 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

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. 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. 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. 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. 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. 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

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. 1 and 2

    Report request type
    AccountPerformanceReportRequest
    Web application report name
    Account
  2. 3 and 5

    Report request type
    CampaignPerformanceReportRequest
    Web application report name
    Campaign
  3. 4 (search terms)

    Report request type
    SearchQueryPerformanceReportRequest
    Web application report name
    Search Term
  4. 4 (keywords)

    Report request type
    KeywordPerformanceReportRequest
    Web application report name
    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.

Report request elements: panels 3 and 4 headline numbers
CampaignPerformanceReportRequest ReportName: <any label> Format: Csv Aggregation: Daily Time: PredefinedTime LastSevenDays (ReportTimeZone set explicitly) Scope: the account ids to include Columns: TimePeriod, CampaignName, CampaignId, Impressions, Clicks, Ctr, AverageCpc, Spend, Conversions, CostPerConversion ReturnOnlyCompleteData: false
Report request elements: panel 5
CampaignPerformanceReportRequest Aggregation: Summary Time: custom date range, 30 days Columns: CampaignName, CampaignId, ImpressionSharePercent, ImpressionLostToBudgetPercent, ImpressionLostToRankAggPercent (no BidMatchType, BudgetName, BudgetStatus, Goal, GoalType or TopVsOther)

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.

  1. 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
  2. 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
  3. 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
  4. 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
  5. 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
  6. 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
  7. Retention, geographic report

    What Microsoft documents
    14 days hourly, 36 months for the other aggregations
    What to do
    Use daily for geography
  8. 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
  9. 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

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.

  1. Get a developer token. A Super Admin requests it in the Microsoft Advertising developer settings, and a universal token works with any user credentials.
  2. Register an app and get an OAuth access token for a user who can reach the accounts.
  3. Call SubmitGenerateReport with a report request object, then poll with PollGenerateReport using the same credentials.
  4. 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.

Prompt: panels 1 to 3 in the Ryze AI chat
For the Microsoft Ads account [account name], read only: change nothing. 1. Spend, conversions and ROAS for the last 7 days vs the 7 before. 2. CTR, average CPC, conversion rate and cost per conversion for the same two periods. 3. A campaign table, highest spend first, with impressions, clicks, spend and conversions. Flag any metric that moved more than [20]% week over week.
Prompt: panel 4, search terms and keywords
For [account name], run a search query report and a keyword report for the last 30 days. Show clicks, spend and conversions, highest spend first. List the [10] search terms with spend and no conversions, and say which campaign each one sits in. Read only.
Prompt: panel 5, competitive position
For [account name], list each campaign with impression share, the share lost to budget and the share lost to rank for the last 30 days. Say which campaigns are limited by budget and which by rank. Read only.

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. 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. 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. 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. 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. 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

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.

Prompt: weekly review
For Microsoft Ads account [account name], summarize last week, Monday to Sunday, vs the week before: spend, CTR, average CPC, conversions and cost per conversion for the account and the top [5] campaigns, then the [10] search terms with the most spend and no conversions. 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.

  1. 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
  2. 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
  3. 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
  4. Reports

    Microsoft Reporting API
    The full report type list, with column-level control
    Ryze AI
    Campaign, keyword, search query, geographic and audience performance reports
  5. Saved fixed layout

    Microsoft Reporting API
    Whatever you build
    Ryze AI
    Prompts in chat; no layout is saved by this method
  6. Acting on findings

    Microsoft Reporting API
    Campaign Management service, a separate API
    Ryze AI
    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.

  1. Own database or a custom chart

    Use
    The Reporting API, with the column names above
  2. A quick look at one account

    Use
    The Microsoft Advertising web app reports
  3. Several accounts or changing questions

    Use
    Ryze AI prompts
  4. Acting on what the numbers show

    Use
    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

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?
14 metrics on 5 panels: spend and results, efficiency, campaigns, search terms and keywords, and competitive position. Core Reporting API columns are Spend, Impressions, Clicks, Ctr, AverageCpc, Conversions, CostPerConversion and ReturnOnAdSpend. Compare the last 7 days with the 7 before.
How do I pull a Bing Ads report through the API?
Call SubmitGenerateReport with a report request object, poll with PollGenerateReport, then download and unzip the file when the status is Success. The report id is valid for 2 days and the download link for 5 minutes.
Which time zone do Bing Ads reports use?
Row data is relative to UTC. The ReportTimeZone element only sets what today means for periods such as Yesterday, and it defaults to Pacific Time (US and Canada) when you leave it out.
Why do my Microsoft Ads conversions differ between reports?
Conversions, ConversionRate, CostPerConversion, Revenue and ReturnOnAdSpend exclude conversion goals with ExcludeFromBidding set to true, while the All versions of those columns include every goal.
Show 7 more questions
Why is impression share empty or late?
Microsoft says the value is empty when the data is not available, that the lost-to-budget and lost-to-rank columns usually update 14 to 18 hours after the UTC day ends, and that Hourly or HourOfDay aggregation returns code 2053.
Can Ryze AI build a Microsoft Ads dashboard?
Yes, as prompts rather than a saved layout. Ryze AI runs Microsoft Advertising performance reports such as campaign, keyword, search query, geographic and audience performance.
Which Ryze AI tools read Microsoft Ads data?
This page uses read tools: microsoft_ads__listAccounts, microsoft_ads__getEntities, microsoft_ads__report, microsoft_ads__adInsight and microsoft_ads__rawCall. The connection has 9 tools in all, including write and delete tools.
Can I use several Microsoft Ads accounts in one chat?
Yes. Ryze AI sees every ad account the connected login can access, and several Microsoft Advertising logins can be connected to one workspace under View > Add one more account. Agent default accounts sets which accounts the agent works with first.
Can the agent change my account while I build a dashboard?
Only if you ask it to and the approval setting allows it. The Ryze AI chat starts on Skip all approvals, so say read only in the prompt, or switch Tool approvals to Approve write & delete.
Does Microsoft have its own MCP server for Microsoft Advertising?
The Microsoft Advertising API pages opened on November 21, 2026 mention none. Check Microsoft's docs for current details.
How much does Ryze AI cost for this?
Paid Ads is $89 a month with a 7-day free trial. Connecting the connector is free; the tools need an active plan or trial.

Related guides

Ryze AI: Microsoft Ads dashboard

7-day free trial, $89 a month flat

Start free trial