MCP & AI reporting

How to Connect Microsoft Ads (Bing Ads) to Claude with MCP

Connect Microsoft Ads to Claude with the Data Bloo MCP and pull impressions, clicks, spend and cost per conversion straight from the chat, no exports, no dashboards. It's read-only, so it's safe, and here's the 2-minute setup.

Free to start Read-only & secure Works in ~2 min
Claude Data Bloo connected
Pull impressions, clicks and spend for my Microsoft Ads account, last 30 days.
query_data · Microsoft Ads ✓
Here's your last 30 days on Microsoft Ads:
Metric
Value
Impressions
842,317
Clicks
24,655
Spend
€11,238
That's a 2.93% CTR at a €0.46 CPC, noticeably cheaper clicks than your Google Ads account. Want a breakdown by network?
Reply to Claude…
The one thing you need

Your Data Bloo MCP URL

Paste this into Claude when you add a custom connector. Then expand Advanced settings and enter 43 in the OAuth Client ID field, leave the Client Secret blank. That's the whole secret; everything below is just where to click.

https://mcp.databloo.com/mcp Copy
Using Claude Code instead? Grab the one-line CLI command →

What connecting Microsoft Ads to Claude actually means

You can ask Claude about your Microsoft Ads, still "Bing Ads" to half the industry, and get a real answer, pulled from your actual account, in seconds. Type "how did my Bing Ads do last month" and Claude reads your numbers and tells you, no CSV export, no dashboard to open. The connection runs through the Data Bloo MCP, takes about two minutes to set up, and it's read-only, so Claude can analyze your campaigns but can never change them.

Microsoft does have its own official MCP server now, announced in June 2026 and rolling out as an open pilot, and it's also read-only. If you live inside Microsoft 365 Copilot and only care about Microsoft data, it's worth a look. Want Claude to read Microsoft Ads next to Google Ads and the rest of your marketing, and feed the same data to your Data Studio dashboards? That's Data Bloo, and that's what the rest of this guide covers.

Why connect Microsoft Ads to Claude

Stop exporting from the Ads UI. Start asking.

The same Microsoft Ads account you already trust for your Data Studio reports, now answering questions in a chat. No exports, no dashboards to open.

Ask, get instant answers

"Which Microsoft Ads campaigns had the highest CTR last week?" Claude pulls the numbers and explains them.

Reports inside the chat

Ask for a 30-day Microsoft Ads view and get tables plus a summary ready to share, no Data Studio setup.

Client-ready summaries

"Turn the last 30 days of Bing Ads into an executive summary." Paste it into Slack, email or a doc.

Diagnose dips fast

"Why did our cost per conversion jump on Tuesday?" Claude looks across campaigns, keywords, devices and dates and explains it.

See it next to Google Ads

Line Microsoft Ads up against Google Ads, Facebook Ads or Bing Webmaster Tools in one answer, one chat.

Connect once, use everywhere

The same Microsoft Ads account you linked for Data Studio is instantly available to Claude, zero duplicate setup.

Supported data sources

Microsoft Ads, plus every other connector

Already connected in Data Bloo? It's instantly available to Claude, connect once, use everywhere.

Pick your route

Three ways to connect Microsoft Ads to Claude

There are three real options, built for different people. Here's the honest version, including the case where the answer isn't us, so you pick the right one the first time.

Recommended for reporting

A connector like Data Bloo

Paste one URL, sign in once, ask in plain English. No pilot waitlist, nothing to host. Read-only, blends Microsoft Ads with Google Ads and every other channel, and the same connection feeds your Data Studio reports.

Microsoft's official MCP

Microsoft announced its own Microsoft Advertising MCP server in June 2026, now rolling out as an open pilot. Read-only like ours, covering campaigns, ad groups, ads and keywords, and it works with Claude, ChatGPT and M365 Copilot. The trade-off: it's Microsoft-only, access is still rolling out, and it won't feed your dashboards.

A manual CSV export

Pull a report from the Microsoft Advertising UI, save the file, upload it to Claude. Free, and it works once. Then you do it again next week, separately for every account.

Data Bloo vs Microsoft's official MCP vs a manual export

Data Bloo
Microsoft MCP
Manual CSV
Setup
~2 min, point & click
Pilot access, gradual rollout
New export each time
Reads your data
Yes
Yes
A snapshot
Changes campaigns
No (read-only)
No (read-only pilot)
No
Blends other channels
Yes
No, Microsoft only
By hand
Feeds Data Studio
Yes, same connection
No
No
Works with other AI
Yes (ChatGPT, Gemini…)
Claude, ChatGPT, Copilot
Any (paste a file)
Price
Free to start
Free pilot
Free
Upkeep
None
Pilot may change under you
Redo it each time

The bottom line: if you only run Microsoft Ads and you're happy inside a pilot, Microsoft's own server is free and first-party. If you want Claude to read Microsoft Ads next to Google Ads and the rest of your marketing, and feed the same data to your dashboards, that's Data Bloo.

The honest bit

When to use Microsoft's official MCP instead

Data Bloo isn't the right tool for everyone, and Microsoft's own server is a genuinely good sign for the platform. Announced in June 2026 and rolling out as an open pilot, the Microsoft Advertising MCP server gives AI assistants read-only access to your campaigns, ad groups, ads and keywords, with the performance metrics you'd expect: spend, clicks, impressions, CTR, average CPC, conversions, revenue and ROAS. At launch it supports the Claude desktop app, the ChatGPT desktop app and Microsoft 365 Copilot via Copilot Studio, and it's free to connect. It's first-party, so its numbers come straight from the source.

If your team already lives inside M365 Copilot, or you want a first-party feed and only care about Microsoft Advertising data, join the pilot, it's the natural fit. The trade-offs are the ones you'd guess. Access is still rolling out, so your account may be waiting a while. It only sees Microsoft, so it can't put Bing Ads next to Google Ads, Facebook Ads or your Bing Webmaster Tools data, which for most search teams is the whole question. And it won't feed the Data Studio dashboards you already send clients. Plenty of teams will end up running both: Microsoft's server inside Copilot, Data Bloo wherever the cross-channel reporting happens.

Before you start

What you need

Three things, and you probably already have them.

A Data Bloo account with Microsoft Ads connected. If you already use Data Bloo for your Data Studio reports, your source is ready, connect once, use everywhere.
A Claude account. Desktop, Web or Claude Code all work, and a free Claude account is enough to start.
Pop-ups allowed for sign-in. Data Bloo's sign-in opens a browser window during setup, so make sure your browser isn't blocking it.
Setup · ~2 minutes

How to connect Microsoft Ads to Claude

Pick your Claude client. Desktop & Web are easiest for most marketers; Claude Code is a one-liner for developers.

Claude Desktop / Web Claude Code (CLI)
1
Open Claude and click the + in the chat

Launch Claude Desktop or claude.ai. In the chat input, click the + icon on the left to open the tools menu.

2
Go to Connectors → Manage connectors

Hover over Connectors, then click Manage connectors to open your connector settings.

3
Click + → Add custom connector

Click the small + at the top of the connector list, then choose Add custom connector.

4
Name your connector "Data Bloo"

Type Data Bloo in the Name field. That's how you'll find it inside any conversation later.

5
Paste the Data Bloo MCP URL

In the Remote MCP server URL field, paste https://mcp.databloo.com/mcp. Then expand Advanced settings and enter 43 in the OAuth Client ID field, leave the Client Secret blank.

6
Click Add and sign in

Claude opens your browser on Data Bloo's sign-in page, sign in and approve so Claude can read your data. You sign in once.

7
Ask about your Microsoft Ads

Start a new chat and try: "Using Data Bloo, pull impressions, clicks and spend for my Microsoft Ads account for the last 30 days." Claude returns a table plus a short analysis.

Step 1, Register the Data Bloo MCP

Open your terminal and run:

terminal
# Register Data Bloo as an HTTP MCP server in Claude Code
claude mcp add --transport http databloo https://mcp.databloo.com/mcp
Step 2, Authenticate with Data Bloo

Next time you start a Claude Code session, Claude opens your browser to sign in to Data Bloo. Sign in once, the connection persists across sessions.

Step 3, Verify

Run /mcp, you should see databloo with status connected.

Confirm it works: in a fresh chat, ask "Using Data Bloo, list all the Microsoft Ads accounts I have connected." If Claude returns your accounts, you're fully connected.

See it in action

Take the MCP for a spin

Walk through connecting Microsoft Ads to Claude and pulling a report, no signup, right here in the page.

Under the hood

Seven read-only tools, why this can't get you banned

You just ask in plain language, Claude picks the right tool. The typical flow: list_data_sources → get_connector_accounts → list_fields → query_data.

Tool
What it does
get_user
Your plan, MCP access, usage limits and remaining calls.
list_data_sources
Every available connector, with its name and description.
get_connector_accounts
Your linked Microsoft Ads accounts, and the IDs to query.
list_fields
The valid metrics and dimensions for Microsoft Ads.
query_data
The actual pull: metrics and dimensions over a date range.
list_accounts
Every connected account across every connector, in one call.
get_dates
Turns "last month" into the exact start and end dates to query.

Read-only, always. Claude can pull and analyze your Microsoft Ads, it can never pause a campaign, change a bid, edit a keyword or touch a budget. Nothing Microsoft could ever flag.

Why Data Bloo

Read-only safety and your dashboards, in one connection

Microsoft Ads rarely runs alone, it almost always runs next to Google Ads. Data Bloo reads both, and everything else you've connected, and the exact same connection already powering your Data Studio dashboards now answers questions in Claude.

It can't touch your account

All seven tools are read-only. Claude pulls and analyzes your Microsoft Ads, but it can't pause a campaign, change a bid or edit a keyword, so there's no wrong instruction that could put your account at risk. No safety checklist to memorize, because there's nothing to switch off.

One connection, two surfaces

The Microsoft Ads source you built for Data Studio is the same one Claude reads. No second setup, no second bill, and the numbers Claude quotes always match the dashboards you send clients. It's the one thing a Microsoft-only pilot structurally can't give you.

The data

What Microsoft Ads data you can pull

The same metrics you use in your reports, sliced by campaign, ad group, keyword, ad, device, network, location and date.

Delivery & cost

Impressions, clicks, spend, CTR, average CPC and CPM.

Conversions & value

Conversions, conversion rate and cost per conversion, plus revenue, so ROAS comes through when your account tracks it.

Breakdowns

Campaign, ad group, keyword, ad, device, network, location and date.

Google Ads, side by side

Most Microsoft Ads accounts mirror a Google Ads account. Connect both in Data Bloo and ask Claude for one blended answer, spend, conversions and cost per conversion, engine by engine.

Real answers

What Claude actually gives you back

Three real prompts and the kind of answer Claude returns once Microsoft Ads is connected through Data Bloo, numbers, then a plain-language read.

"Pull impressions, clicks and spend for my Microsoft Ads account, last 30 days."

Claude: Last 30 days on Microsoft Ads, 842,317 impressions, 24,655 clicks and €11,238 spent. That's a 2.93% CTR at €0.46 CPC, up 5% on the prior period.

The read: healthy search CTR at a low CPC, the account is buying cheap, relevant clicks, worth scaling the winners.
"Which keywords had the best and worst cost per conversion in the last 30 days?"

Claude: Best, crm software demo at €14.20 per conversion (86 conversions). Worst, business software at €68.40 (9 conversions). The broad head term spends nearly as much as your top three converters combined.

The read: tighten the match type on the head term or add negatives, and move the freed budget to the demo keywords.
"Compare Microsoft Ads and Google Ads for last month: spend, conversions and cost per conversion."

Claude: Google Ads, €28,540 spend, 1,112 conversions, €25.67 per conversion. Microsoft Ads, €11,238 spend, 517 conversions, €21.74 per conversion.

The read: Bing converts about 15% cheaper this month, worth shifting incremental budget while the gap holds.

Example outputs shown for illustration; your figures come live from your own connected account.

Data Bloo MCP

Not just charts. Finished, branded deliverables

Plug your live Microsoft Ads data into Claude, ChatGPT or Gemini through our MCP, and generate branded presentations, audits and executive reports straight from a chat prompt.

Client presentations

Slide-ready decks with your logo, colors and commentary, built from live data, ready to send.

92
!

Audits

Automated account audits that flag issues, wins and opportunities, with clear next steps.

REV
€84K
ROAS
4.2×
CVR
2.4%

Executive reports

Concise, narrative summaries for leadership, the numbers that matter, explained in plain language.

Try it

Prompts to paste into Claude

Once connected, drop any of these into a fresh chat. Name Data Bloo in your first message, then drill in.

Discovery
"Using Data Bloo, list all the Microsoft Ads accounts I have connected."
"What fields and date ranges can I pull for my Microsoft Ads account?"
Pulling data
"Pull impressions, clicks and spend for my Microsoft Ads account, last 30 days."
"Show me spend, conversions and cost per conversion by campaign for last month."
Breakdowns
"Break down last month's Microsoft Ads spend by device and network."
"Show Microsoft Ads performance by location for the last 30 days, top 10 markets."
Reporting & analysis
"Write a client-ready summary of my Microsoft Ads for October, with three takeaways."
"Compare this month's cost per conversion to last month's and tell me what changed."
Keywords
"Rank my Microsoft Ads keywords by conversions for the last 30 days, with CPC next to each."
"Which keywords have a CTR above 5% but fewer than 100 impressions a week?"
Find wasted spend
"Which campaigns spent the most last month but drove the fewest conversions?"
"Flag any ad group with spend over €500 and cost per conversion above my account average."
Cross-channel
"Compare Microsoft Ads and Google Ads side by side for last month: spend, conversions, cost per conversion."
"Line up Microsoft Ads spend against Facebook Ads and my Bing Webmaster Tools clicks for the last 30 days."
Account health
"Summarize the health of my Microsoft Ads account this month versus last."
"What changed most week over week, spend, CTR or cost per conversion?"
Who it's for

Built for how you actually work

Same connection, different job to be done. Here's the prompt each type of marketer tends to start with.

Agencies

Microsoft Ads is often the account nobody checks daily. Pull and compare across every client without switching logins, then draft the monthly report in the chat.

"Compare CTR and cost per conversion across all my connected Microsoft Ads accounts this month."

PPC & performance teams

Watch Bing next to Google without a second dashboard, catch the keyword that's quietly cheaper on one engine, and move budget with numbers behind you.

"Which of my top 20 Google Ads keywords also run on Microsoft Ads, and which engine converts cheaper?"

Lead gen & B2B

Bing's audience skews older, professional and desktop-heavy, often a cheaper lead than Google. Watch conversions and cost per lead by campaign, and catch a rising CPA early.

"Break down conversions and cost per conversion by campaign for last month, worst to best."
Troubleshooting

Common issues and fixes

Claude says it can't see your accounts

You're likely not signed in yet, or Microsoft Ads isn't connected in Data Bloo. Ask "Using Data Bloo, list the accounts I have connected." If it comes back empty, open Data Bloo, confirm your Microsoft Ads source is connected, then try again.

The numbers don't match the Microsoft Advertising UI exactly

Small gaps are normal. Conversion windows differ, your account's time zone shifts which day a click lands in, and Microsoft keeps restating recent conversions for days as they trickle in. For trends, comparisons and reporting the Data Bloo pull is solid; for the last few hours of a live campaign, the native UI is freshest.

Clicks look cheap but don't convert

Check the network breakdown. Microsoft Ads serves across Bing, its syndicated search partners and the Microsoft Audience Network, and partner traffic often has a great CPC and a poor conversion rate. Ask Claude to split performance by network, then decide what the cheap clicks are actually worth.

Claude won't take an action on your campaigns

That's on purpose. The connection is read-only. If you need to edit campaigns from a chat, that's a different class of tool, and Microsoft's own MCP pilot is read-only too, so today the edits happen in the Microsoft Advertising UI.

Good to know

Query notes & FAQs

One breakdown dimension per call. For multiple breakdowns, ask Claude to run separate queries and combine them after.
Confirm fields first. Field IDs vary per connector. Claude usually lists fields before querying to avoid rejected requests.
!ROAS may be empty. If an account doesn't pass revenue values, ROAS is omitted rather than shown as a misleading zero.
Numbers vs the native UI. Small gaps are normal, conversion windows, time zones and Microsoft's ongoing restating of recent data.
How do I connect Microsoft Ads (Bing Ads) to Claude?+

Add a custom connector in Claude, name it Data Bloo, and paste the MCP URL https://mcp.databloo.com/mcp. Sign in once, then ask Claude about your Microsoft Ads in plain language.

Is Bing Ads the same as Microsoft Ads?+

Yes. Bing Ads was renamed Microsoft Advertising in 2019, and most marketers still use both names. It's the same platform, the same accounts and the same data, whichever name you search for.

Is there an official Microsoft Ads MCP server?+

Yes. Microsoft announced its Microsoft Advertising MCP server in June 2026, currently rolling out as a read-only open pilot that works with Claude, ChatGPT and M365 Copilot. It only sees Microsoft data, though, so it can't blend Bing Ads with Google Ads or feed your Data Studio dashboards, that's where Data Bloo fits.

Does Claude change anything in my Microsoft Advertising account?+

No. All seven MCP tools are strictly read-only. Claude can pull and analyze your data but can never edit campaigns, bids, keywords or budgets. Any change to your account still happens in the Microsoft Advertising UI, by you.

Is it safe to connect Microsoft Ads to Claude?+

Yes. You sign in once through Data Bloo's secure OAuth flow, and the connection is strictly read-only. Claude can pull and analyze your Microsoft Ads but can never pause a campaign, change a bid or take any action Microsoft could flag.

Can I blend Microsoft Ads with Google Ads?+

Yes, and it's the most common ask. Connect both in Data Bloo and Claude can put spend, conversions and cost per conversion side by side, engine by engine, in one answer. The same goes for Facebook Ads, Search Console or Bing Webmaster Tools.

Which AI tools does the MCP work with?+

Any MCP-compatible client, Claude Desktop, Web and Code, plus ChatGPT, Gemini and Cursor. The same URL works across all of them.

Do I need a paid Claude plan?+

No. A free Claude account is enough to add the Data Bloo connector and start pulling Microsoft Ads reports. Your Claude plan is separate from Data Bloo, and the connector works on Claude Desktop, Web and Code.

How current is the data Claude sees?+

Claude queries your data live through Data Bloo's connectors the moment you ask, subject to each platform's API freshness and your plan's refresh limits. Keep in mind Microsoft restates recent conversions for a few days.

Can I use it across multiple client accounts?+

Yes. Ask Claude to list your connected Microsoft Ads accounts, and it can pull and compare across them, handy for agencies running multiple clients.

Can I automate recurring Microsoft Ads reports?+

Yes. Pair the MCP with Claude's scheduled tasks or Claude Code for an automatic Monday-morning KPI digest, anomaly alerts or a recurring client update, unattended.

Simple, transparent pricing

Scale your reporting without limits

Every plan includes all data sources. Start free, upgrade only when your dashboards demand it.

MonthlyAnnually−17%
FREE
$0/ forever

Best for individuals or early-stage teams starting with marketing data.

Create free account
Destinations included
& more
1 account per connector300 daily refreshes (API calls)All data sources includedData Bloo MCP
STARTER
$8.33/mo
billed annually · save $20/yr

For individuals who need unlimited refreshes with a single account.

Choose Starter
Destinations included
& more
1 account per connectorUnlimited daily refreshesAll data sources includedData Bloo MCPEmail support
Most popularPRO
$16.66/mo
billed annually · save $40/yr

For freelancers & growing teams that need more accounts and volume.

Choose Pro
Destinations included
& more
Up to 5 accounts per connectorUnlimited daily refreshesAll data sources includedData Bloo MCPEmail support
AGENCY
$33.33/mo
billed annually · save $80/yr

For agencies managing multi-client reporting at scale.

Choose Agency
Destinations included
& more
Unlimited accounts per connectorUnlimited daily refreshesAll data sources includedData Bloo MCPPriority email & chat support

No credit card required to start · Cancel anytime · See plan FAQs →

Chat with your Microsoft Ads today

Connect Microsoft Ads to Claude in under 2 minutes and pull reports straight from the chat. Free to start, no credit card.