# Hotjar + ClickHouse

> Export Hotjar events, metrics, and funnels to Clickhouse without code. Analyze product behavior with fresh data and stable pipelines. Erathos.

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

Hotjar is an online behavior analytics tool that provides insights into how users interact with websites, helping to optimize user experience and boost conversion rates. It uses heatmaps, session recordings, and feedback surveys to pinpoint areas for improvement. ClickHouse, on the other hand, is an open-source, high-performance columnar database management system for online analytical processing (OLAP) that delivers robust, large-scale data storage and analytics capabilities.

With Erathos, you can integrate Hotjar data into ClickHouse in just a few minutes. Our platform handles the entire data pipeline to your analytical environment, allowing you to blend these datasets with other sources inside your data warehouse. This keeps your team focused on what actually drives value — extracting critical insights and making data-driven decisions.

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

The integration automatically syncs key Hotjar objects:

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

### Why sync Hotjar with ClickHouse?

In ClickHouse, you can run OLAP queries on your Hotjar data in milliseconds, making it perfect for high-concurrency dashboards and massive time-series datasets.

### How it works

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

## Data in your data warehouse in minutes

### Out-of-the-box Hotjar connector

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

### Full control over your Hotjar 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 Hotjar is broken only after 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 goes off track — so your product metrics stay reliable for roadmap decisions.

## Centralizing Hotjar data into ClickHouse has never been easier

Erathos is a data ingestion platform built for product and analytics teams. With the Hotjar connector, you can automatically export events, product metrics, and conversion funnels directly to Clickhouse — keeping your data fresh for analysis without any 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 Hotjar to their data warehouse — with full observability into every run, zero maintenance, and none of the opacity of traditional market tools.

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

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

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

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

### What happens if a Hotjar 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 Hotjar connector?

Yes. Every Erathos connector comes with a 14-day free trial. Connect Hotjar to Clickhouse and start syncing instantly — no credit card required.