Case Study
How Livesport Activates Data, Saves Engineering Resources with BigQuery and Dataddo
Main Challenge
Livesport, a global provider of real-time sports stats, didn't want to build their data team around synchronizing data to Google BigQuery, their main warehouse. Instead, they wanted to outsource integration work to a trusted Google Cloud partner and build the team around what's most important for their business: analytics.
Key Outcomes
• 70% less data engineering.
• 3-4 full-time equivalents (FTEs) saved
• 1 central repository for all company data: Google BigQuery
• Heavily analytics-focused data team.
Solution
• Ultra smooth integration of all data sources with BigQuery thanks to Dataddo's Google Cloud-optimized connectors.
• New connectors built on request within 10 days.
• Real-time support from Dataddo specialists via Slack.
• Fixed pricing means no billing surprises.
• Nice-to-have capabilities go beyond Livesport's initial requirements:
• Reverse ETL for automatic import of offline conversion data to Google Ads.
• Direct data-to-dashboard connections via no-code interface for business teams.
• Reverse SSH tunneling
CASE STUDY
Read the Full Story
Today, organizations can build a robust, end-to-end data infrastructure with a fraction of the in-house engineering resources. Livesport—a provider of real-time data, results, and statistics for virtually all sporting events around the globe—recognized this early on when building their data team.
Livesport was already using BigQuery as a data warehouse for all layers of their infrastructure, but the company didn't want to build a data team based on syncing data to BigQuery from other databases and non-Google sources. Instead, Livesport sought a solution from Dataddo, a recognized Google Cloud Ready data integration partner for BigQuery.
The Challenge: Offloading Data Integration Tasks to a Dedicated Tool
Livesport's data team has strong SQL skills, so it was important to give the team space to focus on data activation and analytics while outsourcing engineering workloads associated with data automation and ingestion.
The data team was already syncing data from Google services like GA4 and Google Ads to BigQuery, which cost them nothing to maintain thanks to native integrations. However, they needed a tool that could sync a mountain of data from sources outside the Google ecosystem:
- • Livesport's internal databases (e.g., sports data and data from their app)
- • ERP system
- • Third-party services
- • Social media accounts
- • Affiliate partner APIs
Additionally, Livesport was looking for some nice-to-haves:
- • Fixed pricing due to high fluctuation in the amount of data synced monthly
- • Close support to connect data from unique internal solutions
- • Willingness to build new connectors quickly
Flexible, Customizable, End-to-End Connectivity with Dataddo
Livesport first evaluated another popular data integration tool, but eventually chose Dataddo because it met all their essential criteria and more:
- • Dataddo is capable of connecting data from all of Livesport's sources to BigQuery: internal databases (via CDC data replication), third-party services, custom sources, and affiliate partners' APIs.
- • Real-time support from dedicated specialists. Dataddo created a Slack channel where specialists from both sides can interact, especially over the implementation of custom integrations.
- • New connectors built in around 10 days, free of charge.
- • Fixed pricing ensures that there are no surprises at the end of billing periods.
Livesport is also taking advantage of Dataddo capabilities that go beyond their initial requirements:
- • Direct connection of online services with business intelligence (BI) tools. Dataddo's no-code user interface enables Livesport's business teams, such as marketing, to flexibly sync data from apps like Facebook with BI systems to gain ad-hoc insights—without intervention from the data team.
- • Reverse ETL for offline conversion imports (OCI). Livesport is using Dataddo to import offline conversion data from BigQuery to Google Ads.
- • Reverse SSH tunnelling provides an added layer of security.
The Outcomes: 70% Less Engineering, Bigger BI Team
By outsourcing data engineering tasks to Dataddo, Livesport's data team is now free to fully capitalize on the analytics capabilities of BigQuery. They can also spend more time using other Google Cloud Platform services like Vertex AI, BigQueryML, and Cloud Functions to enrich data and then send it downstream to end users.
'We save about 70% of the time it would otherwise take to ingest all our data, or 3-4 full-time equivalents, and spend this much more time on data analytics and activation. We only have one full-time data engineer, who does more than just collect data, while our BI team consists of 11 members,' says Zdeněk Hejnak, Data Development Team Leader at Livesport.
Livesport is also testing Dataddo's reverse ETL capabilities to automate the import of offline conversion data from BigQuery to Google Ads — a cutting-edge way to optimize ad spend and punctually target qualified prospects.
To learn more about the interoperability of Dataddo and Google Cloud, visit the Google Cloud partner directory or Dataddo's Marketplace offerings. If you're interested in using Dataddo for BigQuery, check out our BigQuery connector.
See the Dataddo Platform in Action
Click to book a live demo with one of our experts.
Testimonials
Dataddo Is Ranked #1 by Customers
