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.

Send Facebook Ads data to 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

Connect Facebook Ads Data to Your Analytics Stack

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.

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 in your report, spreadsheet, data warehouse, data lake, or database

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

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.

Try out all the features for free for 14 days

Available Facebook Ads data

available pipelines

1569

extractable fields

Available integrations

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

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 →

Try out all the features for free for 14 days

How to visualize Facebook Ads data in 3 steps

Connect Facebook Ads to 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