Datapipe
Campaigns
A Pinterest Ads report of campaigns.
Live with your own API key
Pinterest Ads for agencies and in-house teams
Social teams use Pinterest Ads in Datapipe to see pin impressions, clicks, and saves. Ad spend needs a separate Pinterest approval.
This page is not indexed yet. It does not have a reviewed integration record.
Connection
Live with your own API key
Live for your own pins when you paste a token from a trial app. Pinterest ads approval is still required before ad spend can be read.
Fields
Columns and metrics from the Pinterest API v5 analytics resource. Ads delivery metrics require an approved ads app; organic pin fields are available on a trial app. Source: https://developers.pinterest.com/docs/api/v5/#tag/ads. Read on 2026-10-27. 14 fields.
Synced today
- Date
DATE - Campaign
CAMPAIGN_NAME - Times shown
IMPRESSION_1 - Clicks
CLICKTHROUGH_1 - Amount spent
SPEND_IN_DOLLAR - Conversions
TOTAL_CONVERSIONS - Revenue
TOTAL_CHECKOUT_VALUE
Advertising
| Name | API field | Description | Type | Group | Cross-channel |
|---|---|---|---|---|---|
| Impressions · Synced today | IMPRESSION_1 | Paid impressions. | metric · integer | Advertising | |
| Clickthroughs · Synced today | CLICKTHROUGH_1 | Paid clicks. | metric · integer | Advertising | |
| Outbound clicks | OUTBOUND_CLICK_1 | Clicks that left Pinterest. | metric · integer | Advertising | |
| Spend · Synced today | SPEND_IN_DOLLAR | Spend in dollars. | metric · number | Advertising |
Conversions
| Name | API field | Description | Type | Group | Cross-channel |
|---|---|---|---|---|---|
| Conversions · Synced today | TOTAL_CONVERSIONS | Conversions attributed to the pin. | metric · integer | Conversions |
Dimensions
| Name | API field | Description | Type | Group | Cross-channel |
|---|---|---|---|---|---|
| Ad group | AD_GROUP_NAME | The ad group name. | dimension · string | Dimensions | |
| Pin | PIN_ID | The pin id. | dimension · string | Dimensions |
Ecommerce
| Name | API field | Description | Type | Group | Cross-channel |
|---|---|---|---|---|---|
| Checkouts | TOTAL_CHECKOUT | Checkout conversions. | metric · integer | Ecommerce | |
| Checkout value · Synced today | TOTAL_CHECKOUT_VALUE | Checkout revenue. | metric · number | Ecommerce |
Metrics
| Name | API field | Description | Type | Group | Cross-channel |
|---|---|---|---|---|---|
| Engagements | ENGAGEMENT_1 | Engagements on the pin. | metric · integer | Metrics | |
| Saves | SAVE_1 | Times the pin was saved. | metric · integer | Metrics |
Time
| Name | API field | Description | Type | Group | Cross-channel |
|---|---|---|---|---|---|
| Date · Synced today | DATE | The day. | dimension · date | Time |
Traffic
| Name | API field | Description | Type | Group | Cross-channel |
|---|---|---|---|---|---|
| Campaign · Synced today | CAMPAIGN_NAME | The campaign name. | dimension · string | Traffic | |
| Campaign id | CAMPAIGN_ID | The campaign id. | dimension · string | Traffic |
Cross-channel metrics
Spend, Impressions, Clicks, Conversions, and Revenue roll up on All channels when a field maps to them. ROAS is revenue divided by spend. CPA is spend divided by conversions. The Cross-channel column above shows the match.
Example reports
Destinations
Pinterest Ads to Google Sheets
A sheet you can open, share, and refresh.
Included on every plan.
Pinterest Ads to Looker Studio
Charts that read the Google Sheet this integration keeps up to date.
Included on every plan. Looker reads the sheet. There is no separate Looker install.
Pinterest Ads to BigQuery
A warehouse table for the same columns.
Pro and Agency plans.
Pinterest Ads to AI and MCP
Ask a question in plain English, or let another tool read the report through MCP.
Included on every plan. An AI key is optional.
Pinterest Ads to the API
Download the rows as CSV or JSON from the report.
Included on every plan.
Pinterest Ads to Google Drive
CSV, Excel, and an optional JSON file in a Drive folder you pick. Each client gets a Datapipe folder. The file can overwrite itself or keep the date in the name.
Included on every plan. Drive API v3 with the drive.file scope only. Enable the Google Drive API in the GCP project. Hourly, daily, or weekly.
How to connect
- Create a free account.
- Open Connections and find this source.
- Paste the key the page asks for. The steps next to the box say where to copy it.
- Open the sample report. It switches to your numbers after the key is accepted.
Refresh by plan
| Plan | Refresh | BigQuery | Price |
|---|---|---|---|
| Free | Daily | No | $0/mo |
| Starter | Daily | No | $15/mo |
| Pro | Hourly | Yes | $49/mo |
| Agency | 15 minutes | Yes | $149/mo |
FAQ
Is the Pinterest Ads connection live?
Live for your own pins when you paste a token from a trial app. Pinterest ads approval is still required before ad spend can be read.
Do I have to talk to sales?
No. Create an account, connect the source, and the first report is on Home. Sample numbers stay available when a key is missing.
How often do the numbers refresh?
Free and Starter refresh daily. Pro refreshes hourly. Agency refreshes every 15 minutes on up to 50 accounts and hourly on the rest. We keep the history for you: 90 days on Free, and for as long as you subscribe on paid plans. No warehouse to set up.
Which fields are synced today?
The list marks Synced today on the fields the current connector pulls. The rest of the list is what the platform publishes, so you can see it before you sign up.