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.
| Field | Type |
|---|---|
| account ID | Text |
| account name | Text |
| advertiser | Text |
| organization ID | Text |
| organization name | Text |
| currency | Text |
| timezone | Text |
| status | Text |
| account type | Text |
| delivery status | Text |
| billing type | Text |
| is test | True/false |
| created at | Timestamp |
| updated at | Timestamp |
Campaigns#
Snapchat campaign hierarchy, objective, budget, lifecycle, and deletion state.
| Field | Type |
|---|---|
| account ID | Text |
| campaign ID | Text |
| campaign name | Text |
| status | Text |
| objective | Text |
| objective v2 properties | Text |
| daily budget | Number |
| lifetime spend cap | Number |
| pacing level | Text |
| start time | Timestamp |
| end time | Timestamp |
| is deleted | True/false |
| created at | Timestamp |
| updated at | Timestamp |
Ad squads#
Snapchat ad-squad hierarchy, placement, optimization, bid, budget, and targeting context.
| Field | Type |
|---|---|
| account ID | Text |
| campaign ID | Text |
| ad squad ID | Text |
| ad squad name | Text |
| status | Text |
| ad squad type | Text |
| placement | Text |
| optimization goal | Text |
| bid strategy | Text |
| bid | Number |
| daily budget | Number |
| lifetime budget | Number |
| billing event | Text |
| conversion window | Text |
| pixel ID | Text |
| event sources | Text |
| targeting | Text |
| start time | Timestamp |
| end time | Timestamp |
| is deleted | True/false |
| created at | Timestamp |
| updated 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#
Snapchat ad and creative-reference hierarchy, review, lifecycle, and deletion state.
| Field | Type |
|---|---|
| account ID | Text |
| ad squad ID | Text |
| ad ID | Text |
| ad name | Text |
| creative ID | Text |
| status | Text |
| ad type | Text |
| render type | Text |
| review status | Text |
| review status reasons | Text |
| delivery status | Text |
| start time | Timestamp |
| end time | Timestamp |
| is deleted | True/false |
| created at | Timestamp |
| updated at | Timestamp |
Ad insights#
Daily Snapchat delivery, engagement, video, install, lead, and conversion facts at ad grain.
| Field | Type |
|---|---|
| account ID | Text |
| account name | Text |
| date | Date |
| campaign ID | Text |
| campaign name | Text |
| ad squad ID | Text |
| ad squad name | Text |
| ad ID | Text |
| ad name | Text |
| creative ID | Text |
| currency | Text |
| reporting timezone | Text |
| swipe up attribution window | Text |
| view attribution window | Text |
| action report time | Text |
| finalized data end time | Timestamp |
| conversion data processed end time | Timestamp |
| impressions | Integer |
| paid impressions | Integer |
| earned impressions | Integer |
| total impressions | Integer |
| swipes | Integer |
| spend | Number |
| uniques | Integer |
| frequency | Number |
| screen time millis | Integer |
| avg screen time millis | Integer |
| video views | Integer |
| video views time based | Integer |
| video views 5s | Integer |
| video views 15s | Integer |
| quartile 1 | Integer |
| quartile 2 | Integer |
| quartile 3 | Integer |
| view completion | Integer |
| landing page views | Integer |
| profile clicks | Integer |
| shares | Integer |
| saves | Integer |
| native leads | Integer |
| total installs | Integer |
| android installs | Integer |
| ios installs | Integer |
| conversion purchases | Integer |
| conversion purchases value | Number |
| conversion add cart | Integer |
| conversion add cart value | Number |
| conversion view content | Integer |
| conversion view content value | Number |
| conversion start checkout | Integer |
| conversion start checkout value | Number |
| conversion signups | Integer |
| conversion signups value | Number |
| conversion page views | Integer |
| conversion page views value | Number |
| conversion subscribe | Integer |
| conversion subscribe value | Number |
| conversion start trial | Integer |
| conversion start trial value | Number |
Custom conversions#
Snapchat custom-conversion definitions discovered from account-visible Pixels and Snap Apps.
| Field | Type |
|---|---|
| definition key | Text |
| account ID | Text |
| custom conversion ID | Text |
| custom conversion name | Text |
| description | Text |
| event type | Text |
| event source ID | Text |
| event source type | Text |
| rules | Text |
| created at | Timestamp |
| updated at | Timestamp |
Custom conversion actions daily#
Daily Snapchat custom-conversion counts and values at ad grain, including total/swipe/view components.
| Field | Type |
|---|---|
| action key | Text |
| account ID | Text |
| account name | Text |
| date | Date |
| campaign ID | Text |
| campaign name | Text |
| ad squad ID | Text |
| ad squad name | Text |
| ad ID | Text |
| ad name | Text |
| creative ID | Text |
| custom conversion ID | Text |
| custom conversion name | Text |
| event type | Text |
| attribution component | Text |
| conversions | Integer |
| conversion value | Number |
| currency | Text |
| swipe up attribution window | Text |
| view attribution window | Text |
| action report time | Text |
Conversion report coverage daily#
Successful Snapchat native conversion-report coverage, including zero-row account-days.
| 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 |
Targeting performance weekly#
Independent weekly campaign demographic, device, and region delivery with provider-deduplicated reach.
| Field | Type |
|---|---|
| account ID | Text |
| account name | Text |
| week start date | Date |
| week end date | Date |
| breakdown type | Text |
| campaign ID | Text |
| campaign name | Text |
| age bucket | Text |
| gender | Text |
| operating system | Text |
| country | Text |
| region | Text |
| impressions | Integer |
| swipes | Integer |
| spend | Number |
| uniques | Integer |
| frequency | Number |
| conversion purchases | Integer |
| conversion purchases value | Number |
| currency | Text |
| reporting timezone | Text |
| swipe up attribution window | Text |
| view attribution window | Text |
| action report time | Text |
| finalized data end time | Timestamp |
| conversion data processed end time | Timestamp |
Targeting performance daily#
Daily campaign country, region, and DMA delivery insights; conversion columns populated for country only and NULL for delivery-only region/dma.
| Field | Type |
|---|---|
| account ID | Text |
| account name | Text |
| date | Date |
| breakdown type | Text |
| campaign ID | Text |
| campaign name | Text |
| country | Text |
| region | Text |
| dma | Text |
| impressions | Integer |
| swipes | Integer |
| spend | Number |
| uniques | Integer |
| video views | Integer |
| view completion | Integer |
| conversion purchases | Integer |
| conversion purchases value | Number |
| currency | Text |
| reporting timezone | Text |
| swipe up attribution window | Text |
| view attribution window | Text |
| action report time | Text |
| finalized data end time | Timestamp |
| conversion data processed end time | Timestamp |