Analytics and Collaboration Success Story

Network Schedule and Traffic Reporting at a Major Media Resource Service Company

Business Situation

• The client ranks among the world's leading media resources services groups with billings of $18.6 billion
• Needed to develop a data warehouse for reporting all national network schedule and traffic data for its agencies, in time for the new broadcast year

Key Issues

• A major agency with the group was migrating from an in-house system to Donovan Data Systems (DDS) NetPak system for buying national network commercial time
• Needed to switch all reporting for its media buyers to reports generated from the data warehouse; and it had to be in place in time for the new broadcast year

Outcomes

• Coordinated requirements definition, design, development and deployment and user acceptance testing
• Supplied project management assistance to DDS to ensure that it met the fixed deadlines imposed by the new broadcast year
• The solution includes capture of all national network commercial buys from DDS and loads the data warehouse nightly
• Media Directors and buyers have online access to standard reports that provide selectable reporting for schedules (planned reach to target audiences by time slot) and traffic (actual airings of specific commercials)
• The data warehouse includes an innovative technique of using a separate table to accelerate “cascading prompts” in Cognos IWR, greatly improving response time to the end user