LupyAi

Klaviyo — data fields

Email activity, attributed campaign revenue and store orders from Klaviyo. Every field id you can pass to fields= in the API, Looker Studio, exports and AI chats. Shared ids line up across sources so they blend.

All sources Meta Ads (Facebook & Instagram)Google AdsTikTok AdsLinkedIn AdsGoogle Analytics 4Google Search ConsoleFacebook Pages (organic)Instagram (organic)YouTube AnalyticsShopifyWooCommerceKlaviyo
Field idNameSectionKindTypeDescription
account_id Account ID dimension string
account_name Account name dimension string
bounced Bounced metric integer
campaign Campaign name dimension string
campaign_id Campaign ID dimension string
click_rate Click rate (%) metric percent
clicks_unique Unique clicks metric integer
conversion_value Attributed revenue metric currency
conversions Attributed conversions metric float
datasource Data source dimension string Connector the row came from
date Date dimension date Daily metrics only (not with campaign fields)
delivered Delivered metric integer
emails_clicked Emails clicked metric integer
emails_opened Emails opened metric integer
emails_received Emails received metric integer
open_rate Open rate (%) metric percent
opens_unique Unique opens metric integer
orders Placed orders metric integer
recipients Recipients metric integer
revenue Placed order revenue metric currency All placed orders (not attribution)
send_channel Channel (email/sms) dimension string
unsubscribes Unsubscribes metric integer

Date parts

Available on any source with date. Metrics are re-aggregated to the period.

weekWeek (starting Monday)year_weekYear-week (2026-W42)monthMonth (2026-10)quarterQuarter (2026-Q4)yearYearday_of_weekDay of week (Mon..Sun)

Calculated metrics

Computed after aggregation wherever the inputs exist.

roasrevenue / nullif(spend, 0)cpaspend / nullif(conversions, 0)conversion_rateconversions / nullif(clicks, 0) * 100aovrevenue / nullif(orders, 0)

Filters

Pass JSON in filters=:

[["spend","gt",100],"and",
 ["campaign","contains","brand"]]

Operators: eq, neq, gt, gte, lt, lte, contains, ncontains, null, notnull, in.