Klaviyo link
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 | 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. |
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 | check | EVENT table |
Fivetran data models | check | Get the models: source / transform; Get the Shopify Holistic model; Supports Quickstart data models |
Private networking |
Setup guidelink
Follow our step-by-step Klaviyo setup guide to connect Klaviyo with your destination using Fivetran connectors.
Sync overviewlink
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
and it's 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.
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