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

Data Schema

---

🔧 Setup Guide - ELT

Step 1 - Create API Key

1. In your Klaviyo click your account name → Account
2. Click on Settings → API Keys
3. Create API Key
4. Copy the Private API Key for the Weld Integration

Step 2 - Finalize Weld Integration

1. On the Weld App enter a Schema Name
2. Enter the Klaviyo API key you created
3. Click Connect

Step 3 - Data To Sync

1. 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

1. Select how often you would like the data to sync.
2. 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)

Setup Instructions

Step 1 - Create API Key

1. In your Klayvio click your account name → Account
2. Click on Settings → API Keys
3. Create API Key
4. Copy the Private API Key for the Weld Integration
5. On the Weld App enter a Schema Name
6. Enter the Klayvio API key you created
7. Click Connect

Step 2 - Begin Configuration

1. Click on the Reverse ETL button in the side bar and click + New on the top right.
2. Select the Klayvio connector from the drop down menu or else click + Add new connection to authorize the connector
3. Select your object:
   profile_list
   profile_activity
4. Select list from drop down or create list. Only used in `profile_list`.

Step 3 - Model

1. Choose the SQL model that contains the data that you would like to send to google sheets.

Step 4 - Sync Operation

Choose how you would like to sync your data:

• Upsert: Inserts new records and updates already synced data

Step 5 - Schedule

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.

Step 6 - Mapping

Primary key: Select the unique identifier fields to match your record between your source and destination. (This is usually the email)

Map the column from your data model to the property in Klayvio. If the property does not exist in Klayvio yet then you can create it from within Weld.