Youtube analytics

Tables in the Youtube analytics connector

No	Table Name	Columns	Primary Keys	Read Mode	Inc. Sync Keys	API Info
1	channel_subtitles_a2	13		Full Refresh, Incremental		API Reference
2	playlist_province_a1	14		Full Refresh, Incremental		API Reference
3	channel_combined_a2	16		Full Refresh, Incremental		API Reference
4	channel_end_screens_a1	11		Full Refresh, Incremental		API Reference
5	playlist_traffic_source_a1	15		Full Refresh, Incremental		API Reference
6	channel_province_a2	26		Full Refresh, Incremental		API Reference
7	playlist_combined_a1	17		Full Refresh, Incremental		API Reference
8	channel_traffic_source_a2	14		Full Refresh, Incremental		API Reference
9	channel_cards_a1	14		Full Refresh, Incremental		API Reference
10	channel_basic_a2	33		Full Refresh, Incremental		API Reference
11	playlist_device_os_a1	15		Full Refresh, Incremental		API Reference
12	channel_sharing_service_a1	8		Full Refresh, Incremental		API Reference
13	playlist_basic_a1	13		Full Refresh, Incremental		API Reference
14	channel_playback_location_a2	14		Full Refresh, Incremental		API Reference
15	playlist_playback_location_a1	15		Full Refresh, Incremental		API Reference
16	channel_demographics_a1	9		Full Refresh, Incremental		API Reference
17	channel_annotations_a1	15		Full Refresh, Incremental		API Reference
18	channel_device_os_a2	14		Full Refresh, Incremental		API Reference

Table: channel_subtitles_a2

No	Column Name	Type	Notes
1	date	INTEGER
2	red_watch_time_minutes	DOUBLE
3	average_view_duration_seconds	DOUBLE
4	live_or_on_demand	VARCHAR
5	subscribed_status	VARCHAR
6	red_views	INTEGER
7	watch_time_minutes	DOUBLE
8	country_code	VARCHAR
9	average_view_duration_percentage	DOUBLE
10	channel_id	VARCHAR
11	views	INTEGER
12	video_id	VARCHAR
13	subtitle_language	VARCHAR

Table: playlist_province_a1

No	Column Name	Type	Notes
1	date	INTEGER
2	average_view_duration_seconds	DOUBLE
3	live_or_on_demand	VARCHAR
4	playlist_saves_removed	VARCHAR
5	subscribed_status	VARCHAR
6	province_code	VARCHAR
7	watch_time_minutes	DOUBLE
8	country_code	VARCHAR
9	playlist_starts	VARCHAR
10	playlist_id	VARCHAR
11	channel_id	VARCHAR
12	views	VARCHAR
13	video_id	VARCHAR
14	playlist_saves_added	VARCHAR

Table: channel_combined_a2

No	Column Name	Type	Notes
1	date	INTEGER
2	red_watch_time_minutes	DOUBLE
3	average_view_duration_seconds	DOUBLE
4	live_or_on_demand	VARCHAR
5	subscribed_status	VARCHAR
6	device_type	INTEGER
7	traffic_source_type	INTEGER
8	red_views	INTEGER
9	watch_time_minutes	DOUBLE
10	playback_location_type	INTEGER
11	country_code	VARCHAR
12	average_view_duration_percentage	DOUBLE
13	operating_system	INTEGER
14	channel_id	VARCHAR
15	views	INTEGER
16	video_id	VARCHAR

Table: channel_end_screens_a1

No	Column Name	Type	Notes
1	date	INTEGER
2	country_code	VARCHAR
3	end_screen_element_clicks	VARCHAR
4	end_screen_element_type	VARCHAR
5	end_screen_element_impressions	VARCHAR
6	live_or_on_demand	VARCHAR
7	end_screen_element_id	VARCHAR
8	subscribed_status	VARCHAR
9	end_screen_element_click_rate	VARCHAR
10	channel_id	VARCHAR
11	video_id	VARCHAR

Table: playlist_traffic_source_a1

No	Column Name	Type	Notes
1	date	INTEGER
2	average_view_duration_seconds	DOUBLE
3	live_or_on_demand	VARCHAR
4	playlist_saves_removed	INTEGER
5	subscribed_status	VARCHAR
6	traffic_source_type	INTEGER
7	traffic_source_detail	VARCHAR
8	watch_time_minutes	DOUBLE
9	country_code	VARCHAR
10	playlist_starts	INTEGER
11	playlist_id	VARCHAR
12	channel_id	VARCHAR
13	views	INTEGER
14	video_id	VARCHAR
15	playlist_saves_added	INTEGER

Table: channel_province_a2

No	Column Name	Type	Notes
1	date	INTEGER
2	red_watch_time_minutes	DOUBLE
3	card_teaser_click_rate	INTEGER
4	subscribed_status	VARCHAR
5	red_views	INTEGER
6	province_code	VARCHAR
7	card_clicks	INTEGER
8	annotation_closable_impressions	INTEGER
9	annotation_closes	INTEGER
10	card_impressions	INTEGER
11	annotation_impressions	INTEGER
12	annotation_click_through_rate	INTEGER
13	annotation_clickable_impressions	INTEGER
14	views	INTEGER
15	annotation_clicks	INTEGER
16	average_view_duration_seconds	DOUBLE
17	live_or_on_demand	VARCHAR
18	card_teaser_clicks	INTEGER
19	card_click_rate	INTEGER
20	watch_time_minutes	DOUBLE
21	annotation_close_rate	INTEGER
22	card_teaser_impressions	INTEGER
23	country_code	VARCHAR
24	average_view_duration_percentage	DOUBLE
25	channel_id	VARCHAR
26	video_id	VARCHAR

Table: playlist_combined_a1

No	Column Name	Type	Notes
1	date	INTEGER
2	average_view_duration_seconds	DOUBLE
3	live_or_on_demand	VARCHAR
4	playlist_saves_removed	INTEGER
5	subscribed_status	VARCHAR
6	device_type	INTEGER
7	traffic_source_type	INTEGER
8	watch_time_minutes	DOUBLE
9	playback_location_type	INTEGER
10	country_code	VARCHAR
11	playlist_starts	INTEGER
12	playlist_id	VARCHAR
13	operating_system	INTEGER
14	channel_id	VARCHAR
15	views	INTEGER
16	video_id	VARCHAR
17	playlist_saves_added	INTEGER

Table: channel_traffic_source_a2

No	Column Name	Type	Notes
1	date	INTEGER
2	red_watch_time_minutes	DOUBLE
3	average_view_duration_seconds	DOUBLE
4	live_or_on_demand	VARCHAR
5	subscribed_status	VARCHAR
6	traffic_source_type	INTEGER
7	red_views	INTEGER
8	traffic_source_detail	VARCHAR
9	watch_time_minutes	DOUBLE
10	country_code	VARCHAR
11	average_view_duration_percentage	DOUBLE
12	channel_id	VARCHAR
13	views	INTEGER
14	video_id	VARCHAR

Table: channel_cards_a1

No	Column Name	Type	Notes
1	date	INTEGER
2	card_teaser_click_rate	VARCHAR
3	live_or_on_demand	VARCHAR
4	card_teaser_clicks	VARCHAR
5	subscribed_status	VARCHAR
6	card_click_rate	VARCHAR
7	card_type	VARCHAR
8	card_clicks	VARCHAR
9	card_id	VARCHAR
10	card_teaser_impressions	VARCHAR
11	country_code	VARCHAR
12	card_impressions	VARCHAR
13	channel_id	VARCHAR
14	video_id	VARCHAR

Table: channel_basic_a2

No	Column Name	Type	Notes
1	date	INTEGER
2	red_watch_time_minutes	DOUBLE
3	card_teaser_click_rate	DOUBLE
4	subscribed_status	VARCHAR
5	red_views	INTEGER
6	card_clicks	INTEGER
7	annotation_closable_impressions	INTEGER
8	shares	INTEGER
9	annotation_closes	INTEGER
10	card_impressions	INTEGER
11	videos_removed_from_playlists	INTEGER
12	annotation_impressions	INTEGER
13	annotation_clickable_impressions	INTEGER
14	annotation_click_through_rate	DOUBLE
15	views	INTEGER
16	likes	INTEGER
17	annotation_clicks	INTEGER
18	comments	INTEGER
19	average_view_duration_seconds	DOUBLE
20	live_or_on_demand	VARCHAR
21	card_teaser_clicks	INTEGER
22	videos_added_to_playlists	INTEGER
23	card_click_rate	DOUBLE
24	dislikes	INTEGER
25	subscribers_lost	INTEGER
26	watch_time_minutes	DOUBLE
27	annotation_close_rate	DOUBLE
28	card_teaser_impressions	INTEGER
29	country_code	VARCHAR
30	average_view_duration_percentage	DOUBLE
31	channel_id	VARCHAR
32	subscribers_gained	INTEGER
33	video_id	VARCHAR

Table: playlist_device_os_a1

No	Column Name	Type	Notes
1	date	INTEGER
2	average_view_duration_seconds	DOUBLE
3	live_or_on_demand	VARCHAR
4	playlist_saves_removed	INTEGER
5	subscribed_status	VARCHAR
6	device_type	INTEGER
7	watch_time_minutes	DOUBLE
8	country_code	VARCHAR
9	playlist_starts	INTEGER
10	playlist_id	VARCHAR
11	operating_system	INTEGER
12	channel_id	VARCHAR
13	views	INTEGER
14	video_id	VARCHAR
15	playlist_saves_added	INTEGER

Table: channel_sharing_service_a1

No	Column Name	Type	Notes
1	date	INTEGER
2	shares	VARCHAR
3	country_code	VARCHAR
4	sharing_service	VARCHAR
5	live_or_on_demand	VARCHAR
6	subscribed_status	VARCHAR
7	channel_id	VARCHAR
8	video_id	VARCHAR

Table: playlist_basic_a1

No	Column Name	Type	Notes
1	date	INTEGER
2	average_view_duration_seconds	DOUBLE
3	live_or_on_demand	VARCHAR
4	playlist_saves_removed	INTEGER
5	subscribed_status	VARCHAR
6	watch_time_minutes	DOUBLE
7	country_code	VARCHAR
8	playlist_starts	INTEGER
9	playlist_id	VARCHAR
10	channel_id	VARCHAR
11	views	INTEGER
12	video_id	VARCHAR
13	playlist_saves_added	INTEGER

Table: channel_playback_location_a2

No	Column Name	Type	Notes
1	date	INTEGER
2	red_watch_time_minutes	DOUBLE
3	average_view_duration_seconds	DOUBLE
4	live_or_on_demand	VARCHAR
5	playback_location_detail	VARCHAR
6	subscribed_status	VARCHAR
7	red_views	INTEGER
8	watch_time_minutes	DOUBLE
9	playback_location_type	INTEGER
10	country_code	VARCHAR
11	average_view_duration_percentage	DOUBLE
12	channel_id	VARCHAR
13	views	INTEGER
14	video_id	VARCHAR

Table: playlist_playback_location_a1

No	Column Name	Type	Notes
1	date	INTEGER
2	average_view_duration_seconds	DOUBLE
3	live_or_on_demand	VARCHAR
4	playlist_saves_removed	INTEGER
5	playback_location_detail	VARCHAR
6	subscribed_status	VARCHAR
7	watch_time_minutes	DOUBLE
8	playback_location_type	INTEGER
9	country_code	VARCHAR
10	playlist_starts	INTEGER
11	playlist_id	VARCHAR
12	channel_id	VARCHAR
13	views	INTEGER
14	video_id	VARCHAR
15	playlist_saves_added	INTEGER

Table: channel_demographics_a1

No	Column Name	Type	Notes
1	date	INTEGER
2	country_code	VARCHAR
3	gender	VARCHAR
4	live_or_on_demand	VARCHAR
5	age_group	VARCHAR
6	views_percentage	VARCHAR
7	subscribed_status	VARCHAR
8	channel_id	VARCHAR
9	video_id	VARCHAR

Table: channel_annotations_a1

No	Column Name	Type	Notes
1	date	INTEGER
2	annotation_clicks	VARCHAR
3	live_or_on_demand	VARCHAR
4	subscribed_status	VARCHAR
5	annotation_closable_impressions	VARCHAR
6	annotation_close_rate	VARCHAR
7	annotation_id	VARCHAR
8	country_code	VARCHAR
9	annotation_closes	VARCHAR
10	annotation_impressions	VARCHAR
11	annotation_type	VARCHAR
12	annotation_clickable_impressions	VARCHAR
13	annotation_click_through_rate	VARCHAR
14	channel_id	VARCHAR
15	video_id	VARCHAR

Table: channel_device_os_a2

No	Column Name	Type	Notes
1	date	INTEGER
2	red_watch_time_minutes	DOUBLE
3	average_view_duration_seconds	DOUBLE
4	live_or_on_demand	VARCHAR
5	subscribed_status	VARCHAR
6	device_type	INTEGER
7	red_views	INTEGER
8	watch_time_minutes	DOUBLE
9	country_code	VARCHAR
10	average_view_duration_percentage	DOUBLE
11	operating_system	INTEGER
12	channel_id	VARCHAR
13	views	INTEGER
14	video_id	VARCHAR

External Resources

• Reporting Job
• Youtube Reporting Api Dashboard
• Authorization Scope

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.