Provide an example of when you had to analyze a large amount of data and what insights you were able to come up with.

Situation- I was assigned as a product manager for a streaming services brand. We had a problem with large amount of video completion drop after the mid roll ad exposure i.e ads shown somewhere around middle of the episode. As ad exposure dropped, ad revenue monetization dropped as well and the task was assigned to me to look for a solution

Task- Undertand as to why there is an video completion drop after mid roll ad.  I wanted to look at the network operations data in the following areas -

a) Which platform was facing this issue e.g. OTT, Mobile vs Web

b) Which customers were resulting in the video conversion drop

c) when did this happen?

d) For what type of content playback

e) What was the attribution that resulted in this drop

Action- The data analysis came out as follows:

a) The issue was happening with OTT platforms which contributed 60% of overall traffic

b) The drop happened for both male and female customer but overwhelming for male customers

c) The drop happened during 8pm onwards- prime watching period

d) Content Genre watched- family drama, series etc.

e) This happened when the user searched for family content and then started playing it.

Resolution:

The issue in this case was that the ad selection was primarily focused on user profile and demographics. The issue with OTT is that, even though one of the family members signed up for an account, everyone in the family would watch together hence when the ads were shown relevant to one user, the other users would switch the content as the ads were not relevant to them.