Spencer Lee

Fp & a Consultant - Content & Programming Analytics @Pluto TV

West Hollywood, CA, US

Created new daily dashboards to monitor performance among content partners, linear streaming channels, streaming devices, and at the series level. Added insights on emerging trends in fill rates, VOD/linear and TV/film share of voice.Developed new processes and data flows to track and report revenue, airings/TVHs, and profitability of content acquired under license fee deal terms. Partnered with Content Strategy team to track content expenditures vs. budget and set monetization assumptions in models for proposed content rights acquisitions.Collaborated with BI teams to execute monthly aggregations of revenue, TVHs, and impressions used to determine payouts to third-party and intra-company content providers.Managed partner reporting and payments spanning 250+ distribution partners and content providers. Created SQL data flows to automate revenue reporting to content providers, reducing turnaround time by 33%+. Integrated insights from Tableau and Looker dashboards to provide context on outlier results.Helped train and on-board four analysts to make meaningful contributions to the team.

UCLA

Bachelor's, Business Economics