Snapchat Extractor Documentation

Snapchat is a microblogging and social networking service on which users post and interact with messages. Merchants can advertise on and use Snapchat to redirect, to generate sales.

 

Snapchat Integration Extractor Info​EXTRACTION OVERVIEW

The Daasity Snapchat integration extracts data from the marketing endpoints needed to populate the UMS table.

 

 

 

Key Topics

Integration Availability

This integration is available for:

  • Growth
  • Pro V1
  • Pro V2

ERD EMBED

ENDPOINT: Snapchat

All Snapchat Marketing Endpoints can be found: https://developers.snapchat.com/api/docs/#introduction

  • Organizations
  • Ad Accounts
  • Campaigns
  • Ad Squads
  • Ads
  • Media
  • Creatives
  • Measurement

Organizations TABLE

Data Mapping.

JSON Element  Database Column Datatype
id organization_id VARCHAR(255)
name organization_name VARCHAR(255)
type type VARCHAR(255)
created_at created_at TIMESTAMP
updated_at updated_at TIMESTAMP
address_line_1 address_line_1 VARCHAR(255)
locality locality VARCHAR(255)
administrative_district_level_1 administrative_district_level_1 VARCHAR(64)
country country VARCHAR(64)
postal_code postal_code VARCHAR(64)


Business Rules.

Business Rule Value
Load Type UPSERT
Extraction Frequency Daily
Sync Key organization_id

​Ad Accounts TABLE

Data Mapping.

JSON Element  Database Column Datatype
id ad_account_id VARCHAR(255)
name ad_account_name VARCHAR(255)
type type VARCHAR(255)
status status VARCHAR(255)
created_at created_at TIMESTAMP
updated_at updated_at TIMESTAMP
organization_id organization_id VARCHAR(255)
currency currency VARCHAR(64)
timezone timezone VARCHAR(64)
advertiser_organization_id advertiser VARCHAR(64)


Business Rules.

 
Business Rule Value
Load Type UPSERT
Extraction Frequency Daily
Sync Key ad_account_id & organization_id

​Campaigns TABLE

Data Mapping.

JSON Element  Database Column Datatype
id campaign_id VARCHAR(255)
name campaign_name VARCHAR(255)
status status VARCHAR(255)
ad_account_id ad_account_id TIMESTAMP
created_at created_at TIMESTAMP
updated_at updated_at TIMESTAMP
start_time start_time TIMESTAMP
end_time end_time TIMESTAMP
daily_budget_micro daily_budget_micro BIGINT


Business Rules.

Business Rule Value
Load Type UPSERT
Extraction Frequency Daily
Sync Key campaign_id & organization_id

Ad Squads TABLE

Data Mapping.

JSON Element  Database Column Datatype
id organization_id VARCHAR(255)
name organization_name VARCHAR(255)
type type VARCHAR(255)
status status VARCHAR(255)
campaign_id campaign_id VARCHAR(255)
created_at created_at TIMESTAMP
updated_at updated_at TIMESTAMP
placement_v2_config placement_v2_config VARCHAR(255)
billing_event billing_event VARCHAR(255)
auto_bid auto_bid BOOLEAN
target_bid target_bid BOOLEAN
bid_strategy bid_strategy VARCHAR(255)
daily_budget_micro daily_budget_micro BIGINT
start_time start_time TIMESTAMP
optimization_goal optimization_goal VARCHAR(255)


Business Rules.

Business Rule Value
Load Type UPSERT
Extraction Frequency Daily
Sync Key ad_squad_id & organization_id

​Ads TABLE

Data Mapping.

JSON Element  Database Column Datatype
id ad_id VARCHAR(255)
name ad_name VARCHAR(255)
type type VARCHAR(255)
status status VARCHAR(255)
created_at created_at TIMESTAMP
updated_at updated_at TIMESTAMP
ad_squad_id ad_squad_id VARCHAR(255)
creative_id creative_id VARCHAR(255)


Business Rules.

Business Rule Value
Load Type UPSERT
Extraction Frequency Daily
Sync Key ad_id & organization_id

Media TABLE

Data Mapping.

JSON Element  Database Column Datatype
id ad_id VARCHAR(255)
name ad_name VARCHAR(255)
type type VARCHAR(255)
media_status status VARCHAR(255)
created_at created_at TIMESTAMP
updated_at updated_at TIMESTAMP
file_name file_name VARCHAR(255)
ad_account_id ad_account_id VARCHAR(255)

Business Rules.

Business Rule Value
Load Type UPSERT
Extraction Frequency Daily
Sync Key media_id & organization_id

Creatives TABLE

Data Mapping.

JSON Element  Database Column Datatype
id creative_id VARCHAR(255)
name creative_name VARCHAR(255)
type type VARCHAR(255)
packaging_status packaging_status VARCHAR(255)
review_status review_status VARCHAR(255)
created_at created_at TIMESTAMP
updated_at updated_at TIMESTAMP
shareable shareable BOOLEAN
call_to_action call_to_action VARCHAR(255)
top_snap_media_id top_snap_media_id VARCHAR(255)
top_snap_crop_position top_snap_crop_position VARCHAR(255)
longform_video_properties.video_media_id longform_video_media_id VARCHAR(255)
app_install_properties.app_name install_app_name VARCHAR(255)
app_install_properties.ios_app_id install_ios_app_id VARCHAR(255)
app_install_properties.android_app_url install_android_app_url VARCHAR(255)
app_install_properties.icon_media_id install_app_icon_media_id VARCHAR(255)
web_view_properties.url web_view_url VARCHAR(255)
ad_account_id ad_account_id VARCHAR(255)


Business Rules.

Business Rule Value
Load Type UPSERT
Extraction Frequency Daily
Sync Key creative_id & organization_id

Measurement TABLE

Data Mapping.

JSON Element  Database Column Datatype
sync key measurement_id VARCHAR(255)
timeseries_stat.id campaign_id VARCHAR(255)
swipe_up_attribution_window swipe_up_attribution_window VARCHAR(64)
view_attribution_window view_attribution_window VARCHAR(64)
granularity granularity VARCHAR(64)
start_time start_time TIMESTAMP
end_time end_time TIMESTAMP
ad_id ad_id VARCHAR(255)
impressions impressions BIGINT
swipes swipes BIGINT
quartile_1 quartile_1 BIGINT
quartile_2 quartile_2 BIGINT
quartile_3 quartile_3 BIGINT
view_completion view_completion BIGINT
attachment_quartile_1 attachment_quartile_1 BIGINT
attachment_quartile_2 attachment_quartile_2 BIGINT
attachment_quartile_3 attachment_quartile_3 BIGINT
attachment_view_completion attachment_view_completion BIGINT
attachment_total_view_time_millis attachment_total_view_time_millis BIGINT
spend spend BIGINT
video_views video_views BIGINT
shares shares BIGINT
saves saves BIGINT
story_opens story_opens BIGINT
story_completes story_completes BIGINT
attachment_video_views attachment_video_views BIGINT
total_installs total_installs BIGINT
conversion_purchases conversion_purchases BIGINT
conversion_purchases_value conversion_purchases_value BIGINT
conversion_save conversion_save BIGINT
conversion_start_checkout conversion_start_checkout BIGINT
conversion_add_cart conversion_add_cart BIGINT
conversion_view_content conversion_view_content BIGINT
conversion_add_billing conversion_add_billing BIGINT
conversion_sign_ups conversion_sign_ups BIGINT
conversion_searches conversion_searches BIGINT
conversion_level_completes conversion_level_completes BIGINT
conversion_app_opens conversion_app_opens BIGINT
conversion_page_views conversion_page_views BIGINT


Business Rules.

Business Rule Value
Load Type UPSERT
Extraction Frequency Daily
Sync Key campaign_id & swipe_up_attribution_window & view_attribution_window& granularity & start_time & ad_id & organization_id