Windsor brings all your TikTok Organic data into Power BI, Looker Studio, Google Sheets, Excel, BigQuery, Snowflake, Tableau, PostgreSQL, MySQL, Python, Amazon S3, Azure, Azure MS SQL
TikTok Organic Field Reference
Sample
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
Fields
| ID | Type | Name | Description | Report |
|---|---|---|---|---|
| account_id | TEXT | Account ID | The account user name | Account |
| account_name | TEXT | Account Name | The account display name | Account |
| audience_activity_count | NUMERIC | Audience Activity Count | The number of followers online in the specified hour. | Account |
| audience_activity_hour | TEXT | Audience Activity Hour | The number of followers online in each hour of the day. The specific hour in the day. | Account |
| audience_countries_country | COUNTRY | Audience Countries Country | Country distribution of the TikTok account's followers. | Account |
| audience_countries_percentage | NUMERIC | Audience Countries Percentage | Percentage of audience registered from a specified country. | Account |
| audience_genders_gender | TEXT | Audience Genders Gender | Gender distribution of the TikTok account's followers. One of Female, Male, Other. | Account |
| audience_genders_percentage | NUMERIC | Audience Gender Percentage | Percentage of audience associated with specified gender. | Account |
| comments | NUMERIC | Comments | Total number of comments received across the TikTok account's videos. | Account |
| datasource | TEXT | Data Source | The name of the Windsor connector returning the row | |
| date | DATE | Date | The date | |
| day_of_month | TEXT | Day of month | Day of the month | |
| display_name | TEXT | Display Name | Display name for TikTok account. | Account |
| 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. | Account |
| is_business_account | BOOLEAN | Is Business Account | Whether the TikTok account is a TikTok Business Account. | Account |
| likes | NUMERIC | Likes | Total number of likes received across the TikTok account's videos. | Account |
| month | TEXT | Month | Number of the month | |
| profile_image | IMAGE_URL | Profile Image | URL for profile image for TikTok account. | Account |
| profile_views | NUMERIC | Profile Views | Total number of time the TikTok account's profile has been viewed. | Account |
| shares | NUMERIC | Shares | Total number of times the TikTok account's videos have been shared. | Account |
| source | TEXT | Source | The name of the Windsor connector returning the row | |
| today | DATE | Today | Today's date | |
| total_followers_count | NUMERIC | Total Followers Count | Total number of followers for the TikTok account. Available only for current day. | Account |
| username | TEXT | Username | User name of TikTok account. | Account |
| video_audience_countries | OBJECT | 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 |
| video_average_time_watched | NUMERIC | Video Average Time Watched | Average watch-time for the video across all views. | Video |
| video_caption | TEXT | Video Caption | The caption/description for the video. | Video |
| video_comments | NUMERIC | Video Comments Total Count | The total number of comments the video has received. | Video |
| video_create_datetime | TEXT | Video Create Time | Date and time when the video was posted. | Video |
| video_duration | NUMERIC | Video Duration | Duration of the video, in seconds. | Video |
| video_embed_url | TEXT | Video Embed URL | An embeddable URL for the video. | Video |
| video_full_watched_rate | PERCENT | Full Video Watched Rate | Percentage of viewers who viewed the whole video. | Video |
| video_id | TEXT | Video ID | Unique identifier for the video. | Video |
| video_impression_sources | OBJECT | 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 |
| video_likes | NUMERIC | Video Likes Total Count | Total number of likes on the video. | Video |
| video_reach | NUMERIC | Video Reach (Unique Viewers Total Count) | Total number of unique viewers who viewed the video. | Video |
| video_share_url | TEXT | Video Share URL | A shareable URL for the video. | Video |
| video_shares | NUMERIC | Video Shares Total Count | The total number of times the video has been shared. | Video |
| video_thumbnail_url | IMAGE_URL | Video Preview Thumbnail URL | Preview thumbnail for the video. | Video |
| video_total_time_watched | NUMERIC | Video Total Time Watched | Total watch-time for the video across all views. | Video |
| video_views | NUMERIC | Total Video Views Count | The total number of times the TikTok account's videos have been viewed. | Account |
| video_views_count | NUMERIC | Video Views Count | Total number of video views. | Video |
| 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_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 |