Using ClickHouse to count unique users at scale

By implementing semantic sharding and optimizing filtering and grouping with ClickHouse, we transformed query times from minutes to seconds, ensuring efficient handling of high-volume journeys in production while paving the way for future enhancements.

We’ll share a copy of this guide and send you content and updates about Twilio Segment’s products as we continue to build the world’s leading CDP. We use your information according to our privacy policy. You can update your preferences at any time.

With Twilio Engage, customers can define a customer’s journey using our Journeys product. When we launched this product, we provided a way to show how many users were in each step of the journey, but it was difficult to find statistics on how the campaign was doing overall. It was so hard to understand the correct for the step level stats. 

We wanted to provide Engage customers with a way to see overall stats per journey, as well as provide more accurate step level stats.

Leave a Comment