Skip to main content
New Introducing Orchestrator Learn more
Data Warehouse integration

Fivetran + Conversion

Export contacts, email engagement, and custom events to your warehouse with an open-source Fivetran connector.

Fivetran
Out of Conversion
Conversion

How Conversion works with Fivetran

Conversion connects to Fivetran through an open-source connector that exports your contacts, email engagement events, and custom events into your warehouse. The connector runs in your own Fivetran account, reads from the Conversion public API export endpoints, and upserts each table by primary key on the schedule Fivetran manages. The export endpoints are not enabled by default, so ask the Conversion team to turn them on before you deploy.

What syncs

Data Direction Details
Contacts Out of Conversion One row per contact, with every contact field flattened into its own column.
Email engagement events Out of Conversion Nine tables, one per event type, covering sends, deliveries, opens, clicks, hard and soft bounces, spam complaints, and full or topic unsubscribes.
Custom events Out of Conversion Opt-in. One row per event with its name, contact, timestamps, and JSON payload.

How to connect Fivetran

  1. 1 Ask the Conversion team to enable the export endpoints, then create an API key under Settings > API Keys.
  2. 2 Clone the open-source connector from github.com/tapp-ai/fivetran-connector and install it with uv.
  3. 3 Copy configuration.example.json to configuration.json, add your API key, and optionally set tables and custom_events_start.
  4. 4 Test with uv run fivetran debug, which runs the sync against a local DuckDB warehouse so you can inspect the tables and confirm cursors advance.
  5. 5 Deploy with uv run fivetran deploy, your Fivetran deploy key, and your destination. Fivetran then manages the sync schedule.

See Conversion with Fivetran

Book a demo and we'll walk through the Fivetran integration on a stack that looks like yours.