ClickHouse
Case Studies
AdGreetz's Transformation: Processing Millions of Daily Ad Impressions with ClickHouse Cloud
Overview
AdGreetz's Transformation: Processing Millions of Daily Ad Impressions with ClickHouse CloudClickHouse |
Application Infrastructure & Middleware - Database Management & Storage Application Infrastructure & Middleware - Event-Driven Application | |
Buildings Construction & Infrastructure | |
Sales & Marketing | |
Personnel Tracking & Monitoring Time Sensitive Networking | |
Cloud Planning, Design & Implementation Services System Integration | |
Operational Impact
The integration of ClickHouse into AdGreetz's tech stack has streamlined their data processing architecture. The company now utilizes Cloudflare workers to process ad impression events individually and asynchronously, with each worker handling one event at a time. This process sends a success response to the client while simultaneously processing and enriching the event in the background. Once complete, the worker asynchronously inserts data into ClickHouse. This streamlined compatibility simplifies the architecture and eliminates the need for an aggregating component like Kafka. Additionally, the ability to query the database over HTTP using TypeScript reduces adoption time and maintains a simplified architecture. With ClickHouse, AdGreetz has been able to deliver personalized, data-driven advertising experiences more efficiently and cost-effectively. | |
Quantitative Benefit
AdGreetz handles 5-6 million ad impression events daily, with numbers peaking at 20-30 million during busy periods. | |
Switching to ClickHouse Cloud resulted in sub-second query times, a significant improvement from their previous solution. | |
ClickHouse Cloud cost nearly six times less than their previous solution, Snowflake. | |