Knowi has a native Klaviyo integration that connects with your private API key. Once connected, you can pull profiles, events, campaigns, lists, flows, and metrics from your Klaviyo account and build dashboards directly in Knowi without any manual exports.
Quick Summary (TL;DR)
- Knowi connects natively to Klaviyo using a private API key starting with
pk_. Keys do not expire unless manually revoked. - Seven pre-built collections are available: Profiles, Events, Lists, Campaigns, Metrics, Flows, and Custom Endpoint.
- Required permissions: read access to the scopes you want to pull (Profiles, Events, Lists, Campaigns, Metrics, Flows).
- Klaviyo API responses use a JSON:API nested format. Knowi uses Cloud9QL’s
expand()function to flatten responses into tabular rows. - Rate limits vary by endpoint: Profiles (75/s burst, 700/min steady), Events (350/s burst), Campaigns (10/s burst, 150/min steady). Knowi handles retries automatically.
- Klaviyo data can be joined natively with Shopify, PostgreSQL, Google Analytics, and 30-plus other sources in Knowi.
Table of Contents
How to Connect Klaviyo to Knowi
The Klaviyo connector is available natively in Knowi. You connect using a private API key generated in your Klaviyo account settings.
- In Klaviyo, go to Account Settings > API Keys and click Create Private API Key.
- Grant read access to the scopes you want to pull: Profiles, Events, Lists, Campaigns, Metrics, Flows.
- Copy the key (starts with
pk_). - In Knowi, go to Queries and select New Data Source.
- Search for Klaviyo in the datasource search.
- Give your datasource a unique name and paste in your private API key.
- Click Save. Your Klaviyo datasource is ready to query.
What Data Can You Pull from Klaviyo?
Once connected, select a collection from the Query Builder, apply filters, and run. All collections support Knowi’s Cloud9QL transformations for flattening and filtering the response.
| Collection | What It Returns | Filters and Options |
|---|---|---|
| Profiles | All contacts: email, first name, last name, phone number, created date, updated date, custom properties | Filter by email (equals(email,"user@example.com")), created date (greater-than(created,2024-01-01T00:00:00Z)). Sort by created, updated, or email. |
| Events | Activity data: opens, clicks, purchases, and custom events with metric ID, profile ID, and datetime | Filter by metric_id, profile_id, or datetime. Sort by datetime or timestamp. |
| Lists | All lists in your Klaviyo account | Default sort: name (ascending) |
| Campaigns | Campaign data across email, SMS, and mobile push | Channel (required): email, SMS, or mobile push. Optional filter by status (equals(status,"Sent")). |
| Metrics | Available event types and metric IDs in your account | Optional integration filter |
| Flows | Automated workflows: welcome series, abandoned cart, post-purchase, and others | Optional filter by status (live, draft, manual). Sort options available. |
| Custom Endpoint | Any Klaviyo API resource not in the pre-built list | Resource path (e.g., segments, tags, catalogs, templates, coupons) |
Technical Details
Rate Limits
- Profiles: 75 requests/second burst, 700 requests/minute steady
- Events: 350 requests/second burst, 3,500 requests/minute steady
- Campaigns: 10 requests/second burst, 150 requests/minute steady
Response Format and Cloud9QL
Klaviyo returns data in JSON:API format with nested structure. Use Cloud9QL’s expand() function to flatten responses into tabular rows. Common transformations:
- Flatten:
select data; select expand(data); - Project fields:
select id, attributes.email from data; - Filter by date:
select * where attributes.created >= '2024-01-01'; - Aggregate:
select attributes.status, count(*) group by attributes.status;
Pagination
Klaviyo uses cursor-based pagination via links.next URLs. Knowi handles pagination automatically so all records are fetched without manual configuration.
How to Build a Klaviyo Dashboard in Knowi
- Select a collection in the Query Builder. Campaigns or Events are common starting points for email performance analysis.
- Apply filters as needed (status, channel, date range).
- Preview your data, give your dataset a name, and run.
- From the Query Overview page, use the AI dashboard builder to generate visualizations automatically.
- Example dashboard from the integration video: attributes count by category, daily count of attributes created, daily count of attributes updated.
- Edit widget types (line chart, stacked area chart) and rearrange the layout after the AI generates the initial dashboard.
- Add the AI Recommendations widget to surface insights and action items automatically.
Watch Video Walkthrough
Frequently Asked Questions
How does Knowi authenticate with Klaviyo?
Knowi uses a private API key starting with pk_. Create it in Klaviyo under Account Settings > API Keys with read access to the scopes you need. Keys do not expire unless you manually revoke them.
What Klaviyo data can I pull into Knowi?
Seven collections: Profiles (contacts and custom properties), Events (opens, clicks, purchases, custom events), Lists, Campaigns (email/SMS/push), Metrics (event types and IDs), Flows (automated workflows), and Custom Endpoint for any other Klaviyo resource.
How do I pull only sent campaigns from Klaviyo?
In the Campaigns collection, set the Channel to email (or SMS/mobile push) and add a filter: equals(status,"Sent"). This returns only campaigns with a Sent status.
Why does Klaviyo data come back nested in Knowi?
Klaviyo uses JSON:API format which nests data under an attributes key. Use Cloud9QL’s select expand(data) transformation to flatten it into rows, then reference fields with dot notation: attributes.email, attributes.created.
Can I join Klaviyo data with Shopify or other sources in Knowi?
Yes. Knowi supports cross-source joins natively. You can combine Klaviyo campaign or event data with Shopify orders, PostgreSQL, Google Analytics, and 30-plus other sources directly in a query without a data warehouse.
What permissions does my Klaviyo API key need?
Read access to the scopes matching the collections you want to pull: Profiles, Events, Lists, Campaigns, Metrics, and Flows. You do not need write permissions.
Ready to connect your Klaviyo account to Knowi? Read the Klaviyo connector documentation to get started, or schedule a demo to see it in action with your marketing data.