# Hotjar + BigQuery

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

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

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 widgets to identify areas for improvement. Amazon Redshift, on the other hand, is a cloud data warehouse designed for fast and efficient analytics on large datasets.

With Erathos, your Hotjar data lands in BigQuery in minutes, ready to be joined with other business data sources in ad-hoc queries, without your team having to manage any ingestion infrastructure.

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

The integration automatically syncs key Hotjar objects:

- **Events:** All tracked events along with their custom properties
- **Sessions:** Source, duration, device, and behavioral data
- **Users:** Profiles, properties, and activity history
- **Conversion Funnels:** Funnel stages, drop-offs, and conversion rates by segment
- **Cohorts:** Retention and engagement metrics over time
- **Custom Properties:** Event and user properties defined by your team

### Why sync Hotjar with BigQuery?

In BigQuery, you can combine Hotjar data with other business sources, running ad-hoc queries in seconds across massive datasets without managing infrastructure.

### How it works

Erathos connects to Hotjar via the official API and syncs your data incrementally: only new or updated records are processed in each run, keeping your pipelines fast and BigQuery costs predictable. You choose the sync frequency (from every 5 minutes to daily), the objects to sync, and the target 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

### Hotjar connector ready to use

Connect Hotjar to BigQuery and automatically export events, metrics, and funnels. Product data always fresh in your data warehouse — no manual engineering required.

### Full control over your Hotjar pipelines

Configure schedule, frequency, and sync type at the table level. Incremental synchronization processes only new or modified records—keeping BigQuery costs low and your analyses always up to date.

### 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 in BigQuery 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 to BigQuery—so your analyses always run on fresh data, with no manual engineering required.

## 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 for every run, zero maintenance, and none of the opacity of traditional market tools.

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

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

### How often does Erathos synchronize Hotjar data to BigQuery?

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

### What happens if a Hotjar synchronization 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 execution is logged with run time, processed rows, 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 includes a 14-day free trial. Connect Hotjar to BigQuery and start syncing immediately—no credit card required.