Appsflyer

Tables in the Appsflyer connector

No	Table Name	Columns	Primary Keys	Read Mode	Inc. Sync Keys	API Info
1	in_app_events	118		Full Refresh, Incremental	event_time
2	retargeting_in_app_events	118		Full Refresh, Incremental	event_time
3	partners_report	38		Full Refresh, Incremental	date
4	uninstall_events	114		Full Refresh, Incremental	event_time
5	geo_report	39		Full Refresh, Incremental	date
6	retargeting_daily_report	13		Full Refresh, Incremental	date
7	retargeting_geo_report	32		Full Refresh, Incremental	date
8	retargeting_conversions	118		Full Refresh, Incremental	install_time
9	installs	118		Full Refresh, Incremental	install_time
10	retargeting_partners_report	31		Full Refresh, Incremental	date
11	daily_report	14		Full Refresh, Incremental	date

Table: in_app_events

No	Column Name	Type	Notes
1	app_type	VARCHAR
2	contributor1_match_type	VARCHAR
3	event_revenue	VARCHAR
4	install_app_store	VARCHAR
5	attributed_touch_type	VARCHAR
6	contributor3_touch_time	VARCHAR
7	idfv	VARCHAR
8	state	VARCHAR
9	app_id	VARCHAR
10	is_primary_attribution	BOOLEAN
11	wifi	BOOLEAN
12	media_source	VARCHAR
13	contributor1_media_source	VARCHAR
14	blocked_sub_reason	VARCHAR
15	ip	VARCHAR
16	idfa	VARCHAR
17	amazon_aid	VARCHAR
18	advertising_id	VARCHAR
19	contributor2_media_source	VARCHAR
20	deeplink_url	VARCHAR
21	contributor2_touch_type	VARCHAR
22	contributor3_af_prt	VARCHAR
23	af_reengagement_window	VARCHAR
24	keyword_id	VARCHAR
25	bundle_id	VARCHAR
26	is_receipt_validated	BOOLEAN
27	http_referrer	VARCHAR
28	rejected_reason_value	VARCHAR
29	placement	VARCHAR
30	blocked_reason_rule	VARCHAR
31	city	VARCHAR
32	af_adset_id	VARCHAR
33	af_ad_type	VARCHAR
34	retargeting_conversion_type	VARCHAR
35	contributor1_af_prt	VARCHAR
36	event_revenue_usd	VARCHAR
37	af_attribution_lookback	VARCHAR
38	sdk_version	VARCHAR
39	match_type	VARCHAR
40	af_channel	VARCHAR
41	contributor1_touch_type	VARCHAR
42	oaid	VARCHAR
43	store_reinstall	BOOLEAN
44	os_version	VARCHAR
45	keyword_match_type	VARCHAR
46	impressions	VARCHAR
47	af_sub1	VARCHAR
48	app_name	VARCHAR
49	ad_unit	VARCHAR
50	device_download_time	VARCHAR
51	af_sub5	VARCHAR
52	af_adset	VARCHAR
53	af_sub4	VARCHAR
54	original_url	VARCHAR
55	af_sub3	VARCHAR
56	af_sub2	VARCHAR
57	af_cost_value	VARCHAR
58	postal_code	VARCHAR
59	event_value	VARCHAR
60	contributor3_touch_type	VARCHAR
61	contributor2_campaign	VARCHAR
62	app_version	VARCHAR
63	campaign_type	VARCHAR
64	event_source	VARCHAR
65	language	VARCHAR
66	device_type	VARCHAR
67	device_category	VARCHAR
68	operator	VARCHAR
69	network_account_id	VARCHAR
70	gp_broadcast_referrer	VARCHAR
71	segment	VARCHAR
72	appsflyer_id	VARCHAR
73	install_time	VARCHAR
74	att	VARCHAR
75	is_lat	BOOLEAN
76	contributor3_match_type	VARCHAR
77	attributed_touch_time	VARCHAR
78	contributor3_media_source	VARCHAR
79	contributor1_campaign	VARCHAR
80	af_siteid	VARCHAR
81	country_code	VARCHAR
82	contributor2_match_type	VARCHAR
83	af_ad_id	VARCHAR
84	af_sub_siteid	VARCHAR
85	event_revenue_currency	VARCHAR
86	event_name	VARCHAR
87	campaign	VARCHAR
88	af_cost_model	VARCHAR
89	contributor2_touch_time	VARCHAR
90	region	VARCHAR
91	is_retargeting	BOOLEAN
92	custom_data	VARCHAR
93	device_model	VARCHAR
94	gp_click_time	VARCHAR
95	af_prt	VARCHAR
96	mediation_network	VARCHAR
97	contributor1_touch_time	VARCHAR
98	gp_referrer	VARCHAR
99	contributor2_af_prt	VARCHAR
100	platform	VARCHAR
101	af_cost_currency	VARCHAR
102	monetization_network	VARCHAR
103	contributor3_campaign	VARCHAR
104	rejected_reason	VARCHAR
105	user_agent	VARCHAR
106	af_c_id	VARCHAR
107	carrier	VARCHAR
108	blocked_reason	VARCHAR
109	conversion_type	VARCHAR
110	dma	VARCHAR
111	imei	VARCHAR
112	af_keywords	VARCHAR
113	af_ad	VARCHAR
114	customer_user_id	VARCHAR
115	blocked_reason_value	VARCHAR
116	android_id	VARCHAR
117	event_time	VARCHAR	Incremental sync key
118	gp_install_begin	VARCHAR

Table: retargeting_in_app_events

No	Column Name	Type	Notes
1	app_type	VARCHAR
2	contributor1_match_type	VARCHAR
3	event_revenue	VARCHAR
4	install_app_store	VARCHAR
5	attributed_touch_type	VARCHAR
6	contributor3_touch_time	VARCHAR
7	idfv	VARCHAR
8	state	VARCHAR
9	app_id	VARCHAR
10	is_primary_attribution	BOOLEAN
11	wifi	BOOLEAN
12	media_source	VARCHAR
13	contributor1_media_source	VARCHAR
14	blocked_sub_reason	VARCHAR
15	ip	VARCHAR
16	idfa	VARCHAR
17	amazon_aid	VARCHAR
18	advertising_id	VARCHAR
19	contributor2_media_source	VARCHAR
20	deeplink_url	VARCHAR
21	contributor2_touch_type	VARCHAR
22	contributor3_af_prt	VARCHAR
23	af_reengagement_window	VARCHAR
24	keyword_id	VARCHAR
25	bundle_id	VARCHAR
26	is_receipt_validated	BOOLEAN
27	http_referrer	VARCHAR
28	rejected_reason_value	VARCHAR
29	placement	VARCHAR
30	blocked_reason_rule	VARCHAR
31	city	VARCHAR
32	af_adset_id	VARCHAR
33	af_ad_type	VARCHAR
34	retargeting_conversion_type	VARCHAR
35	contributor1_af_prt	VARCHAR
36	event_revenue_usd	VARCHAR
37	af_attribution_lookback	VARCHAR
38	sdk_version	VARCHAR
39	match_type	VARCHAR
40	af_channel	VARCHAR
41	contributor1_touch_type	VARCHAR
42	oaid	VARCHAR
43	store_reinstall	BOOLEAN
44	os_version	VARCHAR
45	keyword_match_type	VARCHAR
46	impressions	VARCHAR
47	af_sub1	VARCHAR
48	app_name	VARCHAR
49	ad_unit	VARCHAR
50	device_download_time	VARCHAR
51	af_sub5	VARCHAR
52	af_adset	VARCHAR
53	af_sub4	VARCHAR
54	original_url	VARCHAR
55	af_sub3	VARCHAR
56	af_sub2	VARCHAR
57	af_cost_value	VARCHAR
58	postal_code	VARCHAR
59	event_value	VARCHAR
60	contributor3_touch_type	VARCHAR
61	contributor2_campaign	VARCHAR
62	app_version	VARCHAR
63	campaign_type	VARCHAR
64	event_source	VARCHAR
65	language	VARCHAR
66	device_type	VARCHAR
67	device_category	VARCHAR
68	operator	VARCHAR
69	network_account_id	VARCHAR
70	gp_broadcast_referrer	VARCHAR
71	segment	VARCHAR
72	appsflyer_id	VARCHAR
73	install_time	VARCHAR
74	att	VARCHAR
75	is_lat	BOOLEAN
76	contributor3_match_type	VARCHAR
77	attributed_touch_time	VARCHAR
78	contributor3_media_source	VARCHAR
79	contributor1_campaign	VARCHAR
80	af_siteid	VARCHAR
81	country_code	VARCHAR
82	contributor2_match_type	VARCHAR
83	af_ad_id	VARCHAR
84	af_sub_siteid	VARCHAR
85	event_revenue_currency	VARCHAR
86	event_name	VARCHAR
87	campaign	VARCHAR
88	af_cost_model	VARCHAR
89	contributor2_touch_time	VARCHAR
90	region	VARCHAR
91	is_retargeting	BOOLEAN
92	custom_data	VARCHAR
93	device_model	VARCHAR
94	gp_click_time	VARCHAR
95	af_prt	VARCHAR
96	mediation_network	VARCHAR
97	contributor1_touch_time	VARCHAR
98	gp_referrer	VARCHAR
99	contributor2_af_prt	VARCHAR
100	platform	VARCHAR
101	af_cost_currency	VARCHAR
102	monetization_network	VARCHAR
103	contributor3_campaign	VARCHAR
104	rejected_reason	VARCHAR
105	user_agent	VARCHAR
106	af_c_id	VARCHAR
107	carrier	VARCHAR
108	blocked_reason	VARCHAR
109	conversion_type	VARCHAR
110	dma	VARCHAR
111	imei	VARCHAR
112	af_keywords	VARCHAR
113	af_ad	VARCHAR
114	customer_user_id	VARCHAR
115	blocked_reason_value	VARCHAR
116	android_id	VARCHAR
117	event_time	VARCHAR	Incremental sync key
118	gp_install_begin	VARCHAR

Table: partners_report

No	Column Name	Type	Notes
1	date	VARCHAR	Incremental sync key
2	total_cost	DOUBLE
3	init_appsflyer_id_sales	DOUBLE
4	pay_premium_pkg_unique_users	DOUBLE
5	af_prt	VARCHAR
6	create_product_complete_sales	DOUBLE
7	af_complete_registration_event_counter	DOUBLE
8	af_purchase_registration_unique_users	DOUBLE
9	pay_premium_pkg_sales	DOUBLE
10	init_appsflyer_id_unique_users	DOUBLE
11	average_revenue_per_user	DOUBLE
12	conversion_rate	DOUBLE
13	average_ecpi	DOUBLE
14	af_complete_registration_sales	DOUBLE
15	af_complete_registration_unique_users	DOUBLE
16	create_product_complete_event_counter	DOUBLE
17	pay_premium_pkg_event_counter	DOUBLE
18	account_login_unique_users	DOUBLE
19	af_purchase_registration_event_counter	DOUBLE
20	click_through_rate	DOUBLE
21	init_appsflyer_id_event_counter	DOUBLE
22	sessions	DOUBLE
23	checkout_success_sales	DOUBLE
24	media_source	VARCHAR
25	af_purchase_registration_sales	DOUBLE
26	account_login_sales	DOUBLE
27	account_login_event_counter	DOUBLE
28	return_on_investment	DOUBLE
29	impressions	DOUBLE
30	loyal_users	DOUBLE
31	checkout_success_event_counter	DOUBLE
32	create_product_complete_unique_users	DOUBLE
33	installs	DOUBLE
34	total_revenue	DOUBLE
35	campaign	VARCHAR
36	clicks	DOUBLE
37	loyal_users_rate	DOUBLE
38	checkout_success_unique_users	DOUBLE

Table: uninstall_events

No	Column Name	Type	Notes
1	contributor1_match_type	VARCHAR
2	event_revenue	VARCHAR
3	install_app_store	VARCHAR
4	attributed_touch_type	VARCHAR
5	contributor3_touch_time	VARCHAR
6	idfv	VARCHAR
7	state	VARCHAR
8	app_id	VARCHAR
9	is_primary_attribution	BOOLEAN
10	wifi	BOOLEAN
11	media_source	VARCHAR
12	contributor1_media_source	VARCHAR
13	blocked_sub_reason	VARCHAR
14	ip	VARCHAR
15	idfa	VARCHAR
16	amazon_aid	VARCHAR
17	advertising_id	VARCHAR
18	contributor2_media_source	VARCHAR
19	deeplink_url	VARCHAR
20	contributor2_touch_type	VARCHAR
21	contributor3_af_prt	VARCHAR
22	af_reengagement_window	VARCHAR
23	keyword_id	VARCHAR
24	bundle_id	VARCHAR
25	is_receipt_validated	BOOLEAN
26	http_referrer	VARCHAR
27	rejected_reason_value	VARCHAR
28	placement	VARCHAR
29	blocked_reason_rule	VARCHAR
30	city	VARCHAR
31	af_adset_id	VARCHAR
32	af_ad_type	VARCHAR
33	retargeting_conversion_type	VARCHAR
34	contributor1_af_prt	VARCHAR
35	event_revenue_usd	VARCHAR
36	af_attribution_lookback	VARCHAR
37	sdk_version	VARCHAR
38	match_type	VARCHAR
39	af_channel	VARCHAR
40	contributor1_touch_type	VARCHAR
41	oaid	VARCHAR
42	store_reinstall	BOOLEAN
43	os_version	VARCHAR
44	keyword_match_type	VARCHAR
45	impressions	VARCHAR
46	af_sub1	VARCHAR
47	app_name	VARCHAR
48	ad_unit	VARCHAR
49	device_download_time	VARCHAR
50	af_sub5	VARCHAR
51	af_adset	VARCHAR
52	af_sub4	VARCHAR
53	original_url	VARCHAR
54	af_sub3	VARCHAR
55	af_sub2	VARCHAR
56	af_cost_value	VARCHAR
57	postal_code	VARCHAR
58	event_value	VARCHAR
59	contributor3_touch_type	VARCHAR
60	contributor2_campaign	VARCHAR
61	app_version	VARCHAR
62	event_source	VARCHAR
63	language	VARCHAR
64	device_type	VARCHAR
65	device_category	VARCHAR
66	operator	VARCHAR
67	network_account_id	VARCHAR
68	gp_broadcast_referrer	VARCHAR
69	segment	VARCHAR
70	appsflyer_id	VARCHAR
71	install_time	VARCHAR
72	is_lat	BOOLEAN
73	contributor3_match_type	VARCHAR
74	attributed_touch_time	VARCHAR
75	contributor3_media_source	VARCHAR
76	contributor1_campaign	VARCHAR
77	af_siteid	VARCHAR
78	country_code	VARCHAR
79	contributor2_match_type	VARCHAR
80	af_ad_id	VARCHAR
81	af_sub_siteid	VARCHAR
82	event_revenue_currency	VARCHAR
83	event_name	VARCHAR
84	campaign	VARCHAR
85	af_cost_model	VARCHAR
86	contributor2_touch_time	VARCHAR
87	region	VARCHAR
88	is_retargeting	BOOLEAN
89	custom_data	VARCHAR
90	device_model	VARCHAR
91	gp_click_time	VARCHAR
92	af_prt	VARCHAR
93	mediation_network	VARCHAR
94	contributor1_touch_time	VARCHAR
95	gp_referrer	VARCHAR
96	contributor2_af_prt	VARCHAR
97	platform	VARCHAR
98	af_cost_currency	VARCHAR
99	monetization_network	VARCHAR
100	contributor3_campaign	VARCHAR
101	rejected_reason	VARCHAR
102	user_agent	VARCHAR
103	af_c_id	VARCHAR
104	carrier	VARCHAR
105	blocked_reason	VARCHAR
106	dma	VARCHAR
107	imei	VARCHAR
108	af_keywords	VARCHAR
109	af_ad	VARCHAR
110	customer_user_id	VARCHAR
111	blocked_reason_value	VARCHAR
112	android_id	VARCHAR
113	event_time	VARCHAR	Incremental sync key
114	gp_install_begin	VARCHAR

Table: geo_report

No	Column Name	Type	Notes
1	date	VARCHAR	Incremental sync key
2	total_cost	DOUBLE
3	init_appsflyer_id_sales	DOUBLE
4	pay_premium_pkg_unique_users	DOUBLE
5	af_prt	VARCHAR
6	create_product_complete_sales	DOUBLE
7	af_complete_registration_event_counter	DOUBLE
8	af_purchase_registration_unique_users	DOUBLE
9	pay_premium_pkg_sales	DOUBLE
10	init_appsflyer_id_unique_users	DOUBLE
11	average_revenue_per_user	DOUBLE
12	conversion_rate	DOUBLE
13	average_ecpi	DOUBLE
14	af_complete_registration_sales	DOUBLE
15	af_complete_registration_unique_users	DOUBLE
16	create_product_complete_event_counter	DOUBLE
17	pay_premium_pkg_event_counter	DOUBLE
18	account_login_unique_users	DOUBLE
19	af_purchase_registration_event_counter	DOUBLE
20	click_through_rate	DOUBLE
21	init_appsflyer_id_event_counter	DOUBLE
22	sessions	DOUBLE
23	checkout_success_sales	DOUBLE
24	media_source	VARCHAR
25	af_purchase_registration_sales	DOUBLE
26	account_login_sales	DOUBLE
27	account_login_event_counter	DOUBLE
28	return_on_investment	DOUBLE
29	impressions	DOUBLE
30	loyal_users	DOUBLE
31	checkout_success_event_counter	DOUBLE
32	create_product_complete_unique_users	DOUBLE
33	installs	DOUBLE
34	country_code	VARCHAR
35	total_revenue	DOUBLE
36	campaign	VARCHAR
37	clicks	DOUBLE
38	loyal_users_rate	DOUBLE
39	checkout_success_unique_users	DOUBLE

Table: retargeting_daily_report

No	Column Name	Type	Notes
1	date	VARCHAR	Incremental sync key
2	conversions	DOUBLE
3	sessions	DOUBLE
4	media_source	VARCHAR
5	total_cost	DOUBLE
6	af_prt	VARCHAR
7	loyal_users	DOUBLE
8	conversion_type	VARCHAR
9	campaign	VARCHAR
10	clicks	DOUBLE
11	loyal_users_rate	DOUBLE
12	conversion_rate	DOUBLE
13	average_ecpi	DOUBLE

Table: retargeting_geo_report

No	Column Name	Type	Notes
1	date	VARCHAR	Incremental sync key
2	conversions	DOUBLE
3	total_cost	DOUBLE
4	init_appsflyer_id_sales	DOUBLE
5	af_prt	VARCHAR
6	create_product_complete_sales	DOUBLE
7	af_complete_registration_event_counter	DOUBLE
8	init_appsflyer_id_unique_users	DOUBLE
9	average_revenue_per_user	DOUBLE
10	conversion_rate	DOUBLE
11	average_ecpi	DOUBLE
12	af_complete_registration_sales	DOUBLE
13	af_complete_registration_unique_users	DOUBLE
14	create_product_complete_event_counter	DOUBLE
15	account_login_unique_users	DOUBLE
16	init_appsflyer_id_event_counter	DOUBLE
17	sessions	DOUBLE
18	checkout_success_sales	DOUBLE
19	media_source	VARCHAR
20	account_login_sales	DOUBLE
21	account_login_event_counter	DOUBLE
22	return_on_investment	DOUBLE
23	loyal_users	DOUBLE
24	checkout_success_event_counter	DOUBLE
25	create_product_complete_unique_users	DOUBLE
26	country_code	VARCHAR
27	conversion_type	VARCHAR
28	total_revenue	DOUBLE
29	campaign	VARCHAR
30	clicks	DOUBLE
31	loyal_users_rate	DOUBLE
32	checkout_success_unique_users	DOUBLE

Table: retargeting_conversions

No	Column Name	Type	Notes
1	app_type	VARCHAR
2	contributor1_match_type	VARCHAR
3	event_revenue	VARCHAR
4	install_app_store	VARCHAR
5	attributed_touch_type	VARCHAR
6	contributor3_touch_time	VARCHAR
7	idfv	VARCHAR
8	state	VARCHAR
9	app_id	VARCHAR
10	is_primary_attribution	BOOLEAN
11	wifi	BOOLEAN
12	media_source	VARCHAR
13	contributor1_media_source	VARCHAR
14	blocked_sub_reason	VARCHAR
15	ip	VARCHAR
16	idfa	VARCHAR
17	amazon_aid	VARCHAR
18	advertising_id	VARCHAR
19	contributor2_media_source	VARCHAR
20	deeplink_url	VARCHAR
21	contributor2_touch_type	VARCHAR
22	contributor3_af_prt	VARCHAR
23	af_reengagement_window	VARCHAR
24	keyword_id	VARCHAR
25	bundle_id	VARCHAR
26	is_receipt_validated	BOOLEAN
27	http_referrer	VARCHAR
28	rejected_reason_value	VARCHAR
29	placement	VARCHAR
30	blocked_reason_rule	VARCHAR
31	city	VARCHAR
32	af_adset_id	VARCHAR
33	af_ad_type	VARCHAR
34	retargeting_conversion_type	VARCHAR
35	contributor1_af_prt	VARCHAR
36	event_revenue_usd	VARCHAR
37	af_attribution_lookback	VARCHAR
38	sdk_version	VARCHAR
39	match_type	VARCHAR
40	af_channel	VARCHAR
41	contributor1_touch_type	VARCHAR
42	oaid	VARCHAR
43	store_reinstall	BOOLEAN
44	os_version	VARCHAR
45	keyword_match_type	VARCHAR
46	impressions	VARCHAR
47	af_sub1	VARCHAR
48	app_name	VARCHAR
49	ad_unit	VARCHAR
50	device_download_time	VARCHAR
51	af_sub5	VARCHAR
52	af_adset	VARCHAR
53	af_sub4	VARCHAR
54	original_url	VARCHAR
55	af_sub3	VARCHAR
56	af_sub2	VARCHAR
57	af_cost_value	VARCHAR
58	postal_code	VARCHAR
59	event_value	VARCHAR
60	contributor3_touch_type	VARCHAR
61	contributor2_campaign	VARCHAR
62	app_version	VARCHAR
63	campaign_type	VARCHAR
64	event_source	VARCHAR
65	language	VARCHAR
66	device_type	VARCHAR
67	device_category	VARCHAR
68	operator	VARCHAR
69	network_account_id	VARCHAR
70	gp_broadcast_referrer	VARCHAR
71	segment	VARCHAR
72	appsflyer_id	VARCHAR
73	install_time	VARCHAR	Incremental sync key
74	att	VARCHAR
75	is_lat	BOOLEAN
76	contributor3_match_type	VARCHAR
77	attributed_touch_time	VARCHAR
78	contributor3_media_source	VARCHAR
79	contributor1_campaign	VARCHAR
80	af_siteid	VARCHAR
81	country_code	VARCHAR
82	contributor2_match_type	VARCHAR
83	af_ad_id	VARCHAR
84	af_sub_siteid	VARCHAR
85	event_revenue_currency	VARCHAR
86	event_name	VARCHAR
87	campaign	VARCHAR
88	af_cost_model	VARCHAR
89	contributor2_touch_time	VARCHAR
90	region	VARCHAR
91	is_retargeting	BOOLEAN
92	custom_data	VARCHAR
93	device_model	VARCHAR
94	gp_click_time	VARCHAR
95	af_prt	VARCHAR
96	mediation_network	VARCHAR
97	contributor1_touch_time	VARCHAR
98	gp_referrer	VARCHAR
99	contributor2_af_prt	VARCHAR
100	platform	VARCHAR
101	af_cost_currency	VARCHAR
102	monetization_network	VARCHAR
103	contributor3_campaign	VARCHAR
104	rejected_reason	VARCHAR
105	user_agent	VARCHAR
106	af_c_id	VARCHAR
107	carrier	VARCHAR
108	blocked_reason	VARCHAR
109	conversion_type	VARCHAR
110	dma	VARCHAR
111	imei	VARCHAR
112	af_keywords	VARCHAR
113	af_ad	VARCHAR
114	customer_user_id	VARCHAR
115	blocked_reason_value	VARCHAR
116	android_id	VARCHAR
117	event_time	VARCHAR
118	gp_install_begin	VARCHAR

Table: installs

No	Column Name	Type	Notes
1	app_type	VARCHAR
2	contributor1_match_type	VARCHAR
3	event_revenue	VARCHAR
4	install_app_store	VARCHAR
5	attributed_touch_type	VARCHAR
6	contributor3_touch_time	VARCHAR
7	idfv	VARCHAR
8	state	VARCHAR
9	app_id	VARCHAR
10	is_primary_attribution	BOOLEAN
11	wifi	BOOLEAN
12	media_source	VARCHAR
13	contributor1_media_source	VARCHAR
14	blocked_sub_reason	VARCHAR
15	ip	VARCHAR
16	idfa	VARCHAR
17	amazon_aid	VARCHAR
18	advertising_id	VARCHAR
19	contributor2_media_source	VARCHAR
20	deeplink_url	VARCHAR
21	contributor2_touch_type	VARCHAR
22	contributor3_af_prt	VARCHAR
23	af_reengagement_window	VARCHAR
24	keyword_id	VARCHAR
25	bundle_id	VARCHAR
26	is_receipt_validated	BOOLEAN
27	http_referrer	VARCHAR
28	rejected_reason_value	VARCHAR
29	placement	VARCHAR
30	blocked_reason_rule	VARCHAR
31	city	VARCHAR
32	af_adset_id	VARCHAR
33	af_ad_type	VARCHAR
34	retargeting_conversion_type	VARCHAR
35	contributor1_af_prt	VARCHAR
36	event_revenue_usd	VARCHAR
37	af_attribution_lookback	VARCHAR
38	sdk_version	VARCHAR
39	match_type	VARCHAR
40	af_channel	VARCHAR
41	contributor1_touch_type	VARCHAR
42	oaid	VARCHAR
43	store_reinstall	BOOLEAN
44	os_version	VARCHAR
45	keyword_match_type	VARCHAR
46	impressions	VARCHAR
47	af_sub1	VARCHAR
48	app_name	VARCHAR
49	ad_unit	VARCHAR
50	device_download_time	VARCHAR
51	af_sub5	VARCHAR
52	af_adset	VARCHAR
53	af_sub4	VARCHAR
54	original_url	VARCHAR
55	af_sub3	VARCHAR
56	af_sub2	VARCHAR
57	af_cost_value	VARCHAR
58	postal_code	VARCHAR
59	event_value	VARCHAR
60	contributor3_touch_type	VARCHAR
61	contributor2_campaign	VARCHAR
62	app_version	VARCHAR
63	campaign_type	VARCHAR
64	event_source	VARCHAR
65	language	VARCHAR
66	device_type	VARCHAR
67	device_category	VARCHAR
68	operator	VARCHAR
69	network_account_id	VARCHAR
70	gp_broadcast_referrer	VARCHAR
71	segment	VARCHAR
72	appsflyer_id	VARCHAR
73	install_time	VARCHAR	Incremental sync key
74	att	VARCHAR
75	is_lat	BOOLEAN
76	contributor3_match_type	VARCHAR
77	attributed_touch_time	VARCHAR
78	contributor3_media_source	VARCHAR
79	contributor1_campaign	VARCHAR
80	af_siteid	VARCHAR
81	country_code	VARCHAR
82	contributor2_match_type	VARCHAR
83	af_ad_id	VARCHAR
84	af_sub_siteid	VARCHAR
85	event_revenue_currency	VARCHAR
86	event_name	VARCHAR
87	campaign	VARCHAR
88	af_cost_model	VARCHAR
89	contributor2_touch_time	VARCHAR
90	region	VARCHAR
91	is_retargeting	BOOLEAN
92	custom_data	VARCHAR
93	device_model	VARCHAR
94	gp_click_time	VARCHAR
95	af_prt	VARCHAR
96	mediation_network	VARCHAR
97	contributor1_touch_time	VARCHAR
98	gp_referrer	VARCHAR
99	contributor2_af_prt	VARCHAR
100	platform	VARCHAR
101	af_cost_currency	VARCHAR
102	monetization_network	VARCHAR
103	contributor3_campaign	VARCHAR
104	rejected_reason	VARCHAR
105	user_agent	VARCHAR
106	af_c_id	VARCHAR
107	carrier	VARCHAR
108	blocked_reason	VARCHAR
109	conversion_type	VARCHAR
110	dma	VARCHAR
111	imei	VARCHAR
112	af_keywords	VARCHAR
113	af_ad	VARCHAR
114	customer_user_id	VARCHAR
115	blocked_reason_value	VARCHAR
116	android_id	VARCHAR
117	event_time	VARCHAR
118	gp_install_begin	VARCHAR

Table: retargeting_partners_report

No	Column Name	Type	Notes
1	date	VARCHAR	Incremental sync key
2	conversions	DOUBLE
3	total_cost	DOUBLE
4	init_appsflyer_id_sales	DOUBLE
5	af_prt	VARCHAR
6	create_product_complete_sales	DOUBLE
7	af_complete_registration_event_counter	DOUBLE
8	init_appsflyer_id_unique_users	DOUBLE
9	average_revenue_per_user	DOUBLE
10	conversion_rate	DOUBLE
11	average_ecpi	DOUBLE
12	af_complete_registration_sales	DOUBLE
13	af_complete_registration_unique_users	DOUBLE
14	create_product_complete_event_counter	DOUBLE
15	account_login_unique_users	DOUBLE
16	init_appsflyer_id_event_counter	DOUBLE
17	sessions	DOUBLE
18	checkout_success_sales	DOUBLE
19	media_source	VARCHAR
20	account_login_sales	DOUBLE
21	account_login_event_counter	DOUBLE
22	return_on_investment	DOUBLE
23	loyal_users	DOUBLE
24	checkout_success_event_counter	DOUBLE
25	create_product_complete_unique_users	DOUBLE
26	conversion_type	VARCHAR
27	total_revenue	DOUBLE
28	campaign	VARCHAR
29	clicks	DOUBLE
30	loyal_users_rate	DOUBLE
31	checkout_success_unique_users	DOUBLE

Table: daily_report

No	Column Name	Type	Notes
1	date	VARCHAR	Incremental sync key
2	click_through_rate	DOUBLE
3	sessions	DOUBLE
4	media_source	VARCHAR
5	total_cost	DOUBLE
6	af_prt	VARCHAR
7	impressions	DOUBLE
8	loyal_users	DOUBLE
9	installs	DOUBLE
10	campaign	VARCHAR
11	clicks	DOUBLE
12	loyal_users_rate	DOUBLE
13	conversion_rate	DOUBLE
14	average_ecpi	DOUBLE

External Resources

• Appsflyer

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.