Pinterest Ads SQL templates

1 ready-to-run SQL model for Pinterest Ads data in your own warehouse. Each one runs as-is against your synced tables, in Weld SQL or dbt.

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.
Intermediate

Or browse templates for every connector.