Klaviyo Connector
Klaviyo is a powerful email marketing platform tailored for e-commerce businesses, allowing them to create personalized, multi-channel campaigns.
KlaviyoYour warehouseLive
Agent context over MCPSet up in minutes.
No code, no maintenance.
Klaviyo
Data source
Klaviyo in your warehouse.
Ready for your agents.
Klaviyo is a powerful email marketing platform tailored for e-commerce businesses, allowing them to create personalized, multi-channel campaigns. Weld's Klaviyo connector is fully managed: it extracts data from Klaviyo, loads it into your warehouse, and keeps it in sync. The data lands in a clean, documented schema with agent context attached, so analysts can query it with SQL or dbt, and agents can query it over the Weld MCP server without guessing at tables or joins.
Klaviyo data schema.
The map your agents read.
Every table, field and relationship Weld syncs from Klaviyo is served to agents as context over MCP, so they pick the right tables and join on the right keys.
- tables
- 13
- fields
- 122
- relationships
- 8
Klaviyo models.
What the numbers mean.
Open-source SQL that turns the raw Klaviyo tables into the reports people ask about. Deploy them in Weld and your agent queries the definitions, not guesses.
- Monthly User Engagement per CampaignCalculates 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 ListGenerates 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 send time. The results are grouped by campaign month and list name, and ordered in descending order of the campaign month.
- Monthly Flow EventsGenerates 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, total events triggered, and distinct persons triggered, ordered by month and flow name.
- Email EventsRetrieves 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 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, order IDs, flow names, flow statuses, campaign names, and campaign send times. The final result is sorted in descending order based on the event timestamps.
Ask your agent.
It already knows Klaviyo.
Connect Claude, Cursor, ChatGPT or your own agent to Weld over MCP. It reads the Klaviyo context, finds the tables it needs and queries your warehouse.
- Agent contextKlaviyo tables, fields and joins
- QuerySQL against your warehouse
- OperateCheck, rerun and refresh syncs
How many event rows do we have per profile? Use our Klaviyo data.
Reading the Klaviyo context first, so the query uses the right tables and keys.
Load Klaviyo into any warehouse.
Set up in minutes, no code.
Everything you need.
To get started.
Klaviyo setup guide
Step-by-step instructions to configure and start syncing.
MCP serverConnect your agents
Set up Claude, Cursor, ChatGPT or Codex against your Weld workspace.
Weld Connect APIBuild custom connectors
Use the Weld Connect API to build and publish your own connector.
FAQCommon questions
Answers to frequently asked questions about Weld connectors.
Set it up in code.
One REST API.
Use the Weld Connect REST API to create Klaviyo connections, configure ELT syncs, and manage pipelines entirely through code. Built for embedding, automation, and CI/CD workflows.
▌Common questions.
About connectors.
Put your Klaviyo data to work.
Connect Klaviyo, pick a warehouse, and your agents can query it today. Free for 14 days, no credit card.
Source
