Pinterest Ads
Pinterest Ads is an online advertising platform. Ads can be targeted based on user's demographics, search terms, and interests.
See Pinterest Ads' API documentation to learn more about the type of ad performance data it provides.
Features
| Feature Name | Supported | Notes |
|---|---|---|
| Capture deletes | ||
| History mode | check | _HISTORY suffix and the PIN_MEDIA and PIN_MEDIA_IMAGE tables. |
| Custom data | check | AD_GROUP_HISTORY table: all fields with the tracking_urls_ and tracking_urls_ prefix. |
| Data blocking | check | |
| Column hashing | check | |
| Re-sync | check | |
| API configurable | check | API configuration |
| Priority-first sync | check | |
| Fivetran data models | check | |
| Private networking | ||
| Authorization via API | check |
Supported deployment models
We support the SaaS Deployment model for the connector.
Setup guide
Follow our step-by-step Pinterest Ads setup guide to connect Pinterest Ads with your destination using the Fivetran connector.
Sync overview
The Pinterest Ads API may take a long time to process a report request. Therefore, we gradually sync all the historical reports data until the Advertiser creation date. At any given moment, you have the latest reports until the previous day from the day you create the connector. Complete historical report data is made available over time.
Rollback sync
A rollback sync is a sync that automatically runs once a day. Rollback syncs capture the changes that happen outside the incremental sync time frame.
Fivetran does not automatically capture the rollback window size. You can opt to configure the rollback window in the connection setup form. To do so, set the attribution window using the Click Attribution Window (optional) drop-down.
NOTE: The minimum rollback window size is 7 days. Even if you set a value of
1for the Click Attribution Window, the rollback window defaults to 7 days.
Schema information
This schema applies to all Pinterest Ads connectors.
To zoom, open the ERD in a new window.Syncing empty tables and columns
The Pinterest Ads connector doesn't support the creation of empty tables and columns in your destination.
We only create a table in your destination if we can retrieve the table data from the source. We don't create a table in your destination if the Pinterest Ads API doesn't return data for a source table.
Limitations
For reports with hourly report granularity, the maximum rollback window is 8 days because of Pinterest Ads API limitations.