Snapchat Marketing predefined reports
The Snapchat Marketing data source in Data Integration includes predefined reports. Each report contains a brief description of the data, a list of customizable fields (if applicable), and the schema mapping.
These reports follow a standardized format, so specific fields are locked, and you can only access them through the Custom reports feature.
Source-level selections
Snapchat Marketing has two source-level selections:
- Organizations
- Ad Accounts.
These options filter each report within the river to display only the selected data.
Organizations
The Organizations report pulls a list of the brands, partners, or ad agencies associated with the account and their attributes.
| Field | Data Type | Dimension/Metric |
|---|---|---|
id  | String | Dimension |
| accepted_term_version | String | Dimension |
| administrative_district_level_1 | String | Dimension |
| configuration_settings | Record | Dimension |
| contact_email | String | Dimension |
| contact_name | String | Dimension |
| country | String | Dimension |
| createdByCaller | Boolean | Dimension |
| created_at | String | Dimension |
| address_line_1 | String | Dimension |
| locality | String | Dimension |
| my_display_name | String | Dimension |
| my_invited_email | String | Dimension |
| my_member_id | String | Dimension |
| name | String | Dimension |
| postal_code | String | Dimension |
| roles | String | Dimension |
| state | String | Dimension |
| type | String | Dimension |
| updated_at | String | Dimension |
Ad Accounts
The Ad Accounts report pulls a list of accounts and their attributes.
| Field | Data Type | Dimension/Metric |
|---|---|---|
| id | String | Dimension |
| created_at | String | Dimension |
| currency | String | Dimension |
| name | String | Dimension |
| roles | String | Dimension |
| status | String | Dimension |
| timezone | String | Dimension |
| type | String | Dimension |
| updated_at | String | Dimension |
Campaigns
The Campaigns report pulls a list of campaigns and their attributes.
| Field | Data Type | Dimension/Metric |
|---|---|---|
| id | String | Dimension |
| ad_account_id | String | Dimension |
| buy_model | String | Dimension |
| created_at | String | Dimension |
| delivery_status | String | Dimension |
| name | String | Dimension |
| objective | String | Dimension |
| product_properties | Record | Dimension |
| regulations | Record | Dimension |
| start_time | String | Dimension |
| status | String | Dimension |
| updated_at | String | Dimension |
Ad Squads
The Ad Squads report pulls a list of ad squads and their attributes.
| Field | Data Type | Dimension/Metric |
|---|---|---|
| id | String | Dimension |
| ad_account_id | String | Dimension |
| bid_micro | Integer | Metric |
| bid_strategy | String | Dimension |
| billing_event | String | Dimension |
| campaign_id | String | Dimension |
| created_at | String | Dimension |
| creation_state | String | Dimension |
| daily_budget_micro | Integer | Metric |
| delivery_constraint | String | Dimension |
| delivery_status | String | Dimension |
| auto_bid | Boolean | Dimension |
| name | String | Dimension |
| optimization_goal | String | Dimension |
| pacing_type | String | Dimension |
| pixel_id | String | Dimension |
| placement | String | Dimension |
| product_properties | Record | Dimension |
| start_time | String | Dimension |
| status | String | Dimension |
| target_bid | Boolean | Dimension |
| targeting | Record | Dimension |
| targeting_reach_status | String | Dimension |
| type | String | Dimension |
| updated_at | String | Dimension |
Ads
The Ads report pulls a list of ads and their attributes.
| Field | Data Type | Dimension/Metric |
|---|---|---|
| id | String | Dimension |
| ad_account_id | String | Dimension |
| catalog_properties | Record | Dimension |
| created_at | String | Dimension |
| creative_id | String | Dimension |
| delivery_status | String | Dimension |
| ad_squad_id | String | Dimension |
| name | String | Dimension |
| render_type | String | Dimension |
| review_status | String | Dimension |
| review_status_reasons | String | Dimension |
| status | String | Dimension |
| type | String | Dimension |
| updated_at | String | Dimension |
Audience Filters
The Audience Filters report lists the ways advertisers target Snapchatters based on age, gender, interest groups, and more. You can use two customizations to generate this report, such as the Campaigns filter to filter the output and customize the incremental load type associated with this report.
| Field | Data Type | Dimension/Metric |
|---|---|---|
| organization_id | String | Dimension |
| start_time | String | Dimension |
| ad_id | String | Dimension |
| adsquad_id | String | Dimension |
| campaign_id | String | Dimension |
| account_id | String | Dimension |
| organization_name | String | Dimension |
| end_time_adsquad | String | Dimension |
| finalized_data_end_time_adsquad | String | Dimension |
| granularity | String | Dimension |
| end_time | String | Dimension |
| campaign_name | String | Dimension |
| request_id | String | Dimension |
| request_status | String | Dimension |
| account_name | String | Dimension |
| start_time_adsquad | String | Dimension |
| stats_earned_impressions | Integer | Metric |
| stats_paid_impressions | Integer | Metric |
| stats_saves | Integer | Metric |
| stats_shares | Integer | Metric |
| stats_spend | Integer | Metric |
| stats_uniques | Integer | Metric |
| type | String | Dimension |
Campaign Stats
The Campaign Stats report aggregates metrics at the campaign level. You can use four customizations to generate this report. Use the Campaign filter option to cut down the output and customize the incremental load type associated with this report. The Swipe Up Attribution window and View Attribution window selections are time periods in which a conversion is counted after a user views an ad. By default, Snap’s attribution windows are 28 days post-swipe (Swipe Up Attribution window) and 1 day post-view (View Attribution window).
| Field | Data Type | Dimension/Metric |
|---|---|---|
| account_id | String | Dimension |
| start_time | String | Dimension |
| campaign_id | String | Dimension |
| dimension_stats_conversion_add_billing | Integer | Metric |
| dimension_stats_attachment_total_view_time_millis | Integer | Metric |
| dimension_stats | String | Dimension |
| dimension_stats_conversion_add_cart | Integer | Metric |
| dimension_stats_conversion_app_opens | Integer | Metric |
| dimension_stats_conversion_level_completes | Integer | Metric |
| dimension_stats_conversion_page_views | Integer | Metric |
| dimension_stats_conversion_purchases | Integer | Metric |
| dimension_stats_conversion_purchases_value | Integer | Metric |
| dimension_stats_conversion_save | Integer | Metric |
| dimension_stats_conversion_searches | Integer | Metric |
| dimension_stats_conversion_sign_ups | Integer | Metric |
| dimension_stats_conversion_start_checkout | Integer | Metric |
| dimension_stats_conversion_view_content | Integer | Metric |
| dimension_stats_country | String | Dimension |
| dimension_stats_impressions | Integer | Metric |
| dimension_stats_quartile_1 | Integer | Metric |
| dimension_stats_quartile_2 | Integer | Metric |
| dimension_stats_quartile_3 | Integer | Metric |
| dimension_stats_shares | Integer | Metric |
| dimension_stats_spend | Integer | Metric |
| dimension_stats_swipes | Integer | Metric |
| dimension_stats_total_installs | Integer | Metric |
| dimension_stats_video_views | Integer | Metric |
| dimension_stats_view_completion | Integer | Metric |
| end_time | String | Dimension |
| end_time_campaign | String | Dimension |
| finalized_data_end_time_campaign | String | Dimension |
| granularity | String | Dimension |
| organization_id | String | Dimension |
| organization_name | String | Dimension |
| request_id | String | Dimension |
| request_status | String | Dimension |
| account_name | String | Dimension |
| start_time_campaign | String | Dimension |
| swipe_up_attribution_window | String | Dimension |
| type | String | Dimension |
| view_attribution_window | String | Dimension |
Ad Squad Stats
The Ad Squad Stats report aggregates metrics at the ad squad level. You can use four customizations to generate this report, such as using the Campaign filter option to filter the output and customizing the incremental load type associated with this report. The Swipe Up Attribution Window and View Attribution Window selections are time periods in which a conversion is counted after a user sees an ad. By default, Snap’s attribution windows are 28 days post-swipe (Swipe Up Attribution Window) and 1 day post-view (View Attribution Window).
| Field | Data Type | Dimension/Metric |
|---|---|---|
| account_id | String | Dimension |
| start_time | String | Dimension |
| adsquad_id | String | Dimension |
| campaign_id | String | Dimension |
| organization_id | String | Dimension |
| dimension_stats_attachment_total_view_time_millis | Integer | Metric |
| dimension_stats_conversion_add_billing | Integer | Metric |
| dimension_stats_conversion_add_cart | Integer | Metric |
| dimension_stats_conversion_app_opens | Integer | Metric |
| dimension_stats_conversion_level_completes | Integer | Metric |
| dimension_stats_conversion_page_views | Integer | Metric |
| dimension_stats_conversion_purchases | Integer | Metric |
| dimension_stats_conversion_purchases_value | Integer | Metric |
| dimension_stats_conversion_save | Integer | Metric |
| dimension_stats_conversion_searches | Integer | Metric |
| dimension_stats_conversion_sign_ups | Integer | Metric |
| dimension_stats_conversion_start_checkout | Integer | Metric |
| dimension_stats_conversion_view_content | Integer | Metric |
| dimension_stats_country | String | Dimension |
| dimension_stats_impressions | Integer | Metric |
| dimension_stats_quartile_1 | Integer | Metric |
| dimension_stats_quartile_2 | Integer | Metric |
| dimension_stats_quartile_3 | Integer | Metric |
| dimension_stats_shares | Integer | Metric |
| dimension_stats_spend | Integer | Metric |
| dimension_stats_swipes | Integer | Metric |
| dimension_stats_total_installs | Integer | Metric |
| dimension_stats_video_views | Integer | Metric |
| dimension_stats_view_completion | Integer | Metric |
| end_time | String | Dimension |
| end_time_campaign | String | Dimension |
| finalized_data_end_time_campaign | String | Dimension |
| granularity | String | Dimension |
| dimension_stats | String | Dimension |
| organization_name | String | Dimension |
| request_id | String | Dimension |
| request_status | String | Dimension |
| account_name | String | Dimension |
| start_time_campaign | String | Dimension |
| swipe_up_attribution_window | String | Dimension |
| type | String | Dimension |
| view_attribution_window | String | Dimension |
Ad Stats
The Ad Stats report aggregates metrics at the ad level. You can use four customizations that the user can make to this report, such as using the Campaign filter option to filter the output and customizing the incremental load type associated with this report. The Swipe Up Attribution Window and View Attribution Window selections are time periods in which a conversion is counted after a user sees an ad. By default, Snap’s attribution windows are 28 days post-swipe (Swipe Up Attribution Window) and 1 day post-view (View Attribution Window).
| Field | Data Type | Dimension/Metric |
|---|---|---|
| account_id | String | Dimension |
| start_time | String | Dimension |
| ad_id | String | Dimension |
| campaign_id | String | Dimension |
| organization_id | String | Dimension |
| dimension_stats_attachment_total_view_time_millis | Integer | Metric |
| dimension_stats_conversion_add_billing | Integer | Metric |
| dimension_stats_conversion_add_cart | Integer | Metric |
| dimension_stats_conversion_app_opens | Integer | Metric |
| dimension_stats_conversion_level_completes | Integer | Metric |
| dimension_stats_conversion_page_views | Integer | Metric |
| dimension_stats_conversion_purchases | Integer | Metric |
| dimension_stats_conversion_purchases_value | Integer | Metric |
| dimension_stats_conversion_save | Integer | Metric |
| dimension_stats_conversion_searches | Integer | Metric |
| dimension_stats_conversion_sign_ups | Integer | Metric |
| dimension_stats_conversion_start_checkout | Integer | Metric |
| dimension_stats_conversion_view_content | Integer | Metric |
| dimension_stats_country | String | Dimension |
| dimension_stats_impressions | Integer | Metric |
| dimension_stats_quartile_1 | Integer | Metric |
| dimension_stats_quartile_2 | Integer | Metric |
| dimension_stats_quartile_3 | Integer | Metric |
| dimension_stats_shares | Integer | Metric |
| dimension_stats_spend | Integer | Metric |
| dimension_stats_swipes | Integer | Metric |
| dimension_stats_total_installs | Integer | Metric |
| dimension_stats_video_views | Integer | Metric |
| dimension_stats_view_completion | Integer | Metric |
| end_time | String | Dimension |
| end_time_campaign | String | Dimension |
| finalized_data_end_time_campaign | String | Dimension |
| granularity | String | Dimension |
| dimension_stats | String | Dimension |
| organization_name | String | Dimension |
| request_id | String | Dimension |
| request_status | String | Dimension |
| account_name | String | Dimension |
| start_time_campaign | String | Dimension |
| swipe_up_attribution_window | String | Dimension |
| type | String | Dimension |
| view_attribution_window | String | Dimension |
