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.
Featureslink
Feature Name | Supported | Notes |
---|---|---|
Capture deletes | check | We infer deletes for the CAMPAIGN , CAMPAIGN_LIST , EMAIL_TEMPLATE , FLOW , INTEGRATION , LIST , LIST_EXCLUSION , and METRIC tables. |
Custom data | check | All fields with the property_ prefix in the EVENT table. All fields with the custom_ prefix in the PERSON table. |
Data blocking | check | Column level |
Column hashing | check | |
Re-sync | check | Connector level |
History | ||
API configurable | check | |
Priority-first sync | ||
Fivetran data models | check | Get the models: source / transform; Get the Shopify Holistic model |
Private networking |
Setup guidelink
Follow our step-by-step Klaviyo setup guide to connect Klaviyo with your destination using Fivetran connectors.
Sync overviewlink
Fivetran syncs the EVENT
and PERSON
tables incrementally based on the sync frequency you set for your connector.
Fivetran syncs the rest of the tables using non-incremental endpoints. We re-import these tables once a day irrespective of the sync frequency you set. The table re-imports run as a part of a sync that also includes incremental sync of the EVENT
and PERSON
tables.
NOTE: You may observe older data in the non-incremental tables in comparison to the
EVENT
andPERSON
tables due to the difference in their actual sync frequencies.
Sync strategy for LIST_PERSON tablelink
By default, we do not sync the LIST_PERSON
table because we need to use non-incremental endpoints to sync the table. We have to sync the historical data every time for the non-incremental endpoints. If you’d like to sync the LIST_PERSON
table, contact our support team. We sync the LIST_PERSON
table once a week.
Schema informationlink
This schema applies to all Klaviyo connectors.
To zoom, open the ERD in a new window.
Schema noteslink
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
Sync limitationlink
Klaviyo doesn’t have an API endpoint that returns all the profiles or segments in an account.
You may observe data integrity issues in the PERSON table
because Fivetran cannot fetch the profiles that are not associated with a list. We only sync the profiles that have an associated event (EVENT
table) or are part of a list (LIST
table) to the destination table.