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.
|Capture deletes||check||We infer deletes for the
|Custom data||check||All fields with the
|Data blocking||check||Column level|
|Fivetran data models||check||Get the models: source / transform; Get the Shopify Holistic model|
Follow our step-by-step Klaviyo setup guide to connect Klaviyo with your destination using Fivetran connectors.
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
NOTE: You may observe older data in the non-incremental tables in comparison to the
PERSONtables 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.
This schema applies to all Klaviyo connectors.
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 from List
- Updated Email Preferences
Web tracking events come when you add web tracking to the site. It includes:
- Active on Site
- Viewed Product
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.