Data Analysis Projects

Spotify songs to Youtube playlist reach

I wanted to put myself in the perspective of a Spotify exec, asking a data analysts to see “Has the number of Spotify-released songs that achieve high YouTube playlist distribution increased across release cohorts?”

The trend here is interesting. The sum of Playlist views through YouTube is considerably lower in 2024, comparable to that of 2021. This is not very alarming, as these reaches build up over time and continue to grow past the year-to-date. What is important to see is that the cross-platform amplification is strengthening, not only in total reach, but more breakout singles. Audience spillover is improving over the years and at a rapid pace. What do we do with this information? We double down. Double down on coordinated release strategy. Push for marketing to align across platforms, especially between Spotify and YouTube.

Power of Story-led engagements

This project came from my internships at Sky Story Studios. I was tasked with scraping TED Talk datasets and identifying key storytelling metrics to assess their effect on engagement. I came across metadata for TED Talks, including individual ratings that people gave for each talk. I filtered through 2500+ Ted Talks to find the ratio of votes for "Persuasive." If leading with a story makes a talk more persuasive, there should be a greater trend amongst story-led frameworks compared to those that do not.

I utilized python to create rules within ted talk transcripts to find key words that would signify a story.