ClickHouse Case Studies Real-Time Analytics Enhancement for Adevinta with ClickHouse Cloud

Edit This Case Study Record

	Real-Time Analytics Enhancement for Adevinta with ClickHouse Cloud ClickHouse

Real-Time Analytics Enhancement for Adevinta with ClickHouse Cloud

ClickHouse

Technology Category	Analytics & Modeling - Machine Learning Infrastructure as a Service (IaaS) - Cloud Databases
Applicable Industries	Buildings Equipment & Machinery
Use Cases	Real-Time Location System (RTLS) Time Sensitive Networking
Services	Cloud Planning, Design & Implementation Services System Integration
Challenge	Adevinta, a global online classifieds specialist, operates over 25 platforms across 11 countries, reaching hundreds of millions of users monthly. Their mission is to provide the best user experience for buying and selling goods and services online. To achieve this, they needed a centralized analytics and dashboarding tool to monitor their seller's advertisements, track interactions, and improve performance in real-time. The Central Data Products team at Adevinta was tasked with building data and machine learning products to support their various marketplaces. They faced a complex challenge of needing a solution that could scale, provide end-user facing analytics capabilities with low latency and high throughput, and consider aspects such as reusability, uptime, and scalability. Adevinta required a user-facing real-time analytics and dashboarding solution that would allow the sellers to monitor their advertisements in real-time, tracking views, favorites, and likes, and capturing every interaction that occurs on their marketplaces. Read More
About Customer	Adevinta is a leading online classifieds specialist that operates more than 25 platforms across 11 countries worldwide. Their household brands include Marktplaats in the Netherlands, Mobile.de in Germany, and Leboncoin in France, reaching hundreds of millions of people every month. These platforms are all about matchmaking, and help people find whatever they’re looking for in their local communities – whether it’s a car, an apartment, a sofa, or a new job. Adevinta’s mission is to provide the best user experience for buying and selling goods and services online. They aim to create a world where people share more and waste less. Read More
Solution	Adevinta evaluated several cloud-based database services, including ClickHouse Cloud, Google BigQuery, and Cloud Spanner. Their main requirements were a fully-fledged database service that was performant, efficient, had capabilities like indexing, disaster recovery, backup and restore, low operational complexity, managed service and easily scalable, cloud agnostic, easy to deploy and operate, rich query language, low latency, high throughput use case with <3 sec response time as the service level agreement (SLA), current production workload - 80B rows (18TBs), and highly analytical queries with SQL interface. After evaluation, they found that ClickHouse performed exceptionally well for their specific needs, as it was performant, cloud-agnostic, and more cost-effective than the other solutions. Adevinta chose ClickHouse Cloud as it fit within their budget and offered the most value for their needs. The solution was tested across multiple marketplaces with 22 queries per second, using a single table of 20 billion rows and 20 terabytes of data. Read More Log in to view content
Contents

Technology Category

Analytics & Modeling - Machine Learning

Infrastructure as a Service (IaaS) - Cloud Databases

Applicable Industries

Buildings

Equipment & Machinery

Use Cases

Real-Time Location System (RTLS)

Time Sensitive Networking

Services

Cloud Planning, Design & Implementation Services

System Integration

Challenge

Adevinta, a global online classifieds specialist, operates over 25 platforms across 11 countries, reaching hundreds of millions of users monthly. Their mission is to provide the best user experience for buying and selling goods and services online. To achieve this, they needed a centralized analytics and dashboarding tool to monitor their seller's advertisements, track interactions, and improve performance in real-time. The Central Data Products team at Adevinta was tasked with building data and machine learning products to support their various marketplaces. They faced a complex challenge of needing a solution that could scale, provide end-user facing analytics capabilities with low latency and high throughput, and consider aspects such as reusability, uptime, and scalability. Adevinta required a user-facing real-time analytics and dashboarding solution that would allow the sellers to monitor their advertisements in real-time, tracking views, favorites, and likes, and capturing every interaction that occurs on their marketplaces.

About Customer

Adevinta is a leading online classifieds specialist that operates more than 25 platforms across 11 countries worldwide. Their household brands include Marktplaats in the Netherlands, Mobile.de in Germany, and Leboncoin in France, reaching hundreds of millions of people every month. These platforms are all about matchmaking, and help people find whatever they’re looking for in their local communities – whether it’s a car, an apartment, a sofa, or a new job. Adevinta’s mission is to provide the best user experience for buying and selling goods and services online. They aim to create a world where people share more and waste less.

Solution

Adevinta evaluated several cloud-based database services, including ClickHouse Cloud, Google BigQuery, and Cloud Spanner. Their main requirements were a fully-fledged database service that was performant, efficient, had capabilities like indexing, disaster recovery, backup and restore, low operational complexity, managed service and easily scalable, cloud agnostic, easy to deploy and operate, rich query language, low latency, high throughput use case with <3 sec response time as the service level agreement (SLA), current production workload - 80B rows (18TBs), and highly analytical queries with SQL interface. After evaluation, they found that ClickHouse performed exceptionally well for their specific needs, as it was performant, cloud-agnostic, and more cost-effective than the other solutions. Adevinta chose ClickHouse Cloud as it fit within their budget and offered the most value for their needs. The solution was tested across multiple marketplaces with 22 queries per second, using a single table of 20 billion rows and 20 terabytes of data.

Impact #1	The main benefit of moving to ClickHouse Cloud for Adevinta was the elimination of the need for a self-managed environment. This meant no dedicated site reliability support was required. ClickHouse also proved to be well-suited for scaling analytics solutions to multiple marketplaces within Adevinta. It provided easy integration and onboarding more data into the database instance, making it extremely easy and super flexible. Adevinta's journey to ClickHouse Cloud for real-time analytics has proven to be successful in meeting their needs for monitoring advertisements and tracking interactions in real-time. Overall, ClickHouse Cloud has provided Adevinta with a reliable, scalable and efficient real-time analytics solution for their online classifieds business.

Impact #1

The main benefit of moving to ClickHouse Cloud for Adevinta was the elimination of the need for a self-managed environment. This meant no dedicated site reliability support was required. ClickHouse also proved to be well-suited for scaling analytics solutions to multiple marketplaces within Adevinta. It provided easy integration and onboarding more data into the database instance, making it extremely easy and super flexible. Adevinta's journey to ClickHouse Cloud for real-time analytics has proven to be successful in meeting their needs for monitoring advertisements and tracking interactions in real-time. Overall, ClickHouse Cloud has provided Adevinta with a reliable, scalable and efficient real-time analytics solution for their online classifieds business.

Benefit #1	ClickHouse Cloud was more cost-effective than other solutions, with BigQuery being 2x more expensive and Cloud Spanner being 6x more expensive for the workload tested.
Benefit #2	The solution was tested across multiple marketplaces with 22 queries per second, using a single table of 20 billion rows and 20 terabytes of data.
Benefit #3	Adevinta tested the system using approximately 5x their current workload.

Benefit #1

ClickHouse Cloud was more cost-effective than other solutions, with BigQuery being 2x more expensive and Cloud Spanner being 6x more expensive for the workload tested.

Benefit #2

The solution was tested across multiple marketplaces with 22 queries per second, using a single table of 20 billion rows and 20 terabytes of data.

Benefit #3

Adevinta tested the system using approximately 5x their current workload.

Download PDF Version

Overview

Real-Time Analytics Enhancement for Adevinta with ClickHouse Cloud

Operational Impact

Quantitative Benefit