Fivetran documentation

Search the docs

/

TikTok Organic

Explore the interactive ERD

Table & Field Reference

business_benchmark

Column	Type	Keys
`_fivetran_id`	String	PK
`average_comments`	Unknown
`average_engagement_rate`	Unknown
`average_follower_count`	Unknown
`average_follower_growth`	Unknown
`average_likes`	Unknown
`average_shares`	Unknown
`average_video_count`	Unknown
`average_video_views`	Unknown
`business_category`	Unknown

profile_audience_age

Column	Type	Keys
`index`	Unknown	PK
`profile_username`	Unknown	PKFK
`age`	Unknown
`percentage`	Unknown

profile_audience_country

Column	Type	Keys
`index`	Unknown	PK
`profile_username`	Unknown	PKFK
`country`	Unknown
`percentage`	Unknown

profile_audience_city

Column	Type	Keys
`index`	Unknown	PK
`profile_username`	Unknown	PKFK
`city_name`	Unknown
`percentage`	Unknown

profile_metric_audience_activity

Column	Type	Keys
`hour`	Unknown	PK
`date`	Unknown	PKFK
`profile_username`	Unknown	PKFK
`count`	Unknown

profile_metric

Column	Type	Keys
`date`	Unknown	PK
`profile_username`	Unknown	PKFK
`address_clicks`	Unknown
`app_download_clicks`	Unknown
`bio_link_clicks`	Unknown
`comments`	Unknown
`daily_lost_followers`	Unknown
`daily_new_followers`	Unknown
`daily_total_followers`	Unknown
`email_clicks`	Unknown
`engaged_audience`	Unknown
`followers_count`	Unknown
`lead_submissions`	Unknown
`likes`	Unknown
`phone_number_clicks`	Unknown
`profile_views`	Unknown
`shares`	Unknown
`unique_video_views`	Unknown
`video_views`	Unknown

profile_audience_gender

Column	Type	Keys
`index`	Unknown	PK
`profile_username`	Unknown	PKFK
`gender`	Unknown
`percentage`	Unknown

profile

Column	Type	Keys
`username`	Unknown	PK
`bio_description`	Unknown
`display_name`	Unknown
`followers_count`	Unknown
`following_count`	Unknown
`is_business_account`	Unknown
`is_verified`	Unknown
`profile_deep_link`	Unknown
`profile_image`	Unknown
`total_likes`	Unknown
`videos_count`	Unknown

replies_to_comment

Column	Type	Keys
`id`	Unknown	PK
`parent_comment_id`	Unknown	FK
`username`	Unknown	FK
`video_id`	Unknown	FK
`create_time`	Instant
`display_name`	Unknown
`liked`	Unknown
`likes`	Unknown
`owner`	Unknown
`pinned`	Unknown
`profile_image`	Unknown
`replies`	Unknown
`status`	Unknown
`text`	Unknown
`unique_identifier`	Unknown

video_impression_source

Column	Type	Keys
`index`	Unknown	PK
`video_id`	Unknown	PKFK
`impression_source`	Unknown
`percentage`	Unknown

video_audience_gender

Column	Type	Keys
`index`	Unknown	PK
`video_id`	Unknown	PKFK
`gender`	Unknown
`percentage`	Unknown

video_audience_type

Column	Type	Keys
`index`	Unknown	PK
`video_id`	Unknown	PKFK
`percentage`	Unknown
`type`	Unknown

video_engagement_like

Column	Type	Keys
`index`	Unknown	PK
`video_id`	Unknown	PKFK
`percentage`	Unknown
`second`	Unknown

video_audience_city

Column	Type	Keys
`index`	Unknown	PK
`video_id`	Unknown	PKFK
`city_name`	Unknown
`percentage`	Unknown

video_audience_country

Column	Type	Keys
`index`	Unknown	PK
`video_id`	Unknown	PKFK
`country`	Unknown
`percentage`	Unknown

video_view_retention

Column	Type	Keys
`index`	Unknown	PK
`video_id`	Unknown	PKFK
`percentage`	Unknown
`second`	Unknown

video

Column	Type	Keys
`id`	Unknown	PK
`address_clicks`	Unknown
`app_download_clicks`	Unknown
`average_time_watched`	Unknown
`caption`	Unknown
`comments`	Unknown
`create_time`	Unknown
`email_clicks`	Unknown
`embed_url`	Unknown
`favorites`	Unknown
`full_video_watched_rate`	Unknown
`lead_submissions`	Unknown
`likes`	Unknown
`new_followers`	Unknown
`phone_number_clicks`	Unknown
`profile_views`	Unknown
`reach`	Unknown
`share_url`	Unknown
`shares`	Unknown
`thumbnail_url`	Unknown
`total_time_watched`	Unknown
`video_duration`	Unknown
`video_views`	Unknown
`website_clicks`	Unknown

comment

Column	Type	Keys
`id`	Unknown	PK
`parent_comment_id`	Unknown	FK
`username`	Unknown	FK
`video_id`	Unknown	FK
`create_time`	Instant
`display_name`	Unknown
`liked`	Unknown
`likes`	Unknown
`owner`	Unknown
`pinned`	Unknown
`profile_image`	Unknown
`replies`	Unknown
`status`	Unknown
`text`	Unknown
`unique_identifier`	Unknown