Linking Pinterest Ads as a source
Let AI connect your sources for you
Skip the manual setup — run this in your project and the wizard auto-detects your databases and APIs and connects them to PostHog.
Contents
You can sync data from Pinterest Ads by configuring it as a source in PostHog. The supported entities and reports include campaigns, ad groups, ads, campaign analytics, ad group analytics, and ad analytics:
- Campaigns: Campaign entities from your Pinterest Ads account
- Ad Groups: Ad group entities within campaigns
- Ads: Individual ad entities within ad groups
- Campaign Analytics: Performance metrics at the campaign level
- Ad Group Analytics: Performance metrics at the ad group level
- Ad Analytics: Performance metrics at the ad level
Additional reports will be added based on user feedback we receive via our in-app support form.
Requirements
- A Pinterest Ads account with permission to access data from the accounts you want to sync.
Tip: If you need to find your Ad Account ID manually, go to Pinterest Business > Ads > select your account. The ID is in the URL or account settings.
Configuring PostHog
Connect PostHog to your Pinterest Ads account using a Pinterest account. The Pinterest account must have permission to access the ad account data.
- In PostHog, go to the Data pipelines tab.
- Open the + New drop-down menu in the top-right and select Source.
- Find Pinterest Ads in the sources list and click Link.
- Connect your Pinterest account by selecting an existing integration or creating a new one.
- Select the Ad Account you want to sync from the dropdown. Each account displays your permission level (Owner, Campaign Manager, etc.).
- (Optional) Add a prefix for the table name.
Configuration
| Option | Type | Required |
|---|---|---|
Pinterest Ads account | oauth | Yes |
Pinterest Ads Ad Account ID | oauth-account-select | Yes |
Supported tables
| Table | Description | Sync method | Incremental field | Primary key |
|---|---|---|---|---|
campaigns | A Pinterest advertising campaign that groups ad groups under a single objective and budget. | Full refresh | — | — |
ad_groups | A group of ads within a campaign, sharing targeting, budget, and bidding settings. | Full refresh | — | — |
ads | An individual ad (promoted Pin) belonging to an ad group. | Full refresh | — | — |
ad_accounts | The configured Pinterest ad account, including the currency and time zone every spend figure is reported in. | Full refresh | — | — |
audiences | Targetable audiences owned by the ad account, such as customer lists, engagement audiences, and actalike audiences. | Full refresh | — | — |
conversion_tags | Pinterest tags (pixels) installed for the ad account, which report the conversion events that campaigns optimize against. | Full refresh | — | — |
keywords | Keyword targets defined on the ad account's campaigns and ad groups, used to resolve keyword targeting back to the term that was bid on. | Full refresh | — | — |
campaign_analytics | Daily performance metrics (spend, impressions, clicks, conversions) per campaign. | Incremental, Full refresh | date | — |
ad_group_analytics | Daily performance metrics (spend, impressions, clicks, conversions) per ad group. | Incremental, Full refresh | date | — |
ad_analytics | Daily performance metrics (spend, impressions, clicks, conversions) per ad. | Incremental, Full refresh | date | — |
campaign_targeting_analytics | Daily campaign performance broken down by targeting dimension (age, gender, device, placement, country, region). | Incremental, Full refresh | date | — |
ad_group_targeting_analytics | Daily ad group performance broken down by targeting dimension (age, gender, device, placement, country, region). | Incremental, Full refresh | date | — |
ad_targeting_analytics | Daily ad performance broken down by targeting dimension (age, gender, device, placement, country, region). | Incremental, Full refresh | date | — |