Snapchat Marketing Predefined Reports

Predefined Reports

The Snapchat Marketing datasource in Rivery comes with the below predefined reports. Each report will have a short description of the data, a list of customizable fields (if any), and the schema mapping. Due to the standardized nature of these reports, there are a number of locked fields that will only be accessible through the custom reporting functionality.

Source-Level Selections

Snapchat Marketing has two source-level selections: Organizations and Ad Accounts. These options will filter down each report within the river to only the selected data.

Organizations

The Organizations report pulls a list of the brands, partners, or ad agencies assoiciated 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 ways advertisers are targeting Snapchatters based on age, gender, interest groups and more. There are two customizations the user can make to this report. They can use the Campaigns filter to cut down the output and can customize the type of incremental load 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 agreggates metrics at the campaign level. There are four customizations the user can make to this report. They can use the Campaign filter option to cut down the output and can customize the type of incremental load associated with this report. The Swipe Up Attribution Window and View Attribution Window selections are time periods in which a conversion will be 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
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 agreggates metrics at the ad squad level. There are four customizations the user can make to this report. They can use the Campaign filter option to cut down the output and can customize the type of incremental load associated with this report. The Swipe Up Attribution Window and View Attribution Window selections are time periods in which a conversion will be 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 agreggates metrics at the ad level. There are four customizations the user can make to this report. They can use the Campaign filter option to cut down the output and can customize the type of incremental load associated with this report. The Swipe Up Attribution Window and View Attribution Window selections are time periods in which a conversion will be 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