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 | CUSTOMER_LIST_HISTORY table: all fields with the prefix num_matched_user_records_.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 | Table level and schema level. All of the report tables: AD_GROUP_REPORT, ADVERTISER_REPORT, CAMPAIGN_REPORT, ITEM_REPORT, PIN_PROMOTION_REPORT, PIN_PROMOTION_TARGETING_REPORT, PRODUCT_GROUP_REPORT, and PRODUCT_GROUP_TARGETING_REPORT. |
| Column Hashing | ||
| Re-sync | check | Connector level |
| History | check | |
| API Configurable | check | |
| Priority-first sync | check | Reporting tables |
| dbt Package | check | Get the package: source / transform; Get the ad reporting package |
NOTE: The
CONVERSATION_TAG_HISTORYtable uses Pinterest’sconversation_tagslegacy endpoint. We can only sync data for old tags using this endpoint.
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 ERD in 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.