Challenge

A leading European telecom and consumer hardware provider needed a way to monitor the performance and adoption of its home devices across multiple countries. Their teams faced several hurdles:

• Fragmented insights: Device usage and performance metrics were scattered across countries and data sources.

• Manual effort: Collecting, cleaning, and consolidating data consumed significant time and introduced errors

• Limited supplier tracking: No efficient way to compare suppliers or analyze device models over time

• Slow decision-making: Reliance on monthly reporting cycles delayed responses to emerging market trends

Solution

Automated Data Collection:

Email-Based Pipeline:

Unified Analytics: 

BigQuery structured the datasets, while Google Cloud Storage handled raw inputs.

Interactive Dashboards:

Service robots gathered monthly performance data from multiple sources into Google Cloud.

Incoming country-level datasets sent by email were automatically extracted, cleaned, and standardized.

Looker Studio dashboards visualized device adoption trends, supplier performance, and regional comparisons.

We built an automated monitoring system that centralized and streamlined device performance tracking:

Seamless Updates:

Monthly refreshes ensured that stakeholders had the latest insights without manual intervention.

Impact

The solution delivered significant value across the organization:

• 80% time savings: Automated processes reduced manual work by 30+ hours per month for each regional team.

• Full coverage: Enabled comprehensive monitoring across all European markets.

• Faster insights: Teams identified trends and issues up to 4x faster than before.

• Scalable design: Expanded effortlessly to support 7+ countries and dozens of device models and manufacturers.

“Monitoring telecom network performance across countries with real-time data and automated reporting.”