How Global Telecom Analyzes 168B Subscriber Interactions

About The Customer

A top US telecom and media leader connecting millions worldwide

The company is the largest wireless carrier in the United States, serving more than 146 million subscribers across 150+ countries worldwide. It collects and analyzes over 70 billion network data points daily from 29,000+ diverse sources, including live streaming, set-top boxes, broadband and mobile usage.

Challenges

Growing data volumes overloaded systems, slowing analytics

The company faced major roadblocks in analyzing its massive viewership data across multiple platforms, devices and geographies.

Complex viewership data: Millions of subscribers generated billions of daily interactions across live TV, DVR, video-on-demand, pay-per-view and streaming devices, making existing BI tools slow and inefficient.

Fragmented and inconsistent data: Data was siloed across platforms, preventing a unified view of viewers and making cross-channel analysis difficult.

Delayed insights: Ad hoc queries and trend analyses could take hours or days, causing delays in responding to audience behavior.

Business Goals

Delivering personalized content experiences to millions of subscribers

The company aimed to integrate massive data streams and understand viewing behaviour, optimize network performance and deliver personalized content experiences across channels and devices. Strategic goals included:

Unify data across viewers, geographies and equipment.

Uncover customer behavior patterns and network performance trends.

Accelerate time to insight to support timely marketing decisions.

Increase engagement and customer satisfaction with personalized content.

How Kyvos helped

Delivered instant, multidimensional viewership insights at scale

Kyvos built a semantic layer on the company’s existing data platform to provide instant access to all their viewership data.

Ultra-wide, deep data model: Built a 70-terabyte model covering 14 months of data, 38 dimensions and 168 billion fact rows to enable comprehensive analysis of millions of subscribers.

Interactive, granular drilldowns: Users can explore complex, multi-layered viewership data, uncovering insights across platforms, content and subscriber behavior.

Seamless connectivity with existing BI tools: Connected with Tableau, Qlik, and other BI platforms for interactive, multi-dimensional, high-performance analytics.

Automated data refreshes: Enabled instant incremental refreshes, processing 250 million new rows daily in under 20 minutes.

Content and trend analytics: Provided month-over-month comparisons to uncover evolving viewer patterns and programming performance shifts, driving timely responses to network, content and subscriber issues.