# Pinterest Ads datasets and fields

> The 9 datasets Maven lands from Pinterest Ads, every field in them, and how the connection syncs.

Source: https://mavendata.ai/docs/integrations/pinterest

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](https://mavendata.ai/integrations/pinterest).

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