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.

FieldType
account IDText
account nameText
currencyText
countryText
time zoneText
ownerText
permissionsText
created timeInteger
updated timeInteger

Campaigns#

Pinterest campaign hierarchy, objective, lifecycle, and budget metadata.

FieldType
campaign IDText
account IDText
ad account IDText
account nameText
nameText
statusText
summary statusText
objective typeText
campaign typeText
daily spend capInteger
lifetime spend capInteger
default ad group budget in micro currencyInteger
is automated campaignTrue/false
is campaign budget optimizationTrue/false
is performance plusTrue/false
intended promotion typeText
bid optionsText
tracking URLsText
start timeInteger
end timeInteger
created timeInteger
updated timeInteger

Ad groups#

Ad group metadata.

FieldType
IDText
account IDText
account nameText
ad account IDText
ad group IDText
campaign IDText
nameText
statusText
bid strategy typeText
summary statusText
budget typeText
budget in micro currencyInteger
bid in micro currencyInteger
billable eventText
placement groupText
placement traffic typeText
pacing delivery typeText
auto targeting enabledTrue/false
is creative optimizationTrue/false
lifetime frequency capInteger
conversion eventText
conversion tag IDText
targeting specText
optimization goal metadataText
tracking URLsText
start timeInteger
end timeInteger
created timeInteger
updated timeInteger
loaded atTimestamp

Configured target coverage#

FieldType
coverage keyText
account IDText
scope levelText
collection statusText
source entity countInteger
configured target countInteger
capability reasonText
collected atTimestamp

Ads analytics daily#

Daily ad-level performance.

FieldType
dateDate
account IDText
account nameText
ad account IDText
ad IDText
pin IDText
ad group IDText
campaign IDText
total page visitInteger
spend in micro dollarInteger
spend in dollarNumber
total impressionInteger
total clickthroughInteger
paid impressionInteger
total impression userInteger
total impression frequencyNumber
outbound click 1Integer
total engagementInteger
repin 1Integer
total conversionsInteger
total signupInteger
total click signupInteger
total view signupInteger
total engagement signupInteger
total checkoutInteger
total click checkoutInteger
total view checkoutInteger
total engagement checkoutInteger
total checkout value in micro dollarInteger
total checkout valueNumber
total click checkout valueNumber
total view checkout valueNumber
total engagement checkout valueNumber
total leadInteger
total click leadInteger
total view leadInteger
total engagement leadInteger
leadsInteger
total click page visitInteger
total view page visitInteger
total engagement page visitInteger
total web sessionsInteger
total video 3sec viewsInteger
total video 15sec unique viewsInteger
total video mrc viewsInteger
total video p25 combinedInteger
total video p50 combinedInteger
total video p75 combinedInteger
total video p95 combinedInteger
total video p100 completeInteger
click window daysInteger
engagement window daysInteger
view window daysInteger
conversion report timeText
reporting timezoneText
ingestion timestampTimestamp

Conversion report coverage daily#

Successful Pinterest standard conversion breakdown coverage, including empty dates.

FieldType
coverage keyText
dateDate
account IDText
report nameText
requested grainText
reported grainText
report statusText
row countInteger
is partialTrue/false

Ads targeting analytics weekly#

Independent weekly Pinterest ad placement, app/device, and geography breakdowns.

FieldType
week start dateDate
week end dateDate
account IDText
account nameText
ad account IDText
campaign IDText
ad group IDText
ad IDText
targeting typeText
targeting valueText
spend in micro dollarInteger
spend in dollarNumber
paid impressionInteger
outbound click 1Integer
total impression userInteger
total impression frequencyNumber
click window daysInteger
engagement window daysInteger
view window daysInteger
conversion report timeText
reporting timezoneText

Ads targeting analytics daily#

Daily Pinterest ad-level REGION and GEO targeting breakdowns from async reports.

FieldType
dateDate
account IDText
account nameText
ad account IDText
campaign IDText
ad group IDText
ad IDText
targeting typeText
targeting valueText
spend in micro dollarInteger
spend in dollarNumber
paid impressionInteger
outbound click 1Integer
total impression userInteger
total impression frequencyNumber
conversions reportedTrue/false
total conversionsInteger
total conversions valueNumber
total page visitInteger
total signupInteger
total leadInteger
total checkoutInteger
total checkout value in micro dollarInteger
total checkout valueNumber
click window daysInteger
engagement window daysInteger
view window daysInteger
conversion report timeText
reporting timezoneText

Ads#

Pinterest ad metadata from the ad account ads endpoint.

FieldType
account IDText
account nameText
ad account IDText
ad IDText
ad group IDText
campaign IDText
pin IDText
ad nameText
statusText
summary statusText
review statusText
creative typeText
ad typeText
lead form IDText
is pin deletedTrue/false
disclosure typeText
disclosure URLText
destination URLText
click tracking URLText
view tracking URLText
tracking URLsText
rejected reasonsText
rejection labelsText
created timeInteger
updated timeInteger