Content ROI and Genre Profitability is a data-driven project that dives into how different types of content perform across various platforms. It looks at both financial results and audience engagement to see what's really working.

The dataset covers content from 2023 to 2024, broken down by year and quarter, series name, genre (like Action, Drama, Comedy, Thriller), and platform (YouTube, TV, OTT). It includes details like budgets in Thai Baht (THB), revenue, social mentions, merchandise sales, profit, ROI percentage, and profit margins. The goal? To understand how effectively content is monetizing and to spot trends at the genre level.

Some key insights have emerged:-

• The combo of Action content on YouTube stands out as the most profitable. Both Action series achieved over 125% ROI, making them a clear winner.
• There’s a noticeable link between social mentions and revenue—when engagement spikes, so does income.
• Merchandise sales play a crucial role in boosting profits. In Q1 of 2024 alone, Action content generated around 30 million THB in merchandise revenue, which significantly contributed to profit margins.
• On the flip side, OTT platforms seem to be struggling. ROI dipped to just 27.27% in Q2 of 2024, despite high budgets, revenue growth hasn’t kept pace.
• Engagement clearly fuels revenue. The series Super Legends, which had the highest social buzz at 220K mentions, also delivered the highest ROI.

What does this mean for the business?

• It’s now easier to make smarter, data-backed decisions about where to invest in content.
• We can pinpoint which genres deliver the best ROI, helping us focus on the right projects.
• Budget allocation can be optimized, ensuring funds go where they’ll generate the most profit.
• Plus, we gain a clearer picture of which platforms are strongest for monetization.

Overall, this analysis offers valuable insights to refine content strategies, maximize profitability, and stay ahead in a competitive landscape.