How Livesport Activates Data, Saves Engineering Resources with BigQuery and Dataddo

"

“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.”

Zdeněk Hejnak

Data Development Team Leader

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.

"

“We're constantly looking for new opportunities to get more from our data, so reverse ETL to Google Ads is a promising direction.”

Zdeněk Hejnak

Data Development Team Leader

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 below to start a free trial or book a demo with one of our experts.

Start Free 14-day Trial

Book Demo