Integrations
Pinterest Ads datasets and fields
The 9 datasets Maven lands from Pinterest Ads, every field in them, and how the connection syncs.
Maven lands 9 datasets from Pinterest Ads in each client workspace. This page lists every one with all of its fields. For the metrics, reports and setup steps, see the Pinterest Ads integration page.
Connection and sync#
You connect Pinterest Ads by signing in to it and approving access, so nobody shares a password.
The first Pinterest Ads sync pulls the most recent 30 days so the workspace fills quickly. A follow-up backfill then adds older history, up to 2 years in total. After that, each scheduled sync re-reads the last 7 days, so late changes are picked up.
Datasets#
Ad accounts#
Pinterest ad-account identity and reporting context.
| Field | Type |
|---|---|
| account ID | Text |
| account name | Text |
| currency | Text |
| country | Text |
| time zone | Text |
| owner | Text |
| permissions | Text |
| created time | Integer |
| updated time | Integer |
Campaigns#
Pinterest campaign hierarchy, objective, lifecycle, and budget metadata.
| Field | Type |
|---|---|
| campaign ID | Text |
| account ID | Text |
| ad account ID | Text |
| account name | Text |
| name | Text |
| status | Text |
| summary status | Text |
| objective type | Text |
| campaign type | Text |
| daily spend cap | Integer |
| lifetime spend cap | Integer |
| default ad group budget in micro currency | Integer |
| is automated campaign | True/false |
| is campaign budget optimization | True/false |
| is performance plus | True/false |
| intended promotion type | Text |
| bid options | Text |
| tracking URLs | Text |
| start time | Integer |
| end time | Integer |
| created time | Integer |
| updated time | Integer |
Ad groups#
Ad group metadata.
| Field | Type |
|---|---|
| ID | Text |
| account ID | Text |
| account name | Text |
| ad account ID | Text |
| ad group ID | Text |
| campaign ID | Text |
| name | Text |
| status | Text |
| bid strategy type | Text |
| summary status | Text |
| budget type | Text |
| budget in micro currency | Integer |
| bid in micro currency | Integer |
| billable event | Text |
| placement group | Text |
| placement traffic type | Text |
| pacing delivery type | Text |
| auto targeting enabled | True/false |
| is creative optimization | True/false |
| lifetime frequency cap | Integer |
| conversion event | Text |
| conversion tag ID | Text |
| targeting spec | Text |
| optimization goal metadata | Text |
| tracking URLs | Text |
| start time | Integer |
| end time | Integer |
| created time | Integer |
| updated time | Integer |
| loaded at | Timestamp |
Configured target coverage#
| Field | Type |
|---|---|
| coverage key | Text |
| account ID | Text |
| scope level | Text |
| collection status | Text |
| source entity count | Integer |
| configured target count | Integer |
| capability reason | Text |
| collected at | Timestamp |
Ads analytics daily#
Daily ad-level performance.
| Field | Type |
|---|---|
| date | Date |
| account ID | Text |
| account name | Text |
| ad account ID | Text |
| ad ID | Text |
| pin ID | Text |
| ad group ID | Text |
| campaign ID | Text |
| total page visit | Integer |
| spend in micro dollar | Integer |
| spend in dollar | Number |
| total impression | Integer |
| total clickthrough | Integer |
| paid impression | Integer |
| total impression user | Integer |
| total impression frequency | Number |
| outbound click 1 | Integer |
| total engagement | Integer |
| repin 1 | Integer |
| total conversions | Integer |
| total signup | Integer |
| total click signup | Integer |
| total view signup | Integer |
| total engagement signup | Integer |
| total checkout | Integer |
| total click checkout | Integer |
| total view checkout | Integer |
| total engagement checkout | Integer |
| total checkout value in micro dollar | Integer |
| total checkout value | Number |
| total click checkout value | Number |
| total view checkout value | Number |
| total engagement checkout value | Number |
| total lead | Integer |
| total click lead | Integer |
| total view lead | Integer |
| total engagement lead | Integer |
| leads | Integer |
| total click page visit | Integer |
| total view page visit | Integer |
| total engagement page visit | Integer |
| total web sessions | Integer |
| total video 3sec views | Integer |
| total video 15sec unique views | Integer |
| total video mrc views | Integer |
| total video p25 combined | Integer |
| total video p50 combined | Integer |
| total video p75 combined | Integer |
| total video p95 combined | Integer |
| total video p100 complete | Integer |
| click window days | Integer |
| engagement window days | Integer |
| view window days | Integer |
| conversion report time | Text |
| reporting timezone | Text |
| ingestion timestamp | Timestamp |
Conversion report coverage daily#
Successful Pinterest standard conversion breakdown coverage, including empty dates.
| Field | Type |
|---|---|
| coverage key | Text |
| date | Date |
| account ID | Text |
| report name | Text |
| requested grain | Text |
| reported grain | Text |
| report status | Text |
| row count | Integer |
| is partial | True/false |
Ads targeting analytics weekly#
Independent weekly Pinterest ad placement, app/device, and geography breakdowns.
| Field | Type |
|---|---|
| week start date | Date |
| week end date | Date |
| account ID | Text |
| account name | Text |
| ad account ID | Text |
| campaign ID | Text |
| ad group ID | Text |
| ad ID | Text |
| targeting type | Text |
| targeting value | Text |
| spend in micro dollar | Integer |
| spend in dollar | Number |
| paid impression | Integer |
| outbound click 1 | Integer |
| total impression user | Integer |
| total impression frequency | Number |
| click window days | Integer |
| engagement window days | Integer |
| view window days | Integer |
| conversion report time | Text |
| reporting timezone | Text |
Ads targeting analytics daily#
Daily Pinterest ad-level REGION and GEO targeting breakdowns from async reports.
| Field | Type |
|---|---|
| date | Date |
| account ID | Text |
| account name | Text |
| ad account ID | Text |
| campaign ID | Text |
| ad group ID | Text |
| ad ID | Text |
| targeting type | Text |
| targeting value | Text |
| spend in micro dollar | Integer |
| spend in dollar | Number |
| paid impression | Integer |
| outbound click 1 | Integer |
| total impression user | Integer |
| total impression frequency | Number |
| conversions reported | True/false |
| total conversions | Integer |
| total conversions value | Number |
| total page visit | Integer |
| total signup | Integer |
| total lead | Integer |
| total checkout | Integer |
| total checkout value in micro dollar | Integer |
| total checkout value | Number |
| click window days | Integer |
| engagement window days | Integer |
| view window days | Integer |
| conversion report time | Text |
| reporting timezone | Text |
Ads#
Pinterest ad metadata from the ad account ads endpoint.
| Field | Type |
|---|---|
| account ID | Text |
| account name | Text |
| ad account ID | Text |
| ad ID | Text |
| ad group ID | Text |
| campaign ID | Text |
| pin ID | Text |
| ad name | Text |
| status | Text |
| summary status | Text |
| review status | Text |
| creative type | Text |
| ad type | Text |
| lead form ID | Text |
| is pin deleted | True/false |
| disclosure type | Text |
| disclosure URL | Text |
| destination URL | Text |
| click tracking URL | Text |
| view tracking URL | Text |
| tracking URLs | Text |
| rejected reasons | Text |
| rejection labels | Text |
| created time | Integer |
| updated time | Integer |