Schema Information

This subtopic provides a structured reference to assist you in working with Daton's TikTok Business connector and the associated fields and tables.

Tables/APIs

The following is the list of tables or APIs associated with the TikTok Business connector:

• AccountInsights

• CommentReplies

• Comments

• VideoMetrics

AccountInsights

The AccountInsights API provides comprehensive analytics and performance data for TikTok Business accounts.

For more information, see TikTok Business- AccountInsights.

FIELDS

Field Name	Data Type
followers_count	NUMERIC
metrics	RECORD
display_name	STRING
profile_image	STRING
audience_countries	RECORD
username	STRING
audience_genders	RECORD
is_business_account	BOOLEAN

CommentReplies

With the Comment Replies API, businesses can efficiently manage and respond to comments on their TikTok videos.

For more information, see TikTok Business- CommentReplies.

FIELDS

Field Name	Data Type
likes	NUMERIC
parent_comment_id	STRING
username	STRING
status	STRING
video_id	STRING
profile_image	STRING
user_id	STRING
liked	BOOLEAN
text	STRING
comment_id	STRING
create_time	STRING
owner	BOOLEAN

Comments

The Comments API grants access to comments made on TikTok videos, offering valuable insights into audience sentiment and user feedback for content adjustment.

For more information, see TikTok Business- Comments.

FIELDS

Field Name	Data Type
owner	BOOLEAN
comment_id	STRING
username	STRING
likes	NUMERIC
replies	NUMERIC
video_id	STRING
create_time	STRING
user_id	STRING
text	STRING
liked	BOOLEAN
profile_image	STRING
status	STRING
pinned	BOOLEAN

VideoMetrics

The VideoMetrics API delivers detailed performance metrics for TikTok videos, including views, likes, shares, and comments, enabling businesses to assess the success of their video content and identify trends.

For more information, see TikTok Business- VideoMetrics.

FIELDS

Field Name	Data Type
audience_countries	RECORD
item_id	STRING
share_url	STRING
reach	NUMERIC
average_time_watched	NUMERIC
likes	NUMERIC
thumbnail_url	STRING
caption	STRING
embed_url	STRING
comments	NUMERIC
shares	NUMERIC
create_time	STRING
total_time_watched	NUMERIC
full_video_watched_rate	NUMERIC
video_views	NUMERIC
video_duration	NUMERIC
impression_sources	RECORD