Klaviyo
Klaviyo is an advanced email marketing and automation platform designed for e-commerce businesses. It offers a powerful suite of tools to help businesses build and execute targeted email marketing campaigns, segment their audience, and automate personalized communication with customers.
Features
Feature name | Supported | |
---|---|---|
Column Hashing | True | Field level |
Blocking | True | Field level |
Incremental | True | |
Custom data | False | |
History | False | |
ReSync | True | Table level |
Templates | False |
Prerequisites
An active Klaviyo account with permission to access data from accounts you would like to sync.
Data Schema
🔧 Setup Guide - ELT
Step 1 - Create API Key
- In your Klaviyo click your account name → Account
- Click on Settings → API Keys
- Create API Key
- Copy the Private API Key for the Weld Integration
Step 2 - Finalize Weld Integration
- On the Weld App enter a Schema Name
- Enter the Klaviyo API key you created
- Click Connect
Step 3 - Data To Sync
- Select the pre-built reports you wish to include in the sync.
You can view the schema, remove columns or hash sensitive information.
Step 4 - Configure Sync
- Select how often you would like the data to sync.
- Provide a unique destination table name.
Weld will take over from here and commence syncing data from your Klaviyo account.
🔧 Setup Guide - Reverse ETL
Klayvio reverse ETL allows you to sync data on a schedule from your Weld App automatically into Klayvio.
Supported tables:
- list (
upsert
) - activity (
insert
) - bulk (
upsert
)
Setup Instructions
Prerequisites: Create API Key
- In your Klayvio click your account name → Account
- Click on Settings → API Keys
- Create API Key
- Copy the Private API Key for the Weld Integration
- On the Weld App enter a Schema Name
- Enter the Klayvio API key you created
- Click Connect
Step 1 - Destination
- Click on the Reverse ETL item in the sidebar to navigate to the page.
- If this is your first reverse ETL sync the setup guide will automatically start. Otherwise click "Add Reverse ETL Sync" button to start the setup guide.
- Find the Klaviyo connector from the list of destinations and choose an existing connection, if any, or click to create a new connection which you will need to authorize.
Step 2 - Target Details
The Klaviyo connection does not have additional configuration - This will be skipped.
Step 3 - Map Data
Define how your source data should sync with your destination.
Source
Choose the SQL model that contains the data that you would like to send to Klaviyo
Select your object:
profile_list
profile_activity
profile_bulk_upsert
Select list from drop down or create list.
Only used in `profile_list`.
SQL Model tips for Klaviyo rETL
Profile Lists:
Your SQL model should have one row per unique email.
Profile Activity:
SQL model can have multiple rows per email.
You must have a column containing the Event Name. \
Sync Mode
Choose how you would like to sync your data:
- Upsert: Inserts new records and updates already synced data
Choose Identifier
Select the unique identifier field to match your record between your source and destination (this is usually the email or ID).
Field Mapping
Configure the field mapping between your source and destination. Map the column from your source model to the property in Klaviyo.
Step 4 - Schedule sync
Choose how often you would like the sync to run. You can choose to have the sync running on an independent schedule or as part of an orchestration workflow.
- Independent: The sync will run on its own schedule, independent of other syncs.
- Orchestration: The sync will be part of an orchestration workflow, allowing you to run it in conjunction with other tasks.
Step 5 - Finalise and run
After you have configured the sync, click on Start Sync to finalize the setup. The sync will perform the initial run immediately.