Skip to main content
← Work
Data

Creator data for a regional report

e-Conomy SEA 2024

BigQuery dataset with SQL cleaning pipeline normalising creator metrics across Meta, TikTok, and YouTube

What I built

In a four-month data analyst role, I built the base BigQuery dataset for creator data and cleaned it in SQL. I used it to trace video-commerce and creator-economy trends across Meta, TikTok, and YouTube for a 2024 regional flagship report Google published with outside research partners.

The hard part

Each platform measures things its own way, so a lot of the work was making their numbers comparable before any trend meant anything.