# What Replo learned optimizing 100+ billion events in ClickHouse

DevFeed: [What Replo learned optimizing 100+ billion events in ClickHouse](<https://devfeed.tech/articles/what-replo-learned-optimizing-100-billion-events-in-clickhouse-5549.md>)

Original publisher: [Read original article](<https://clickhouse.com/blog/replo>)

Author: ClickHouse

Published: 2026-03-09T11:40:43Z

Content type: article

Language: en

Sources: [ClickHouse Blog](<https://devfeed.tech/sources/clickhouse-blog.md>)

Topics: [clickhouse](<https://devfeed.tech/topics/clickhouse.md>), [product analytics](<https://devfeed.tech/topics/product-analytics.md>), [real-time](<https://devfeed.tech/topics/real-time.md>), [dashboards](<https://devfeed.tech/topics/dashboards.md>), [Shopify](<https://devfeed.tech/topics/shopify.md>), [data](<https://devfeed.tech/topics/data.md>), [Artificial Intelligence](<https://devfeed.tech/topics/ai.md>)

Tags: [analysis](<https://devfeed.tech/tags/analysis.md>), [analytics](<https://devfeed.tech/tags/analytics.md>), [case-study](<https://devfeed.tech/tags/case-study.md>), [clickhouse](<https://devfeed.tech/tags/clickhouse.md>), [conversion](<https://devfeed.tech/tags/conversion.md>), [dashboards](<https://devfeed.tech/tags/dashboards.md>), [data](<https://devfeed.tech/tags/data.md>), [events](<https://devfeed.tech/tags/events.md>), [frontend](<https://devfeed.tech/tags/frontend.md>), [models](<https://devfeed.tech/tags/models.md>), [performance](<https://devfeed.tech/tags/performance.md>), [product](<https://devfeed.tech/tags/product.md>), [real-time](<https://devfeed.tech/tags/real-time.md>), [revenue](<https://devfeed.tech/tags/revenue.md>), [scale](<https://devfeed.tech/tags/scale.md>), [shopify](<https://devfeed.tech/tags/shopify.md>)

## AI overview

Replo describes how it built real-time, in-product analytics for Shopify merchants using ClickHouse. The article covers data-model iterations, precomputation, deduplication, recomputation boundaries, and the operational challenges of processing more than 100 billion events while keeping dashboards responsive and attribution accurate.

## Source excerpt

Replo uses ClickHouse to analyze 100+ billion events in real time, keeping analytics dashboards fast and responsive for 4,000+ Shopify merchants.