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 | ||
| Column Hashing | ||
| Re-sync | check | Connector level |
| History | ||
| API Configurable | check | |
| Priority-first sync | ||
| dbt Package |
Setup guidelink
Follow our step-by-step Klaviyo setup guide to connect Klaviyo with your destination using Fivetran connectors.
Schema informationlink
This schema applies to all Klaviyo connectors.
To zoom, open ERD in 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