Data Sources

TikTok Organic

Metrics & Dimensions List

Updated: 2026-01-25

Important

For the Video table: We retrieve the latest 500 videos from a TikTok Profile daily

Profile Table

username
Text

Username - The unique username of the TikTok profile. This is the @ handle.

display_name
Text

Display Name - The display name of the TikTok profile. This is the name that is publicly shown on the profile.

date
Date

Date - The date for which the metrics are being reported.

followers_count
Number

Followers Count - The total number of followers the account has accumulated over its lifetime.

profile_views
Number

Profile Views - The total number of times the profile has been viewed.

video_views
Number

Video Views - The total number of times the TikTok video has been viewed.

likes
Number

Likes - The total number of likes the TikTok video has received.

comments
Number

Comments - The total number of comments on the TikTok video.

shares
Number

Shares - The total number of times the TikTok video has been shared.

daily_new_followers
Number

Daily New Followers - The number of new followers the account has gained on a given day.

daily_lost_followers
Number

Daily Lost Followers - The number of followers the account has lost on a given day.

bio_link_clicks
Number

Bio Link Clicks - The number of times the bio link has been clicked on a given day.

email_clicks
Number

Email Clicks - The number of times the email has been clicked on a given day.

address_clicks
Number

Address Clicks - The number of times the address has been clicked on a given day.

app_download_clicks
Number

App Download Clicks - The number of times the app download has been clicked on a given day.

lead_submissions
Number

Lead Submissions - The number of times the lead submission has been clicked on a given day.

phone_number_clicks
Number

Phone Number Clicks - The number of times the phone number has been clicked on a given day.

Video Table

username
Text

Username - The unique username of the TikTok profile. This is the @ handle.

display_name
Text

Display Name - The display name of the TikTok profile. This is the name that is publicly shown on the profile.

item_id
Text

Item ID - The unique identifier for the TikTok video.

caption
Text

Caption - The caption text associated with the TikTok video.

create_time
Datetime

Create Time - The date and time the video was created on TikTok. Format should be specified (e.g., YYYY-MM-DD HH:MM:SS).

total_time_watched
Number

Total Time Watched - The total amount of time (in seconds) the video has been watched across all views.

share_url
Text

Share URL - The URL used for sharing the TikTok video.

thumbnail_url
Text

Thumbnail URL - The URL of the video's thumbnail image.

embed_url
Text

Embed URL - The URL used for embedding the TikTok video on other platforms.

video_duration
Number

Video Duration - The length of the video in seconds.

video_views
Number

Video Views - The total number of times the TikTok video has been viewed.

full_video_watched_rate
Number

Full Video Watched Rate - The percentage of viewers who watched the entire video. Represented as a decimal (e.g., 0.85 for 85%).

average_time_watched
Number

Average Time Watched - The average amount of time (in seconds) viewers watched the video.

reach
Number

Reach - The total number of unique users who saw the video.

likes
Number

Likes - The total number of likes the TikTok video has received.

comments
Number

Comments - The total number of comments on the TikTok video.

shares
Number

Shares - The total number of times the TikTok video has been shared.