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 | API configuration |
| 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
EVENTandPERSONtables 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.