Snapchat Integration Extractor Info

Snapchat Extractor Document

snapchat.png

INTEGRATION OVERVIEW

Snapchat is a microblogging and social networking service on which users post and interact with messages, and also where clients can advertise on and use to redirect in order to generate sales. The Daasity Snapchat integration extracts data from the marketing endpoints needed to populate the UMS table.

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

 

Was this article helpful?
0 out of 0 found this helpful