# Mixpanel + ClickHouse

> Automatically sync Mixpanel events, users, funnels, and cohorts to ClickHouse. Start your free 14-day trial.

Source: https://www.erathos.com/en/pipelines/mixpanel-clickhouse
Em português: https://www.erathos.com/pipelines/mixpanel-clickhouse

Mixpanel is a product analytics tool that allows companies to track and analyze user behavior across apps and websites. ClickHouse, in turn, is a high-performance columnar database management system for online analytical processing (OLAP), providing robust capabilities for storing and analyzing data at scale.

With Erathos, you can integrate Mixpanel data into ClickHouse in just a few minutes. Our platform handles the entire data movement process to your analytical environment, allowing you to cross-reference data with other sources in your Data Warehouse. This frees up your time to focus on what actually drives value — extracting valuable insights and making more data-driven decisions.

### What Mixpanel data does Erathos sync with ClickHouse?

The integration automatically syncs key Mixpanel objects:

- **Events** — all tracked events with custom properties
- **Sessions** — source, duration, device, and behavioral data
- **Users** — profiles, properties, and activity history
- **Conversion funnels** — steps, drop-offs, and rates by segment
- **Cohorts** — retention and engagement over time
- **Custom properties** — event properties and user properties defined by your team

### Why sync Mixpanel with ClickHouse?

In ClickHouse, you can run OLAP queries on your Mixpanel data in milliseconds, which is ideal for high-concurrency dashboards and high-volume time-series analysis.

### How it works

Erathos connects to Mixpanel via its official API and syncs your data incrementally — only new or updated records are processed during each run, keeping your pipelines fast and your ClickHouse costs predictable. You choose the sync frequency (ranging from every 5 minutes to daily), the objects to sync, and the destination dataset. Every run is logged with full observability: execution time, rows processed, contextual error logs, and instant alerts via Slack or email if anything goes wrong.

## Data in your data warehouse in minutes

### Ready-to-use Mixpanel connector

Connect Mixpanel to Clickhouse and automatically export events, metrics, and funnels. Keep your product data fresh in your data warehouse — with zero manual pipeline engineering.

### Full control over your Mixpanel pipelines

Configure frequency and sync mode on a per-table basis. Data lands in ClickHouse optimized for OLAP queries, delivering millisecond-level analytics even across millions of rows.

### End-to-end observability

Stop finding out about Mixpanel failures only when the business team complains. Every run is logged with runtime, processed rows, and error context. Automatic alerts via Slack, Discord, or email the moment something deviates from expected behavior—so your product metrics stay reliable for roadmap decisions.

## Centralizing Mixpanel data into ClickHouse has never been easier

Erathos is a data ingestion platform built for product and analytics teams. With the Mixpanel connector, you can automatically export events, product metrics, and conversion funnels to Clickhouse — keeping your data fresh for analysis without manual engineering.

## FAQ

### What is Erathos and how can it help my company?

Erathos is a data ingestion platform built for reliability, transparency, and control. We help data teams connect tools like Mixpanel to their data warehouse — with full observability over every execution, zero maintenance, and none of the opacity found in traditional market tools.

### What Mixpanel data does Erathos sync to ClickHouse?

Erathos syncs Mixpanel Events, Sessions, Users, Conversion Funnels, and Product Metrics to Clickhouse. Custom event properties and user properties are automatically exported alongside each record.

### How often does Erathos sync data from Mixpanel to Clickhouse?

You can configure the sync frequency from every 5 minutes to daily, at the table level. Erathos uses incremental syncs—only new or updated records are processed in each run, keeping your Mixpanel pipeline efficient and Clickhouse costs predictable.

### What happens if a Mixpanel sync fails?

Erathos automatically detects failures and sends alerts to your email, Slack, or Discord with full context — not just "job failed." Smart retries handle transient errors, and every run is logged with runtime, rows processed, and error context so your team can debug in minutes, not hours.

### Is there a free trial period for the Mixpanel connector?

Yes. Every Erathos connector includes a 14-day free trial. Connect Mixpanel to Clickhouse and start syncing immediately — no credit card required.