Integrations

Snapchat Ads datasets and fields

The 11 datasets Maven lands from Snapchat Ads, every field in them, and how the connection syncs.

Maven lands 11 datasets from Snapchat Ads in each client workspace. This page lists every one with all of its fields. For the metrics, reports and setup steps, see the Snapchat Ads integration page.

Connection and sync#

You connect Snapchat Ads by signing in to it and approving access, so nobody shares a password.

The first Snapchat 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#

Snapchat ad-account identity, organization, currency, timezone, and lifecycle context.

FieldType
account IDText
account nameText
advertiserText
organization IDText
organization nameText
currencyText
timezoneText
statusText
account typeText
delivery statusText
billing typeText
is testTrue/false
created atTimestamp
updated atTimestamp

Campaigns#

Snapchat campaign hierarchy, objective, budget, lifecycle, and deletion state.

FieldType
account IDText
campaign IDText
campaign nameText
statusText
objectiveText
objective v2 propertiesText
daily budgetNumber
lifetime spend capNumber
pacing levelText
start timeTimestamp
end timeTimestamp
is deletedTrue/false
created atTimestamp
updated atTimestamp

Ad squads#

Snapchat ad-squad hierarchy, placement, optimization, bid, budget, and targeting context.

FieldType
account IDText
campaign IDText
ad squad IDText
ad squad nameText
statusText
ad squad typeText
placementText
optimization goalText
bid strategyText
bidNumber
daily budgetNumber
lifetime budgetNumber
billing eventText
conversion windowText
pixel IDText
event sourcesText
targetingText
start timeTimestamp
end timeTimestamp
is deletedTrue/false
created atTimestamp
updated atTimestamp

Configured target coverage#

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

Ads#

Snapchat ad and creative-reference hierarchy, review, lifecycle, and deletion state.

FieldType
account IDText
ad squad IDText
ad IDText
ad nameText
creative IDText
statusText
ad typeText
render typeText
review statusText
review status reasonsText
delivery statusText
start timeTimestamp
end timeTimestamp
is deletedTrue/false
created atTimestamp
updated atTimestamp

Ad insights#

Daily Snapchat delivery, engagement, video, install, lead, and conversion facts at ad grain.

FieldType
account IDText
account nameText
dateDate
campaign IDText
campaign nameText
ad squad IDText
ad squad nameText
ad IDText
ad nameText
creative IDText
currencyText
reporting timezoneText
swipe up attribution windowText
view attribution windowText
action report timeText
finalized data end timeTimestamp
conversion data processed end timeTimestamp
impressionsInteger
paid impressionsInteger
earned impressionsInteger
total impressionsInteger
swipesInteger
spendNumber
uniquesInteger
frequencyNumber
screen time millisInteger
avg screen time millisInteger
video viewsInteger
video views time basedInteger
video views 5sInteger
video views 15sInteger
quartile 1Integer
quartile 2Integer
quartile 3Integer
view completionInteger
landing page viewsInteger
profile clicksInteger
sharesInteger
savesInteger
native leadsInteger
total installsInteger
android installsInteger
ios installsInteger
conversion purchasesInteger
conversion purchases valueNumber
conversion add cartInteger
conversion add cart valueNumber
conversion view contentInteger
conversion view content valueNumber
conversion start checkoutInteger
conversion start checkout valueNumber
conversion signupsInteger
conversion signups valueNumber
conversion page viewsInteger
conversion page views valueNumber
conversion subscribeInteger
conversion subscribe valueNumber
conversion start trialInteger
conversion start trial valueNumber

Custom conversions#

Snapchat custom-conversion definitions discovered from account-visible Pixels and Snap Apps.

FieldType
definition keyText
account IDText
custom conversion IDText
custom conversion nameText
descriptionText
event typeText
event source IDText
event source typeText
rulesText
created atTimestamp
updated atTimestamp

Custom conversion actions daily#

Daily Snapchat custom-conversion counts and values at ad grain, including total/swipe/view components.

FieldType
action keyText
account IDText
account nameText
dateDate
campaign IDText
campaign nameText
ad squad IDText
ad squad nameText
ad IDText
ad nameText
creative IDText
custom conversion IDText
custom conversion nameText
event typeText
attribution componentText
conversionsInteger
conversion valueNumber
currencyText
swipe up attribution windowText
view attribution windowText
action report timeText

Conversion report coverage daily#

Successful Snapchat native conversion-report coverage, including zero-row account-days.

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

Targeting performance weekly#

Independent weekly campaign demographic, device, and region delivery with provider-deduplicated reach.

FieldType
account IDText
account nameText
week start dateDate
week end dateDate
breakdown typeText
campaign IDText
campaign nameText
age bucketText
genderText
operating systemText
countryText
regionText
impressionsInteger
swipesInteger
spendNumber
uniquesInteger
frequencyNumber
conversion purchasesInteger
conversion purchases valueNumber
currencyText
reporting timezoneText
swipe up attribution windowText
view attribution windowText
action report timeText
finalized data end timeTimestamp
conversion data processed end timeTimestamp

Targeting performance daily#

Daily campaign country, region, and DMA delivery insights; conversion columns populated for country only and NULL for delivery-only region/dma.

FieldType
account IDText
account nameText
dateDate
breakdown typeText
campaign IDText
campaign nameText
countryText
regionText
dmaText
impressionsInteger
swipesInteger
spendNumber
uniquesInteger
video viewsInteger
view completionInteger
conversion purchasesInteger
conversion purchases valueNumber
currencyText
reporting timezoneText
swipe up attribution windowText
view attribution windowText
action report timeText
finalized data end timeTimestamp
conversion data processed end timeTimestamp