Chat with your Facebook Ads data

AI to analyze Facebook Ads 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

Facebook Ads
You
What was my total Facebook Ads spend yesterday across all accounts?
Facebook Ads
Your Facebook Ads accounts spent a total of R$ 12.450,00 yesterday, with the highest spend coming from the Summer Sale campaign.
Via Kondado MCP
You
Which ad set had the best CTR this month compared to last month?
Ad Performance
The "Lookalike 1%" ad set achieved a +18% CTR improvement compared to the previous month, reaching 3.42% overall.
Via Kondado MCP
You
What are my top 3 campaigns by lead form submissions this week?
Lead Forms
Your top campaigns generated 847, 623, and 412 leads respectively, with the Education Webinar campaign leading submissions.
Via Kondado MCP
You
How many active campaigns do I currently have running?
Campaign Status
You currently have 14 active campaigns running across 3 ad accounts, with 2 campaigns ending budget today.
Via Kondado MCP
Works in Claude, ChatGPT and any MCP client

AI to analyze Facebook Ads data with Claude and ChatGPT

Ask Claude, ChatGPT, or any other MCP client about your Facebook Ads performance using everyday language. Marketing teams can instantly query total spend across all ad accounts, compare click-through rates between active campaigns, or verify lead form capture volumes without touching a database. The AI accesses your replicated Facebook Ads pipelines and returns precise answers about ROAS trends, audience engagement patterns, and cost-per-acquisition fluctuations across any time period.

Kondado replicates Facebook Ads data through 14 pipelines comprising 1,569 fields, serving them via MCP server to Claude, ChatGPT, and other compatible clients. This setup enables natural language analysis of advertising metrics while the same replicated data simultaneously supports ready dashboards in Power BI and Looker Studio.

E-commerce managers monitor daily budget efficiency by asking which campaigns delivered the highest conversion value yesterday, while marketing analysts benchmark CPM performance across regional ad sets to optimize targeting strategies. Finance teams reconcile advertising invoices against actual campaign costs by querying account-level spend summaries, and operations specialists track lead form status to coordinate sales follow-ups. Every stakeholder accesses these insights through simple chat conversations, transforming complex advertising metrics into immediate business decisions without technical training.

I prefer ready dashboards

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

View Facebook Ads dashboards →

I want to ask the AI

Claude, ChatGPT and other MCP clients query your Facebook Ads data in natural language.

View MCP setup →

Connect the specific Facebook Ads pipelines below to unlock detailed advertising intelligence through conversational AI. Query the Campaign Performance pipeline to analyze impression volumes and cost-per-acquisition trends across your active initiatives, or examine Ad Set Performance to compare click-through rates and total spend between different audience segments. The Ad Performance and Post Metrics pipelines reveal which individual creatives drive the highest engagement, while Page Metrics offers insights into organic versus paid reach patterns. Combine data from Lead Forms with Campaign Metadata to trace which advertising initiatives generate the most qualified prospects, or cross-reference Ad Account Performance with Ad Metadata to audit spend distribution across your entire portfolio. These pipelines refresh on a configurable schedule, ensuring Claude and ChatGPT always reference current campaign statistics and recent engagement data when answering your business questions.

How to connect Facebook Ads 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

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

14
Tables
1569
Fields
∞
Ad-hoc questions
Ad account performance
Analyze account performance with metrics such as total spend, account status, and age of the account.
Ad accounts
View information on ad accounts, including name, account ID, and account status.
Ad metadata
Explore ad details such as ad ID, account ID, and ad set name.
Ad performance
Evaluate ad performance with metrics such as impressions, clicks, and cost per click.
Ad preview
Preview ads including creative content and targeting settings.
Ad set performance
Analyze ad set performance with metrics such as impressions, clicks, and total cost.
Adset metadata
Examine ad set metadata including ID, name, and status.
Campaign metadata
View campaign metadata such as campaign ID, name, and status.
Campaign performance
Analyze campaign performance with metrics such as impressions, clicks, and cost per acquisition.
Lead forms
Examine lead forms including fields, status, and captured data.
Page Metrics
Analyze impressions, clicks, and engagement of the page, including fields like page name, business city, and account status.
Page: Posts
Examine post performance with metrics such as impressions, clicks, post ID, and ad set name.
Pages
Provides information about pages, including business name, address, and account status, allowing an overview of operations.
Post Metrics
Evaluate post performance with metrics such as clicks, impressions, and cost, along with ad ID and ad set ID.
Full docs on the wiki → Connect Facebook Ads now →

How to connect and use AI with your data

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

1
Connect Facebook Ads at Kondado

Visit app.kondado.com.br to connect your Facebook Ads data source and select a Via Kondado destination, which prepares your advertising data for both AI chat access and the dashboard templates.

2
Add Kondado MCP in Claude or ChatGPT

Open Claude Web or Desktop, or ChatGPT, and add the Kondado MCP server in the connection settings. Authorize once via OAuth at app.kondado.com.br to enable immediate data access without any CLI commands or JSON configuration.

3
Chat about data or open dashboards

Ask questions in natural language about your Facebook Ads campaigns, metrics, and performance. For ongoing visual monitoring, open the ready Power BI or Looker Studio dashboard templates powered by the same data.

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
Google Play Store Google Play Store
Instagram Ads Instagram Ads
Meta Ads Meta Ads
Microsoft Ads Microsoft Ads
Microsoft Advertising Microsoft Advertising
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 I ask Claude or ChatGPT about my Facebook Ads data? ▼
You can ask about campaign ROI comparisons, ad set spend efficiency, lead form conversion rates, and page engagement trends. The AI analyzes your replicated data to answer questions like which campaigns generated the most clicks last week or how your current CPM compares to the previous month.
How do I configure Claude Web or Desktop to access my Facebook Ads data through Kondado? ▼
Open Claude Web or Claude Desktop and navigate to the connection settings to add the Kondado MCP server. Authorize once via OAuth at app.kondado.com.br to grant read access to your Facebook Ads pipelines, enabling immediate chat analysis without any code or command line setup.
How does authentication work when connecting ChatGPT to my Facebook Ads data? ▼
When adding the Kondado MCP server in ChatGPT, you will be redirected to app.kondado.com.br to complete OAuth authorization.
Can the AI execute actions on my Facebook Ads account or modify campaigns? ▼
No, the AI provides read-only analytical chat capabilities. It can analyze campaign performance, calculate ROAS, and compare metrics across ad accounts, but it cannot create ads, modify budgets, publish posts, or execute any actions within your Facebook Ads account.
How often does the Facebook Ads data update for AI queries? ▼
Facebook Ads data updates on a configurable schedule that you set in Kondado, ensuring the AI references fresh campaign statistics and recent engagement metrics. This automated refresh keeps your chat answers current without manual data exports.
What dashboard templates are available for visual monitoring of Facebook Ads? ▼
Kondado offers ready report templates in Power BI and Looker Studio that visualize Facebook Ads performance through pre-built charts and graphs. These templates use the same replicated data as the AI chat, providing visual monitoring for recurring dashboard reviews.
What is the difference between asking the AI in chat and opening a ready dashboard? ▼
AI chat enables spontaneous, natural language exploration of specific questions about your Facebook Ads data, ideal for ad-hoc analysis and quick insights. Ready dashboards provide structured visual templates in Power BI or Looker Studio for recurring monitoring and standardized reporting.
Can I use other MCP clients besides Claude and ChatGPT to analyze Facebook Ads data? ▼
Yes, any MCP-compatible client can connect to Kondado to analyze Facebook Ads data. While Claude and ChatGPT are the primary supported interfaces, other MCP clients also work with the same OAuth configuration and pipeline access.

Try out all the features for free for 14 days