> ## Documentation Index
> Fetch the complete documentation index at: https://www.integrate.io/docs/llms.txt
> Use this file to discover all available pages before exploring further.

# Pinterest source for ELT & CDC

> Configure Pinterest as a data source in Integrate.io ELT & CDC. Replicate ad campaigns, pins, boards, and analytics data to your data warehouse.

|                           |                                                                                                                                                                                     |
| :------------------------ | :---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| **Description**           | Pinterest is a visual discovery platform where users find and save ideas. The Pinterest Ads API provides access to ad accounts, campaigns, pins, boards, and performance analytics. |
| **Supported Replication** | Initial Sync, Continuous Sync                                                                                                                                                       |
| **Authentication Type**   | OAuth                                                                                                                                                                               |

## Collections

| **Collection Name** | **Full/Initial Sync** | **Incremental/Continuous Sync** | **Supports Update** | **Supports Delete** | **Notes**         |
| :------------------ | :-------------------- | :------------------------------ | :------------------ | :------------------ | :---------------- |
| Ad accounts         | ✔                     | ✖                               | ✔                   | ✖                   |                   |
| Campaigns           | ✔                     | ✔                               | ✔                   | ✖                   |                   |
| Ad groups           | ✔                     | ✔                               | ✔                   | ✖                   |                   |
| Ads                 | ✔                     | ✔                               | ✔                   | ✖                   |                   |
| Boards              | ✔                     | ✖                               | ✔                   | ✖                   |                   |
| Pins                | ✔                     | ✖                               | ✔                   | ✖                   |                   |
| Ad analytics        | ✔                     | ✔                               | ✖                   | ✖                   | Daily granularity |
| Campaign analytics  | ✔                     | ✔                               | ✖                   | ✖                   | Daily granularity |

## Setting up Pinterest for ELT & CDC

ELT & CDC uses the API provided by Pinterest to sync the data.

<Card title="Pinterest API Reference" icon="code" href="https://developers.pinterest.com/docs/api/v5/" horizontal />

### Requirements

* A Pinterest Business account.
* At least one ad account linked to your Pinterest Business profile.
* You need to authenticate via OAuth2.

### Setup Steps

<Steps>
  <Step title="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.
  </Step>

  <Step title="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.
  </Step>

  <Step title="Choose collections">
    Select which collections (campaigns, ads, boards, pins, analytics) you want to sync to your destination.
  </Step>

  <Step title="Configure your destination and start the pipeline">
    Select a destination warehouse, map your tables, and start the initial sync.
  </Step>
</Steps>

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

## FAQ

**Q: Do I need a Pinterest Business account, or will a personal account work?**

A Pinterest Business account is required. Personal accounts do not have access to the Ads API or ad account data.

**Q: Can I sync data from multiple ad accounts?**

Each pipeline connects to a single ad account. To replicate data from multiple ad accounts, create a separate pipeline for each one.

**Q: How frequently does analytics data update?**

Analytics collections sync on a daily granularity. Data for a given day is typically available the following day, though Pinterest may retroactively adjust metrics for up to 30 days.

## Related

<CardGroup cols={2}>
  <Card title="What is ELT & CDC" icon="arrow-right" href="/cdc/what-is-integrateio-cdc" horizontal />

  <Card title="Hooks" icon="arrow-right" href="/cdc/hooks" horizontal />

  <Card title="Initial Sync Process" icon="arrow-right" href="/cdc/initial-sync-process" horizontal />

  <Card title="Data Type Mapping" icon="arrow-right" href="/cdc/data-type-mapping-redshift-snowflake-and-bigquery" horizontal />
</CardGroup>