Overview
Klaviyo is an email and SMS marketing automation platform used for targeted campaigns, customer segmentation, and marketing analytics. This connector extracts campaign metadata, automation flows, event data, and metric definitions from the Klaviyo API.Configuration
1
Add account access
To connect Klaviyo to Nekt, you need a Private API Key with read access.
2
Select streams
Choose which streams you want to sync. Available streams are listed in the Streams and Fields section below.
3
Configure data streams
For each selected stream, configure:
- Layer: Choose the destination layer (e.g., Bronze).
- Folder: Organize data within the layer.
- Table name: The table name in your lakehouse.
- Sync Type: Incremental (recommended) or Full Sync.
4
Configure data source
Set up the source-level configuration:
- Description: Add a description for this data source.
- Triggers: Configure sync triggers (schedule or manual).
- Delta Log Retention Days: Number of days to retain delta log history.
- Full Sync: Optionally force a full sync on first run.
5
Check your new source
After saving, verify the source appears in your Sources list. Run a manual sync to validate that data flows correctly.
Streams and Fields
campaigns
campaigns
Email campaign metadata including status, audiences, scheduling, and tracking configuration. Supports incremental sync via
updated_at.events
events
Raw event data including email opens, clicks, bounces, purchases, and custom events. Supports incremental sync via
datetime. This is the granular data behind Klaviyo’s reporting, enabling custom aggregations downstream.flows
flows
Automation flow definitions including status and trigger configuration. Supports incremental sync via
updated.metrics
metrics
Metric definitions that describe the types of events tracked in Klaviyo (e.g., “Opened Email”, “Clicked Email”, “Placed Order”). Reference data for joining with events.
Implementation Notes
- Authentication: Uses Klaviyo’s private API key via the
Klaviyo-API-Keyauthorization header. - Rate limits: The Klaviyo API enforces rate limits per endpoint. The connector handles rate limiting automatically with backoff.
- Campaigns filter: The campaigns stream currently syncs email campaigns only. SMS and push campaigns use separate channel filters.
- Events volume: The events stream can produce a high volume of records. Use the Start Date configuration to limit the initial sync window.
- JSON fields: Fields like
audiences,send_strategy,tracking_options,event_properties, andintegrationare serialized as JSON strings for maximum flexibility. Parse them downstream as needed.