Case study

Forecast Video-On-Demand Requirement for a Large Media Firm

video on demand


A US-based large media firm focused on commercial broadcasting, television production, and publishing.


The client wanted to forecast video-on-demand requirement for a new show that was yet to be telecasted, and wanted a separate model for each service provider.


SG Analytics undertook the following steps to deliver the desired output to the client:

  • Data preparation: The SG Analytics team aggregated data at a daily level, and merged the program scheduling information. The team created a training and validation sample, and identified proxy data for the new show based on genre, telecast time, etc.
  • Model building and validation: SG Analytics built time series models to forecast orders and capture the trends, seasonality, and program airing patterns. SG Analytics also included post-model adjustments based on the business situation. SG Analytics built a separate model for each service provider, as required. To validate the model, the SGA team checked the mean absolute percentage error (MAPE), i.e. a difference between actual and forecasted orders.
  • Results: The SG Analytics model was able to forecast orders for up to one year with an accuracy of 80%. The tool was able to present results in an intuitive dashboard format. The model also had the provision of handling dynamic changes in program schedules.
  • Advertisement placement: SG Analytics built an algorithm for dynamic ad placement in the content, whereby advertisements could be placed at the beginning, middle, or toward the end of the program, based on factors such as demographics, historical usage, etc.

Value Delivered

  • Enabled revenue maximization by effective advertisement pricing and placement.
  • Implemented business changes in the episode placement, taking the viewership pattern into account.

We bring comprehensive data driven insights to everyone, everywhere

In depth-analysis with simple solutions