Klaviyo

Klaviyo ETL connector for data replication

Snapshot

Features	Details
Features	Details
Release Status	Released
Source API Version	v2
Table Selection	Yes
Column Selection	Yes
Edit Integration	Yes
Replication Type Selection	No
Authentication Parameters	Klaviyo Private Key
Replication Type	Key Based Incremental
Replication Key	Date
Suggested Replication Frequency

Tables/APIs Supported
Metrics	EventsTimeline
Campaigns	Lists
EmailTemplates

Integrate Klaviyo with Daton

1. Signin to Daton

2. Select Klaviyo from Integrations page

3. Provide Integration Name, Replication Frequency, and History. Integration name would be used in creating tables for the integration and cannot be changed later

4. Provide Klaviyo Private Key. Follow the section below for instructions.

5. Post successful authentication, you will be prompted to choose from the list of available tables

6. Then select all required fields for each table

7. Submit the integration

How to get the Klaviyo API Key?

Step 1 - Click on the profile section and navigate to Account Settings

Step 2 - Click on the API Keys tab and create a new API key for Daton

Copy the API key and enter it in the Daton configuration screen

Workflow

1. Integrations would be in Pending state initially and will be moved to Active state as soon as the first job loads data successfully on to the configured warehouse

2. Users would be able to edit/pause/re-activate/delete integration anytime

3. Users can view job status and process logs from the integration details page by clicking on the integration name from the active list

Klaviyo Data

Metrics

Purpose: The Metrics API is used for historical event data in Klaviyo. Returns a list of all the metrics in Klaviyo.

Source API Documentation https://www.klaviyo.com/docs/api/metrics

Replication: Key-Based Replication

Replication Key: created

Fields

Name	Target Datatype
updated	STRING
name	STRING
created	STRING
object	STRING
id	STRING
integration	RECORD

EventsTimeline

Purpose: Returns a batched timeline of all events in your Klaviyo account. Each event object contains information about what metric the event tracks, which person the event is related to, and any extra properties about the event.

Source API Documentation https://www.klaviyo.com/docs/api/metrics

Replication: Key-Based Replication

Replication Key: created

Fields

Name	Target Datatype
uuid	STRING
event_name	STRING
timestamp	NUMERIC
object	STRING
datetime	STRING
statistic_id	STRING
id	STRING
person	RECORD
event_properties	RECORD

Campaigns

Purpose: Returns a list of all the campaigns you've created. Each entry is a separate Campaign object.

Source API Documentation https://www.klaviyo.com/docs/api/campaigns

Replication: Key-Based Replication

Replication Key: created

Fields

Name	Target Datatype

status STRING updated STRING from_name STRING status_id NUMERIC object STRING num_recipients NUMERIC is_segmented BOOLEAN id STRING sent_at STRING campaign_type STRING name STRING created STRING status_label STRING from_email STRING subject STRING template_id STRING lists RECORD excluded_lists RECORD

Lists

Purpose: Get a listing of all of the lists (memberships and subscriptions) in an account.

Source API Documentation https://www.klaviyo.com/docs/api/v2/lists

Replication: Key-Based Replication

Replication Key: created

Fields

Name	Target Datatype
list_name	STRING
list_id	STRING

EmailTemplates

Purpose: Returns a list of all the campaigns you've created. Each entry is a separate Campaign object.

Source API Documentation https://www.klaviyo.com/docs/api/email-templates

Replication: Key-Based Replication

Replication Key: created

Fields

Name	Target Datatype
is_writeable	BOOLEAN
updated	STRING
name	STRING
created	STRING
id	STRING