---
title: "How Insider One uses ClickHouse Cloud to power real-time customer engagement at scale"
description: "Insider One’s Unified Customer Database (UCD) unifies event data, user attributes, identity resolution, and profiles across channels to support real-time segmentation, personalization, and analytics. The platform initially ran ClickHouse in a self-managed AWS deployment, but growth brought larger datasets, more concurrent queries, and increasing work tuning clusters and balancing performance against cost. In a proof of concept, the team migrated an anonymized dataset from one of its largest customers to ClickHouse Cloud and replayed UI segmentation, audience-count, and scheduled-campaign workloads. Average query latency fell 50–60% without significant changes, reaching 70–75% for the largest customers, while latency percentiles became more predictable; the managed service also reduced operational burden and gave the team more capacity for product development and its AI-oriented roadmap."
---

# How Insider One uses ClickHouse Cloud to power real-time customer engagement at scale

[Clickhouse](https://yomu.fyi/company/clickhouse) · Jul 13, 2026

**Type:** Problem & solution

## Summary

Insider One’s Unified Customer Database (UCD) unifies event data, user attributes, identity resolution, and profiles across channels to support real-time segmentation, personalization, and analytics. The platform initially ran ClickHouse in a self-managed AWS deployment, but growth brought larger datasets, more concurrent queries, and increasing work tuning clusters and balancing performance against cost. In a proof of concept, the team migrated an anonymized dataset from one of its largest customers to ClickHouse Cloud and replayed UI segmentation, audience-count, and scheduled-campaign workloads. Average query latency fell 50–60% without significant changes, reaching 70–75% for the largest customers, while latency percentiles became more predictable; the managed service also reduced operational burden and gave the team more capacity for product development and its AI-oriented roadmap.

## Context

Insider One needed a unified data foundation for customer engagement across channels, with high-volume event ingestion and low-latency queries for live segmentation and personalization. As customer adoption grew, larger datasets and more concurrent queries increased infrastructure-management demands, including cluster tuning and performance-versus-cost trade-offs.

## Approach / What changed

Insider One validated ClickHouse Cloud with a proof of concept using an anonymized dataset from one of its largest customers. The team replayed UI-triggered segmentation queries, dynamically updated audience counts, and analytical jobs for scheduled campaigns, then compared latency percentiles and operational experience with its self-managed ClickHouse deployment on AWS.

## Takeaways

- A ClickHouse Cloud proof of concept reduced average query latency by 50–60% without significant changes to Insider One’s workloads, with improvements reaching 70–75% for its largest customers.
- The validation measured P50, P75, P90, and P99 latency because long-tail delays affect segment building and campaign launches; ClickHouse Cloud reduced those outliers and made performance more predictable.
- Moving cluster management to ClickHouse Cloud reduced operational effort, allowing Insider One to focus more on building features on its Unified Customer Database and supporting an AI-driven roadmap.

**Tags:** [AWS](https://yomu.fyi/topic/aws), [Performance](https://yomu.fyi/topic/performance), [Scalability](https://yomu.fyi/topic/scalability)

- Source: [Clickhouse](https://clickhouse.com/blog/insiderone-customer-data-platform)
- Source URL: https://clickhouse.com/blog/insiderone-customer-data-platform
- Ingested by Yomu: 2026-08-29T01:38:24.143Z

[Read original post](https://clickhouse.com/blog/insiderone-customer-data-platform)