Problem:
A leading US television and media company works with a large number of syndication partners.
They faced the following problems:
- Diverse data formats
- Mix of Automated and Manual Data Collection
- Inability to perform automated data extractions from the partner systems.
- Manual downloads and data pulls were time-consuming and redundant.
Approach:
- Automated methods like web scraping, ETL and API Integration were used for partners like MSN, Yahoo, Smartnews, Newsbreak and Youtube
- Automated merging of manual submissions for Samsung, Twitter, Apple News and McClatchy
Impact:
- Enabled quick and accurate reporting across all platforms.
- Reduced human involvement through automation.
- Eliminated manual downloads and data pulls.
- Reduced data reconciliation time through automated aggregation.
- Enabled better partner evaluation with insights into category-level behavior.
- Improved target tracking to ensure partnerships meet defined goals.
