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.