Connect Facebook to Metabase: Dashboards in Minutes

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
Metabase

Visualize Facebook Data in Metabase with Kondado

Kondado makes it simple to visualize your Facebook advertising and page data directly in Metabase without any technical setup or intermediate databases. You can replicate data from your ad accounts, campaigns, and posts on a configurable schedule, keeping your marketing dashboards always current with fresh insights. Simply connect Facebook as your data source, select Metabase as your destination, and start building charts that help you optimize ad spend within minutes.

Kondado offers a direct connection between Facebook and Metabase that delivers 14 ready-to-use pipelines with 1,569 fields, enabling marketing teams to track campaign performance and audience engagement without writing code or managing complex infrastructure.

This connection helps marketing teams and agencies monitor advertising metrics, analyze lead generation forms, and optimize social media strategies through intuitive visualizations. Whether you need to track cost per click across multiple ad sets or measure page engagement trends over time, you get actionable insights that drive better budget decisions and improved marketing ROI without technical complexity.

Our prices start from $19 USD/month, and you can try Kondado for free for 14 days with no credit card required

With Kondado’s Facebook connection, you can unlock deep insights into your marketing performance by analyzing data from pipelines such as Ad Performance, Campaign Performance, and Page Metrics. These datasets allow you to build comprehensive dashboards that reveal which campaigns generate the most qualified leads, how your ad spend translates into clicks and conversions, and which posts drive the highest audience engagement across your social presence.

By combining Ad Account Performance data with Post Metrics in Metabase, marketing teams can correlate paid advertising results with organic content performance to optimize overall strategy. This connection enables you to identify top-performing creative assets, adjust budget allocation between campaigns as performance trends emerge based on cost per acquisition data, and share unified marketing reports with stakeholders who need clear visibility into social media ROI.

Try out all the features for free for 14 days

Facebook data available in Metabase

14
available pipelines
1569
extractable fields

Available integrations

Integration Description
Ad account performance Performance analysis includes fields such as total spend, account status, and account age.
Ad accounts Information on ad accounts, including name, account ID, and currency used.
Ad metadata Details of ads, such as ad ID, account ID, and ad set name.
Ad performance Performance metrics include impressions, clicks, cost, and click-through rate (CTR).
Ad preview Preview of ads based on metadata and creative settings.
Ad set performance Analysis of ad set performance, including impressions, clicks, and cost.
Adset metadata Information about the ad set, such as ID and ad set name.
Campaign metadata Campaign data, including campaign ID and name.
Campaign performance Campaign performance metrics, such as impressions, clicks, and total cost.
Lead forms Data on lead forms, including form ID and status.
Page Metrics Analyze impressions, reach, and engagement, including metrics such as likes, comments, and shares.
Page: Posts Examine post performance, with data on impressions, clicks, and engagement per post.
Pages View general information about pages, including name, ID, and engagement data.
Post Metrics Evaluate detailed post metrics, such as reach, clicks, and cost per engagement.
Ad account performance
Performance analysis includes fields such as total spend, account status, and account age.
Ad accounts
Information on ad accounts, including name, account ID, and currency used.
Ad metadata
Details of ads, such as ad ID, account ID, and ad set name.
Ad performance
Performance metrics include impressions, clicks, cost, and click-through rate (CTR).
Ad preview
Preview of ads based on metadata and creative settings.
Ad set performance
Analysis of ad set performance, including impressions, clicks, and cost.
Adset metadata
Information about the ad set, such as ID and ad set name.
Campaign metadata
Campaign data, including campaign ID and name.
Campaign performance
Campaign performance metrics, such as impressions, clicks, and total cost.
Lead forms
Data on lead forms, including form ID and status.
Page Metrics
Analyze impressions, reach, and engagement, including metrics such as likes, comments, and shares.
Page: Posts
Examine post performance, with data on impressions, clicks, and engagement per post.
Pages
View general information about pages, including name, ID, and engagement data.
Post Metrics
Evaluate detailed post metrics, such as reach, clicks, and cost per engagement.

Try out all the features for free for 14 days

How to create Facebook dashboards in Metabase

Visualize your data automatically — no spreadsheet exports or custom scripts.

1
Connect Facebook as your data source

Log into Kondado and add Facebook as a new data source, then authenticate with your Meta Business account to grant access to your ad accounts and pages. Choose from 14 available pipelines including Ad Performance, Campaign Metadata, and Page Metrics to define which marketing data you want to replicate.

2
Select Metabase as your destination

Choose Metabase from the destination options and configure your connection settings to establish a direct link with no intermediate databases required. This creates a seamless pathway for your Facebook advertising and engagement data to flow into your existing Metabase workspace.

3
Build dashboards and configure data refresh

Launch Metabase to create visualizations using your replicated Facebook data, then set your preferred update frequency from every 5 minutes to daily to keep reports current automatically. Your marketing team can now explore campaign performance, lead generation, and audience insights through interactive charts without manual data exports.

Access Facebook data in Metabase and combine it with dozens of other data sources

If the source you want is not listed, drop us a chat message. We love to add new sources!

Visualize Facebook data in other BI tools

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

Hundreds of data-driven companies trust Kondado
arezzo
brf
Contabilizei
dpz
Experian
grupo_soma
inpress
multilaser
olist
unimed
v4_company
yooper

Frequently Asked Questions (FAQ)

Answers about visualizing Facebook data in Metabase automatically

How do I connect Facebook to Metabase using Kondado?
Start by adding Facebook as a data source in your Kondado account and authenticate with your Meta Business credentials. Then choose Metabase as your destination and select the specific pipelines you need, such as Ad Performance or Page Metrics. Your data begins replicating immediately on your chosen schedule, with no intermediate databases or complex configuration required.
What Facebook marketing KPIs should I track in Metabase?
Focus on metrics that directly impact your return on ad spend, including click-through rates from the Ad Performance pipeline, cost per lead from Lead Forms data, and engagement rates from Post Metrics. You can also monitor account-level spend trends and campaign reach to optimize budget allocation across different audience segments and creative formats.
How often does Facebook data update in Metabase?
Kondado updates your Facebook data on a configurable schedule that you control, with options ranging from every 5 minutes to daily intervals. This flexibility allows you to balance fresh insights with API usage, ensuring your Metabase dashboards reflect recent campaign performance without manual refreshes.
Can I share Facebook dashboards with my team in Metabase?
Yes, once you build your visualizations in Metabase, you can share them with marketing teams, agency clients, or executives through Metabase's native sharing features. Team members can view campaign performance, lead generation results, and audience insights without needing access to your Facebook Business Manager or Kondado account.
Are there pre-built report templates for Facebook advertising analytics?
Yes, Kondado provides ready-made report templates including the Meta Ads Looker Studio Report, Meta Ads Power BI Report, and Google Ads and Meta Ads Looker Studio Report. These templates are also available for Looker Studio and Power BI, giving you instant dashboards for cross-platform campaign analysis while you build custom views in Metabase.
What types of Facebook ad performance data can I visualize?
You can access detailed metrics from the Ad Performance and Ad Set Performance pipelines, including impressions, clicks, conversions, and cost per result across all your campaigns. This data includes creative metadata and audience targeting details that help you identify which ad variations and demographic segments deliver the best results for your business objectives.
Do I need technical skills to set up the Facebook Metabase connection?
No coding or database administration is required to connect Facebook to Metabase through Kondado. The setup process uses simple point-and-click configuration where you select your data endpoints and define update schedules, making it accessible for marketing managers and business users without IT support.

Try out all the features for free for 14 days