TikTok Organic
Important
For the Video
table
- We retrieve the latest 500 videos from a TikTok Profile daily
Profile Table
Account ID
- The unique ID of the Instagram account.
Username
- The username of the Instagram account
Instagram ID
- The unique ID of the Instagram account.
Name
- The name associated with the Instagram account (e.g., business or personal name).
Date
- The date for which the metrics are being reported.
Followers Count (Lifetime)
- The total number of followers the account has accumulated over its lifetime.
Media Count (Lifetime)
- The total number of media items (posts, stories, etc.) shared by the account over its lifetime.
Accounts Engaged (Day)
- The number of unique accounts that engaged with the account's content on a given day.
Comments (Day)
- The number of comments received on the account's content on a given day.
Impressions (Day)
- The number of times the account's content was displayed on a given day.
Likes (Day)
- The number of likes received on the account's content on a given day.
Reach (Day)
- The number of unique accounts that saw the account's content on a given day.
Replies (Day)
- The number of replies received on the account's comments on a given day.
Saves (Day)
- The number of times the account's content was saved on a given day.
Shares (Day)
- The number of times the account's content was shared on a given day.
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
- The unique username of the TikTok profile. This is the @ handle.
Display Name
- The display name of the TikTok profile. This is the name that is publicly shown on the profile.
Item ID
- The unique identifier for the TikTok video.
Caption
- The caption text associated with the TikTok video.
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
- The total amount of time (in seconds) the video has been watched across all views.
Share URL
- The URL used for sharing the TikTok video.
Thumbnail URL
- The URL of the video's thumbnail image.
Embed URL
- The URL used for embedding the TikTok video on other platforms.
Video Duration
- The length of the video in seconds.
Video Views
- The total number of times the TikTok video has been viewed.
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
- The average amount of time (in seconds) viewers watched the video.
Reach
- The total number of unique users who saw the video.
Likes
- The total number of likes the TikTok video has received.
Comments
- The total number of comments on the TikTok video.
Shares
- The total number of times the TikTok video has been shared.