Collections
Setting up Pinterest for ELT & CDC
ELT & CDC uses the API provided by Pinterest to sync the data.Pinterest API Reference
Requirements
- A Pinterest Business account.
- At least one ad account linked to your Pinterest Business profile.
- You need to authenticate via OAuth2.
Setup Steps
1
Connect your Pinterest account
In Integrate.io, go to the ELT & CDC Sources page and select Pinterest. Click Sign In to authenticate via OAuth2 with your Pinterest Business account.
2
Select your ad account
After authentication, select the Pinterest ad account you want to replicate data from. If you manage multiple ad accounts, choose the one that contains the campaigns and analytics you need.
3
Choose collections
Select which collections (campaigns, ads, boards, pins, analytics) you want to sync to your destination.
4
Configure your destination and start the pipeline
Select a destination warehouse, map your tables, and start the initial sync.
Limitations
- Analytics lookback window: Pinterest analytics data can be retroactively adjusted for up to 30 days. If you need fully settled metrics, account for this window in your reporting.
- Rate limits: The Pinterest API enforces rate limits per ad account. Large accounts with many campaigns may experience slower sync times during the initial load.
- Organic vs. paid data: The ads, campaigns, ad groups, and analytics collections cover paid (advertising) data only. Boards and pins include both organic and promoted content.