TikTok Organic

Creating the data source

Requirements

Account Type: TikTok Business or Personal account
Minimum Followers: At least 100 followers
Analytics: Must be enabled
Public Content: At least one public post
Login Credentials: Must log in with the same credentials used on the TikTok mobile app

Instructions

Go to the TikTok Organic connector creation page by clicking on CREATE + > Data source
Click Authenticate
On the authorization page, click Continue
After authentication, click SAVE

Pipelines

Relationship chart

Click to expand

Account

Stores a daily history (field metric_date) of the readings performed since the pipeline was created

Campo	Tipo
video_creator_username	text	[en] TikTok account username or @
metric_date	date	[en] Date the data was read
bio_description	text	[en] User-entered description in the profile bio section.
display_name	text	[en] Display name set on the TikTok account.
followers_count	float	[en] Total number of followers of the account.
following_count	float	[en] Number of accounts this profile is following on TikTok.
is_business_account	boolean	[en] Indicates whether the account is a TikTok Business account.
is_verified	boolean	[en] Indicates whether the account is officially verified by TikTok.
profile_deep_link	text	[en] Direct deep link to the TikTok profile, usually in shortened format.
profile_image	text	[en] URL of the profile image associated with the TikTok account.
total_likes	float	[en] Total number of likes received by the TikTok account across all videos.
videos_count	float	[en] Total number of videos published by the account.

Account: metrics

The maximum historical load period is 58 days

Main object

Campo	Tipo
video_creator_username	text	[en] TikTok account username or @ Account > > video_creator_username
metric_date	date	[en] Date of the analytics data
profile_image	text	[en] URL of the profile image associated with the TikTok account. Account > > profile_image
address_clicks	float	[en] Number of clicks on the address/location link in the TikTok profile.
app_download_clicks	float	[en] Number of clicks on the app download link in the profile on the given date.
bio_link_clicks	float	[en] Number of clicks on the link in the bio section of the TikTok profile.
comments	float	[en] Total number of comments received on videos during the given date.
daily_lost_followers	float	[en] Number of followers lost on the given date.
daily_new_followers	float	[en] Number of new followers gained on the given date.
daily_total_followers	float	[en] Total number of followers at the end of the given date.
email_clicks	float	[en] Number of clicks on the email contact link in the TikTok profile.
engaged_audience	float	[en] Number of followers who engaged (liked, commented, shared, etc.) with content on the given date.
followers_count	float	[en] Total number of followers of the account at the time of the report.
lead_submissions	float	[en] Number of leads submitted through TikTok lead forms associated with the account.
likes	float	[en] Total number of likes received on the account’s videos during the given date.
phone_number_clicks	float	[en] Number of clicks on the phone number link in the TikTok profile.
profile_views	float	[en] Number of times the TikTok profile was viewed on the given date.
shares	float	[en] Total number of times the account’s videos were shared on the given date.
unique_video_views	float	[en] Total number of unique views across all videos on the specified date.
video_views	float	[en] Total number of views on all videos for the specified date.

tiktok_organic_account_metrics_audience_activity

Campo	Tipo
video_creator_username	text	[en] TikTok account username or @ Account > > video_creator_username
metric_date	date	[en] Date of the analytics data related to audience activity
audience_activity_count	float	[en] Count of audience activity on the TikTok account.
audience_activity_hour	float	[en] Hours of day associated with each audience activity count.

Videos

Stores a daily history (field metric_date) of the readings performed since the pipeline was created
The data will stop being updated after 365 days
The update window (and savepoint) is based on the video creation date

Main object

Campo	Tipo
item_id	text	[en] Video unique identifier.
video_creator_username	text	[en] TikTok account username or @ Account > > video_creator_username
metric_date	date	[en] Date of video data collection.
app_download_clicks	float	[en] Number of clicks to download the application from the video.
average_time_watched	float	[en] Average time (in seconds) viewers watched the video.
caption	text	[en] Caption or description added to the video.
comments	float	[en] Number of comments on the video.
create_time	timestamp	[en] Video publication date/time in Unix/Epoch format.
embed_url	text	[en] URL used to embed the video in external pages.
favorites	float	[en] Number of times the video was added to favorites.
full_video_watched_rate	float	[en] Proportion of complete video views (between 0 and 1).
lead_submissions	float	[en] Number of form submissions (leads) generated by the video.
likes	float	[en] Number of likes received by the video.
new_followers	float	[en] Number of new followers gained from the video.
phone_number_clicks	float	[en] Number of clicks on the phone number shown in the video or profile.
profile_views	float	[en] Number of times the profile was viewed from the video.
reach	float	[en] Number of people who watched the video at least once.
share_url	text	[en] Public URL of the video, used for sharing.
shares	float	[en] Number of times the video was shared.
thumbnail_url	text	[en] URL of the video thumbnail.
total_time_watched	float	[en] Total time (in seconds) the video was watched by all users.
video_duration	float	[en] Video duration in seconds.
video_views	float	[en] Number of video views.
website_clicks	float	[en] Number of clicks to visit the website from the video.

tiktok_organic_videos_impression_sources

Campo	Tipo
item_id	text	[en] Video unique identifier.
video_creator_username	text	[en] TikTok account username or @ Account > > video_creator_username
metric_date	date	[en] Date of video data collection.
impression_sources_impression_source	text	[en] Video impression source (e.g.: Search, For You, Personal Profile).
impression_sources_percentage	float	[en] Percentage of impressions that came from the indicated source.

tiktok_organic_videos_engagement_likes

Campo	Tipo
item_id	text	[en] Video unique identifier.
video_creator_username	text	[en] TikTok account username or @ Account > > video_creator_username
metric_date	date	[en] Date of video data collection.
engagement_likes_percentage	float	[en] Percentage of likes received in the corresponding second.
engagement_likes_second	float	[en] Specific second where likes occurred during the video.

tiktok_organic_videos_audience_types

Campo	Tipo
item_id	text	[en] Video unique identifier.
video_creator_username	text	[en] TikTok account username or @ Account > > video_creator_username
metric_date	date	[en] Date of video data collection.
audience_types_percentage	float	[en] Percentage corresponding to the audience type.
audience_types_type	text	[en] Audience type (e.g.: FOLLOWER_PERCENT, NEW_VIEWER, NON_FOLLOWER_PERCENT, RETURN_VIEWER).

tiktok_organic_videos_audience_countries

Campo	Tipo
item_id	text	[en] Video unique identifier.
video_creator_username	text	[en] TikTok account username or @ Account > > video_creator_username
metric_date	date	[en] Date of video data collection.
audience_countries_country	text	[en] Country code (e.g.: BR, US) where the video audience comes from.
audience_countries_percentage	float	[en] Percentage of audience from the specified country.

tiktok_organic_videos_audience_cities

Campo	Tipo
item_id	text	[en] Video unique identifier.
video_creator_username	text	[en] TikTok account username or @ Account > > video_creator_username
metric_date	date	[en] Date of video data collection.
audience_cities_city_name	text	[en] Name of the city where the video audience comes from.
audience_cities_percentage	float	[en] Percentage of video audience from the specified city.

tiktok_organic_videos_video_view_retention

Campo	Tipo
item_id	text	[en] Video unique identifier.
video_creator_username	text	[en] TikTok account username or @ Account > > video_creator_username
metric_date	date	[en] Date of video data collection.
video_view_retention_percentage	float	[en] Percentage of views retained up to the corresponding second.
video_view_retention_second	float	[en] Specific second of the video where view retention occurred.

tiktok_organic_videos_audience_genders

Campo	Tipo
item_id	text	[en] Video unique identifier.
video_creator_username	text	[en] TikTok account username or @ Account > > video_creator_username
metric_date	date	[en] Date of video data collection.
audience_genders_gender	text	[en] Audience gender (e.g.: male_vv, female_vv, other_vv).
audience_genders_percentage	float	[en] Percentage of audience for each gender.

Videos: comments

The update window (and savepoint) is based on the video creation date

Campo	Tipo
video_id	text	[en] Identifier of the video to which the comment is associated. Videos > > item_id
comment_id	text	[en] Unique identifier of the comment.
video_creator_username	text	[en] TikTok account username or @ Account > > video_creator_username
thumbnail_url	text	[en] URL of the video thumbnail.
create_time	timestamp	[en] Date/time when the comment was created, in Unix/Epoch format.
display_name	text	[en] Display name of the comment author (may contain special characters or emojis).
liked	boolean	[en] Indicates if the comment was liked by the API authenticated user (boolean).
likes	float	[en] Number of likes received by this comment.
owner	boolean	[en] Indicates if the comment was made by the account owner (boolean).
pinned	boolean	[en] Indicates if the comment is pinned at the top of the comments section (boolean).
profile_image	text	[en] URL of the comment author's profile image.
replies	float	[en] Number of replies to the comment (threaded comments).
status	text	[en] Comment status, such as 'PUBLIC' for publicly visible comments.
text	text	[en] Text of the comment made on the video.
unique_identifier	text	[en] Encrypted or encoded comment identifier (platform internal use).
user_id	text	[en] Unique identifier of the comment author.
comment_author_username	text	[en] Username of the comment author.