What We Faced
The Fortune 100 media company, despite being one of the largest media and communications conglomerates in the United States, was unable to accurately measure the number of user subscriptions it received on a daily basis.
They were also challenged in matching their subscriber base with their actual product usage. Without this data, it was difficult to know exactly who their audience was and how they were interacting with their products in order to get deeper consumer insights.
Consumer insights would enable the company to assess product strategy, improve advertising revenue, and overall future planning.
SQL Server Analysis Services
What We Did
To begin collecting the level of data that the media company needed for consumer insights, MRE first needed to build a single source of truth (SSOT) system.
Once an accurate database of subscribers and product usage had been compiled, MRE tied these two data sets together to view and analyze the relationship between individual users and specific product usage.
An executive dashboard helped drive engagement with the data by presenting business users with live metrics in an easily digestible form. The dashboard provided visuals of their subscriber base by region including:
- Product Usage
- Subscriber count
- Business Support
What We Delivered
New insights led to higher quality data, which revealed that the company actually had a greater number of subscribers than previously estimated.
Armed with an accurate subscriber count, the company was able to charge more for advertising space and increase revenue.
The dashboards allowed business users to see live business metrics to track their progress in real time. MRE also provided training on how to easily create ad-hoc reports.
- Single source of truth system of record
- Accurate and consolidated reporting structure
- Live dashboard metrics for executives and other decision makers
- Standardized and reproducible data schemas
- OLAP analytics for improved data quality