The company of this challenge allows users to upload videos online, just like YouTube.
This company is interested in knowing whether a video is “hot” (i.e. trending up in terms of popularity), stable, or going down. Understanding this would allow to optimize the videos promoted on the home-page and, therefore, maximize ads revenue.
Company XYZ is an online video streaming company, just like YouTube or Dailymotion.
The Head of Product has identified as a major problem for the site a very high home page drop-off rate. That is, users come to the home-page and then leave the site without taking any actions or watching any videos.
Since customer acquisition costs are very high, this is a huge problem: the company is spending a lot of money to acquire users who don’t generate any revenue by clicking on ads.
Currently, the videos shown on the home page to new users are manually chosen. The Head of Product had the idea of creating a new recommended video section on the home page.
She asked you the following:
We have 2 table downloadable by clicking here.
The 2 tables are:
video_count - provides information about how many times each video was seen each day.
Columns:
- video_id : unique by video and joinable to the video id in the other table
- count : total count of views for each video
- date : on which day that video was watched that many times
video_features - characteristics of the video.
Columns:
- video_id : unique by video and joinable to the video id in the other table
- video_length : length of the video in seconds
- video_language : language of the video, as selected by the user when she uploaded the video
- video_upload_date : when the video was uploaded
- video_quality : quality of the video. It can be [ 240p, 360p, 480p, 720p, 1080p]
Full course in Product Data Science