Data connector

Send Facebook Ads data to AI, reports, spreadsheets and ETL

Get started for free

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

or sign up with your email

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

Facebook Ads

Advertising and Media

Kondado enables you to replicate comprehensive Facebook Ads data including campaign performance metrics, ad set spend analysis, lead form submissions, and page engagement statistics. Extract detailed advertising information such as impressions, clicks, cost per acquisition, and creative metadata directly through the Facebook Ads API without writing complex code. Access account-level performance data alongside granular post metrics, audience targeting details, and lead form submissions for complete marketing visibility across all your advertising activities and digital campaigns.

Connect Facebook Ads now →

Try out all the features for free for 14 days

Kondado provides 14 distinct pipelines encompassing 1,569 fields from Facebook Ads, covering everything from ad account performance and campaign metadata to lead forms and page metrics.

Marketing teams leverage this Facebook Ads data to optimize ad spend across campaigns and identify high-performing creative assets through detailed performance analytics. Data analysts combine advertising metrics with CRM and sales information to calculate true customer acquisition costs and lifetime value ratios across different audience segments. Operations teams monitor lead form submissions and page engagement to coordinate follow-up workflows and content calendars, ensuring no advertising insight remains trapped inside the platform while enabling data-driven budget allocation decisions and comprehensive Facebook Ads analytics.

The Kondado platform takes care of refreshing Facebook Ads data, allowing you to stop wasting time with manual work and complex workflows, and focus on analyzing Facebook Ads data with AI (Claude, ChatGPT and MCP) or in your report, spreadsheet, data warehouse, data lake, or database

Try out all the features for free for 14 days

Ready-to-use and customizable reports for Facebook Ads

Looker Studio

Google Ads and Meta Ads Looker Studio (now Data Studio) Report

Looker Studio

Meta Ads Looker Studio (now Data Studio) Report

Power BI

Meta Ads Power BI Report

Try out all the features for free for 14 days

Available Facebook Ads Pipelines

The following pipelines deliver specific Facebook Ads data structures to power your analytics workflows. Access Ad Performance pipelines to evaluate creative effectiveness through impressions and click-through rates, or analyze Campaign Performance data to track cost per acquisition across different audience segments. Examine Ad Set Performance metrics to understand budget distribution efficiency, while Lead Forms pipelines capture submission data for conversion tracking. Page Metrics and Post Metrics pipelines provide engagement insights that reveal how organic and paid content performs across your Facebook presence. By merging Campaign Metadata with Ad Performance statistics, you can correlate targeting strategies with actual revenue outcomes, while combining Page data with advertising metrics reveals the full customer journey from discovery to conversion. Configure automated updates on schedules ranging from every five minutes to daily, ensuring your KPI dashboards always reflect current spend efficiency and campaign results without manual data pulls.

Connector schema

Available Facebook Ads data

available pipelines

1569

extractable fields

Available integrations

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.

See all available data → Use this connector in chat (AI + MCP) →

Try out all the features for free for 14 days

How to visualize Facebook Ads data in 3 steps

Connect Facebook Ads to AI (Claude/ChatGPT via MCP), dashboards, spreadsheets, or databases — no code required.

Authenticate with Facebook Login

Connect your Facebook Ads data source using OAuth authentication through Facebook Login, granting Kondado permission to access your specific ad accounts and advertising data.

Select pipelines and destinations

Choose from 14 available Facebook Ads pipelines including Campaign Performance, Ad Performance, and Lead Forms, then send your data to destinations such as Power BI, BigQuery, Google Sheets, or PostgreSQL.

Analyze across dashboards, sheets, and databases

Visualize your Facebook Ads data in Looker Studio or Power BI dashboards, explore metrics in Google Sheets or Excel spreadsheets, and query detailed advertising data in BigQuery, PostgreSQL, MySQL, or Redshift databases for comprehensive cross-channel analysis.

Try out all the features for free for 14 days

Hundreds of data-driven companies trust Kondado

Why Kondado?

Focus on extracting value from your data and leave the rest to us

Wherever you need

With the same platform, you send data to AI (Claude/ChatGPT via MCP), reports, spreadsheets, databases, data warehouses, and data lakes. ETL and ELT

Learn More About Our Platform →

From wherever you need

Data from over 80 sources for Marketing, Ecommerce, ERPs, Customer Service, Finance, Databases, and much more

Learn More About Our Data Sources →

Predictable pricing

No surprise invoices, pick a plan and change it anytime

Check out our plans →

Pick an AI, Spreadsheet, Database, Data Warehouse or Data Lake to use Facebook Ads data

Facebook Ads > AI (Claude, ChatGPT, MCP)

Facebook Ads > Looker Studio

Facebook Ads > Power BI

Other visualizations

Facebook Ads > Amazon S3

Facebook Ads > BigQuery

Facebook Ads > Excel

Facebook Ads > Google Sheets

Facebook Ads > MySQL

Facebook Ads > PostgreSQL

Facebook Ads > Redshift

Facebook Ads > SQL Server

Choose a tool to visualize your Facebook Ads data

If the software you need is not listed, drop us a messagem. You can use almost every tool

Facebook Ads > Airtable

Facebook Ads > Alteryx

Facebook Ads > Amazon Quicksight

Facebook Ads > BIMachine

Facebook Ads > Cortex

Facebook Ads > Data Studio

Facebook Ads > Geckoboard

Facebook Ads > Grafana

Facebook Ads > IBM Cognos Analytics

Facebook Ads > Klipfolio

Facebook Ads > Looker Studio

Facebook Ads > Looker

Facebook Ads > Looqbox

Facebook Ads > Metabase

Facebook Ads > Microstrategy

Facebook Ads > Pentaho

Facebook Ads > Power BI

Facebook Ads > Qlik Cloud Analytics

Facebook Ads > Qlik Sense

Facebook Ads > Qlik

Facebook Ads > QlikView

Facebook Ads > Redash

Facebook Ads > Superset

Facebook Ads > Tableau

Facebook Ads > BI TOTVS

Facebook Ads > Zoho Analytics

Frequently Asked Questions (FAQ)

Find answers to common questions about connecting Facebook Ads to AI (Claude/ChatGPT via MCP), dashboards, spreadsheets, and databases

What specific Facebook Ads data can I extract using Kondado? ▼

You can access 14 specialized pipelines including Ad Performance for creative metrics like impressions and clicks, Campaign Performance for cost per acquisition tracking, and Lead Forms for submission data. Additional pipelines cover Ad Set Performance, Page Metrics, Post Metrics, and comprehensive metadata for campaigns, ad sets, and individual ads, providing over 1,500 distinct fields for analysis.

How do I authenticate and connect Facebook Ads to Kondado? ▼

Connection requires OAuth authentication through Facebook Login, allowing you to authorize data access without complex API key management. Simply select Facebook Ads as your data source, authenticate with your existing Facebook credentials, and grant permissions for the specific ad accounts you want to replicate.

What pre-built dashboards and report templates are available for Facebook Ads analytics? ▼

Kondado offers ready-made report templates including the Google Ads and Meta Ads Looker Studio Report, Meta Ads Looker Studio Report, and Meta Ads Power BI Report for immediate visualization. You can also build custom analyses in Power BI, Looker Studio, or Google Sheets using your replicated data.

How frequently can I update Facebook Ads data in my destination? ▼

Kondado replicates data on a configurable schedule that you control, ranging from every five minutes to daily updates depending on your monitoring needs. This automated approach keeps your reports current without manual exports, operating on a configurable schedule rather than continuous streaming.

Can I send Facebook Ads data to spreadsheets and databases simultaneously? ▼

Yes, you can replicate the same Facebook Ads pipelines to multiple destinations including Google Sheets, Excel, BigQuery, PostgreSQL, MySQL, Redshift, and SQL Server. This flexibility allows marketing teams to work in spreadsheets while analysts access the same data in data warehouses.

What insights can I gain by combining Campaign Metadata with Ad Performance pipelines? ▼

Merging Campaign Metadata containing targeting settings and status information with Ad Performance metrics reveals which audience configurations, bidding strategies, and creative combinations drive the best results. This cross-analysis helps identify underperforming campaigns quickly and optimize budget allocation across different ad sets and creative variations.

Is it possible to track Facebook lead form submissions alongside advertising spend? ▼

Yes, the Lead Forms pipeline captures all submission data including form fields and captured leads, which you can combine with Campaign Performance and Ad Set Performance metrics. This allows you to calculate cost per lead and lead quality scores by connecting submission volumes directly to your advertising spend data.

Related on Kondado

Try out all the features for free for 14 days