Facebook Ads integration
Facebook Ads data, in your warehouse.
A built-in ingestr connector: add credentials, pick tables, schedule it.
name: raw.campaigns
type: ingestr
parameters:
source_connection: meta_ads
source_table: 'campaigns'
destination: snowflake
incremental_strategy: merge$ bruin run assets/raw/facebook_ads.asset.yml
- extract · Facebook Ads campaignsincremental
- load · snowflake raw.campaignsmerged
- checks · not_null, unique
Loaded and checked. Downstream models can run.
How it connects
Connected in three steps.
Meta's advertising platform providing comprehensive campaign performance data, audience insights, and ad analytics across Facebook and Instagram.
- 01
Add a Meta Ads connection with its credentials.
- 02
Pick the tables to load and how: replace, append or merge.
- 03
Bruin runs it on your schedule and checks every load.
Connection parameters
- access_token
- Facebook Marketing API access token
- account_ids
- Comma-separated list of Facebook Ad Account IDs
Tables
6 tables, ready to load.
campaignsad_setsadsinsightscreativesaudiences
Step-by-step
Pick a destination.
Facebook Ads → Snowflake
Read the guide
Facebook Ads → Google BigQuery
Read the guide
Facebook Ads → Databricks
Read the guide
Facebook Ads → Amazon Redshift
Read the guide
Facebook Ads → PostgreSQL
Read the guide
Facebook Ads → ClickHouse
Read the guide
Facebook Ads → DuckDB
Read the guide
Facebook Ads → MotherDuck
Read the guide
The platform
Part of the Bruin platform.
Data in, ready for everything downstream: the models, the checks, the lineage and the AI layer.
Sources
DatabasesWarehousesApps & APIsFiles & storageStreams & webhooksWeb scrapingMove
Data IngestionFrequently asked
Questions about Facebook Ads.
Does Bruin have a built-in Facebook Ads integration?
Yes. Built-in ingestr source.
Which Facebook Ads tables can Bruin load?
campaigns, ad_sets, ads, insights, creatives, audiences.
Where can Facebook Ads data go?
Snowflake, BigQuery, Databricks, Redshift, ClickHouse, Postgres, DuckDB, MotherDuck, Microsoft Fabric and more, plus files on S3 and GCS.
How fresh is the data?
As fresh as your schedule. Incremental loads append, merge or replace a time window, every few minutes if you like.
Do we need Bruin Cloud?
No. The Bruin CLI and ingestr run locally, in CI or in your own orchestrator. Bruin Cloud adds scheduling, lineage, alerts and the AI data analyst on top.
Ready to connect Facebook Ads?
$100 in credits and 50 AI tasks. No credit card.
A demo walks through your own data.