Setup and Schema information for Klaviyo V3
Setup and Schema information for Klaviyo V3
Setup Instructions for Klaviyo V3
1. Log in to your Daton account and search for Klaviyo V3 in the list of Connectors, then click Configure.
2. Enter the following details and click Authenticate:
- Integration Name
- Replication Frequency
- Replication Start Date
-
Lookback window for attribution events
- This sets how many hours Daton must look back for events such as placed_order or unsubscribed_from_email_marketing. These events can take hours to update on Klaviyo’s servers. We suggest 6 hours, but you may set your own value.
- All other events use a default 1-hour lookback to avoid missing late updates.
-
Lookback window for Flow reports
- This sets how many days Daton must look back to refresh Flow report data. we suggest 30 days.
-
Timeframe for Campaign reports
- Choose the time ranges you want Daton to pull for your Klaviyo campaign reports.
-
Advanced Configuration
- You can decide the loading behavior whether you want to Upsert or Append and unnesting configuration.
- You can also disable automatic column detection for events table if you think all your required columns are loaded.
3. Provide the Klaviyo API Key and click authenticate. Check out our article: Klaviyo: Authentication Credentials to learn how to generate your API Key.
4. After successful authentication, you can choose from the list of available tables. Select the required tables and click Next
5. Select the required fields for each table and click Next
Metrics selection for ‘events’ table
If you have chosen the ‘events’ table from the previous step, then you will find an additional step for selecting the required metrics. Please select only required metrics that are needed for your analysis to reduce unnecessary loading of all events.
6. Select the destination and click Confirm.
An integration successful message will be displayed.
Schema information of Klaviyo V3 tables
Please refer to the Google Sheets to understand the columns we will pull for each table - Klaviyo Column Reference.
Table |
Primary Key(s) |
Is Full Replication? |
Incremental key/filter |
|---|---|---|---|
templates |
id |
No |
updated |
campaigns |
id |
No |
updated |
campaign_messages |
id |
No |
updated |
flows |
id |
No |
updated |
flow_actions |
id |
No |
updated |
flow_messages |
id |
Yes |
updated (full-load available) |
profiles |
id |
No |
updated |
lists_by_profile |
id, profile_id |
No |
updated |
segments_by_profile |
id, profile_id |
No |
updated |
metrics |
id |
No |
updated |
lists |
id |
No |
updated |
profiles_by_list |
id, list_id |
Yes |
updated |
segments |
id |
No |
updated |
profiles_by_segment |
id, segment_id |
Yes |
updated |
Metric-specific events (placed_order, opened_email, etc.,) |
id |
No |
datetime |
events |
id |
No |
datetime |
campaign_report_summary |
campaign_id, campaign_message_id, metric_id, timeframe |
Yes |
Snapshot report based on timeframe chosen |
flow_report_daily |
flow_id, flow_message_id, metric_id, start_date, end_date |
No |
report start/end dates |