Pinterest Ads Connector

Start moving your Pinterest Ads data with fully managed data pipelines. Get clean normalized data ready for analytics, easy to setup and analyze with AI in minutes.

View more about the Pinterest Ads connector in the Weld documentation

ad_group_report

index

CAMPAIGN_DAILY_SPEND_CAP

8 more pinterest-ads tables

Explore available Pinterest Ads data

Browse all the data tables available for the Pinterest Ads connector, in our interactive ERD data viewer.

View the Pinterest Ads Data Schema

Transform and model Pinterest Ads data

Get clean data models from your Pinterest Ads data. Weld makes it easy to transform and model with the powerful built in SQL editor and AI Assistant.

Pinterest Ads

raw.pinterest_ads.table1

raw.pinterest_ads.table2

Get started with Pinterest Ads SQL Templates

Get inspiration on how to model your data, with our collection of foundational SQL templates we have battle-tested at Weld. All the templates work out of the gate with the Weld data integrations for Pinterest Ads.

Ad Report

Generates an ad report for the Pinterest Ads integration. It retrieves data from multiple tables, including ad reports, ad accounts, campaigns, and ads. The report includes information such as date, account name and ID, campaign name and ID, ad name, status, type, created time, spend, impressions, clicks, CPC, CTR, CPM, and total conversions. The data is grouped by various columns for analysis.