YouTube Public Connector Reference
6 metrics32 dimensions
The YouTube Public connector exposes 38 fields (6 metrics, 32 dimensions). Every field ID below can be passed to the Windsor.ai API in the fields parameter.
YouTube Public Fields
YouTube Public Channel fields
The Channel report of the YouTube Public connector includes 8 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| channel_country | COUNTRY | Channel Country | The country the channel is associated with. |
| channel_created_date | DATE | Channel Created Date | The date the channel was created. |
| channel_handle | TEXT | Channel Handle | The @handle of the channel. |
| channel_id | TEXT | Channel ID | The ID of the channel. |
| channel_title | TEXT | Channel Title | The title of the channel. |
| subscriber_count | NUMERIC | Subscriber Count | The current number of subscribers, rounded by YouTube. Empty when the channel hides it. |
| video_count | NUMERIC | Video Count | The current number of public videos of the channel. |
| view_count | NUMERIC | View Count | The current total number of views of all the channel's videos. |
YouTube Public Video fields
The Video report of the YouTube Public connector includes 9 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| published_at | DATE | Video Published Date | The date and time that the video was published (UTC). |
| video | TEXT | Video ID | The ID of the video. |
| video_comment_count | NUMERIC | Video Comment Count | The current total number of comments of the video. Empty when comments are off. |
| video_length | TEXT | Video Length | The length of the video as H:MM:SS, e.g. 0:01:30. |
| video_like_count | NUMERIC | Video Like Count | The current total number of likes of the video. Empty when the channel hides it. |
| video_tags | TEXT | Video Tags | The tags of the video, separated by commas. |
| video_thumbnail_url | IMAGE_URL | Video Thumbnail URL | The URL of the 480x360 thumbnail of the video. |
| video_title | TEXT | Video Title | The title of the video. |
| video_view_count | NUMERIC | Video View Count | The current total number of views of the video. |
YouTube Public other fields
The YouTube Public connector has 21 fields that do not belong to a named report, or belong to a report with only one or two fields.
| ID | Type | Name | Description | Report |
|---|---|---|---|---|
| account_id | TEXT | Account ID | The followed channel as entered: an @handle or a channel ID. | |
| account_name | TEXT | Account Name | The name of the followed channel as entered. | |
| data_fetched_at | Data fetched at | UTC timestamp (second precision) of when the connector request that pulled the row started. Freshly pulled rows show this request's start time; cache hits keep the start time of the request that filled the cache. Selecting this field disables aggregation, so rows are returned individually (each keeping its own fetch time) instead of being summed. | ||
| datasource | TEXT | Data Source | The name of the Windsor connector returning the row | |
| date | DATE | Date | The date the video was published (UTC). Rows without video fields carry the end date of the requested range. | |
| day_of_month | TEXT | Day of month | Day of the month | |
| month | TEXT | Month | Number of the month | |
| now | Now | Current timestamp | ||
| source | TEXT | Source | The name of the Windsor connector returning the row | |
| today | DATE | Today | Today's date | |
| week | TEXT | Week | Week (Sun-Sat). | |
| week_day | TEXT | Day of week and day number | Weekday number and name combined (Sun-Sat).Numbered from 0 Sunday to 6 Saturday. | |
| week_day_iso | TEXT | Day of week and day number, ISO | Weekday number and name combined, ISO format (Mon-Sun).Numbered from 1 Monday to 7 | |
| week_iso | TEXT | Week ISO | Week, ISO format (Mon-Sun). | |
| year | TEXT | Year | Year | |
| year_month | TEXT | Yearmonth | Year and month, e.g. 2024|3 | |
| year_month_name | TEXT | Year month name | Year and month with the month name written out, e.g. "Jan 2025". | |
| year_of_week | TEXT | Year of week | The year that contains first day of the week (Sun-Sat). | |
| year_of_week_iso | TEXT | Year of week, ISO | The year that contains first day of the ISO week (Mon-Sun). | |
| year_week | TEXT | Year week | Year and week for US weeks (Sun-Sat), e.g. 2024|15 | |
| year_week_iso | TEXT | Year week ISO | Year and week for ISO weeks (Mon-Sun), e.g. 2024|20 |
