Supermetrics brings all your marketing data into Google Sheets, Google Data Studio, Excel, BigQuery, Snowflake, Redshift, Azure
| Category | Field | Code | Type | Description |
|---|---|---|---|---|
| Time | Year | profile_year | dim | |
| Year of week (Sun-Sat) | profile_year_of_week | dim | ||
| Year of week (Mon-Sun) | profile_year_of_week_iso | dim | ||
| Year & month | profile_year_month | dim | ||
| Month | profile_month | dim | ||
| Year & week (Sun-Sat) | profile_year_week | dim | ||
| Year & week (Mon-Sun) | profile_year_week_iso | dim | ||
| Week (Sun-Sat) | profile_week | dim | ||
| Week (Mon-Sun) | profile_week_iso | dim | ||
| Day of month | profile_day_of_month | dim | ||
| Day of week (Sun-Sat) | profile_day_of_week_name | dim | ||
| Day of week (Mon-Sun) | profile_day_of_week_name_iso | dim | ||
| Date | profile_date | dim | ||
| Datetime | profile_atom | dim | ||
| Profile | Username | profile_username | dim | Username of TikTok account. |
| Display name | profile_display_name | dim | Display name for TikTok account. | |
| Profile image URL | profile_profile_image_url | dim | The URL link to profile image of the Tiktok account. | |
| Video views | profile_video_views | met | The total number of times the business accounts videos have been viewed. This metric is available per day. | |
| Profile views | profile_profile_views | met | Total number of time the business accounts profile has been viewed. This metric is available per day. | |
| Total engagement | profile_total_engagement | met | Total number of engagement. Calculated with Likes + Comments + Shares | |
| Likes | profile_likes | met | 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. | |
| Comments | profile_comments | met | Total number of comments received across business accounts videos. This metric is available per day. | |
| Shares | profile_shares | met | Total number of times the business accounts videos have been shared. This metric is available per day. | |
| New followers | profile_new_followers | met | Total number of followers each day within the specified range. | |
| Current followers | profile_profile_followers__current_followers | met | Current total number of accounts following this profile. | |
| Username | videos_username | dim | Username of TikTok account. | |
| Display name | videos_display_name | dim | Display name for TikTok account. | |
| Video | Video ID | videos_video_id | dim | Unique identifier for the video. |
| Caption | videos_caption | dim | The caption/description for the video. | |
| Create date | videos_create_date | dim | Date when the video was posted. | |
| Create datetime | videos_create_datetime | dim | Date-time when the video was posted. | |
| Thumbnail URL | videos_thumbnail_url | dim | Preview thumbnail URL for the video. | |
| Share URL | videos_share_url | dim | A shareable URL for the video. | |
| Embed URL | videos_embed_url | dim | An embeddable URL for the video. | |
| Video views | videos_video_views | met | The total number of views the video has received. | |
| Likes | videos_likes | met | The total number of likes the video has received | |
| Comments | videos_comments | met | The total number of comments the video has received. | |
| Shares | videos_shares | met | The total number of times the video has been shared. | |
| Reach | videos_reach | met | Total number of unique viewers who viewed the video. | |
| Video duration (s) | videos_video_duration_sec | met | Duration of the video, in seconds. | |
| Video duration (min) | videos_video_duration_min | met | Duration of the video, in minutes. | |
| Video completion rate | videos_video_completion_rate | met | Percentage of viewers who viewed the whole video. | |
| Total time watched (s) | videos_total_time_watched_sec | met | Total watch-time in seconds for the video across all views. | |
| Total time watched (min) | videos_total_time_watched_min | met | Total watch-time in minutes for the video across all views. | |
| Total time watched (h) | videos_total_time_watched_h | met | Total watch-time in hours for the video across all views. | |
| Average view time (s) | videos_average_view_time | met | Average watch-time in seconds for the video across all views (Total time watched (s) / Video views). | |
| Profile | Username | territories_username | dim | Username of TikTok account. |
| Display name | territories_display_name | dim | Display name for TikTok account. | |
| Country | Country | territories_country | dim | Country of business accounts followers. |
| Distribution | territories_distribution | met | 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. | |
| Profile | Username | gender_username | dim | Username of TikTok account. |
| Display name | gender_display_name | dim | Display name for TikTok account. | |
| Gender | Gender | gender_gender | dim | Gender of business accounts followers. |
| Distribution | gender_distribution | met | 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. |