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.

Account Report

Generates an account report for Pinterest Ads integration. It retrieves data from the `pinterest_ads.ad_account_report` table and joins it with the `pinterest_ads.ad_account` table. The report includes information such as date, account name, account ID, currency code, country, spend, impressions, clicks, CPC, CTR, CPM, and total conversions. The data is grouped by various columns specified in the query.

Ad Group Report

Generates an ad group report for the Pinterest Ads integration. It retrieves data from various tables such as ad groups, campaigns, and advertisers. The report includes information such as the date, account name and ID, campaign name and status, ad group name and status, spend, impressions, clicks, CPC, CTR, CPM, and total conversions.

Campaign Report

Generates a campaign report for Pinterest Ads integration. It retrieves data from the `pinterest_ads.campaign_report`, `pinterest_ads.campaign`, and `pinterest_ads.ad_account` tables. The report includes information such as date, account name and ID, campaign name and status, spend, impressions, clicks, CPC, CTR, CPM, and total conversions.

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.

View all Pinterest Ads templates