item_id
Video ID
TEXT
Dimension
Unique identifier for the video
caption
Caption
TEXT
Dimension
The caption/description for the video
likes
Likes
NUMBER
Metric
The total number of likes the video has received
comments
Comment Count
NUMBER
Metric
The total number of comments the video has received
shares
Share Count
NUMBER
Metric
The total number of times the video has been shared
reach
Reach
NUMBER
Metric
Total number of unique viewers
video_views
Video Views
NUMBER
Metric
The total number of times the video was viewed
video_duration_seconds
Video Duration [S]
NUMBER
Metric
The duration of the video, in seconds
video_duration_minutes
Video Duration [M]
NUMBER
Metric
The duration of the video, in minutes
thumbnail_url
Thumbnail URL
URL
Dimension
Preview thumbnail URL of the video
thumbnail_image
Thumbnail Image
IMAGE
Dimension
Thumbnail of the video
share_url
Share URL
URL
Dimension
A shareable URL for the video
embed_url
Embed URL
URL
Dimension
An embeddable URL for the video
total_time_watched_seconds
Total Time Watched (s)
NUMBER
Metric
Total watch-time in seconds for the video across all views
total_time_watched_minutes
Total Time Watched (m)
NUMBER
Metric
Total watch-time in minutes for the video across all views
total_time_watched_hours
Total Time Watched (h)
NUMBER
Metric
Total watch-time in hours for the video across all views
average_time_watched
Average Time Watched
NUMBER
Metric
Average watch-time, in seconds, for the video across all views
full_video_watched_rate
Video Completion Rate
NUMBER
Metric
The rate the video was watched to completion
audience_countries
Audience Countries
TEXT
Dimension
An array of objects containing data about what countries the audience originate from
impression_sources
Impression Sources
TEXT
Dimension
An array of objects containing data about what countries the audience originate from
create_datetime
Create Datetime
DATETIME
Dimension
create_date
Create Date
DATE
Dimension
username
Username
TEXT
Dimension
The accounts username
is_business_account
Business Account?
BOOLEAN
Dimension
Whether or not the account is a business account
display_name
Display Name
TEXT
Dimension
The accounts display name
profile_image
Profile Image URL
URL
Dimension
The profile picture URL
followers_count
Total Followers
NUMBER
Metric
The accounts total number of followers
profile_views
Profile Views
NUMBER
Metric
The total amount of times the business account has been viewed
new_followers
New Followers
NUMBER
Metric
Total number of new followers each day within the specified range. Takes into account unfollows
daily_likes
Likes
NUMBER
Metric
Total number of likes received across the TikTok account's videos. This metric is available per day.
daily_shares
Shares
NUMBER
Metric
Total number of times the TikTok account's videos have been shared. This metric is available per day.
daily_engagement
Engagement
NUMBER
Metric
Total number of engagement. Calculated with Likes + Comments + Shares
daily_comments
Comments
NUMBER
Metric
Total number of comments received across the TikTok account's videos. This metric is available per day.
daily_views
Views
NUMBER
Metric
The total number of times the TikTok account's videos have been viewed. This metric is available per day.
country
Country
TEXT
Dimension
Country distribution of the accounts followers
username
Username
TEXT
Dimension
The accounts username
display_name
Display Name
TEXT
Dimension
The accounts display name
distribution
Distribution
NUMBER
Metric
Country distribution of the accounts followers. This information is not available for accounts with less than 100 followers.
gender
Gender
TEXT
Dimension
Gender distribution of the accounts followers
username
Username
TEXT
Dimension
The accounts username
display_name
Display Name
TEXT
Dimension
The accounts display name
distribution
Distribution
NUMBER
Metric
Gender distribution of the accounts followers. This information is not available for accounts with less than 100 followers.
Access detailed documentation related to the various data connectors provided by our company.
Our Looker Studio connectors enable seamless integration with multiple data sources, allowing you to visualise and analyse data effortlessly within Looker Studio
By consolidating all relevant information in one place, this documentation page aims to simplify your experience with Looker Studio and our connectors, ensuring you can make the most out of your data integration and analysis efforts. If you need further assistance, our support team is always here to help!
Each connector has its own dedicated documentation page. These pages provide detailed descriptions of the fields they support.
Understand the data structure and how each field is used in your analysis. Our documentation provides clear definition for every field, helping you to accurately interpret and use the data retrieved through our connectors.
TikTok Organic is a powerful tool that will allow you to create reports within minutes of connecting. Using the dimensions and metrics pulled from your TikTok business account, you will be able to build charts, tables and graphs about your account or any videos you have posted.
We offer 4 queries you are able to pull data from:
Accounts
Videos
Audience by country
Audience by gender
Before using our connector, you will need to ensure that you have the following prerequisites
A Google account
A Tiktok account linked to your business account
Open the connector you wish to use in Looker Studio.
Click 'Authorise' and sign in to your Google account.
Click the second 'Authorise' button to link you TikTok Account to the connector and grant it the permissions necessary to pull data.
Select the query you would like to pull data about in the drop down menu, then click 'Connect' in the top right corner to begin using the connector.