Weekly TRP assessment is a critical and accurate indicator of the viewership of the client’s various programs and service providers. Two distinct data sources are involved in the process. TRP data extracted from the Broadcast Audience Research Council (BARC) India application is collated and reconciled with spot data from Markdata. The reconciled data is injected into ETL and then it goes into the analytics server for deriving market insights.
Owing to high human intervention in the process, accuracy was taking a hit, leading to the wrong assessment of program and channel popularity, which ultimately caused business errors. Attempts to streamline the manual way of data extraction, aggregation, and reconciliation didn’t bear fruit and finally, the client decided to opt for complete automation of the process.
Our team worked on building a robot that executed the process through the following steps
The Bot authenticates the BARC Media Works application and updates the database to extract the current weekly report. It then downloads and saves the TRP data for Channel, Week Target, Rat%, etc. and derives critical readings such as GRPs, Channel Group.
Bot authenticates the MAFRAS application, navigates to Manage Clients, and for each client provided in the configuration file, it adds and removes channels in subscriptions.
Spot Data related to the channel name, market data, sum duration, television rating, sort type, etc. is exported from the MAFRAS application in an Excel format.
With the two data sets, the bot performs the below set of reconciliation to ensure zero errors.
The reconciled file is pushed into the ETL engine using the FileZilla FTP and processed for market insights.
The bot sends process status emails to configured stakeholders.
Before Automation | Automated Process | |
---|---|---|
FTE | 5 | 1 |
Transactions per day | 5 | 50 |
Time per transaction | 120 minutes | 10 minutes |
To choose the right AS400 support for your business, we would like to understand your needs better. The form below is a great way to start that!