Linking Pinterest Ads as a source
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.
- Your Ad Account ID from Pinterest Business > Ads > select your account > the ID is in the URL or account settings.
Configuring PostHog
Connect PostHog to your Pinterest Ads 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.
- Enter the Ad Account ID of the Pinterest Ads account you want to sync.
- Select an existing Pinterest Ads account, or create a new integration.
- (Optional) Add a prefix for the table name.
Configuration
| Option | Type | Required |
|---|---|---|
Pinterest Ads Ad Account ID | text | Yes |
Pinterest Ads account | oauth | 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 | — | — |
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 | — |