How do I sync Facebook Ads data to Amazon Redshift?

Sign up for Weld, connect Facebook Ads as a source and Amazon Redshift as a destination. Weld handles the extraction, loading, and lets you transform data using SQL or dbt.

What Facebook Ads data can I sync to Amazon Redshift?

You can sync Campaigns, Ad Sets, Ads, Ad Insights, and Ad Creatives. The available objects depend on your Facebook Ads account permissions and configuration.

How often does Weld sync data from Facebook Ads?

Sync frequency depends on your Weld plan. Schedules range from every 5 minutes to daily intervals. Each sync processes only new and changed data.

Can I transform Facebook Ads data before it lands in Amazon Redshift?

Yes. Weld supports SQL-based transformations in the platform and integrates with dbt Cloud. You can clean, join, and model your data before analysis.

Is the Facebook Ads to Amazon Redshift integration secure?

Yes. Weld encrypts all data in transit and at rest, is SOC 2 Type II certified, and supports IP whitelisting. Credentials are stored encrypted and never logged.

Can I also sync data from Amazon Redshift to Facebook Ads?

Yes. Weld supports both directions. You can use reverse ETL to push data back into Facebook Ads.

Facebook Ads to Amazon Redshift integration

Connect Facebook Ads to Amazon Redshift and automatically sync your advertising platform data. Weld extracts Campaigns, Ad Sets, Ads, and Ad Insights from Facebook Ads, loads them into Amazon Redshift, and lets you transform the data using SQL or dbt, no custom scripts required.

Start for free View setup guide

4.8 on G2

Source

Weld

Warehouse

Weld · New sync

SourceFacebook AdsConnected

Tables to sync

account43 cols
campaign47 cols
ad18 cols
action_canvas_component6 cols
label5 cols
ad_roas_insight_purchase_roas28 cols

Extract
Load
Keep in sync

DestinationAmazon RedshiftReady

facebook_ads schema

facebook_ads.accountSynced
facebook_ads.campaignSyncing
facebook_ads.adSynced
facebook_ads.action_canvas_componentSynced
facebook_ads.labelSynced
facebook_ads.ad_roas_insight_purchase_roasSynced

Facebook Ads tables: 136
fields, typed: 1,790
agent context included: MCP

Trusted by data and AI teams

How it works

How to set up Facebook Ads to Amazon Redshift in Weld.
In the app, with the API or an agent.

Setup guide API guide MCP docs

Weld · New Facebook Ads sync

New connectionFacebook AdsAuthorised

Connection namefacebook_ads

AuthorizeOpens Facebook Ads to grant read access

Use cases

Why sync Facebook Ads to Amazon Redshift?
Ready for analysis.

Centralizing your Facebook Ads data in Amazon Redshift lets you join it with other data sources for cross-platform analytics and deeper insights.

Build reliable dashboards and reports by querying Facebook Ads data directly in Amazon Redshift using SQL or your preferred BI tool.

Cross-channel ad performance
Consolidate Facebook Ads campaign data in Amazon Redshift alongside other ad platforms. Compare ROAS, CPA, and conversion rates in a single dashboard.
Centralized data warehouse
Bring Facebook Ads data into Amazon Redshift alongside other sources to create a single source of truth for your organization.
Automated reporting
Replace manual exports and spreadsheet-based reporting with automated pipelines from Facebook Ads to Amazon Redshift. Connect BI tools like Looker, Metabase, or Power BI.

Schema

What data can you sync?
Every Facebook Ads table, keys intact.

Weld syncs the following data objects from Facebook Ads into Amazon Redshift. The exact tables and fields depend on your Facebook Ads configuration and the permissions granted during setup.

Open the schema explorer

All 136 tables

account
campaign
ad
action_canvas_component
label
ad_roas_insight_purchase_roas
ad_roas_insight_website_purchase_roas
ad_set
campaign_roas_insight_purchase_roas
campaign_roas_insight_website_purchase_roas
demographics_delivery_platform_ad
ad_insight
ad_roas_insight
all_level
lead_ad
ad_roas_insight_actions
ad_roas_insight_action_values
ad_roas_insight_conversions
ad_roas_insight_conversion_values
ad_roas_insight_cost_per_action_type
ad_roas_insight_cost_per_conversion
ad_roas_insight_conversion_insights
creative
action_carousel_card_website_purchase_roas
action_conversion_device_website_purchase_roas
action_product_id_website_purchase_roas
ad_set_roas_insight_purchase_roas
ad_set_roas_insight_website_purchase_roas
demographics_country_ad
ad_set_insight
and 104 more

Weld MCP server

Ask your agent.
It queries Amazon Redshift for you.

Connect Claude, Cursor, ChatGPT or your own agent to Weld over MCP. It reads the Facebook Ads context, finds the tables it needs and runs the query in Amazon Redshift.

Set up the MCP server

Claude CodeOpus 5

ConnectedWeld MCPAgent contextFacebook Adstables136fields1,790

How many campaign rows do we have per account? Use our Facebook Ads data in Amazon Redshift.

Reading the Facebook Ads context first, so the query uses the right tables and keys.

●weld·search_available_references

⎿raw.facebook_ads.campaign

raw.facebook_ads.account

+ 134 more Facebook Ads tables

●weld·get_reference_schema

⎿campaign · 47 columns

joins account on account_id

●weld·run_query

⎿select a.id, count(*) from {{raw.facebook_ads.campaign}} c

join {{raw.facebook_ads.account}} a on c.account_id = a.id

group by 1

submitted

●weld·get_query_status

⎿DONE

●weld·get_query_result

⎿rows returned

✓Answered from Facebook Ads data in Amazon Redshift

>Ask about your Facebook Ads dataMCP

Under the hood

Technical considerations.
What to expect.

Reverse ETL

ELT vs. reverse ETL: Facebook Ads and Amazon Redshift

ELT (Extract, Load, Transform) moves data from Facebook Ads into Amazon Redshift for analysis. This is the approach shown on this page, and the one to use for dashboards, reports, and data models.

Reverse ETL works the other direction: it pushes enriched data from Amazon Redshift back into Facebook Ads. For example, you could sync computed lead scores or customer segments from your warehouse into Facebook Ads to personalize outreach.

Weld supports both directions, so you can build a complete data loop between Facebook Ads and Amazon Redshift.

Amazon Redshift to Facebook Ads

Incremental syncing: Weld uses incremental syncing where supported by the Facebook Ads API, loading only new and updated records to minimize data transfer and warehouse costs.
Schema handling: Weld automatically manages schema changes. If Facebook Ads adds new fields, they're detected and added to the corresponding Amazon Redshift tables.
Data freshness: Sync frequency depends on your Weld plan. Most connectors support schedules from every 5 minutes up to daily intervals.
Security: All data is encrypted in transit (TLS) and at rest. Weld is SOC 2 Type II compliant and supports IP whitelisting for database connections.

Resources

Keep reading.
Guides, docs and schema.

Documentation

Facebook Ads setup guide

How to connect Facebook Ads to Weld, step by step.

Documentation

Amazon Redshift setup guide

How to connect Amazon Redshift to Weld, step by step.

Schema

Facebook Ads schema explorer

Browse all 136 tables and 1,790 fields.

Connector

Facebook Ads connector

Everything Weld does with Facebook Ads.

FAQ

Common questions.
About Facebook Ads to Amazon Redshift.

Start syncing Facebook Ads to Amazon Redshift.

Set up your Facebook Ads data pipeline in minutes. No credit card required. Free for 14 days.

Source

Weld

Warehouse

Start for free Talk to us

Related integrations.
More with Facebook Ads and Amazon Redshift.

View all

Facebook Ads to Amazon Redshift integration

How to set up Facebook Ads to Amazon Redshift in Weld.In the app, with the API or an agent.

Why sync Facebook Ads to Amazon Redshift?Ready for analysis.

Cross-channel ad performance

Centralized data warehouse

Automated reporting

What data can you sync?Every Facebook Ads table, keys intact.

Ask your agent.It queries Amazon Redshift for you.

Technical considerations.What to expect.