Playbook 05 · Report
Market Intelligence for HQ:
The Weekly Market Report, From 90 Minutes to 5
The problem
Every week the team needed to know how Warner's catalog moved on each Korean platform. Merging Melon, Genie, FLO and YouTube charts by hand took about 1.5 hours.
What I built
A Python pipeline that pulls each chart, splits domestic and international repertoire, computes week-over-week change, and flags the movers.
For a company entering APACHQ needs a reliable weekly read of markets it cannot see. I build that reporting once, automate it, and keep it in English.
Sample output · Melon, international · one week in autumn 2023
| Track | This wk | Last wk | Δ |
|---|---|---|---|
| Charlie Puth · I Don't Think That I Like | ~880K | ~970K | −9% |
| Charlie Puth · Dangerously | ~810K | ~890K | −10% |
| Zac Efron, Zendaya · Rewrite The Stars | ~690K | ~310K | +121% |
| Charlie Puth · That's Hilarious | ~550K | ~650K | −16% |
The same weekly data also fed seasonal work, such as an R script that pulls holiday and winter songs from the Melon Top 500 by ISRC.