Integration Specifications
This page will help you learn about how Daasity replicates data from Snapchat, limitations to the data we can extract and where the data is stored in the Snapchat schema.
Integration Overview
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 and generate sales.
The Daasity Snapchat integration extracts data from the marketing endpoints needed to populate the UMS table.
Integration Availability
This integration is available for:
Enterprise
Growth
API Endpoints
The Daasity Snapchat extractor is built based on this Snapchat Marketing API documentation. The following endpoints are used by Daasity to replicate data from Snapchat:
Entity Relationship Diagram (ERD)
Click here to view the ERD for the Daasity Snapchat integration illustrating the different tables and keys to join across tables.
Snapchat Schema
The Daasity Snapchat extractor creates these tables using the endpoints and replication methods listed. The data is mapped from the source API endpoint to the table based on the mapping logic outlined in each table.
Organizations
Endpoint: Organizations
Update Method: UPSERT
Table Name: [
snapchat.organizations]
id
organization_id
name
organization_name
type
type
created_at
created_at
updated_at
updated_at
locality
locality
administrative_district_level_1
administrative_district_level_1
country
country
postal_code
postal_code
MD5(id)
__sync_key
Ad Accounts
Endpoint: Ad Accounts
Update Method: UPSERT
Table Name: [
snapchat.ad_accounts]
id
ad_account_id
name
ad_account_name
type
type
status
status
created_at
created_at
updated_at
updated_at
organization_id
organization_id
currency
currency
timezone
timezone
advertiser_organization_id
advertiser_organization_id
MD5(id + organization_id)
__sync_key
Campaigns
Endpoint: Campaigns
Update Method: UPSERT
Table Name: [
snapchat.campaigns]
id
campaign_id
name
campaign_name
status
status
ad_account_id
ad_account_id
created_at
created_at
updated_at
updated_at
start_time
start_time
end_time
end_time
daily_budget_micro
daily_budget_micro
MD5(id + organization_id)
__sync_key
Ad Squads
Endpoint: Ad Squads
Update Method: UPSERT
Table Name: [
snapchat.adsquads]
id
adsquad_id
name
adsquad_name
type
type
status
status
campaign_id
campaign_id
created_at
created_at
updated_at
updated_at
placement
placement
billing_event
billing_event
auto_bid
auto_bid
target_bid
target_bid
bid_strategy
bid_strategy
daily_budget_micro
daily_budget_micro
optimization_goal
optimization_goal
MD5(id + organization_id)
__sync_key
Ads
Endpoint: Ads
Update Method: UPSERT
Table Name: [
snapchat.ads]
id
ad_id
name
ad_name
type
type
status
status
created_at
created_at
updated_at
updated_at
ad_squad_id
ad_squad_id
creative_id
creative_id
MD5(id + organization_id)
__sync_key
Media
Endpoint: Media
Update Method: UPSERT
Table Name: [
snapchat.media]
id
media_id
name
media_name
type
type
status
status
created_at
created_at
updated_at
updated_at
file_name
file_name
ad_account_id
ad_account_id
MD5(id + organization_id)
__sync_key
Creatives
Endpoint: Creatives
Update Method: UPSERT
Table Name: [
snapchat.creatives]
id
creative_id
name
creative_name
type
type
packaging_status
packaging_status
review_status
review_status
created_at
created_at
updated_at
updated_at
shareable
shareable
call_to_action
call_to_action
top_snap_media_id
top_snap_media_id
top_snap_crop_position
top_snap_crop_position
longform_video_properties::video_media_id
longform_video_media_id
app_install_properties::app_name
install_app_name
app_install_properties::ios_app_id
install_ios_app_id
app_install_properties::android_app_url
install_android_app_url
app_install_properties::icon_media_id
install_app_icon_media_id
web_view_properties::url
web_view_url
ad_account_id
ad_account_id
MD5(id + organization_id)
__sync_key
Measurement
Endpoint: Measurement
Update Method: UPSERT
Table Name: [
snapchat.measurement]
MD5(campaign_id + timeseries_stat::swipe_up_attribution_window + timeseries_stat::view_attribution_window + timeseries_stat::granularity + ad_time::start_time + timeseries_stat::id + organization_id)
measurement_id
campaign_id
campaign_id
timeseries_stat::swipe_up_attribution_window
swipe_up_attribution_window
timeseries_stat::view_attribution_window
view_attribution_window
timeseries_stat::granularity
granularity
ad_time::start_time
start_time
ad_time::end_time
end_time
timeseries_stat::id
ad_id
impressions
impressions
swipes
swipes
quartile_1
quartile_1
quartile_2
quartile_2
quartile_3
quartile_3
view_completion
view_completion
attachment_quartile_1
attachment_quartile_1
attachment_quartile_2
attachment_quartile_2
attachment_quartile_3
attachment_quartile_3
attachment_view_completion
attachment_view_completion
attachment_total_view_time_millis
attachment_total_view_time_millis
spend
spend
video_views
video_views
shares
shares
saves
saves
story_opens
story_opens
story_completes
story_completes
attachment_video_views
attachment_video_views
total_installs
total_installs
conversion_purchases
conversion_purchases
conversion_purchases_value
conversion_purchases_value
conversion_save
conversion_save
conversion_start_checkout
conversion_start_checkout
conversion_add_cart
conversion_add_cart
conversion_view_content
conversion_view_content
conversion_add_billing
conversion_add_billing
conversion_sign_ups
conversion_sign_ups
conversion_searches
conversion_searches
conversion_level_completes
conversion_level_completes
conversion_app_opens
conversion_app_opens
conversion_page_views
conversion_page_views
MD5(campaign_id + timeseries_stat::swipe_up_attribution_window + timeseries_stat::view_attribution_window + timeseries_stat::granularity + ad_time::start_time + timeseries_stat::id + organization_id)
__sync_key
Was this helpful?