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. 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 new 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 distribution of business accounts followers. |
| Distribution | territories_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. | |
| 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. |