Chat with your Microsoft Advertising data

AI to analyze Microsoft Advertising data with Claude and ChatGPT

Get started for free

No credit card required | 14 days | 10 million records | 30 pipelines

sso google logo
Sign up with Google
sso facebook logo
Sign up with Facebook
sso microsoft logo
Sign up with Microsoft
sso linkedin logo
Sign up with Linkedin

or sign up with your email

By signing up, you agree to Kondado’s Terms of service and Privacy policy

Microsoft Advertising
You
What was my total Microsoft Advertising spend last month?
Microsoft Advertising
Your Microsoft Advertising spend last month totaled R$ 47.850, representing a 12% increase compared to the previous period.
Via Kondado MCP
You
Which device type has the highest conversion rate?
Device Performance
Desktop traffic shows the strongest performance with a 4.8% conversion rate, significantly higher than mobile at 2.1%.
Via Kondado MCP
You
How does my current ROAS compare to last quarter?
ROAS Metrics
Your current return on ad spend is 3.42x, improving from 2.98x last quarter due to better keyword targeting.
Via Kondado MCP
You
What is my average cost per acquisition this week?
Acquisition Costs
The average cost per acquisition across Microsoft channels this week is R$ 125, down 8% from the previous week.
Via Kondado MCP
Works in Claude, ChatGPT and any MCP client

AI to analyze Microsoft Advertising data with Claude and ChatGPT

Connect Microsoft Advertising to Kondado and start asking Claude or ChatGPT about your campaign performance in natural language. Query your cost per acquisition trends across Bing and partner networks, compare conversion rates between audience segments, or check daily spend against monthly budgets. The AI accesses your replicated data instantly and returns specific metrics without you writing a single line of code.

Kondado provides a pipeline that replicates Microsoft Advertising data to a structured destination, making it accessible via the MCP standard to Claude, ChatGPT, and compatible clients through 1 customizable report with 6 configurable fields. The same replicated data also fuels ready report templates in Power BI and Looker Studio for teams that prefer visual dashboards.

Marketing analysts use this to track ROAS fluctuations and identify underperforming keywords without SQL knowledge. E-commerce managers reconcile advertising costs with revenue attribution from Microsoft channels. Finance operations teams audit spend distribution and budget pacing across campaigns. Each stakeholder simply describes what they need to know, and the AI retrieves the precise figures from your Microsoft Advertising pipelines.

I prefer ready dashboards

Dashboard templates in Power BI and Looker Studio, connected to your Microsoft Advertising data by Kondado in minutes.

View Microsoft Advertising dashboards →

I want to ask the AI

Claude, ChatGPT and other MCP clients query your Microsoft Advertising data in natural language.

View MCP setup →

The pipelines below deliver Microsoft Advertising metrics structured for natural language analysis. The Relatório customizado pipeline captures your fully configurable dimensions and metrics, unlocking insights when you ask about click-through rates segmented by device type, impression share trends against competitors, cost per conversion across different audience segments, or geographic spend distribution by region. You can compare conversion volumes between ad groups, track quality score averages over time, analyze budget pacing across multiple campaigns, or examine device performance splits. Since this single customizable report consolidates your chosen fields into one accessible structure, you can cross-analyze multiple dimensions within the same chat session without switching contexts. Scheduled updates run on a configurable frequency, ensuring your AI conversations always reference the latest campaign performance data.

How to connect Microsoft Advertising to Claude, ChatGPT and other AI clients

MCP is an open standard. Add the Kondado server to the connections of Claude (Web or Desktop), ChatGPT, or any other MCP client you use, and authorize via OAuth at app.kondado.com.br. Setup through the UI, no code.

Kondado MCP server: https://mcp.kondado.io/mcp
Detailed guide: Claude Detailed guide: ChatGPT
AI vocabulary

Microsoft Advertising tables and metrics available via Kondado

Each item below is something Claude, ChatGPT or another MCP client already knows how to query — no schema setup, no manual mapping.

1
Table
6
Fields
∞
Ad-hoc questions
Relatório customizado
Fully customizable report with dimensions and metrics defined by you
Full docs on the wiki → Connect Microsoft Advertising now →

How to connect and use AI with your data

In 3 steps: connect on Kondado, pick dashboard or chat, analyze.

1
Connect Microsoft Advertising at app.kondado.com.br

Select Microsoft Advertising as your data source in Kondado, choose a 'Via Kondado' destination, and configure your Relatório customizado pipeline. Your advertising data lands ready for immediate AI access and for the Power BI or Looker Studio report templates.

2
Add Kondado MCP server in Claude or ChatGPT

Open the connection settings in Claude Web or Desktop, or in ChatGPT, and add the Kondado MCP server URL. Authorize once via OAuth at app.kondado.com.br to grant secure read access, using the same simple GUI process in both clients with no CLI commands required.

3
Ask questions in chat or open report templates

Start chatting with natural language questions about your Microsoft Advertising performance, ROAS, or campaign costs. For recurring visual monitoring, open a ready Power BI or Looker Studio report template.

Other connectors with AI via MCP

Same Kondado data, in chat through Claude, ChatGPT and other MCP clients.

CRM and Sales

ActiveCampaign ActiveCampaign
Bitrix24 CRM Bitrix24 CRM
Exact Sales Exact Sales
Hubspot Hubspot
Infusionsoft (Keap) Infusionsoft (Keap)
Meetime Meetime
NectarCRM NectarCRM
Pipedrive Pipedrive
PipeRun PipeRun
Ploomes Ploomes
RDStation CRM RDStation CRM
Salesforce Salesforce

Marketing and Automation

Google Ads Google Ads
E-goi E-goi
Google Search Console Google Search Console
Hi Platform Hi Platform
Huggy Huggy
Linkedin Linkedin
MailChimp MailChimp
Mandrill Mandrill
Mautic Mautic
Pushwoosh Pushwoosh
RDStation RDStation
Salesforce Marketing Cloud (Exact Target) Salesforce Marketing Cloud (Exact Target)
SenseData SenseData
Taboola Taboola
Twilio Twilio
WordPress WordPress

Advertising and Media

Apple App Store Apple App Store
Bing Bing
Criteo Criteo
Facebook Facebook
Facebook Ads Facebook Ads
Google Play Store Google Play Store
Instagram Ads Instagram Ads
Meta Ads Meta Ads
Microsoft Ads Microsoft Ads
Pinterest Ads Pinterest Ads
TikTok Ads TikTok Ads
X Ads X Ads
YouTube YouTube

E-commerce and Marketplaces

Bling! Bling!
Hotmart Hotmart
Loja Integrada Loja Integrada
Mercado Libre Mercado Libre
Nuvemshop (Tiendanube) Nuvemshop (Tiendanube)
Olist Tiny Olist Tiny
Omie Omie
Pagar.me Pagar.me
Shopify Shopify
Tiny ERP Tiny ERP
Tray Tray
VNDA VNDA
VTEX VTEX
Wake Commerce Wake Commerce

Financial and Payments

ASAAS ASAAS
ContaAzul ContaAzul
Fatura Simples Fatura Simples
Granatum Granatum
Superlogica Superlogica
Sympla Sympla

Support and Customer Service

55pbx 55pbx
api4com api4com
Blip (take) Blip (take)
Clockify Clockify
EADBOX EADBOX
Freshdesk Freshdesk
Movidesk Movidesk
Recruiterbox Recruiterbox
Stilingue Stilingue
Wootric Wootric
Zendesk Zendesk
Zendesk Chat (Zopim) Zendesk Chat (Zopim)

Databases

AWS CloudWatch Metrics AWS CloudWatch Metrics
Azure Table Storage Azure Table Storage
BigQuery BigQuery
InfluxDB v1 InfluxDB v1
MongoDB MongoDB
MySQL (& MariaDB) MySQL (& MariaDB)
Oracle Oracle
PostgreSQL PostgreSQL
SQLServer SQLServer
Webhook Webhook

Productivity and Collaboration

ClickUp ClickUp
Google Sheets Google Sheets
Jira Jira
monday.com monday.com
Notion Notion
Pipefy Pipefy
Tangerino Tangerino
Toggl Toggl
Trello Trello

Social Media

Instagram Instagram
TikTok Organic TikTok Organic

User Analytics

Google Analytics GA4 Google Analytics GA4
Mixpanel Mixpanel
Zeeng Zeeng

Storage and Transfer

Amazon S3 Amazon S3
FTP FTP
Google Cloud Storage Google Cloud Storage
See all AI connectors →

Related on Kondado

Frequently asked questions about AI

How ready dashboards and chat via Claude / ChatGPT work together with your data via Kondado.

What business questions can Claude or ChatGPT answer about my Microsoft Advertising campaigns? ▼
They can answer questions about ROAS trends, cost per click variations, conversion rate comparisons between ad groups, budget pacing against monthly limits, and geographic performance distribution. The AI reads your replicated Relatório customizado data and calculates specific metrics on demand based on your natural language questions.
How do I configure Claude or ChatGPT to access my Microsoft Advertising data through Kondado? ▼
In Claude Web or Desktop, or directly in the ChatGPT interface, navigate to the connection settings and add the Kondado MCP server. You will authorize access once via OAuth at app.kondado.com.br, granting the AI read access to your replicated pipelines. This GUI-based setup requires no command line tools or JSON configuration files.
Can the AI execute actions on my Microsoft Advertising account or modify campaigns? ▼
No, the connection provides read-only analytical access. Claude, ChatGPT, and other MCP clients can only query and analyze your existing data to answer questions about performance, costs, and conversions. They cannot create ads, adjust bids, pause campaigns, or write any data back to Microsoft Advertising.
How frequently does the Microsoft Advertising data update for AI queries? ▼
Data replicates on a configurable schedule that you set in Kondado, which can range from hourly to daily depending on your reporting needs. This ensures the AI references near-real-time campaign metrics without manual exports, keeping your analysis current with the latest advertising performance.
What report templates are available for Microsoft Advertising data? ▼
Kondado offers ready report templates in Power BI and Looker Studio that visualize the same Microsoft Advertising data used by the AI chat. These templates provide pre-built charts for spend analysis, conversion tracking, and campaign comparison, complementing the conversational analysis with visual monitoring.
What is the difference between asking the AI in chat and opening a ready report? ▼
Chat allows you to ask specific, spontaneous questions in natural language and receive precise numerical answers or summaries tailored to your immediate need. Ready reports in Power BI or Looker Studio provide fixed visual layouts for recurring monitoring of standard KPIs without typing queries.
Can I use other AI assistants besides Claude and ChatGPT with this data? ▼
Yes, any MCP-compatible client can connect to the Kondado server to analyze your Microsoft Advertising data. While Claude and ChatGPT are the most popular interfaces, other MCP clients work equally well for querying your replicated pipelines through the same OAuth authorization process.

Try out all the features for free for 14 days