Sync Facebook Insights Data to BigQuery
Detrics loads Facebook Insights into Google BigQuery on the schedule you set. The tables arrive clean, the history keeps growing, and you can query everything from SQL, Looker Studio, or Claude. We run the pipeline so you don't have to.
*Free 30-minute consultation
SELECT
page_name,
SUM(page_post_engagements) AS page_post_engagements,
SUM(page_actions_post_reactions_like_total) AS page_actions_post_reactions_like_total,
SUM(page_actions_post_reactions_love_total) AS page_actions_post_reactions_love_total
FROM `your_project.marketing_data.facebook_insights_page_reactions_and_engagement_daily`
WHERE date >= DATE_SUB(CURRENT_DATE(), INTERVAL 30 DAY)
GROUP BY page_name
ORDER BY page_post_engagements DESC
LIMIT 10Why send Facebook Insights data to BigQuery?
Audience evolution
Store daily snapshots of followers and engagement to measure real long-term growth.
History without limits
Platform APIs cap how far back you can query. In BigQuery every Facebook Insights sync is stored across its 10 tables, so you accumulate years of your own history.
One warehouse for everything
Join Facebook Insights with the rest of your platforms in one place, no copy-pasting between sheets.
Ask Claude about it
With your data in BigQuery, Claude can answer business questions about Facebook Insights in plain language.
Facebook Insights tables in BigQuery
This is what Detrics creates for Facebook Insights: 10 preset tables with scheduled syncs, plus any custom one you define.
Page Analytics
page_performance_overview_dailyKey page metrics including impressions and reach
page_performance_overview_dailyDaily reach metrics with engagement and fan count
page_reactions_and_engagement_dailyDaily breakdown of all reaction types
Post & Leads
post_performancePost-level impressions, reach, and engagement
individual_leads_detailFull lead data with field values
lead_forms_overviewForm-level summary with lead counts
From Facebook Insights to your warehouse
Connect your account once. Detrics handles schemas, syncs, and backfills.
Connect your first datasource
Link any of 32+ marketing and ecommerce platforms in a couple of clicks.
Set up your destination
Point Detrics at your BigQuery project and dataset. We write the SQL and handle the setup for you.
Create your transfer
Choose what to sync and how often. Detrics builds and runs the pipeline for you.
Real-time data, forever
Your data lands in the warehouse and stays fresh automatically. We handle the syncing, the maintenance, and every API update for you.
In the demo we set everything up for you and save you hours.
Then ask Claude about it
With Facebook Insights in BigQuery, the Detrics MCP server lets you run queries in plain language. MCP access is included with every BigQuery plan.
Summarize my organic Facebook Insights performance for the last month
Which day and time work best for my Facebook Insights posts?
Engagement dropped this month on Facebook Insights. Show me where.
Every Facebook Insights field, on demand
- Preset tables curated by our team
- Custom tables with any field combination
- Incremental syncs that only load new data
- Automatic backfill of up to 12 months of history
Get Facebook Insights into your warehouse this week
*No credit card required
- Setup guided by our team, in your own GCP project
- Historical backfill included (up to 12 months)
- Query it from Looker Studio, Sheets, or Claude afterwards