ClickHouse Case Studies Plausible Analytics Leverages ClickHouse for Privacy-Friendly Web Analytics

Edit This Case Study Record

	Plausible Analytics Leverages ClickHouse for Privacy-Friendly Web Analytics ClickHouse

Plausible Analytics Leverages ClickHouse for Privacy-Friendly Web Analytics

ClickHouse

Technology Category	Platform as a Service (PaaS) - Application Development Platforms
Applicable Industries	Electrical Grids Equipment & Machinery
Challenge	Plausible Analytics, a privacy-friendly alternative to Google Analytics, faced a significant challenge as it scaled its services. Since its launch in April 2019, the platform had grown to service over 5000 paying subscribers, tracking 28,000 different websites and more than 1 billion page views per month. However, the original architecture using Postgres to store analytics data was unable to handle the platform’s future growth. The loading speed of their dashboards was slow, taking up to 5 seconds, which was not conducive to a good user experience. The team realized that to continue their growth trajectory and maintain customer satisfaction, they needed a more efficient solution. Read More
About Customer	Plausible Analytics is an open-source web analytics tool that has quickly gained popularity as a privacy-friendly alternative to Google Analytics. By using Plausible Analytics, customers maintain full ownership of their website data and protect the privacy of their visitors, as the tool does not use cookies and is fully compliant with GDPR. Since its launch in April 2019, the platform has grown to service over 5000 paying subscribers, tracking 28,000 different websites and more than 1 billion page views per month. The platform's mission is to reduce corporate surveillance by providing an alternative web analytics tool that doesn't come from the AdTech world. Read More
Solution	The Plausible Analytics team decided to try ClickHouse, a recommendation they received through word of mouth. They noticed significant improvements in the loading speed of their dashboards, which now took less than a second to load, compared to the previous 5 seconds with Postgres. The team also tried other solutions, but ClickHouse outperformed them in terms of both performance and features. ClickHouse's efficiency and rich feature set made it easy for the team to work with, and it met all their needs exceptionally well. With ClickHouse, Plausible Analytics was able to serve even its largest customers with ease, including a customer with 150 million pages per month, a feat that would not have been possible with their previous architecture. Read More Log in to view content
Contents

Technology Category

Platform as a Service (PaaS) - Application Development Platforms

Applicable Industries

Electrical Grids

Equipment & Machinery

Challenge

Plausible Analytics, a privacy-friendly alternative to Google Analytics, faced a significant challenge as it scaled its services. Since its launch in April 2019, the platform had grown to service over 5000 paying subscribers, tracking 28,000 different websites and more than 1 billion page views per month. However, the original architecture using Postgres to store analytics data was unable to handle the platform’s future growth. The loading speed of their dashboards was slow, taking up to 5 seconds, which was not conducive to a good user experience. The team realized that to continue their growth trajectory and maintain customer satisfaction, they needed a more efficient solution.

About Customer

Plausible Analytics is an open-source web analytics tool that has quickly gained popularity as a privacy-friendly alternative to Google Analytics. By using Plausible Analytics, customers maintain full ownership of their website data and protect the privacy of their visitors, as the tool does not use cookies and is fully compliant with GDPR. Since its launch in April 2019, the platform has grown to service over 5000 paying subscribers, tracking 28,000 different websites and more than 1 billion page views per month. The platform's mission is to reduce corporate surveillance by providing an alternative web analytics tool that doesn't come from the AdTech world.

Solution

The Plausible Analytics team decided to try ClickHouse, a recommendation they received through word of mouth. They noticed significant improvements in the loading speed of their dashboards, which now took less than a second to load, compared to the previous 5 seconds with Postgres. The team also tried other solutions, but ClickHouse outperformed them in terms of both performance and features. ClickHouse's efficiency and rich feature set made it easy for the team to work with, and it met all their needs exceptionally well. With ClickHouse, Plausible Analytics was able to serve even its largest customers with ease, including a customer with 150 million pages per month, a feat that would not have been possible with their previous architecture.

Impact #1	Switching to ClickHouse has been a game-changer for Plausible Analytics. The improved loading speed of their dashboards has significantly enhanced the user experience, which is crucial for a lightweight product like Plausible Analytics. The fast loading of the dashboard, data segmentation, and other background processes have been well-received by customers, who appreciate the speedy experience. The team has also found ClickHouse to be very efficient and easy to work with, saving them time and effort. The switch to ClickHouse has been instrumental in Plausible's growth and customer acquisition, and the team believes they wouldn't be where they are today without it.

Impact #1

Switching to ClickHouse has been a game-changer for Plausible Analytics. The improved loading speed of their dashboards has significantly enhanced the user experience, which is crucial for a lightweight product like Plausible Analytics. The fast loading of the dashboard, data segmentation, and other background processes have been well-received by customers, who appreciate the speedy experience. The team has also found ClickHouse to be very efficient and easy to work with, saving them time and effort. The switch to ClickHouse has been instrumental in Plausible's growth and customer acquisition, and the team believes they wouldn't be where they are today without it.

Benefit #1	Reduced dashboard loading time from 5 seconds to less than a second
Benefit #2	Enabled service to the largest customer with 150 million pages per month
Benefit #3	Supports tracking of over 28,000 different websites and more than 1 billion page views per month

Benefit #1

Reduced dashboard loading time from 5 seconds to less than a second

Benefit #2

Enabled service to the largest customer with 150 million pages per month

Benefit #3

Supports tracking of over 28,000 different websites and more than 1 billion page views per month

Download PDF Version

Overview

Plausible Analytics Leverages ClickHouse for Privacy-Friendly Web Analytics

Operational Impact

Quantitative Benefit