Klaviyo
Klaviyo is an email platform powered by data built for commerce and web businesses. Klaviyo makes it easy for ecommerce marketers to target, personalize, measure and optimize email and Facebook campaigns.
Features
Feature Name | Supported | Notes |
---|---|---|
Capture deletes | check | CAMPAIGN , CAMPAIGN_LIST , CAMPAIGN_TRACKING_UTM_PARAM , CAMPAIGN_MESSAGE , CAMPAIGN_MESSAGE_SEND_TIME , EMAIL_TEMPLATE , FLOW , LIST , LIST_EXCLUSION , METRIC , PERSON , LIST_PERSON , SEGMENT_PERSON , GLOBAL_EXCLUSION , and SEGMENT tables. |
History mode | ||
Custom data | check | property_ prefix in the EVENT table. All fields with the custom_ prefix in the PERSON table. |
Data blocking | check | |
Column hashing | check | |
Re-sync | check | |
API configurable | check | API configuration |
Priority-first sync | check | EVENT table |
Fivetran data models | check | |
Private networking | ||
Authorization via API | check |
Setup guide
Follow our step-by-step Klaviyo setup guide to connect Klaviyo with your destination using Fivetran connectors.
Sync overview
We incrementally sync the following tables based on the sync frequency you set for your connector:
EMAIL_TEMPLATE
EVENT
FLOW
PERSON
LIST_EXCLUSION
LIST_PERSON
SEGMENT_PERSON
GLOBAL_EXCLUSION
We perform a weekly re-import of the above tables (except EVENT
) to infer deletes.
We sync the CAMPAIGN
table and its child tables using non-incremental endpoints. We re-import these tables once a day irrespective of the sync frequency you set.
By default, we sync events associated with both active and deleted profiles in Klaviyo. However, you can choose to only sync active profile events in the connector setup form.
Limit historical data sync
You can set the limit on how much of the historical data you want to pull for the EVENT
table. By selecting a range from the drop-down menu in the setup form, you can restrict how much of the historical data will be included.
Pack modes
Pack modes determine the form in which Fivetran delivers your data to your destination. We provide you the option to choose the pack mode for the custom fields of the EVENT
and PERSON
tables.
In the connector setup form, you can choose one of the following packing modes for your custom fields:
- UNPACKED: If you choose this option, we will upsert all the custom fields into separate columns in the
EVENT
andPERSON
tables. If you select this mode and if the final number of columns exceeds the column limit of your destination tables, some columns may be missing from your destination even though the sync is marked as successful. By default, we use this pack mode. - PACKED: If you choose this option, we will pack all the custom fields into a single JSON file and upsert it into a single column. We recommend that you choose this option if the number of custom fields exceeds the column limit of your destination tables.
IMPORTANT: The packing mode options apply only to the
EVENT
andPERSON
tables. As we are setting a hard limit of 10,000 columns for these tables this feature is useful. If Unpacked Mode is selected and the number of columns of your table exceeds 10,000 then we will truncate the columns to 10,000. To avoid this, switch to Packed Mode.
Switching pack modes
You can switch pack modes at any time in your Fivetran dashboard. When you change the pack mode, we automatically perform a full table re-sync of the EVENT
and PERSON
tables. This resync is free.
To change the pack mode for a table, do the following:
- In the connector details page, go to the Setup tab.
- Click Edit connection details.
- In the connector setup form, select the Pack Mode of your choice.
- Click Save & Test.
Schema information
This schema applies to all Klaviyo connectors.
To zoom, open the ERD in a new window.Schema notes
Klaviyo has standard email and web tracking events.
Email event includes:
- Bounced Email
- Clicked Email
- Dropped Email
- Marked Email as Spam
- Opened Email
- Received Email
- Subscribed to List
- Unsubscribed
- Unsubscribed from List
- Updated Email Preferences
Web tracking events come when you add web tracking to the site. It includes:
- Active on Site
- Viewed Product