# Schema Information

## Tables/APIs 

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

* [AccountInsights](#accountinsights) 
* [CommentReplies](#commentreplies) 
* [Comments](#comments) 
* [VideoMetrics](#videometrics)

#### AccountInsights 

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

For more information, see [TikTok Business- AccountInsights](https://business-api.tiktok.com/portal/docs?id=1769113237682177\&rid=l74jb3dn5ib).

**FIELDS**

<table><thead><tr><th width="64">Field Name</th><th width="64">Data Type</th></tr></thead><tbody><tr><td>followers_count</td><td>NUMERIC</td></tr><tr><td>metrics</td><td>RECORD</td></tr><tr><td>display_name</td><td>STRING</td></tr><tr><td>profile_image</td><td>STRING</td></tr><tr><td>audience_countries</td><td>RECORD</td></tr><tr><td>username</td><td>STRING</td></tr><tr><td>audience_genders</td><td>RECORD</td></tr><tr><td>is_business_account</td><td>BOOLEAN</td></tr></tbody></table>

#### CommentReplies

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

For more information, see [TikTok Business- CommentReplies](https://business-api.tiktok.com/portal/docs?id=1762228430145538\&rid=l74jb3dn5ib).

**FIELDS**

<table><thead><tr><th width="64">Field Name</th><th width="64">Data Type</th></tr></thead><tbody><tr><td>likes</td><td>NUMERIC</td></tr><tr><td>parent_comment_id</td><td>STRING</td></tr><tr><td>username</td><td>STRING</td></tr><tr><td>status</td><td>STRING</td></tr><tr><td>video_id</td><td>STRING</td></tr><tr><td>profile_image</td><td>STRING</td></tr><tr><td>user_id</td><td>STRING</td></tr><tr><td>liked</td><td>BOOLEAN</td></tr><tr><td>text</td><td>STRING</td></tr><tr><td>comment_id</td><td>STRING</td></tr><tr><td>create_time</td><td>STRING</td></tr><tr><td>owner</td><td>BOOLEAN</td></tr></tbody></table>

#### Comments&#x20;

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](https://business-api.tiktok.com/portal/docs?id=1769113255352322\&rid=l74jb3dn5ib).

**FIELDS**

<table><thead><tr><th width="64">Field Name</th><th width="64">Data Type</th></tr></thead><tbody><tr><td>owner</td><td>BOOLEAN</td></tr><tr><td>comment_id</td><td>STRING</td></tr><tr><td>username</td><td>STRING</td></tr><tr><td>likes</td><td>NUMERIC</td></tr><tr><td>replies</td><td>NUMERIC</td></tr><tr><td>video_id</td><td>STRING</td></tr><tr><td>create_time</td><td>STRING</td></tr><tr><td>user_id</td><td>STRING</td></tr><tr><td>text</td><td>STRING</td></tr><tr><td>liked</td><td>BOOLEAN</td></tr><tr><td>profile_image</td><td>STRING</td></tr><tr><td>status</td><td>STRING</td></tr><tr><td>pinned</td><td>BOOLEAN</td></tr></tbody></table>

#### 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](https://business-api.tiktok.com/portal/docs?id=1769113361610753\&rid=l74jb3dn5ib).

**FIELDS**

<table><thead><tr><th width="64">Field Name</th><th width="64">Data Type</th></tr></thead><tbody><tr><td>audience_countries</td><td>RECORD</td></tr><tr><td>item_id</td><td>STRING</td></tr><tr><td>share_url</td><td>STRING</td></tr><tr><td>reach</td><td>NUMERIC</td></tr><tr><td>average_time_watched</td><td>NUMERIC</td></tr><tr><td>likes</td><td>NUMERIC</td></tr><tr><td>thumbnail_url</td><td>STRING</td></tr><tr><td>caption</td><td>STRING</td></tr><tr><td>embed_url</td><td>STRING</td></tr><tr><td>comments</td><td>NUMERIC</td></tr><tr><td>shares</td><td>NUMERIC</td></tr><tr><td>create_time</td><td>STRING</td></tr><tr><td>total_time_watched</td><td>NUMERIC</td></tr><tr><td>full_video_watched_rate</td><td>NUMERIC</td></tr><tr><td>video_views</td><td>NUMERIC</td></tr><tr><td>video_duration</td><td>NUMERIC</td></tr><tr><td>impression_sources</td><td>RECORD</td></tr></tbody></table>