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:

• Organizations

• Ad Accounts

• Campaigns

• Ad Squads

• Ads

• Media

• Creatives

• Measurement

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

• Ad Accounts

• Campaigns

• Ad Squads

• Ads

• Media

• Creatives

• Measurement

Organizations

• Endpoint: Organizations

• Update Method: UPSERT

• Table Name: [snapchat.organizations]

JSON Element	Database Column
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]

JSON Element	Database Column
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]

JSON Element	Database Column
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]

JSON Element	Database Column
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]

JSON Element	Database Column
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]

JSON Element	Database Column
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]

JSON Element	Database Column
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]

JSON Element	Database Column
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