![case study](https://cdn.quantiphi.com/2024/03/73b67162-cs_media-planning-application.png)
Media Planning Application
Media & EntertainmentBusiness Impacts
40%
Reduction in time to generate media plans
35%
Increase in overall productivity
25%
Increase in customer satisfaction
14%
Reduction in manual error
Customer Key Facts
- Location : South Africa
- Industry : Media & Entertainment
Problem Context
Client is a media agency focused on delivering cost-effective & innovative media buying
Client used to generate media plans manually in excel and had issues with discrepancies in the format, calculations and pricing used by each individual. Client wants to develop an internal online application to manage their processes.Â
Quantiphi developed an application to manage it’s inventory, pricing, billing, seamlessly create media plans as well as fetch data in a quick and consistent way. This application was integrated with Amazon QuickSight and these dashboards provided business insights and trends
Challenges
- Multiple data sources required effort while integrating
- Data cleaning and ensuring data consistency
- Development of a versatile application to meet the ever-changing needs of the media industry
![](https://cdn.quantiphi.com/2024/03/d9685f5d-challenges_media-planning-application.png)
Technologies Used
![AWS Elastic Beanstalk](https://cdn.quantiphi.com/2024/02/AWS-Elastic-Beanstalk_light-bg@4x.png)
AWS Elastic Beanstalk
![Amazon S3](https://cdn.quantiphi.com/2024/02/9c40e5d8-amazon-s3.png)
Amazon S3
![Amazon EC2](https://cdn.quantiphi.com/2024/02/Amazon-EC2_light-bg@4x.png)
Amazon EC2
![Amazon CloudWatch](https://cdn.quantiphi.com/2024/02/5ae3bf05-amazon-cloudwatch.png)
Amazon CloudWatch
![Amazon RDS](https://cdn.quantiphi.com/2024/02/a5cc314d-amazon-rds.png)
Amazon RDS
![Amazon QuickSight](https://cdn.quantiphi.com/2024/02/Amazon-Quicksight@4x.png)
Amazon QuickSight
Improving Productivity, Cost Savings, and Reduction in Errors with an Internal Online Application
Solution
Quantiphi developed an internal online application for Simply Black to manage its inventory, pricing and billing, and seamlessly create media plans for clients as well as fetch data in a quick and consistent way. This end-to-end application involves a rule-based system that reduces dependency on each individual to protect profit margin and increase profitability of the client.
Result
- Easy to Use Application with embedded dashboards
- Reduced Resource intensive processes
- Reduced time in planning by 40% due to ad-hoc analysis
- Savings - Eliminated user based license service
- Reduction in time to generate media plans by 40%