Home / Connectors / Klaviyo
Connector

Klaviyo connector: datasets and metric definitionsBeta

Bring in email and SMS revenue by day, campaign and flow results, and list growth. Updates daily.

4 datasets13 metric definitionsRead-onlyRefreshes daily

When you connect Klaviyo, Quiriz imports the datasets below and adds the metric definitions to Company Context, the one place your company’s definitions live. Every answer that uses one of these metrics uses the same definition, in the app, in Slack and in the Excel, Sheets, PowerPoint, Slides, Word and Docs add-ins. An admin can edit any of them.

DatasetsMetric definitionsWorks withQuestionsFAQ

Datasets

DatasetWhat it holds
[Klaviyo] Attributed revenue by dayOrders and revenue per day, split by the channel Klaviyo attributes them to (email, sms, or other for orders it does not attribute), from the Placed Order metric. Days are in the account time zone; amounts are in the account currency. Summed over all channels this is the store revenue Klaviyo sees, so the attributed share is a ratio.
5 columnsdate, month, channel, orders, revenue
[Klaviyo] Audience activity by dayList events per day: subscribes, unsubscribes, spam complaints and bounces. These are events, not list size: net growth is subscribed minus unsubscribed. A column is 0 when the account has no such Klaviyo metric.
6 columnsdate, month, subscribed, unsubscribed, spam_complaints, bounced
[Klaviyo] CampaignsOne row per email or SMS campaign sent in the last 12 months, with unique opens and clicks and the orders and revenue Klaviyo attributes to it. Events are counted only inside the 12-month window, so a campaign sent just before it shows a partial total. Apple Mail privacy pre-opens inflate opens: compare campaigns by clicks and revenue first. For any period use sums of the counts; click rate = sum(clicks) / sum(recipients).
14 columnscampaign_id, campaign_name, channel, send_date, month, recipients, delivered, opens, clicks, unsubscribes, bounced, spam_complaints, orders, revenue
[Klaviyo] Flows by monthOne row per automated flow, channel and month for the last 12 months: recipients, unique opens and clicks, unsubscribes, bounces and the orders and revenue Klaviyo attributes to the flow. Months with no activity are left out. Per-step message results are not read.
13 columnsmonth, flow_id, flow_name, channel, recipients, delivered, opens, clicks, unsubscribes, bounced, spam_complaints, orders, revenue

Metric definitions

Each metric is a total over the period you ask about. A metric built from other metrics, such as a rate, divides the totals for the whole period; it does not average daily rates. Dated by is the date column that decides which period a row belongs to.

[Klaviyo] Attributed revenue by day

MetricHow it is calculatedDated byNotes
Klaviyo revenueSum of revenue, where channel <> 'other'dateOrder revenue Klaviyo attributes to its emails and texts (email and SMS), by order date, in the account currency.
Klaviyo email revenueSum of revenue, where channel = 'email'dateOrder revenue Klaviyo attributes to email, by order date.
Klaviyo SMS revenueSum of revenue, where channel = 'sms'dateOrder revenue Klaviyo attributes to SMS, by order date.
Klaviyo store revenueSum of revenuedateAll order revenue Klaviyo saw, attributed or not, by order date.
Klaviyo attributed shareKlaviyo revenue ÷ Klaviyo store revenuedateShare of order revenue Klaviyo attributes to email and SMS, as a decimal (0.25 = 25%).

[Klaviyo] Audience activity by day

MetricHow it is calculatedDated byNotes
Klaviyo subscribesSum of subscribeddateNew subscriptions to any list, by day.
Klaviyo unsubscribesSum of unsubscribeddateUnsubscribes, by day.

[Klaviyo] Campaigns

MetricHow it is calculatedDated byNotes
Klaviyo campaign revenueSum of revenuesend_dateRevenue attributed to each campaign, by send date.
Klaviyo campaign recipientsSum of recipientssend_dateRecipients of each campaign, by send date.
Klaviyo campaign clicksSum of clickssend_dateUnique clicks on each campaign, by send date.
Klaviyo click rateKlaviyo campaign clicks ÷ Klaviyo campaign recipientssend_dateUnique clicks per recipient, as a decimal (0.02 = 2%).
Klaviyo revenue per recipientKlaviyo campaign revenue ÷ Klaviyo campaign recipientssend_dateCampaign revenue per recipient, in the account currency.

[Klaviyo] Flows by month

MetricHow it is calculatedDated byNotes
Klaviyo flow revenueSum of revenuemonthRevenue attributed to automated flows, by month.

Works with other connectors

Questions to ask

Ask Klaviyo in plain words

Try the questions on sample data with no signup, then connect Klaviyo read-only and ask your own.

Try Quiriz free →

Frequently asked questions

Does Quiriz change anything in Klaviyo?
No. The Klaviyo connector is read-only. Quiriz reads the data into datasets and never writes back to Klaviyo.
How often does the Klaviyo data refresh?
Once a day. Each dataset shows when it was last updated, and answers use the latest refresh.
Can I change how a metric is calculated?
Yes. The definitions are added to Company Context, where an admin can edit the formula, the filter or the date it uses. A daily refresh never overwrites a definition someone has changed.
Can I combine Klaviyo with other sources?
Yes. An admin can also define a metric from metrics on different datasets. See cross-source metrics.

All connectors: Quiriz connectors. Definitions on this page are generated from the product’s own connector code.