Clients cases – Case Study: Megogo 
“Achieving that kind of efficiency with traditional infrastructure would require an enormous investment. For instance, 52 seconds to process 2.82 TB of data. This level of efficiency is our everyday reality now. Imagine pulling 3 terabytes of data from storage, running a complex query, and getting a result in under a minute — this is the power BigQuery brings to the table.”
Megogo is a leading provider of OTT streaming media products and services. As one of the largest entertainment services in Eastern Europe, the company has over 55 million users and a catalog of about 200,000 hours of content. It also provides streams of over 4,000 local and foreign TV channels.
Megogo’s rapid growth required a scalable, flexible, and cost-efficient solution to handle increasing data volumes and streamline their infrastructure. With a vast amount of data across content and user activity, they needed a robust platform to process and analyze large datasets quickly while optimizing costs.
The need for a cloud-based system that could process large amounts of data quickly, while keeping costs under control, led Megogo to explore BigQuery, a highly scalable data warehouse, in collaboration with Cloudfresh. Megogo started to implement BigQuery for data storage and analysis — across all data sets, focusing on analysis, insight discovery, and cross-referencing data clusters and views.
Initially, the company’s tech specialists had no prior experience with BigQuery. However, by leveraging their existing competencies and eliminating the need to manage hardware, they were able to gradually build a dedicated team.
The cost and efficiency BigQuery offers, compared with the hardware setup that could handle similar data volumes, became transformative for the company.
BigQuery’s “pay-as-you-go” pricing model, combined with scalability, allowed Megogo to annually optimize both their query processes and architecture while eliminating the heavy financial burden associated with maintaining physical infrastructure.
Another advantage for the company is seamless Google authentication, which Megogo already use for our email services, enabling Megogo’s teams to manage access to both communication and analytics platforms efficiently.
As for data analysis, Megogo relies on Looker, Google Cloud’s BI and data analytics platform, to access, explore, and extract meaningful insights from their data. With over 300 dashboards supporting various departments, Looker enables Megogo to make informed decisions without needing real-time updates. By intentionally adjusting the data refresh cycle from hourly to daily, Megogo found Looker’s analytics perfectly suited to meet their needs, delivering powerful insights from their data.
By partnering with Cloudfresh, Megogo successfully leveraged BigQuery and Looker solutions to transform how it manages and analyzes data. The combination of speed, scalability, and cost optimization allows Megogo to focus on deriving insights from their data rather than being constrained by infrastructure limitations. Here are the key results:
Cloudfresh provided the strategic guidance and technical expertise needed to implement and optimize BigQuery for Megogo. From cost-saving measures to ongoing support, Cloudfresh helped Megogo fully harness the power of Google Cloud.
“GitLab provided everything we needed to manage the project in one tool—repository, documentation, task management, roadmap planning. High-quality code, quick integration, and effective teamwork—this is what GitLab can help with.”
“The immediate improvement in communication and document management has demonstrated the value of this partnership, and I’m confident in the ongoing benefits it will bring to our operations.”
"The migration marked a significant milestone, empowering our teams to leverage cloud technology's scalability, flexibility, and security to propel the business forward. This migration journey underscored the importance of comprehensive planning, ongoing training, and community engagement. Monitoring and optimization post-migration proved crucial, as did keeping a close eye on expenses. Now, we're starting the new chapter by teaming up with Cloudfresh to maximize our Google Cloud experience."
Order the consultation