Snapchat Marketing Predefined Reports
  • 6 Minutes to read
  • Dark
    Light
  • PDF

Snapchat Marketing Predefined Reports

  • Dark
    Light
  • PDF

Article summary

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.

FieldData TypeDimension/Metric
id system schemaStringDimension
accepted_term_versionStringDimension
administrative_district_level_1StringDimension
configuration_settingsRecordDimension
contact_emailStringDimension
contact_nameStringDimension
countryStringDimension
createdByCallerBooleanDimension
created_atStringDimension
address_line_1StringDimension
localityStringDimension
my_display_nameStringDimension
my_invited_emailStringDimension
my_member_idStringDimension
nameStringDimension
postal_codeStringDimension
rolesStringDimension
stateStringDimension
typeStringDimension
updated_atStringDimension

Ad Accounts

The Ad Accounts report pulls a list of accounts and their attributes.

FieldData TypeDimension/Metric
id system schemaStringDimension
created_atStringDimension
currencyStringDimension
nameStringDimension
rolesStringDimension
statusStringDimension
timezoneStringDimension
typeStringDimension
updated_atStringDimension

Campaigns

The Campaigns report pulls a list of campaigns and their attributes.

FieldData TypeDimension/Metric
id system schemaStringDimension
ad_account_idStringDimension
buy_modelStringDimension
created_atStringDimension
delivery_statusStringDimension
nameStringDimension
objectiveStringDimension
product_propertiesRecordDimension
regulationsRecordDimension
start_timeStringDimension
statusStringDimension
updated_atStringDimension

Ad Squads

The Ad Squads report pulls a list of ad squads and their attributes.

FieldData TypeDimension/Metric
id system schemaStringDimension
ad_account_idStringDimension
bid_microIntegerMetric
bid_strategyStringDimension
billing_eventStringDimension
campaign_idStringDimension
created_atStringDimension
creation_stateStringDimension
daily_budget_microIntegerMetric
delivery_constraintStringDimension
delivery_statusStringDimension
auto_bidBooleanDimension
nameStringDimension
optimization_goalStringDimension
pacing_typeStringDimension
pixel_idStringDimension
placementStringDimension
product_propertiesRecordDimension
start_timeStringDimension
statusStringDimension
target_bidBooleanDimension
targetingRecordDimension
targeting_reach_statusStringDimension
typeStringDimension
updated_atStringDimension

Ads

The Ads report pulls a list of ads and their attributes.

FieldData TypeDimension/Metric
id system schemaStringDimension
ad_account_idStringDimension
catalog_propertiesRecordDimension
created_atStringDimension
creative_idStringDimension
delivery_statusStringDimension
ad_squad_idStringDimension
nameStringDimension
render_typeStringDimension
review_statusStringDimension
review_status_reasonsStringDimension
statusStringDimension
typeStringDimension
updated_atStringDimension

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.

FieldData TypeDimension/Metric
organization_id system schemaStringDimension
start_time system schemaStringDimension
ad_id system schemaStringDimension
adsquad_id system schemaStringDimension
campaign_id system schemaStringDimension
account_id system schemaStringDimension
organization_nameStringDimension
end_time_adsquadStringDimension
finalized_data_end_time_adsquadStringDimension
granularityStringDimension
end_timeStringDimension
campaign_nameStringDimension
request_idStringDimension
request_statusStringDimension
account_nameStringDimension
start_time_adsquadStringDimension
stats_earned_impressionsIntegerMetric
stats_paid_impressionsIntegerMetric
stats_savesIntegerMetric
stats_sharesIntegerMetric
stats_spendIntegerMetric
stats_uniquesIntegerMetric
typeStringDimension

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).

FieldData TypeDimension/Metric
account_id system schemaStringDimension
start_time system schemaStringDimension
campaign_id system schemaStringDimension
dimension_stats_conversion_add_billingIntegerMetric
dimension_stats_attachment_total_view_time_millisIntegerMetric
dimension_statsStringDimension
dimension_stats_conversion_add_cartIntegerMetric
dimension_stats_conversion_app_opensIntegerMetric
dimension_stats_conversion_level_completesIntegerMetric
dimension_stats_conversion_page_viewsIntegerMetric
dimension_stats_conversion_purchasesIntegerMetric
dimension_stats_conversion_purchases_valueIntegerMetric
dimension_stats_conversion_saveIntegerMetric
dimension_stats_conversion_searchesIntegerMetric
dimension_stats_conversion_sign_upsIntegerMetric
dimension_stats_conversion_start_checkoutIntegerMetric
dimension_stats_conversion_view_contentIntegerMetric
dimension_stats_countryStringDimension
dimension_stats_impressionsIntegerMetric
dimension_stats_quartile_1IntegerMetric
dimension_stats_quartile_2IntegerMetric
dimension_stats_quartile_3IntegerMetric
dimension_stats_sharesIntegerMetric
dimension_stats_spendIntegerMetric
dimension_stats_swipesIntegerMetric
dimension_stats_total_installsIntegerMetric
dimension_stats_video_viewsIntegerMetric
dimension_stats_view_completionIntegerMetric
end_timeStringDimension
end_time_campaignStringDimension
finalized_data_end_time_campaignStringDimension
granularityStringDimension
organization_idStringDimension
organization_nameStringDimension
request_idStringDimension
request_statusStringDimension
account_nameStringDimension
start_time_campaignStringDimension
swipe_up_attribution_windowStringDimension
typeStringDimension
view_attribution_windowStringDimension

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).

FieldData TypeDimension/Metric
account_id system schemaStringDimension
start_time system schemaStringDimension
adsquad_id system schemaStringDimension
campaign_id system schemaStringDimension
organization_id system schemaStringDimension
dimension_stats_attachment_total_view_time_millisIntegerMetric
dimension_stats_conversion_add_billingIntegerMetric
dimension_stats_conversion_add_cartIntegerMetric
dimension_stats_conversion_app_opensIntegerMetric
dimension_stats_conversion_level_completesIntegerMetric
dimension_stats_conversion_page_viewsIntegerMetric
dimension_stats_conversion_purchasesIntegerMetric
dimension_stats_conversion_purchases_valueIntegerMetric
dimension_stats_conversion_saveIntegerMetric
dimension_stats_conversion_searchesIntegerMetric
dimension_stats_conversion_sign_upsIntegerMetric
dimension_stats_conversion_start_checkoutIntegerMetric
dimension_stats_conversion_view_contentIntegerMetric
dimension_stats_countryStringDimension
dimension_stats_impressionsIntegerMetric
dimension_stats_quartile_1IntegerMetric
dimension_stats_quartile_2IntegerMetric
dimension_stats_quartile_3IntegerMetric
dimension_stats_sharesIntegerMetric
dimension_stats_spendIntegerMetric
dimension_stats_swipesIntegerMetric
dimension_stats_total_installsIntegerMetric
dimension_stats_video_viewsIntegerMetric
dimension_stats_view_completionIntegerMetric
end_timeStringDimension
end_time_campaignStringDimension
finalized_data_end_time_campaignStringDimension
granularityStringDimension
dimension_statsStringDimension
organization_nameStringDimension
request_idStringDimension
request_statusStringDimension
account_nameStringDimension
start_time_campaignStringDimension
swipe_up_attribution_windowStringDimension
typeStringDimension
view_attribution_windowStringDimension

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).

FieldData TypeDimension/Metric
account_id system schemaStringDimension
start_time system schemaStringDimension
ad_id system schemaStringDimension
campaign_id system schemaStringDimension
organization_id system schemaStringDimension
dimension_stats_attachment_total_view_time_millisIntegerMetric
dimension_stats_conversion_add_billingIntegerMetric
dimension_stats_conversion_add_cartIntegerMetric
dimension_stats_conversion_app_opensIntegerMetric
dimension_stats_conversion_level_completesIntegerMetric
dimension_stats_conversion_page_viewsIntegerMetric
dimension_stats_conversion_purchasesIntegerMetric
dimension_stats_conversion_purchases_valueIntegerMetric
dimension_stats_conversion_saveIntegerMetric
dimension_stats_conversion_searchesIntegerMetric
dimension_stats_conversion_sign_upsIntegerMetric
dimension_stats_conversion_start_checkoutIntegerMetric
dimension_stats_conversion_view_contentIntegerMetric
dimension_stats_countryStringDimension
dimension_stats_impressionsIntegerMetric
dimension_stats_quartile_1IntegerMetric
dimension_stats_quartile_2IntegerMetric
dimension_stats_quartile_3IntegerMetric
dimension_stats_sharesIntegerMetric
dimension_stats_spendIntegerMetric
dimension_stats_swipesIntegerMetric
dimension_stats_total_installsIntegerMetric
dimension_stats_video_viewsIntegerMetric
dimension_stats_view_completionIntegerMetric
end_timeStringDimension
end_time_campaignStringDimension
finalized_data_end_time_campaignStringDimension
granularityStringDimension
dimension_statsStringDimension
organization_nameStringDimension
request_idStringDimension
request_statusStringDimension
account_nameStringDimension
start_time_campaignStringDimension
swipe_up_attribution_windowStringDimension
typeStringDimension
view_attribution_windowStringDimension

Was this article helpful?