Snapchat marketing

Setting up the Snapchat marketing connector

No	Item	Required	Example	Notes
1	Client ID	Yes		The Client ID of your Snapchat developer application.
2	Client Secret	Yes		The Client Secret of your Snapchat developer application.
3	Refresh Token	Yes		Refresh Token to renew the expired Access Token.
4	Start Date	No	2022-01-01	Date in the format 2022-01-01. Any data before this date will not be replicated.
5	End Date	No	2022-01-30	Date in the format 2017-01-25. Any data after this date will not be replicated.

Tables in the Snapchat marketing connector

No	Table Name	Columns	Primary Keys	Read Mode	Inc. Sync Keys	API Info
1	adsquads	26	id	Incremental, Full Refresh	updated_at
2	ads	11	id	Incremental, Full Refresh	updated_at
3	campaigns	10	id	Incremental, Full Refresh	updated_at
4	adaccounts	16	id	Incremental, Full Refresh	updated_at
5	basic_stats	73
6	organizations	22	id	Full Refresh
7	creatives	19	id	Incremental, Full Refresh	updated_at
8	media	16	id	Incremental, Full Refresh	updated_at
9	segments	14	id	Incremental, Full Refresh	updated_at

Table: adsquads

No	Column Name	Type	Notes
1	optimization_goal	VARCHAR
2	skadnetwork_properties	VARCHAR
3	billing_event	VARCHAR
4	bid_strategy	VARCHAR
5	created_at	VARCHAR
6	target_bid	BOOLEAN
7	type	VARCHAR
8	child_ad_type	VARCHAR
9	targeting_reach_status	VARCHAR
10	targeting	VARCHAR
11	updated_at	VARCHAR	Incremental sync key
12	daily_budget_micro	INTEGER
13	creation_state	VARCHAR
14	id	VARCHAR	Primary Key
15	delivery_constraint	VARCHAR
16	campaign_id	VARCHAR
17	pacing_type	VARCHAR
18	end_time	VARCHAR
19	lifetime_budget_micro	INTEGER
20	auto_bid	BOOLEAN
21	forced_view_setting	VARCHAR
22	start_time	VARCHAR
23	name	VARCHAR
24	placement	VARCHAR
25	delivery_status	VARCHAR
26	status	VARCHAR

Table: ads

No	Column Name	Type	Notes
1	updated_at	VARCHAR	Incremental sync key
2	name	VARCHAR
3	created_at	VARCHAR
4	id	VARCHAR	Primary Key
5	review_status	VARCHAR
6	type	VARCHAR
7	ad_squad_id	VARCHAR
8	creative_id	VARCHAR
9	render_type	VARCHAR
10	delivery_status	VARCHAR
11	status	VARCHAR

Table: campaigns

No	Column Name	Type	Notes
1	start_time	VARCHAR
2	updated_at	VARCHAR	Incremental sync key
3	name	VARCHAR
4	created_at	VARCHAR
5	id	VARCHAR	Primary Key
6	buy_model	VARCHAR
7	delivery_status	VARCHAR
8	ad_account_id	VARCHAR
9	status	VARCHAR
10	objective	VARCHAR

Table: adaccounts

No	Column Name	Type	Notes
1	agency_representing_client	BOOLEAN
2	timezone	VARCHAR
3	billing_center_id	VARCHAR
4	created_at	VARCHAR
5	client_paying_invoices	BOOLEAN
6	type	VARCHAR
7	funding_source_ids	VARCHAR
8	updated_at	VARCHAR	Incremental sync key
9	organization_id	VARCHAR
10	regulations	VARCHAR
11	name	VARCHAR
12	billing_type	VARCHAR
13	currency	VARCHAR
14	id	VARCHAR	Primary Key
15	status	VARCHAR
16	advertiser_organization_id	VARCHAR

Table: basic_stats

No	Column Name	Type	Notes
1	android_installs	DOUBLE
2	quartile_2	DOUBLE
3	quartile_3	DOUBLE
4	swipes	DOUBLE
5	quartile_1	DOUBLE
6	conversion_start_checkout	DOUBLE
7	conversion_achievement_unlocked	DOUBLE
8	play_time_millis	DOUBLE
9	type	VARCHAR
10	conversion_login	DOUBLE
11	frequency	DOUBLE
12	avg_screen_time_millis	DOUBLE
13	conversion_page_views	DOUBLE
14	saves	DOUBLE
15	custom_event_3	DOUBLE
16	custom_event_4	DOUBLE
17	video_views	DOUBLE
18	custom_event_5	DOUBLE
19	conversion_list_view	DOUBLE
20	earned_reach	DOUBLE
21	conversion_share	DOUBLE
22	conversion_reserve	DOUBLE
23	id	VARCHAR
24	swipe_up_percent	DOUBLE
25	conversion_purchases_value	DOUBLE
26	conversion_spend_credits	DOUBLE
27	attachment_total_view_time_millis	DOUBLE
28	conversion_add_to_wishlist	DOUBLE
29	attachment_impressions	DOUBLE
30	conversion_start_trial	DOUBLE
31	uniques	DOUBLE
32	video_views_15s	DOUBLE
33	conversion_subscribe	DOUBLE
34	start_time	VARCHAR
35	conversion_save	DOUBLE
36	conversion_level_completes	DOUBLE
37	granularity	VARCHAR
38	screen_time_millis	DOUBLE
39	total_reach	DOUBLE
40	conversion_invite	DOUBLE
41	total_installs	DOUBLE
42	attachment_uniques	DOUBLE
43	view_completion	DOUBLE
44	total_impressions	DOUBLE
45	shares	DOUBLE
46	video_views_time_based	DOUBLE
47	attachment_quartile_1	DOUBLE
48	conversion_complete_tutorial	DOUBLE
49	ios_installs	DOUBLE
50	conversion_app_opens	DOUBLE
51	attachment_quartile_3	DOUBLE
52	attachment_quartile_2	DOUBLE
53	spend	DOUBLE
54	native_leads	DOUBLE
55	conversion_rate	DOUBLE
56	conversion_add_cart	DOUBLE
57	conversion_searches	DOUBLE
58	avg_view_time_millis	DOUBLE
59	conversion_ad_view	DOUBLE
60	attachment_avg_view_time_millis	DOUBLE
61	attachment_view_completion	DOUBLE
62	earned_impressions	DOUBLE
63	end_time	VARCHAR
64	view_time_millis	DOUBLE
65	custom_event_1	DOUBLE
66	impressions	DOUBLE
67	custom_event_2	DOUBLE
68	conversion_view_content	DOUBLE
69	attachment_frequency	DOUBLE
70	conversion_ad_click	DOUBLE
71	conversion_add_billing	DOUBLE
72	paid_impressions	DOUBLE
73	conversion_purchases	DOUBLE

Table: organizations

No	Column Name	Type	Notes
1	country	VARCHAR
2	contact_name	VARCHAR
3	contact_phone	VARCHAR
4	my_invited_email	VARCHAR
5	configuration_settings	VARCHAR
6	roles	VARCHAR
7	locality	VARCHAR
8	created_at	VARCHAR
9	contact_phone_optin	BOOLEAN
10	administrative_district_level_1	VARCHAR
11	type	VARCHAR
12	contact_email	VARCHAR
13	my_member_id	VARCHAR
14	accepted_term_version	VARCHAR
15	updated_at	VARCHAR
16	name	VARCHAR
17	address_line_1	VARCHAR
18	createdByCaller	BOOLEAN
19	id	VARCHAR	Primary Key
20	state	VARCHAR
21	postal_code	VARCHAR
22	my_display_name	VARCHAR

Table: creatives

No	Column Name	Type	Notes
1	packaging_status	VARCHAR
2	shareable	BOOLEAN
3	review_status_details	VARCHAR
4	call_to_action	VARCHAR
5	created_at	VARCHAR
6	brand_name	VARCHAR
7	type	VARCHAR
8	ad_account_id	VARCHAR
9	top_snap_media_id	VARCHAR
10	updated_at	VARCHAR	Incremental sync key
11	web_view_properties	VARCHAR
12	name	VARCHAR
13	top_snap_crop_position	VARCHAR
14	id	VARCHAR	Primary Key
15	review_status	VARCHAR
16	forced_view_eligibility	VARCHAR
17	headline	VARCHAR
18	render_type	VARCHAR
19	ad_product	VARCHAR

Table: media

No	Column Name	Type	Notes
1	file_size_in_bytes	INTEGER
2	media_status	VARCHAR
3	visibility	VARCHAR
4	is_demo_media	BOOLEAN
5	file_name	VARCHAR
6	created_at	VARCHAR
7	type	VARCHAR
8	ad_account_id	VARCHAR
9	video_metadata	VARCHAR
10	image_metadata	VARCHAR
11	download_link	VARCHAR
12	updated_at	VARCHAR	Incremental sync key
13	name	VARCHAR
14	id	VARCHAR	Primary Key
15	hash	VARCHAR
16	duration_in_seconds	DOUBLE

Table: segments

No	Column Name	Type	Notes
1	approximate_number_users	INTEGER
2	retention_in_days	INTEGER
3	created_at	VARCHAR
4	description	VARCHAR
5	source_type	VARCHAR
6	ad_account_id	VARCHAR
7	targetable_status	VARCHAR
8	updated_at	VARCHAR	Incremental sync key
9	visible_to	VARCHAR
10	organization_id	VARCHAR
11	name	VARCHAR
12	id	VARCHAR	Primary Key
13	status	VARCHAR
14	upload_status	VARCHAR

External Resources

• Set Up Snapchat Business Account
• Activate Access To The Snapchat Marketing Api
• Https://accounts.snapchat.com/login/oauth2/authorize?response_type=code&client_id={client_id}&redirect_uri={redirect_uri}&scope=snapchat-marketing-api&state=wmkkg0twgppw8ptbz20sldumf7hwvu
• Here

Zipstack Cloud features a powerful SQL querying engine on top of many types of connectors, including those from Trino, some custom connectors and connectors from the open source Airbyte project. Some Zipstack cloud connectors are designed to utilize and expand upon Airbyte's connector protocol, but they do not use Airbyte's EL core. Additionally, some parts of the documentation for these connectors have been adapted from the connector documentation found in Airbyte's open source project.