Reddit Ads Connector

Reddit is a vast network of communities based on people's interests, where users can post content, engage in discussions, and vote on submissions.

4.8 on G2

Weld · Data Sources

Reddit Ads

Reddit AdsYour warehouseLive

ad_account19 columnsSynced

ad30 columnsSynced

campaign27 columnsSynced

business13 columnsSyncing

ad_group32 columnsQueued

Lands in

snowflake

bigquery

databricks

Agent context over MCP

How it works

Set up in minutes.
No code, no maintenance.

Reddit Ads

Reddit Ads

Data source

Authenticating...

Ready to connect

Overview

Reddit Ads in your warehouse.
Ready for your agents.

Reddit is a vast network of communities based on people's interests, where users can post content, engage in discussions, and vote on submissions. Weld's Reddit Ads connector is fully managed: it extracts data from Reddit 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

Reddit Ads data schema.
The map your agents read.

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

tables: 34
fields: 305
relationships: 15

Loading diagram…

campaign_objective_type

configured_status

delivery_status

effective_status

ad_click_url_query_parameter

ad_event_tracker

attribution_type

click_attribution_window

pixel_partner_preferences

ad_account_history

cause_changed_at

change_entity_id

change_field_name

cause_member_id

cause_partner_business_name

cause_reddit_username

campaign_objective_type

configured_status

delivery_status

effective_status

ad_group_targeting_carrier

ad_group_targeting_community

ad_group_targeting_custom_audience

custom_audience_id

ad_group_targeting_device

ad_group_targeting_geolocation

ad_group_targeting_interest

ad_group_targeting_keyword

ad_group_targeting_location

ad_group_targeting_platform

ad_group_targeting_suppression_event_type

suppression_event_type

ad_group_targeting_view_mode

ad_group_schedule

ad_group_shopping_targeting_conversion_event_type

conversion_event_type

agency_affiliated

primary_contact_id

two_fa_enforcement

funding_instrument_id

configured_status

conversion_pixel_id

delivery_status

subscriber_count

custom_audience

delivery_status

size_range_upper

size_range_lower

funding_instrument

billable_amount

reasons_not_servable

invoice_group_status

authorize_status

automatic_matching_config_collect_email

automatic_matching_config_collect_phone_number

product_catalog

default_currency

default_language

summary_products_count

summary_approved_products_count

summary_rejected_products_count

Open the schema explorer Open the full schema explorer

Weld MCP server

Ask your agent.
It already knows Reddit Ads.

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

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

Set up the MCP server

Claude CodeOpus 5

ConnectedWeld MCPAgent contextReddit Adstables34fields305joins15

>

How many ad_account rows do we have per business? Use our Reddit Ads data.

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

●weld·search_available_references

⎿raw.reddit_ads.ad_account

raw.reddit_ads.business

+ 32 more Reddit Ads tables

●weld·get_reference_schema

⎿ad_account · 19 columns

joins business on business_id

●weld·run_query

⎿select b.id, count(*) from {{raw.reddit_ads.ad_account}} a

join {{raw.reddit_ads.business}} b on a.business_id = b.id

group by 1

submitted

●weld·get_query_status

⎿DONE

●weld·get_query_result

⎿rows returned

✓Answered from Reddit Ads data in your warehouse

>Ask about your Reddit Ads dataMCP

Destinations

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

Resources

Everything you need.
To get started.

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.

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 Reddit 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 Reddit 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": "reddit-ads",
    "destination_schema_name": "reddit-ads_data",
    "sync_interval": "0 * * * *"
  }'
▌

FAQ

Common questions.
About connectors.

Something not covered here? A data engineer can walk through your setup with you.

Put your Reddit Ads data to work.

Connect Reddit Ads, pick a warehouse, and your agents can query it today. Free for 14 days, no credit card.

Reddit Ads

Source

Weld

MCPAgents

Start for free Talk to us

Connectors

Explore more connectors.
300+ and counting.

View all connectors