Media Case Studies
Consolidating Global "Media Budgeting"
Client: A Fortune 500 company with operations across 121 countries through 350+ agencies.
Challenge
The client managed the consolidation of budget data of over a million excels for their numerous customers manually. Each agency had its own custom macro-driven spreadsheets (managing billboards, print & social media etc.), resulting in data integrity & accuracy issues during the merging of multiple documents.
Solution
Elait designed a framework/reusable components based approach with a flexible & user-friendly design enabling the client to configure and onboard agencies. Some of the capabilities developed were:
- “Rule Engine” developed to enable users to alter or remove rulesets.
- Ability to identify data Issues on a near real-time basis enabling the client to rectify data and making it available for reprocessing.
- Streamlining and securing the source data by using SharePoint to reposit data.
Outcome
The customer experienced substantial benefits:
- Automated “onboarding” time reduced from months to three hours per agency.
- Audited & error-free data collation time reduced from three months per agency to one hour