Data Sources

TikTok Organic

Metrics & Dimensions List

Important

For the Video table

  • We retrieve the latest 500 videos from a TikTok Profile daily

Profile Table

account_id
Text

Account ID - The unique ID of the Instagram account.

username
Text

Username - The username of the Instagram account

ig_id
Text

Instagram ID - The unique ID of the Instagram account.

name
Text

Name - The name associated with the Instagram account (e.g., business or personal name).

date
Date

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

followers_count_lifetime
Number

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

media_count_lifetime
Number

Media Count (Lifetime) - The total number of media items (posts, stories, etc.) shared by the account over its lifetime.

accounts_engaged_day
Number

Accounts Engaged (Day) - The number of unique accounts that engaged with the account's content on a given day.

comments_day
Number

Comments (Day) - The number of comments received on the account's content on a given day.

impressions_day
Number

Impressions (Day) - The number of times the account's content was displayed on a given day.

likes_day
Number

Likes (Day) - The number of likes received on the account's content on a given day.

reach_day
Number

Reach (Day) - The number of unique accounts that saw the account's content on a given day.

replies_day
Number

Replies (Day) - The number of replies received on the account's comments on a given day.

saves_day
Number

Saves (Day) - The number of times the account's content was saved on a given day.

shares_day
Number

Shares (Day) - The number of times the account's content was shared on a given day.

total_interactions_day
Number

Total Interactions (Day) - The total number of interactions (likes, comments, shares, saves, etc.) with the account's content 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.