Project Description:
The dataset includes the network through which Ads are airing, types of networks like Cable/ Broadcast and the show name also on which Ads got aired. You can also see the data of Dayparts, Time zone and the time & date at which Ads got aired. IT also includes other data like Pod Position (the lesser the valuable), the duration for which Ads aired on screen, Equivalent sales, and the total amount spent on the Ads aired.
What is Pod Position? Does the Pod position number affect the amount spent on Ads for a specific period by a company? (Explain in details with examples from the dataset provided)
What is the share of various brands in TV airings and how has it changed from Q1 to Q4 in 2021?
Approach:
All the questions are clearly explained and can be solved using Microsoft Excel only.
Tech-Stack Used:
Microsoft Excel for Microsoft 365
Dataset:
Insights:
1. What is Pod Position? Does the Pod position number affect the amount spent on Ads for a specific period by a company? (Explain in detail with examples from the dataset provided)
Ad pod is a term used in connection with CTV advertising to specify multiple ads sequenced together and played back-to-back within a single ad break, like traditional linear TV.
They allow publishers to return multiple ads from a single ad request, and then those ads are played in sequence.
This graph shows the average amount spend on various Pod positions:
2. What is the share of various brands in TV airings and how has it changed from Q1 to Q4 in 2021?
Share of various brands in TV airing is as shown below:
Change in Brand share in TV airing from Q1 to Q4 is shown below:
Comments