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

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

Send data to Klaviyo

Sync data from any data source to Klaviyo, with the Weld Reverse ETL, for powerful data enrichment. Easy setup fully managed data pipeline to Klaviyo in minutes with no coding required.

View more about the Klaviyo integration in the Weld documentation

Klaviyo is a powerful email marketing platform tailored for e-commerce businesses, allowing them to create personalized, multi-channel campaigns.

Beyond just email, Klaviyo integrates with a wide array of platforms and offers segmentation, analytics, and automation features. Here are a combination of analytics-focused and reverse ETL use-cases for Klaviyo:

Analytics (ETL) Use-Cases:

Campaign Performance Analysis: By pulling data on open rates, click-through rates, and conversion metrics from Klaviyo, brands can measure the efficacy of their email campaigns and adjust strategies accordingly.
Segmentation Analysis: Klaviyo's detailed segmentation capabilities mean businesses can analyze the performance of specific customer segments, understanding which demographics or behaviors yield the highest engagement or purchase rates.
Customer Lifetime Value (CLV) Estimation: Integrating purchase history and engagement metrics from Klaviyo can help businesses calculate CLV, identifying their most valuable customers and informing retention strategies.
A/B Testing Insights: Klaviyo allows for A/B testing of email campaigns. Analyzing these results helps businesses refine their email content, design, and delivery times for optimal performance.

Reverse ETL Use-Cases:

Personalized Product Recommendations: By pushing product interaction data from a Destination into Klaviyo, brands can craft highly personalized product recommendation emails based on individual customer behaviors.
Syncing Customer Segments: Based on analytics done outside of Klaviyo, businesses can update and refine customer segments within Klaviyo, ensuring email campaigns are precisely targeted.
Automated Behavioral Triggers: Insights derived from external analytics platforms can be sent to Klaviyo to automate email triggers. For instance, if a customer shows interest in a category on a website but doesn't purchase, this data can prompt a targeted email campaign.
Feedback Integration: Survey responses or feedback collected from other platforms can be pushed into Klaviyo, allowing for follow-up emails or tailored campaigns based on customer feedback.

By integrating Klaviyo with both ETL and reverse ETL processes, eCommerce businesses can achieve a highly personalized marketing approach, driving customer engagement, loyalty, and conversions.

Start working with your Klaviyo data today

Get started building your data warehouse with Klaviyo and 150+ more apps and database connectors available.

Get started for free