Media Adbreak Dashboard

Flexibility

Lets user choose the show parameters

Historical analysis

Calculates the optimal breaks based on historical performance

Slot selection

Allows the user to select the time slot for ad break analysis

Predictive model

Runs regression to calculate ad drop %

Select the Competitor

Select the Weekday

Select the show start time

Select the show end time

Select the show duration

* Optimal ad breaks are calculated using historical data for the selected slot. Breaks with the lowest ad drop% and higher GRP contribution are prioritized. They are further filtered to eliminate breaks with very low GRPs

Select the custom number of ad breaks

Select total length of the ad break(seconds)

Projected Ad Drop %

1) Select the show parameters basis intended ad placement using the left panel. Click on 'Calculate Ad Breaks'. This calculates the optimal number of breaks for the lowest ad drop basis historical data. Also shown is the avg length of ads for the selected duration basis historical data.

2) There is an option to change the number of breaks by selecting 'Custom number of ad breaks' from the dropdown list in the middle panel. Once selected , click on 'Proceed to define breaks'

3) For each selected break you would need to select the start time and the intended length of the break. Once selected click on 'Calculate Ad Drop'

4) The ad drop for each ad break is displayed as a table in the third panel. A expected avg ad drop for the entire selected show time is also shown in the third panel.

Ad Drop Formula:

Ad Drop% = ((Ad GRP - Program GRP)/Program GRP)*100
Higher positive Ad Drop% refers to higher Ad GRP and vice versa

1) The showcased model is based on one month of BARC data starting 1st May, 2017 To 29th May, 2017

2) For calculating optimal ad breaks, one month of data was used starting 1st May, 2017 To 29th May, 2017