Klaviyo Setup Guide

Follow our setup guide to connect Klaviyo to Fivetran.

Prerequisites

To connect Klaviyo to Fivetran, your Klaviyo user account must have Owner, Admin, or Manager permissions.

In the connection setup form, enter your chosen destination schema name.
In the Destination schema names field, choose the naming convention you want Fivetran to use for the schemas, tables, and columns in your destination:
- Fivetran naming: Standardizes the schema, table, and column names in your destination according to the Fivetran naming conventions.
- Source naming: Preserves the original schema, table, and column names from the source system in your destination.
The Source naming feature is not compatible with Quickstart transformations. To ensure successful syncs, we automatically disable Quickstart transformations for connections configured with Source naming.
If you want to modify your selection, make sure you do it before you start the initial sync.
Click Authorize to authorize Fivetran to access your Klaviyo account.
(Optional) In the Historical sync time frame drop-down menu, select the amount of historical data you want to include in your initial sync.
- If you choose Sync data from selected date, enter a date in the Historical Sync Limit Date field.
(Optional) If you do not want to sync events associated with deleted profiles, set the Sync events linked to deleted profiles toggle to OFF.
Choose the Pack Mode for custom fields.

Click + Add report if you want to sync a custom report.
Enter a Name for the report. The name must be unique within this connection.
Select the Type for the report.
Select the Interval for the report.
Select the list of Statistics that you want to retrieve as part of the report.
Select the Conversion metric for the report.
Click Save.

Click Save & Test. Fivetran will take it from here and sync your Klaviyo data.