Pinterest is an online pin board for collecting and sharing multimedia. Pinterest Ads help businesses increase brand’s visibility and drive conversions. Ads can be targeted based on user’s demographics, search terms, and interests.
Featureslink
| Feature Name | Supported | Notes |
|---|---|---|
| Capture deletes | ||
| Custom data | check | PIN_HISTORY table: all fields with the prefix board_.AD_GROUP_HISTORY table: all fields with the prefix tracking_urls_ and targeting_spec_.PIN_PROMOTION_HISTORY table: all fields with the prefix tracking_urls_. |
| Data blocking | check | Column level, table level, and schema level. All of the report tables: AD_GROUP_REPORT, ADVERTISER_REPORT, CAMPAIGN_REPORT, PRODUCT_ITEM_REPORT, PIN_PROMOTION_REPORT, PIN_PROMOTION_TARGETING_REPORT, PRODUCT_GROUP_REPORT, and PRODUCT_GROUP_TARGETING_REPORT. |
| Column hashing | check | |
| Re-sync | check | Connector level |
| History | check | |
| API configurable | check | API configuration |
| Priority-first sync | check | Reporting tables |
| Fivetran data models | check | Get the models: source / transform; Get the ad reporting model |
| Private networking |
Setup guidelink
Follow our step-by-step Pinterest Ads setup guide to connect Pinterest Ads with your destination using Fivetran connectors.
Sync overviewlink
Pinterest takes good amount of time to process request for a report. So, we sync all the historical reports till the Advertiser creation date gradually as the integration runs. At any given time, you will have the latest reports till previous day from the day you create the connector and the complete historical reports will be available over time.
Schema informationlink
This schema applies to all Pinterest Ads connectors.
To zoom, open the ERD in a new window.
Syncing empty tables and columnslink
The Pinterest Ads connector doesn’t support the creation of empty tables and columns in your destination.
We create a table in the destination only if we can retrieve the table data from the source. If Pinterest Ads doesn’t return data for the source table, we don’t create the table in your destination.