Write a query to identify top-performing content creators based on specific engagement metrics over a rolling 30-day window at TikTok.
Use the provided TikTok tables to evaluate the 30-day period ending 2024-02-29. Include creators with positive views during the period and return the top three using engagement rate, with creator ID as the final tie-breaker.
Output
- One row per included creator with
creator_id, creator_name, total_views, total_engagements, engagement_rate_pct, and creator_rank.
total_engagements is likes plus comments plus shares, and engagement_rate_pct is total engagements divided by total views, multiplied by 100 and rounded to two decimals.- Return the top three creators, ordered by rank ascending.
