Lucen

TikTok Organic data reference

Sync paused
Social
2 tables
38 columns

Lucen loads your TikTok Organic data (Social) to your warehouse once when you connect and models it into the tables below. You connect TikTok Organic with one OAuth sign-in.

TikTok exposes only lifetime totals and no daily history, so the first sync loads those totals. Your plan sets how much history the first sync loads, see pricing.

Connecting TikTok Organic loads your history once, and the daily refresh is not on yet.

Send TikTok Organic data to

Tables

gold_tiktok_organic_account_day

Grain
open_id / snapshot_date
Use for
Followers, following, lifetime likes and public video count as read each day, and their change since the previous snapshot

gold_tiktok_organic_video

Grain
open_id / video_id
Use for
The account's current public videos with lifetime views, likes, comments and shares, and their change since the video's previous snapshot

Columns

Column names match your warehouse exactly. Descriptions come from dbt.

gold_tiktok_organic_account_day columns

17

gold_tiktok_organic_video columns

21

Typical questions

Prompt to try
How many followers does the account have?

gold_tiktok_organic_account_daylatest cumulative_follower_count, not a sum

Prompt to try
How many followers did we gain last week?

gold_tiktok_organic_account_daylast minus first cumulative_follower_count; check previous_snapshot_date for gaps

Prompt to try
Which videos perform best?

gold_tiktok_organic_videorank by cumulative_view_count; compare videos by published_date

Prompt to try
How many videos has the account published?

gold_tiktok_organic_account_daylatest cumulative_video_count

Starter queries

sql
SELECT snapshot_date, open_id, display_name, username, is_verified
FROM `your-project.your_org_gold.gold_tiktok_organic_account_day`
WHERE snapshot_date >= DATE_SUB(CURRENT_DATE(), INTERVAL 30 DAY)
ORDER BY snapshot_date DESC
LIMIT 100;
sql
SELECT snapshot_date, open_id, video_id, title, video_description
FROM `your-project.your_org_gold.gold_tiktok_organic_video`
WHERE snapshot_date >= DATE_SUB(CURRENT_DATE(), INTERVAL 30 DAY)
ORDER BY snapshot_date DESC
LIMIT 100;

Integration page