TikTok Organic fields

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

Supermetrics brings all your TikTok Organic data into Google Sheets, Looker Studio, Power BI, Excel, BigQuery, Snowflake, Redshift, Azure

23 metrics49 dimensions

COMMENT

videos__video_comments_decorations__comment_id
Field label Comment ID
Description Unique identifier for the comment
Field type dimension
Data type string.text.value
videos__video_comments_decorations__comment_date
Field label Comment date
Description Date when the comment was posted
Field type dimension
Data type string.time.date
videos__video_comments_decorations__comment_date_time
Field label Comment datetime
Description Date and time when the comment was posted
Field type dimension
Data type string.time.date
videos__video_comments_decorations__comment_username
Field label Comment username
Description Username of the comment
Field type dimension
Data type string.text.value
videos__video_comments_decorations__comment_text
Field label Comment text
Description The text content of the comment
Field type dimension
Data type string.text.value

COUNTRY

territories__country
Field label Country
Description Country of business accounts followers
Field type dimension
Data type string.geo.country.twolettercode

COUNTRY DISTRIBUTION

territories__distribution
Field label 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

DATASOURCE

dataSourceName
Field label 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
Destinations API, Data warehouse
system_metadata.data_source_logins
Field label Data source logins
Description The data source login accounts that were used to authenticate against the data source
Field type dimension
Data type string.text.json
system_metadata.data_source_login_owners
Field label Data source login owners
Description The Supermetrics users that created the data source login connections
Field type dimension
Data type string.text.json

ENGAGEMENT

profile__video_views
Field label 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
profile__profile_views
Field label 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__total_engagement
Field label Total engagement
Description Total number of engagement. Calculated with Likes + Comments + Shares
Field type metric
Data type int.number.value
profile__likes
Field label 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__comments
Field label 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__shares
Field label 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__new_followers
Field label 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
Field label Current followers
Description Current total number of accounts following this profile
Field type metric
Data type int.number.value

GENDER

gender__gender
Field label Gender
Description Gender of business accounts followers
Field type dimension
Data type string.person.gender

GENDER DISTRIBUTION

gender__distribution
Field label 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

PROFILE

profile__username
Field label Username
Description Username of TikTok account
Field type dimension
Data type string.text.value
profile__display_name
Field label Display name
Description Display name for TikTok account
Field type dimension
Data type string.text.value
profile__profile_image_url
Field label Profile image URL
Description The URL link to profile image of the Tiktok account
Field type dimension
Data type string.text.url
videos__username
Field label Username
Description Username of TikTok account
Field type dimension
Data type string.text.value
videos__display_name
Field label Display name
Description Display name for TikTok account
Field type dimension
Data type string.text.value
territories__username
Field label Username
Description Username of TikTok account
Field type dimension
Data type string.text.value
territories__display_name
Field label Display name
Description Display name for TikTok account
Field type dimension
Data type string.text.value
gender__username
Field label Username
Description Username of TikTok account
Field type dimension
Data type string.text.value
gender__display_name
Field label Display name
Description Display name for TikTok account
Field type dimension
Data type string.text.value

QUERY

system_metadata.query_date_range_start
Field label Start date
Description The start date of the requested query
Field type dimension
Data type string.time.date
system_metadata.query_date_range_end
Field label End date
Description The end date of the requested query
Field type dimension
Data type string.time.date
system_metadata.query_timezone
Field label Timezone
Description The timezone that is supplied to the query
Field type dimension
Data type string.time.timezone
system_metadata.query_filters
Field label Filters
Description All filters used in the query
Field type dimension
Data type string.text.json
system_metadata.query_date_start
Field label Start
Description When the query was started
Field type dimension
Data type string.time.datetime
system_metadata.query_date_end
Field label End
Description When the query completed
Field type dimension
Data type string.time.datetime
system_metadata.query_duration
Field label Duration
Description The duration in seconds of the query
Field type dimension
Data type int.duration.seconds
system_metadata.query_accounts
Field label Accounts
Description A list of accounts of which the data was pulled from
Field type dimension
Data type string.text.json

TIME

today
Field label Today
Description Today's date, e.g. 2017-01-31
Field type dimension
Data type string.time.date
Destinations API, Data warehouse
profile__year
Field label Year
Field type dimension
Data type string.time.year
profile__year_of_week
Field label Year of week (Sun-Sat)
Field type dimension
Data type string.time.year
profile__year_of_week_iso
Field label Year of week (Mon-Sun)
Field type dimension
Data type string.time.year
profile__year_month
Field label Year & month
Field type dimension
Data type string.time.yearmonth
profile__month
Field label Month
Field type dimension
Data type string.time.month
profile__year_week
Field label Year & week (Sun-Sat)
Field type dimension
Data type string.time.yearweek
profile__year_week_iso
Field label Year & week (Mon-Sun)
Field type dimension
Data type string.time.yearweekiso
profile__week
Field label Week (Sun-Sat)
Field type dimension
Data type string.time.week
profile__week_iso
Field label Week (Mon-Sun)
Field type dimension
Data type string.time.weekiso
profile__day_of_month
Field label Day of month
Field type dimension
Data type string.time.dayofmonth
profile__day_of_week_name
Field label Day of week (Sun-Sat)
Field type dimension
Data type string.time.dayofweek
profile__day_of_week_name_iso
Field label Day of week (Mon-Sun)
Field type dimension
Data type string.time.dayofweekiso
profile__date
Field label Date
Field type dimension
Data type string.time.date
profile__atom
Field label Datetime
Field type dimension
Data type string.time.datetime

VIDEO

videos__video_id
Field label Video ID
Description Unique identifier for the video
Field type dimension
Data type string.text.value
videos__caption
Field label Caption
Description The caption/description for the video
Field type dimension
Data type string.text.value
videos__create_date
Field label Create date
Description Date when the video was posted
Field type dimension
Data type string.time.date
videos__create_datetime
Field label Create datetime
Description Date-time when the video was posted
Field type dimension
Data type string.time.datetime
videos__thumbnail_url
Field label Thumbnail URL
Description Preview thumbnail URL for the video
Field type dimension
Data type string.text.url
videos__share_url
Field label Share URL
Description A shareable URL for the video
Field type dimension
Data type string.text.url
videos__embed_url
Field label Embed URL
Description An embeddable URL for the video
Field type dimension
Data type string.text.url
videos__video_views
Field label Video views
Description The total number of views the video has received
Field type metric
Data type int.number.value
videos__likes
Field label Likes
Description The total number of likes the video has received
Field type metric
Data type int.number.value
videos__comments
Field label Comments
Description The total number of comments the video has received
Field type metric
Data type int.number.value
videos__shares
Field label Shares
Description The total number of times the video has been shared
Field type metric
Data type int.number.value
videos__reach
Field label Reach
Description Total number of unique viewers who viewed the video
Field type metric
Data type int.number.value
videos__favorites
Field label Favorites
Description The total number of times the video has been added to favorites
Field type metric
Data type int.number.value
videos__video_duration_sec
Field label Video duration (s)
Description Duration of the video, in seconds
Field type metric
Data type float.number.value
videos__video_duration_min
Field label Video duration (min)
Description Duration of the video, in minutes
Field type metric
Data type float.number.value
videos__video_completion_rate
Field label Video completion rate
Description Percentage of viewers who viewed the whole video
Field type metric
Data type float.number.ratio
videos__total_time_watched_sec
Field label 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__total_time_watched_min
Field label 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_h
Field label 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__average_view_time
Field label Average view time (s)
Description Average watch-time in seconds for the video across all views (Total time watched (s) / Video views)
Field type metric
Data type float.number.value