---
title: How Livesport Activates Data, Saves Engineering Resources with BigQuery and Dataddo
description: Livesport saves 3-4 full-time engineering equivalents using Dataddo, enabling their data team to focus almost exclusively on analytics.
image: https://blog.dataddo.com/hubfs/Livesport%20featured.png
---

[![Dataddo Blog](https://blog.dataddo.com/hs-fs/hubfs/blog-logo.png?width=180&name=blog-logo.png)](https://blog.dataddo.com)

**

[Get Dataddo Free](https://www.dataddo.com/signup?hsLang=en)

[![Start for Free](https://no-cache.hubspot.com/cta/default/7885580/42e092dc-d403-4ac3-bd34-06dc490bf6d9.png)](https://cta-redirect.hubspot.com/cta/redirect/7885580/42e092dc-d403-4ac3-bd34-06dc490bf6d9)

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

By Petr Nemeth | 7 min read

![](https://blog.dataddo.com/hubfs/Livesport%20featured.png)

- **
- **
- **

## 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

![Livesport data integrations, database replication, reverse ETL](https://blog.dataddo.com/hs-fs/hubfs/Livesport%20tech.png?width=770&height=157&name=Livesport%20tech.png)

- **70% less engineering**.
- **3-4 full-time equivalents saved**. 
- **1 central repository for all company data**: Google BigQuery.
- **Heavily analytics-focused data team**.

 

## Solution

![Dataddo + Livesport + Google Cloud](https://blog.dataddo.com/hs-fs/hubfs/Livesport%20%26%20Dataddo.png?width=770&height=156&name=Livesport%20%26%20Dataddo.png)

- **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.

 

*![ZdenekHejnakLivesport](https://blog.dataddo.com/hs-fs/hubfs/ZdenekHejnakLivesport.png?width=211&height=217&name=ZdenekHejnakLivesport.png)*

“*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 at Livesport.

 

## Full Case Study

![Livesport: company info](https://blog.dataddo.com/hs-fs/hubfs/Livesport%20about%20table.png?width=181&height=233&name=Livesport%20about%20table.png)Today, organizations can build a robust, end-to-end data infrastructure with a fraction of the in-house engineering resources. [Livesport](https://www.livesport.com/uk/)—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](https://cloud.google.com/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](https://dataddo.com/), a recognized [Google Cloud Ready](https://cloud.google.com/bigquery/docs/bigquery-ready-overview) data integration partner for BigQuery.

 

### **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](https://support.google.com/analytics/topic/9359001). 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

At the same time, Livesport was also looking for a solution that could provide some other nice-to-haves that could help reduce the burden on the data team:

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

With Dataddo, Livesport can:

- **Dataddo is capable of [connecting data from all of Livesport’s sources](https://dataddo.com/connectors) 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**](https://dataddo.com/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](https://dataddo.com/products/data-to-dashboards). 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)](https://blog.dataddo.com/easy-automated-accurate-offline-conversion-imports-to-google-ads?hsLang=en). Livesport is using Dataddo to import offline conversion data from BigQuery to Google Ads.
- Reverse SSH tunneling provides an added layer of security.

 

### **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.

![ZdenekHejnakLivesport](https://blog.dataddo.com/hs-fs/hubfs/ZdenekHejnakLivesport.png?width=227&height=232&name=ZdenekHejnakLivesport.png)“*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,*” said [Zdeněk Hejnak](https://www.linkedin.com/in/zden%C4%9Bk-hejnak-8b39564/), 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](https://dataddo.com/app/google_ads) — a cutting-edge way to optimize ad spend and punctually target qualified prospects.

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

To learn more about Dataddo, visit the [Google Cloud partner directory](https://cloud.google.com/find-a-partner/partner/dataddo) or [Dataddo’s Marketplace offerings](https://console.cloud.google.com/marketplace/product/dataddo-public/dataddo). If you’re interested in using Dataddo for BigQuery, check out [Dataddo’s BigQuery Connector](https://www.dataddo.com/connector/google_big_query?hsLang=en) and learn more about [Google Cloud Ready - BigQuery](https://cloud.google.com/bigquery/docs/bigquery-ready-overview).

 

|   **Connect All Your Data with Dataddo** ETL/ELT, database replication, reverse ETL. Maintenance-free. Coding-optional interface. SOC 2 Type II certified. Predictable pricing. [![Start for Free](https://no-cache.hubspot.com/cta/default/7885580/7ed5acf0-8674-4253-bada-90465ddc6f8a.png)](https://cta-redirect.hubspot.com/cta/redirect/7885580/7ed5acf0-8674-4253-bada-90465ddc6f8a) |
| --- |

 Category: [Product](https://blog.dataddo.com/tag/product), [Case Studies](https://blog.dataddo.com/tag/case-studies), [Data Anywhere](https://blog.dataddo.com/tag/data-anywhere)

### Related Articles**

<https://blog.dataddo.com/databox-new-visualization-destination?hsLang=en>

## [Databox now supported for easy data visualization](https://blog.dataddo.com/databox-new-visualization-destination?hsLang=en)

*(7 min read )*

 Topics: [Product](https://blog.dataddo.com/tag/product), [Case Studies](https://blog.dataddo.com/tag/case-studies), [Data Anywhere](https://blog.dataddo.com/tag/data-anywhere)

<https://blog.dataddo.com/dataddo-now-connects-to-microsoft-fabric?hsLang=en>

## [Dataddo Now Connects to Microsoft Fabric](https://blog.dataddo.com/dataddo-now-connects-to-microsoft-fabric?hsLang=en)

*(7 min read )*

 Topics: [Product](https://blog.dataddo.com/tag/product), [Case Studies](https://blog.dataddo.com/tag/case-studies), [Data Anywhere](https://blog.dataddo.com/tag/data-anywhere)

<https://blog.dataddo.com/never-lose-a-byte-when-and-why-to-use-full-data-re-sync?hsLang=en>

## [Never Lose a Byte: When and Why to Use Full Data Re-Sync](https://blog.dataddo.com/never-lose-a-byte-when-and-why-to-use-full-data-re-sync?hsLang=en)

*(7 min read )*

 Topics: [Product](https://blog.dataddo.com/tag/product), [Case Studies](https://blog.dataddo.com/tag/case-studies), [Data Anywhere](https://blog.dataddo.com/tag/data-anywhere)

### Subscribe to The Chronicles of Marketing Newsletter

## Comments

## Subscribe to Our Blog

Stay up to date with the latest marketing, sales, and service tips and news.

![subscribe](https://blog.dataddo.com/hubfs/Illustrations/subscribe.svg)

- [****](https://www.linkedin.com/company/dataddo)

- ©  Dataddo, Inc. All Rights Reserved

```json
{
  "@context" : "https://schema.org",
  "@type" : "BlogPosting",
  "author" : {
    "@type" : "Person",
    "name" : "Petr Nemeth",
    "url" : "https://blog.dataddo.com/author/petr-nemeth"
  },
  "dateModified" : "2024-09-23T08:54:43.763Z",
  "datePublished" : "2024-03-12T09:49:14.000Z",
  "headline" : "How Livesport Activates Data, Saves Engineering Resources with BigQuery and Dataddo",
  "image" : [ "https://blog.dataddo.com/hubfs/Livesport%20featured.png" ],
  "mainEntityOfPage" : {
    "@id" : "https://blog.dataddo.com/how-livesport-activates-data-saves-engineering-resources-with-bigquery-and-dataddo",
    "@type" : "WebPage"
  },
  "publisher" : {
    "@type" : "Organization",
    "logo" : {
      "@type" : "ImageObject",
      "url" : "https://blog.dataddo.com/hubfs/Dark%20logo@3x-1.png"
    },
    "name" : "Dataddo, Inc."
  }
}
```