Klaviyo V2
Klaviyo ETL connector for data replication
Features | Details |
---|---|
Release Status | Released |
Source API Version | v2022-10-17 |
Table Selection | Yes |
Column Selection | Yes |
Edit Integration | Yes |
Replication Type Selection | No |
Authentication Parameters | Klaviyo API Key |
Replication Type | Full Replication
Key Based Incremental |
Replication Key | Date Time |
Suggested Replication Frequency | 1 hour |
Metrics | Lists |
Segments | Profiles |
Flows | Flow Actions |
Flow Messages | Templates |
Active On Site | Bounced Email |
Cancelled Order | Clicked SMS |
Clicked Email | Consented To Receive SMS |
Dropped Email | Failed To Deliver Automated Response SMS |
Failed To Deliver SMS | Marked Email As Spam |
Merged Profile | Opened Email |
Opened Push | Placed Order |
Received Automated Response SMS | Received Email |
Received Push | Received SMS |
Refunded Order | Sent SMS |
Subscribed To Back In Stock | Subscribed To List |
Unsubscribed | Unsubscribed From List |
Unsubscribed From SMS | Updated Email Preferences |
- 1.Sign in to Daton
- 2.Select Klaviyo V2 from the list of Integrations
- 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.
- 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
- 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
Purpose: This API is used to fetch all metrics in the account
Replication: Full Replication
Replication Key: NA
Fields
Name | Data Type |
---|---|
type | STRING |
id | STRING |
attributes | RECORD |
links | RECORD |
Purpose: This API is used to fetch all lists in the account
Replication: Full Replication
Replication Key: NA
Fields
Name | Data Type |
---|---|
type | STRING |
id | STRING |
attributes | RECORD |
links | RECORD |
Purpose: This API is used to fetch all segments in the account
Replication: Full Replication
Replication Key: NA
Fields
Name | Data Type |
---|---|
type | STRING |
id | STRING |
attributes | RECORD |
links | RECORD |
Purpose: This API is used to fetch all profiles in the account
Replication: Full Replication
Replication Key: NA
Fields
Name | Data Type |
---|---|
type | STRING |
id | STRING |
attributes | RECORD |
links | RECORD |
Purpose: This API is used to fetch all flows
Replication: Full Replication
Replication Key: NA
Fields
Name | Data Type |
---|---|
type | STRING |
id | STRING |
attributes | RECORD |
links | RECORD |
Purpose: This API is used to fetch all flow actions for the flows
Replication: Full Replication
Replication Key: NA
Fields
Name | Data Type |
---|---|
type | STRING |
id | STRING |
attributes | RECORD |
links | RECORD |
Purpose: This API is used to fetch all flow messages for the flow actions
Replication: Full Replication
Replication Key: NA
Fields
Name | Data Type |
---|---|
type | STRING |
id | STRING |
attributes | RECORD |
links | RECORD |
Purpose: This API is used to fetch all templates in the account
Replication: Key Based Incremental
Replication Key: greater-or-equal, less-or-equal
Fields
Name | Data Type |
---|---|
type | STRING |
id | STRING |
attributes | RECORD |
links | RECORD |
Purpose: This API is used to fetch all events of Active On Site metric
Replication: Key Based Incremental
Replication Key: greater-or-equal, less-or-equal
Fields
Name | Data Type |
---|---|
type | STRING |
id | STRING |
attributes | RECORD |
links | RECORD |
Purpose: This API is used to fetch all events of Bounced Email metric
Replication: Key Based Incremental
Replication Key: greater-or-equal, less-or-equal
Fields
Name | Data Type |
---|---|
type | STRING |
id | STRING |
attributes | RECORD |
links | RECORD |
Purpose: This API is used to fetch all events of Cancelled Order metric of Shopify
Replication: Key Based Incremental
Replication Key: greater-or-equal, less-or-equal
Fields
Name | Data Type |
---|---|
type | STRING |
id | STRING |
attributes | RECORD |
links | RECORD |
Purpose: This API is used to fetch all events of Clicked SMS metric
Replication: Key Based Incremental
Replication Key: greater-or-equal, less-or-equal
Fields
Name | Data Type |
---|---|
type | STRING |
id | STRING |
attributes | RECORD |
links | RECORD |
Purpose: This API is used to fetch all events of Clicked Email metric
Replication: Key Based Incremental
Replication Key: greater-or-equal, less-or-equal
Fields
Name | Data Type |
---|---|
type | STRING |
id | STRING |
attributes | RECORD |
links | RECORD |
Purpose: This API is used to fetch all events of Consented To Receive SMS metric
Replication: Key Based Incremental
Replication Key: greater-or-equal, less-or-equal
Fields
Name | Data Type |
---|---|
type | STRING |
id | STRING |
attributes | RECORD |
links | RECORD |
Purpose: This API is used to fetch all events of Dropped Email metric
Replication: Key Based Incremental
Replication Key: greater-or-equal, less-or-equal
Fields
Name | Data Type |
---|---|
type | STRING |
id | STRING |
attributes | RECORD |
links | RECORD |
Purpose: This API is used to fetch all events of Failed To Deliver Automated Response SMS metric
Replication: Key Based Incremental
Replication Key: greater-or-equal, less-or-equal
Fields
Name | Data Type |
---|---|
type | STRING |
id | STRING |
attributes | RECORD |
links | RECORD |
Purpose: This API is used to fetch all events of Failed To Deliver SMS metric
Replication: Key Based Incremental
Replication Key: greater-or-equal, less-or-equal
Fields
Name | Data Type |
---|---|
type | STRING |
id | STRING |
attributes | RECORD |
links | RECORD |
Purpose: This API is used to fetch all events of Marked Email As Spam metric
Replication: Key Based Incremental
Replication Key: greater-or-equal, less-or-equal
Fields
Name | Data Type |
---|---|
type | STRING |
id | STRING |
attributes | RECORD |
links | RECORD |
Purpose: This API is used to fetch all events of Merged Profile metric
Replication: Key Based Incremental
Replication Key: greater-or-equal, less-or-equal
Fields
Name | Data Type |
---|---|
type | STRING |
id | STRING |
attributes | RECORD |
links | RECORD |
Purpose: This API is used to fetch all events of Opened Email metric
Replication: Key Based Incremental
Replication Key: greater-or-equal, less-or-equal
Fields
Name | Data Type |
---|---|
type | STRING |
id | STRING |
attributes | RECORD |
links | RECORD |
Purpose: This API is used to fetch all events of Opened Push metric
Replication: Key Based Incremental
Replication Key: greater-or-equal, less-or-equal
Fields
Name | Data Type |
---|---|
type | STRING |
id | STRING |
attributes | RECORD |
links | RECORD |
Purpose: This API is used to fetch all events of Placed Order metric of Shopify
Replication: Key Based Incremental
Replication Key: greater-or-equal, less-or-equal
Fields
Name | Data Type |
---|---|
type | STRING |
id | STRING |
attributes | RECORD |
links | RECORD |
Purpose: This API is used to fetch all events of Received Automated Response SMS metric
Replication: Key Based Incremental
Replication Key: greater-or-equal, less-or-equal
Fields
Name | Data Type |
---|---|
type | STRING |
id | STRING |
attributes | RECORD |
links | RECORD |
Purpose: This API is used to fetch all events of Received Email metric
Replication: Key Based Incremental
Replication Key: greater-or-equal, less-or-equal
Fields
Name | Data Type |
---|---|
type | STRING |
id | STRING |
attributes | RECORD |
links | RECORD |
Purpose: This API is used to fetch all events of Received Push metric
Replication: Key Based Incremental
Replication Key: greater-or-equal, less-or-equal
Fields
Name | Data Type |
---|---|
type | STRING |
id | STRING |
attributes | RECORD |
links | RECORD |
Purpose: This API is used to fetch all events of Received SMS metric
Replication: Key Based Incremental
Replication Key: greater-or-equal, less-or-equal
Fields
Name | Data Type |
---|---|
type | STRING |
id | STRING |
attributes | RECORD |
links | RECORD |
Purpose: This API is used to fetch all events of Refunded Order metric of Shopify
Replication: Key Based Incremental
Replication Key: greater-or-equal, less-or-equal
Fields
Name | Data Type |
---|---|
type | STRING |
id | STRING |
attributes | RECORD |
links | RECORD |
Purpose: This API is used to fetch all events of Sent SMS metric
Replication: Key Based Incremental
Replication Key: greater-or-equal, less-or-equal
Fields
Name | Data Type |
---|---|
type | STRING |
id | STRING |
attributes | RECORD |
links | RECORD |
Purpose: This API is used to fetch all events of Subscribed To Back In Stock metric
Replication: Key Based Incremental
Replication Key: greater-or-equal, less-or-equal
Fields
Name | Data Type |
---|---|
type | STRING |
id | STRING |
attributes | RECORD |
links | RECORD |
Purpose: This API is used to fetch all events of Subscribed To List metric
Replication: Key Based Incremental
Replication Key: greater-or-equal, less-or-equal
Fields
Name | Data Type |
---|---|
type | STRING |
id | STRING |
attributes | RECORD |
links | RECORD |
Purpose: This API is used to fetch all events of Unsubscribed metric
Replication: Key Based Incremental
Replication Key: greater-or-equal, less-or-equal
Fields
Name | Data Type |
---|---|
type | STRING |
id | STRING |
attributes | RECORD |
links | RECORD |
Purpose: This API is used to fetch all events of Unsubscribed From List metric
Replication: Key Based Incremental
Replication Key: greater-or-equal, less-or-equal
Fields
Name | Data Type |
---|---|
type | STRING |
id | STRING |
attributes | RECORD |
links | RECORD |
Purpose: This API is used to fetch all events of Unsubscribed From SMS metric
Replication: Key Based Incremental
Replication Key: greater-or-equal, less-or-equal
Fields
Name | Data Type |
---|---|
type | STRING |
id | STRING |
attributes | RECORD |