Skip to content
sandadocs
Console Start free trial

Klaviyo

Connect Klaviyo to sanda: what to prepare, the fields the connection form asks for, and how its data lands in your warehouse.

View as Markdown

Connect Klaviyo

  1. Open the catalogue. In the console, go to Data · Connections and press New connection.
  2. Choose Klaviyo. It is listed under marketing and analytics; you can also search for it by name.
  3. Fill in the form. Enter the fields below. Credentials go straight to sanda’s sync engine and are never stored in sanda’s database.
  4. Choose what to sync. Pick the streams you want, and a sync mode for each. See choose what to sync.
  5. Run the first sync. sanda tests the connection, then lands each stream as a table in your warehouse.

Configuration fields

What the connection form asks for. Required fields are marked; the rest are optional.

Field Type Required Description
Api Key string, secret Yes Klaviyo API Key.
Start Date string No UTC date and time in the format 2017-01-25T00:00:00Z. Any data before this date will not be replicated. This field is optional. If not provided, becca will replicate the data for the last year. The metrics stream is not affected by this field and always syncs all metric definitions.
Disable Fetching Predictive Analytics boolean No Certain streams like the profiles stream can retrieve predictive analytics data from Klaviyo's API. However, at high volume, this can lead to service availability issues on the API which can be improved by not fetching this field. Warning: Enabling this setting will stop the "predictive_analytics" column from being populated in your downstream destination.
Number of concurrent threads integer No The number of worker threads to use for the sync. The performance upper boundary is based on the limit of your Klaviyo plan. Default 10.
Lookback Window (Days) integer No The number of days to look back when syncing data in incremental mode. This helps capture any late-arriving data. Only applies to the events_detailed stream. For the flow_series_reports stream, use Reporting Lookback Window instead. Default 0.
Reporting Lookback Window (Days) integer No Re-syncs the last N days of the flow_series_reports stream on every incremental run. Klaviyo keeps updating conversion attribution after a send (by default for up to 5 days, and up to 90 days if you raise the attribution window in your account settings), so the numbers first reported for a day keep changing for a while. Set this to at least your attribution window to pick those revisions up. Because flow_series_reports rows are keyed by the calendar day they report on, a destination that deduplicates on the primary key replaces the row previously written for a re-synced day, while in append mode each re-synced day adds an extra row per sync. This does not apply to campaign_values_reports: that endpoint returns a single aggregate for the whole requested period instead of a per-day breakdown, so a re-read cannot replace anything and would only add double-counted rows. Defaults to 0 (no re-sync). Default 0.
Report Stream Conversion Metric IDs string No Comma-separated list of specific metric IDs to use for flow_series_reports and campaign_values_reports streams. If left empty, the connector will automatically fetch reports for ALL available metrics in your account. Due to Klaviyo's strict API rate limits, syncing all metrics can be extremely slow and may take hours to complete. Recommended: Specify only the conversion metrics you need (e.g., "RESQ6t" for Placed Order) to avoid slow syncs. Find metric IDs in your Klaviyo account under Analytics · Metrics, or use the metrics stream to list all available metrics and their IDs.
Event Stream Metric IDs string No Comma-separated list of Klaviyo metric IDs to filter the events and events_detailed streams. If left empty, events for ALL metrics will be synced. Specify only the metrics you need to significantly reduce sync volume and duration. Note: Klaviyo does not support filtering by custom metrics. Only built-in metrics can be filtered. Find metric IDs in your Klaviyo account under Analytics · Metrics, or use the metrics stream to list all available metrics and their IDs.

Something unclear or out of date? Tell us, and we will fix the page.