Weld
Start free

Pinterest Ads Connector

Pinterest is a visual discovery and bookmarking platform where users curate and share images and ideas through "pins" and "boards".

Start for freeView documentation
4.8 on G2
Weld · Data Sources
Pinterest AdsLive
adSynced
campaignSynced
ad_groupSynced
ad_accountSyncing
ad_group_reportQueued
Lands insnowflakebigquerydatabricksAgent context over MCP
How it works

Set up in minutes.
No code, no maintenance.

Pinterest Ads

Pinterest Ads

Data source

Authenticating...
Ready to connect
Overview

Pinterest Ads in your warehouse.
Ready for your agents.

Pinterest is a visual discovery and bookmarking platform where users curate and share images and ideas through "pins" and "boards". Weld's Pinterest Ads connector is fully managed: it extracts data from Pinterest 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.

AgentsQuery over MCPYour warehouse10 tables, with agent contextWeldExtract, load, keep in syncPinterest AdsSource
Agent context

Pinterest Ads data schema.
The map your agents read.

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

tables
10
fields
268
relationships
20
Open the schema explorer Open the full schema explorer
Weld MCP server

Ask your agent.
It already knows Pinterest Ads.

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

  • Agent contextPinterest Ads tables, fields and joins
  • QuerySQL against your warehouse
  • OperateCheck, rerun and refresh syncs
Set up the MCP serverClaudeCursorChatGPTGemini
Claude CodeOpus 5
>

How many pin rows do we have in our Pinterest Ads data?

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

●weld·search_available_references
⎿raw.pinterest_ads.pin
raw.pinterest_ads.board
+ 8 more Pinterest Ads tables
●weld·get_reference_schema
⎿pin · 9 columns
related to board
●weld·run_query
⎿select count(*) from {{raw.pinterest_ads.pin}}
submitted
●weld·get_query_status
⎿DONE
●weld·get_query_result
⎿rows returned
✓Answered from Pinterest Ads data in your warehouse
>Ask about your Pinterest Ads data
Destinations

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

Resources

Everything you need.
To get started.

Documentation

Pinterest 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 Pinterest Ads connections, configure ELT syncs, and manage pipelines entirely through code. Built for embedding, automation, and CI/CD workflows.

Explore Weld ConnectAPI reference
POST/elt_syncs
▌
FAQ

Common questions.
About connectors.

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

Talk to us

Put your Pinterest Ads data to work.

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

Pinterest AdsSource
WeldWeld
MCPAgents
Start for freeTalk to us
Connectors

Explore more connectors.
300+ and counting.

View all connectors