Facebook Ads Connector

Facebook is an online social networking service that enables its users to connect with friends and family.

Start for free View documentation

4.8 on G2

Weld · Data Sources

Facebook AdsYour warehouseLive

account43 columnsSynced

campaign47 columnsSynced

ad18 columnsSynced

action_canvas_component6 columnsSyncing

label5 columnsQueued

Lands in

Agent context over MCP

How it works

Set up in minutes.
No code, no maintenance.

Facebook Ads

Data source

Authenticating...

Ready to connect

Overview

Facebook Ads in your warehouse.
Ready for your agents.

Facebook is an online social networking service that enables its users to connect with friends and family. Weld's Facebook Ads connector is fully managed: it extracts data from Facebook Ads, loads it into your warehouse, and keeps it in sync. The data lands in a clean, documented schema with agent context attached, so analysts can query it with SQL or dbt, and agents can query it over the Weld MCP server without guessing at tables or joins.

Agent context

Facebook Ads data schema.
The map your agents read.

Every table, field and relationship Weld syncs from Facebook Ads is served to agents as context over MCP, so they pick the right tables and join on the right keys.

tables: 136
fields: 1,790

136 tables

Open the schema explorer Open the full schema explorer

Weld MCP server

Ask your agent.
It already knows Facebook Ads.

Connect Claude, Cursor, ChatGPT or your own agent to Weld over MCP. It reads the Facebook Ads context, finds the tables it needs and queries your warehouse.

Agent contextFacebook Ads tables, fields and joins
QuerySQL against your warehouse
OperateCheck, rerun and refresh syncs

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.

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 your warehouse

>Ask about your Facebook Ads dataMCP

Destinations

Load Facebook Ads into any warehouse.
Set up in minutes, no code.

Resources

Everything you need.
To get started.

Documentation

Facebook Ads setup guide

Step-by-step instructions to configure and start syncing.

MCP server

Connect your agents

Set up Claude, Cursor, ChatGPT or Codex against your Weld workspace.

Weld Connect API

Build custom connectors

Use the Weld Connect API to build and publish your own connector.

FAQ

Common questions

Answers to frequently asked questions about Weld connectors.

Weld Connect API

Set it up in code.
One REST API.

Use the Weld Connect REST API to create Facebook Ads connections, configure ELT syncs, and manage pipelines entirely through code. Built for embedding, automation, and CI/CD workflows.

Explore Weld Connect API reference

POST/elt_syncs

# Create a Facebook Ads ELT sync
curl -X POST https://connect.weld.app/elt_syncs \
  -H "x-api-key: $API_KEY" \
  -d '{
    "connection_id": "conn_abc123",
    "integration_id": "facebook-ads",
    "destination_schema_name": "facebook-ads_data",
    "sync_interval": "0 * * * *"
  }'
▌