Klaviyo Connector

Start moving your Klaviyo data with fully managed data pipelines. Get clean normalized data ready for analytics, easy to setup and analyze with AI in minutes.

View more about the Klaviyo connector in the Weld documentation

campaign

string

11 more klaviyo tables

Explore available Klaviyo data

Browse all the data tables available for the Klaviyo connector, in our interactive ERD data viewer.

View the Klaviyo Data Schema

Transform and model Klaviyo data

Get clean data models from your Klaviyo data. Weld makes it easy to transform and model with the powerful built in SQL editor and AI Assistant.

Klaviyo

raw.klaviyo.table1

raw.klaviyo.table2

Get started with Klaviyo SQL Templates

Get inspiration on how to model your data, with our collection of foundational SQL templates we have battle-tested at Weld. All the templates work out of the gate with the Weld data integrations for Klaviyo.

Monthly User Engagement per Campaign

Calculates the monthly user engagement per campaign using data from Klaviyo integration. It extracts the year, month, campaign ID, event name, and counts the number of unique persons for specific events. It then aggregates the counts for each event type and campaign, grouping them by year, month, campaign ID, and campaign name. The final result is ordered by year, month, and campaign name.

Monthly Campaign Status Breakdown by List

Generates a monthly breakdown of campaign status for a specific integration with Klaviyo. It retrieves the number of campaigns, the number of campaigns sent, the number of campaigns in draft and scheduled status, as well as other campaign statuses if needed. Additionally, it includes the list name, the number of lists used, and the last sent date. The results are grouped by campaign month, list name, and template name, and ordered in descending order of the campaign month.

Monthly Flow Events

Generates a report of monthly flow events from the Klaviyo integration. It calculates the total number of events triggered and the number of distinct persons triggered for each flow in a given month. The result includes the month, flow ID, flow name, flow status, trigger type, trigger filter, customer filter, total events triggered, and distinct persons triggered, ordered by month and flow name.

Email Events

Retrieves various event details from the Klaviyo integration, including the event ID, timestamp, event name, custom properties, Klaviyo properties, UUID, person ID, metric ID, campaign ID, flow ID, flow, attributed event ID, message ID, send cohort, send timestamp, and order ID (if the event name is "Placed Order"). The results are ordered by the event timestamp in descending order.

Events Flow Campaign Report

Retrieves data from the Klaviyo integration to generate an Events Flow Campaign Report. It combines information from the events, campaign, and flow tables to provide details such as event timestamps, event names, custom properties, Klaviyo properties, metric IDs, campaign IDs, person IDs, flow IDs, attributed event IDs, message IDs, send cohorts, send timestamps, order IDs, flow names, flow statuses, campaign subjects, and campaign sent timestamps. The final result is sorted in descending order based on the event timestamps.

View all Klaviyo templates