TikTok Organic Connector Reference

66 metrics54 dimensions

Fields

https://connectors.windsor.ai/tiktok_organic?api_key=[your API key]&date_preset=last_7d&fields=date,username,likes,audience_genders_gender,audience_genders_percentage

The TikTok Organic connector exposes 120 fields (66 metrics, 54 dimensions). Every field ID below can be passed to the Windsor.ai API in the fields parameter.

TikTok Organic Fields

TikTok Organic Account fields

The Account report of the TikTok Organic connector includes 45 fields.

TikTok Organic Account fields (account_id to total_followers_count)

ID	Type	Name	Description
account_id	TEXT	Account ID	The account user name
account_name	TEXT	Account Name	The account display name
address_clicks	NUMERIC	Address Clicks	The daily number of clicks collected on the Address button on your profile during the selected time range.
app_download_clicks	NUMERIC	App Download Link Clicks	The daily number of clicks collected on your app download link in the selected date range.
audience_activity_count	NUMERIC	Audience Activity Count	The number of followers online in the specified hour.
audience_activity_count_non_aggregated	NUMERIC	(Internal) Audience Activity Count (Non-Aggregated)	(Internal) The number of followers online in the specified hour.
audience_activity_hour	TEXT	Audience Activity Hour	The number of followers online in each hour of the day. The specific hour in the day.
audience_ages_age	TEXT	Audience Ages Age Group	Age group: 18-24, 25-34, 35-44, 45-54, 55+.
audience_ages_percentage	NUMERIC	Audience Ages Percentage	Percentage of followers associated with the age group.
audience_ages_percentage_non_aggregated	NUMERIC	(Internal) Audience Ages Percentage (Non-Aggregated)	(Internal) Percentage of followers associated with the age group.
audience_cities_city_name	CITY	Audience Cities City	City name.
audience_cities_percentage	NUMERIC	Audience Cities Percentage	Percentage of followers associated with the city.
audience_cities_percentage_non_aggregated	NUMERIC	(Internal) Audience Cities Percentage (Non-Aggregated)	(Internal) Percentage of followers associated with the city.
audience_countries_country	COUNTRY	Audience Country	Country distribution of the TikTok account's followers.
audience_countries_percentage	NUMERIC	Audience Country Percentage	Percentage of audience registered from a specified country.
audience_countries_percentage_non_aggregated	NUMERIC	(Internal) Audience Country Percentage (Non-Aggregated)	(Internal) Percentage of audience registered from a specified country.
audience_genders_gender	TEXT	Audience Gender	Gender distribution of the TikTok account's followers. One of Female, Male, Other.
audience_genders_percentage	NUMERIC	Audience Gender Percentage	Percentage of audience associated with specified gender.
audience_genders_percentage_non_aggregated	NUMERIC	(Internal) Audience Gender Percentage (Non-Aggregated)	(Internal) Percentage of audience associated with specified gender.
bio_description	TEXT	Bio Description	The bio description of the TikTok account.
bio_link_clicks	NUMERIC	Bio Link Clicks	The daily number of clicks collected on your link-in-bio during the selected time range.
comments	NUMERIC	Comments	The daily number of times people have commented on your published videos.
daily_lost_followers	NUMERIC	Daily count of lost followers	The daily number of followers you have lost.
daily_total_followers	NUMERIC	Daily Total Followers Growth	The daily change in the number of followers.
daily_total_followers_count	NUMERIC	(Internal) Daily Total Followers Count	(Internal) Total number of followers for the TikTok account for day.
display_name	TEXT	Display Name	Display name for TikTok account.
email_clicks	NUMERIC	Email Clicks	The daily number of clicks collected on the Email button on your profile during the selected time range.
engaged_audience	NUMERIC	Engaged Audience	The daily number of people who engaged (liked, commented or shared) with at least one of your published content.
followers_count	NUMERIC	Daily count of gained followers	Net number of followers gained for the TikTok Account on the specified day, which is calculated by subtracting the count of unfollowed users from the count of new followers.
following_count	NUMERIC	Following Count	The number of accounts that the TikTok account is following.
is_business_account	BOOLEAN	Is Business Account	Whether the TikTok account is a TikTok Business Account.
is_verified	BOOLEAN	Is Verified	Whether TikTok has provided a verified badge to the TikTok account after confirming that it belongs to the user it represents.
lead_submissions	NUMERIC	Lead Submissions	The daily number of leads (e.g. price quotes, newsletter subscriptions, etc.) collected from your consumers in the selected date range.
likes	NUMERIC	Likes	The daily number of times people have liked your published videos.
phone_number_clicks	NUMERIC	Phone Number Clicks	The daily number of clicks collected on your phone number link in the selected date range.
profile_deep_link	TEXT	Profile Deep Link	The link to the profile page of the TikTok account.
profile_image	IMAGE_URL	Profile Image	URL for profile image for TikTok account.
profile_views	NUMERIC	Profile Views	The daily number of clicks on your profile from users.
shares	NUMERIC	Shares	The daily number of times people have shared your published videos.
total_followers_count	NUMERIC	Total Followers Count	Total number of followers for the TikTok account for current day.

TikTok Organic Account fields (total_likes to videos_count)

ID	Type	Name	Description
total_likes	NUMERIC	Total Likes	The total number of times people have liked your published videos.
unique_video_views	NUMERIC	Daily reached audience	The daily number of people who watched your published content at least once.
username	TEXT	Username	User name of TikTok account.
video_views	NUMERIC	Total Video Views Count	The total number of times the TikTok account's videos have been viewed.
videos_count	NUMERIC	Videos Count	The lifetime number of public videos posted by the TikTok account.

TikTok Organic Comment fields

The Comment report of the TikTok Organic connector includes 7 fields.

ID	Type	Name	Description
comment_id	TEXT	Comment ID	The unique identifier of the comment.
comment_likes	NUMERIC	Comment Likes	The number of likes the comment has received.
comment_parent_id	TEXT	Comment Parent ID	The parent comment identifier; empty for a top-level comment.
comment_text	TEXT	Comment Text	The text content of the comment.
comment_username	TEXT	Comment Username	The username of the comment author.
comment_video_id	TEXT	Comment Video ID	The identifier of the video the comment belongs to.
comment_visibility	TEXT	Comment Visibility	The visibility status of the comment.

TikTok Organic Video fields

The Video report of the TikTok Organic connector includes 49 fields.

TikTok Organic Video fields (video_address_clicks to video_reach)

ID	Type	Name	Description
video_address_clicks	NUMERIC	Video Address Clicks	Total number of times people have clicked the Address button on your profile after watching this specific video.
video_app_download_clicks	NUMERIC	Video App Download Link Clicks	Total number of clicks on your app download link from users who visited your profile page through your video.
video_audience_cities_city_name	CITY	Video Audience City	City name.
video_audience_cities_percentage	PERCENT	Video Audience City Percentage	Percentage of viewers associated with the city.
video_audience_cities_percentage_non_aggregated	PERCENT	(Internal) Video Audience City Percentage (Non-Aggregated)	(Internal) Percentage of viewers associated with the city.
video_audience_countries	OBJECT	(Deprecated) Video Audience Countries	Country percentage distribution of the top 10 countries where video viewers are located. Contains list with fields `country` and `percentage`. For example: [{"country":"CA","percentage":0.0132}, {"country":"GB","percentage":0.0987}.
video_audience_countries_country	COUNTRY	Video Audience Country	Country or region code of the video viewers.
video_audience_countries_percentage	PERCENT	Video Audience Country Percentage	Percentage of viewers registered from a country or region.
video_audience_countries_percentage_non_aggregated	PERCENT	(Internal) Video Audience Country Percentage (Non-Aggregated)	(Internal) Percentage of viewers registered from a country or region.
video_audience_genders_gender	TEXT	Video Audience Gender	Gender: Female, Male, Other.
video_audience_genders_percentage	PERCENT	Video Audience Gender Percentage	Percentage of viewers associated with the gender.
video_audience_genders_percentage_non_aggregated	PERCENT	(Internal) Video Audience Gender Percentage (Non-Aggregated)	(Internal) Percentage of viewers associated with the gender.
video_audience_types_percentage	PERCENT	Video Audience Type Percentage	Percentage of viewers associated with the audience type.
video_audience_types_percentage_non_aggregated	PERCENT	(Internal) Video Audience Type Percentage (Non-Aggregated)	(Internal) Percentage of viewers associated with the audience type.
video_audience_types_type	TEXT	Video Audience Type	Audience type: NEW_VIEWER, RETURN_VIEWER, FOLLOWER_PERCENT, NON_FOLLOWER_PERCENT.
video_average_time_watched	NUMERIC	Video Average Time Watched	Average watch-time for the video across all views.
video_average_time_watched_non_aggregated	NUMERIC	(Internal) Video Average Time Watched (Non-Aggregated)	(Internal) Average watch-time for the video across all views.
video_caption	TEXT	Video Caption	The caption/description for the video.
video_comments	NUMERIC	Video Comments Total Count	The total number of comments the video has received.
video_create_datetime	TEXT	Video Create Time	Date and time when the video was posted.
video_duration	NUMERIC	Video Duration	Duration of the video, in seconds.
video_email_clicks	NUMERIC	Video Email Clicks	Total number of times people have clicked the Email button on your profile after watching this specific video.
video_embed_url	TEXT	Video Embed URL	An embeddable URL for the video.
video_engagement_likes_percentage	PERCENT	Video Engagement Likes Percentage	Percentage of viewers who liked your video at the specific second.
video_engagement_likes_percentage_non_aggregated	PERCENT	(Internal) Video Engagement Likes Percentage (Non-Aggregated)	(Internal) Percentage of viewers who liked your video at the specific second.
video_engagement_likes_second	TEXT	Video Engagement Likes Second	A specific second in the video's timeline.
video_favorites	NUMERIC	Video Favorites Total Count	The total number of times the video has been added to favorites.
video_full_watched_rate	PERCENT	Full Video Watched Rate	Percentage of viewers who viewed the whole video.
video_full_watched_rate_non_aggregated	PERCENT	(Internal) Full Video Watched Rate (Non-Aggregated)	(Internal) Percentage of viewers who viewed the whole video.
video_id	TEXT	Video ID	Unique identifier for the video.
video_impression_sources	OBJECT	(Deprecated) Video Impression Sources	Sources of video views, contains list with fields `impression_source` and `percentage`. `impression_source` possible values are: "For You": View originated from a user For You feed; "Follow": View originated from a user Follow feed; "Hashtag": View originated from a hashtag; "Sound": View originated from the videos sound; "Search": View originated from a search on the Discover page.
video_impression_sources_impression_source	TEXT	Video Impression Source	The traffic source type.
video_impression_sources_percentage	PERCENT	Video Impression Source Percentage	The percentage of views from the source type.
video_impression_sources_percentage_non_aggregated	PERCENT	(Internal) Video Impression Source Percentage (Non-Aggregated)	(Internal) The percentage of views from the source type.
video_lead_submissions	NUMERIC	Video Lead Submissions	Total number of leads (e.g. price quotes, newsletter subscriptions, etc.) collected from your consumers who visited your profile page through your video.
video_likes	NUMERIC	Video Likes Total Count	Total number of likes on the video.
video_new_followers	NUMERIC	Video New Followers	Number of viewers who started following you.
video_phone_number_clicks	NUMERIC	Video Phone Number Clicks	Total number of clicks on your phone number link from users who visited your profile page through your video.
video_profile_views	NUMERIC	Video Profile Views	Total number of profile views from users who visited through your video.
video_reach	NUMERIC	Video Reach (Unique Viewers Total Count)	Number of people who watched the video at least once, as reported by TikTok's `reach` field (TikTok Studio "Total viewers"). TikTok delivers it 24-48 hours after the views and can under-report it for high-volume videos.

TikTok Organic Video fields (video_share_url to video_website_clicks)

ID	Type	Name	Description
video_share_url	TEXT	Video Share URL	A shareable URL for the video.
video_shares	NUMERIC	Video Shares Total Count	The total number of times the video has been shared.
video_thumbnail_url	IMAGE_URL	Video Preview Thumbnail URL	Preview thumbnail for the video.
video_total_time_watched	NUMERIC	Video Total Time Watched	Total watch-time for the video across all views.
video_view_retention_percentage	PERCENT	Video View Retention Percentage	The percentage of viewers who are still watching your video at the specific second.
video_view_retention_percentage_non_aggregated	PERCENT	(Internal) Video View Retention Percentage (Non-Aggregated)	(Internal) The percentage of viewers who are still watching your video at the specific second.
video_view_retention_second	TEXT	Video View Retention Second	A specific second in the video's timeline on which retention is measured.
video_views_count	NUMERIC	Video Views Count	Total number of video views.
video_website_clicks	NUMERIC	Video Website Clicks	Total number of clicks on your website link from users who visited your profile page through your video.

TikTok Organic other fields

The TikTok Organic connector has 19 fields that do not belong to a named report, or belong to a report with only one or two fields.

ID	Type	Name	Description
data_fetched_at	TIMESTAMP	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	Date. For video and comment rows, the date the video was created. The date range selects videos by this date.
day_of_month	TEXT	Day of month	Day of the month
month	TEXT	Month	Number of the month
now	TIMESTAMP	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

API Connectors