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 nameSupported
Column HashingTrueField level
BlockingTrueField level
IncrementalTrue
Custom dataFalse
HistoryFalse
ReSyncTrueTable level
TemplatesFalse

Data Schema

T
- Table
S
- Sub table

🔧 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)
  • bulk (upsert)

Setup Instructions

Prerequisites: 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 1 - Destination

  1. Click on the Reverse ETL item in the sidebar to navigate to the page.
  2. 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.
  3. 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`.

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.

Was this page helpful?