TikTok Organic data reference
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.
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
How many followers does the account have?
gold_tiktok_organic_account_daylatest cumulative_follower_count, not a sum
How many followers did we gain last week?
gold_tiktok_organic_account_daylast minus first cumulative_follower_count; check previous_snapshot_date for gaps
Which videos perform best?
gold_tiktok_organic_videorank by cumulative_view_count; compare videos by published_date
How many videos has the account published?
gold_tiktok_organic_account_daylatest cumulative_video_count
Starter queries
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;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;