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 |
|---|---|---|---|
| account_id | TEXT | Account ID | The account user name |
| account_name | TEXT | Account Name | The account display name |
| audience_activity_count | NUMERIC | Audience Activity Count | 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_countries_country | COUNTRY | Audience Countries Country | Country distribution of the TikTok account's followers. |
| audience_countries_percentage | NUMERIC | Audience Countries Percentage | Percentage of audience registered from a specified country. |
| audience_genders_gender | TEXT | Audience Genders 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. |
| comments | NUMERIC | Comments | Total number of comments received across the TikTok account's videos. |
| 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. |
| 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. |
| is_business_account | BOOLEAN | Is Business Account | Whether the TikTok account is a TikTok Business Account. |
| likes | NUMERIC | Likes | Total number of likes received across the TikTok account's videos. |
| month | TEXT | Month | Number of the month |
| profile_image | IMAGE_URL | Profile Image | URL for profile image for TikTok account. |
| profile_views | NUMERIC | Profile Views | Total number of time the TikTok account's profile has been viewed. |
| shares | NUMERIC | Shares | Total number of times the TikTok account's videos have been shared. |
| 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. |
| username | TEXT | Username | User name of TikTok account. |
| video_views | NUMERIC | Video Views | The total number of times the TikTok account's videos have been viewed. |
| 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 |