STAR NETWORK
SUMMARY
As per the regulations by TRAI, Star needed to maintain a 13 minute inventory for ads, along with a fixed number of minutes per day to sell these ads. The sales team were using excel sheets to keep track of inventory, which meant the process was cumbersome, time consuming and outdated. While there was already an ad aggregator system in place, it was not designed well and aligned with the internal systems and processes. There was also a massive lag in terms of performance and deadline delivery.
CHALLENGE
As per the regulations by TRAI, Star needed to maintain a 13 minute inventory for ads, along with a fixed number of minutes per day to sell these ads. The sales team were using excel sheets to keep track of inventory, which meant the process was cumbersome, time consuming and outdated. While there was already an ad aggregator system in place, it was not designed well and aligned with the internal systems and processes. There was also a massive lag in terms of performance and deadline delivery.
INSIGHT
The earlier aggregator had been built on a legacy tech stack that could not handle multiple requests at the same time, thus leading to performance lags. Adding more features to that was recipe for disaster. The entire architectural framework of the existing aggregator platform would need a revamp, making Star an entire rescue mission for the Josh team.
THE JOSH EDGE
Soon after the Josh team started working on the pre-created architecture, the need for a new, all integrated platform was felt. What started off as a rescue mission thus turned into an entirely new framework that was built from scratch. Focused on selling less inventory for maximum price, the target audience, ad space, ad requirements and show ratings were aligned with each other. With an on premise team responsible for documentation and delivery, the first version of the solution was delivered in five months. Backed by deft technology including Ruby on Rails at the backend, React on front end and a Postgres mastered database, it was nothing short of an automated proposal creator that could be used for media buying and selling! It was an all integrated platform that took care of sponsorship and competition as well.
IMPACT
Turnaround time for media buying reduced from 2 days to 10 minutes.
Multiple proposals and requests handled through one platform.
All data from advertisers and producers stored in a single database.
Real time view of sold inventory and ad revenue.