TikTok Organic data warehouse table groups

  • Updated on Oct 6, 2025
  • Published on Aug 5, 2025
Prev Next

Table: PROFILE

dataSourceName
Display name Data source
Description The name of the source for this data, as listed on supermetrics.com/docs
Field type dimension
Data type string.text.value
profile__comments
Display name Comments
Description Total number of comments received across business accounts videos. This metric is available per day
Field type metric
Data type int.number.value
profile__date
Display name Date
Field type dimension
Data type string.time.date
profile__display_name
Display name Display name
Description Display name for TikTok account
Field type dimension
Data type string.text.value
profile__likes
Display name Likes
Description Total number of likes received across business accounts videos. The likes count displayed in this field does not subtract unlikes (likes that are removed or withdrawn later). This metric is available per day
Field type metric
Data type int.number.value
profile__new_followers
Display name New followers
Description Total number of followers each day within the specified range
Field type metric
Data type int.number.value
profile__profile_followers__current_followers
Display name Current followers
Description Current total number of accounts following this profile
Field type metric
Data type int.number.value
profile__profile_image_url
Display name Profile image URL
Description The URL link to profile image of the Tiktok account
Field type dimension
Data type string.text.url
profile__profile_views
Display name Profile views
Description Total number of time the business accounts profile has been viewed. This metric is available per day
Field type metric
Data type int.number.value
profile__shares
Display name Shares
Description Total number of times the business accounts videos have been shared. This metric is available per day
Field type metric
Data type int.number.value
profile__total_engagement
Display name Total engagement
Description Total number of engagement. Calculated with Likes + Comments + Shares
Field type metric
Data type int.number.value
profile__username
Display name Username
Description Username of TikTok account
Field type dimension
Data type string.text.value
profile__video_views
Display name Video views
Description The total number of times the business accounts videos have been viewed. This metric is available per day
Field type metric
Data type int.number.value

Table: VIDEO

dataSourceName
Display name Data source
Description The name of the source for this data, as listed on supermetrics.com/docs
Field type dimension
Data type string.text.value
videos__caption
Display name Caption
Description The caption/description for the video
Field type dimension
Data type string.text.value
videos__comments
Display name Comments
Description The total number of comments the video has received
Field type metric
Data type int.number.value
videos__create_date
Display name Create date
Description Date when the video was posted
Field type dimension
Data type string.time.date
videos__create_datetime
Display name Create datetime
Description Date-time when the video was posted
Field type dimension
Data type string.time.datetime
videos__display_name
Display name Display name
Description Display name for TikTok account
Field type dimension
Data type string.text.value
videos__embed_url
Display name Embed URL
Description An embeddable URL for the video
Field type dimension
Data type string.text.url
videos__likes
Display name Likes
Description The total number of likes the video has received
Field type metric
Data type int.number.value
videos__reach
Display name Reach
Description Total number of unique viewers who viewed the video
Field type metric
Data type int.number.value
videos__share_url
Display name Share URL
Description A shareable URL for the video
Field type dimension
Data type string.text.url
videos__shares
Display name Shares
Description The total number of times the video has been shared
Field type metric
Data type int.number.value
videos__thumbnail_url
Display name Thumbnail URL
Description Preview thumbnail URL for the video
Field type dimension
Data type string.text.url
videos__total_time_watched_h
Display name Total time watched (h)
Description Total watch-time in hours for the video across all views
Field type metric
Data type float.number.value
videos__total_time_watched_min
Display name Total time watched (min)
Description Total watch-time in minutes for the video across all views
Field type metric
Data type float.number.value
videos__total_time_watched_sec
Display name Total time watched (s)
Description Total watch-time in seconds for the video across all views
Field type metric
Data type float.number.value
videos__username
Display name Username
Description Username of TikTok account
Field type dimension
Data type string.text.value
videos__video_completion_rate
Display name Video completion rate
Description Percentage of viewers who viewed the whole video
Field type metric
Data type float.number.ratio
videos__video_duration_min
Display name Video duration (min)
Description Duration of the video, in minutes
Field type metric
Data type float.number.value
videos__video_duration_sec
Display name Video duration (s)
Description Duration of the video, in seconds
Field type metric
Data type float.number.value
videos__video_id
Display name Video ID
Description Unique identifier for the video
Field type dimension
Data type string.text.value
videos__video_views
Display name Video views
Description The total number of views the video has received
Field type metric
Data type int.number.value

Table: COUNTRY

dataSourceName
Display name Data source
Description The name of the source for this data, as listed on supermetrics.com/docs
Field type dimension
Data type string.text.value
territories__country
Display name Country
Description Country of business accounts followers
Field type dimension
Data type string.geo.country.twolettercode
territories__display_name
Display name Display name
Description Display name for TikTok account
Field type dimension
Data type string.text.value
territories__distribution
Display name Distribution
Description Country distribution of business accounts followers. This information is available as an aggregate of the previous 60 days. This information is not available for accounts with less than 100 followers
Field type metric
Data type float.number.ratio
territories__username
Display name Username
Description Username of TikTok account
Field type dimension
Data type string.text.value

Table: GENDER

dataSourceName
Display name Data source
Description The name of the source for this data, as listed on supermetrics.com/docs
Field type dimension
Data type string.text.value
gender__display_name
Display name Display name
Description Display name for TikTok account
Field type dimension
Data type string.text.value
gender__distribution
Display name Distribution
Description Gender distribution of business accounts followers. This information is available as an aggregate of the previous 60 days. This information is not available for accounts with less than 100 followers
Field type metric
Data type float.number.ratio
gender__gender
Display name Gender
Description Gender of business accounts followers
Field type dimension
Data type string.person.gender
gender__username
Display name Username
Description Username of TikTok account
Field type dimension
Data type string.text.value