tiktok.creator_stats

derived · one row = one creator active in the last 180 days

Posting frequency, typical views (median of last 12), engagement rate, AI/branded/shop share, follower growth.

Coverage: Creators with videos in tiktok.videos. Follower growth only for priority-1 creators.
Refresh: Every 6 h.
Sorted by country, creator_id. Filters on the leading columns are fastest.

Example

SELECT *
FROM tiktok.creator_stats
LIMIT 100

Column	Type	Description
`creator_id`	`UInt64`
`username`	`String`
`country`	`LowCardinality(String)`
`priority`	`UInt8`
`followers`	`UInt32`
`has_email`	`UInt8`
`videos_30d`	`UInt32`
`posts_per_week`	`Float32`	videos_30d / 30 * 7
`last_posted_at`	`DateTime`
`typical_views`	`Nullable(Float64)`	median of last 12 videos older than 48 h
`engagement_rate`	`Nullable(Float32)`	over the same 12 videos
`ai_share_30d`	`Nullable(Float32)`	share of last-30-day videos labelled AI
`branded_videos_30d`	`UInt32`	paid partnership + shop affiliate
`shop_videos_30d`	`UInt32`
`followers_change_7d`	`Nullable(Int64)`	Priority-1 creators only (the only ones with a daily series); NULL else.
`followers_change_30d`	`Nullable(Int64)`
`followers_growth_pct_7d`	`Nullable(Float32)`	change / greatest(previous, 1000) * 100
`followers_growth_pct_30d`	`Nullable(Float32)`
`as_of`	`DateTime`