Klaviyo Field Reference

Sample

https://connectors.windsor.ai/klaviyo?api_key=[your API key]&date_preset=last_7d&fields=email,first_name,last_name,organization,created&_renderer=csv


Fields

IDTypeNameDescriptionReport
account_idTEXTAccount IDKlaviyo account IDgeneral
address1TEXTAddress Line 1The primary address line of the objectmembers
address2TEXTAddress Line 2The secondary address line of the objectmembers
bounced_emailNUMERICBounced EmailBounced Emailmetrics
bounced_email_rateNUMERICBounced Email RateBounced Email Ratemetrics
campaignTEXTCampaign NameCampaign namecampaigns
campaign_channelTEXTCampaign ChannelCampaign Channelcampaigns
campaign_idTEXTCampaign IDCampaign idcampaigns
campaign_report_average_order_valueNUMERICCampaign report Average Order ValueCampaign report Average Order Valuecampaign-reports
campaign_report_bounce_ratePERCENTCampaign report Bounce RateCampaign report Bounce Ratecampaign-reports
campaign_report_bouncedNUMERICCampaign report BouncedCampaign report Bouncedcampaign-reports
campaign_report_bounced_or_failedNUMERICCampaign report Bounced Or FailedCampaign report Bounced Or Failedcampaign-reports
campaign_report_bounced_or_failed_ratePERCENTCampaign report Bounced Or Failed RateCampaign report Bounced Or Failed Ratecampaign-reports
campaign_report_click_ratePERCENTCampaign report Click RateCampaign report Click Ratecampaign-reports
campaign_report_click_to_open_ratePERCENTCampaign report Click To Open RateCampaign report Click To Open Ratecampaign-reports
campaign_report_clicksNUMERICCampaign report ClicksCampaign report Clickscampaign-reports
campaign_report_clicks_uniqueNUMERICCampaign report Clicks UniqueCampaign report Clicks Uniquecampaign-reports
campaign_report_conversion_metric_active_on_siteTEXTCampaign Report Conversion Metric Active on SiteCampaign Report Conversion Metric Active on Sitecampaign-reports
campaign_report_conversion_metric_bounced_emailTEXTCampaign Report Conversion Metric Bounced EmailCampaign Report Conversion Metric Bounced Emailcampaign-reports
campaign_report_conversion_metric_clicked_emailTEXTCampaign Report Conversion Metric Clicked EmailCampaign Report Conversion Metric Clicked Emailcampaign-reports
campaign_report_conversion_metric_clicked_smsTEXTCampaign Report Conversion Metric Clicked SMSCampaign Report Conversion Metric Clicked SMScampaign-reports
campaign_report_conversion_metric_dropped_emailTEXTCampaign Report Conversion Metric Dropped EmailCampaign Report Conversion Metric Dropped Emailcampaign-reports
campaign_report_conversion_metric_failed_to_deliver_smsTEXTCampaign Report Conversion Metric Failed to Deliver SMSCampaign Report Conversion Metric Failed to Deliver SMScampaign-reports
campaign_report_conversion_metric_marked_email_as_spamTEXTCampaign Report Conversion Metric Marked Email as SpamCampaign Report Conversion Metric Marked Email as Spamcampaign-reports
campaign_report_conversion_metric_opened_emailTEXTCampaign Report Conversion Metric Opened EmailCampaign Report Conversion Metric Opened Emailcampaign-reports
campaign_report_conversion_metric_received_emailTEXTCampaign Report Conversion Metric Received EmailCampaign Report Conversion Metric Received Emailcampaign-reports
campaign_report_conversion_metric_sent_smsTEXTCampaign Report Conversion Metric Sent SMSCampaign Report Conversion Metric Sent SMScampaign-reports
campaign_report_conversion_metric_subscribed_to_listTEXTCampaign Report Conversion Metric Subscribed to ListCampaign Report Conversion Metric Subscribed to Listcampaign-reports
campaign_report_conversion_metric_unsubscribe_page_submitTEXTCampaign Report Conversion Metric Unsubscribe Page SubmitCampaign Report Conversion Metric Unsubscribe Page Submitcampaign-reports
campaign_report_conversion_metric_unsubscribedTEXTCampaign Report Conversion Metric UnsubscribedCampaign Report Conversion Metric Unsubscribedcampaign-reports
campaign_report_conversion_metric_unsubscribed_from_listTEXTCampaign Report Conversion Metric Unsubscribed from ListCampaign Report Conversion Metric Unsubscribed from Listcampaign-reports
campaign_report_conversion_ratePERCENTCampaign report Conversion RateCampaign report Conversion Ratecampaign-reports
campaign_report_conversion_uniquesNUMERICCampaign report Conversion UniquesCampaign report Conversion Uniquescampaign-reports
campaign_report_conversion_valueNUMERICCampaign report Conversion ValueCampaign report Conversion Value. Default conversion metric for this field is Placed Ordercampaign-reports
campaign_report_conversionsNUMERICCampaign report ConversionsCampaign report Conversionscampaign-reports
campaign_report_deliveredNUMERICCampaign report DeliveredCampaign report Deliveredcampaign-reports
campaign_report_delivery_ratePERCENTCampaign report Delivery RateCampaign report Delivery Ratecampaign-reports
campaign_report_failedNUMERICCampaign report FailedCampaign report Failedcampaign-reports
campaign_report_failed_ratePERCENTCampaign report Failed RateCampaign report Failed Ratecampaign-reports
campaign_report_open_ratePERCENTCampaign report Open RateCampaign report Open Ratecampaign-reports
campaign_report_opensNUMERICCampaign report OpensCampaign report Openscampaign-reports
campaign_report_opens_uniqueNUMERICCampaign report Opens UniqueCampaign report Opens Uniquecampaign-reports
campaign_report_recipientsNUMERICCampaign report RecipientsCampaign report Recipientscampaign-reports
campaign_report_revenue_per_recipientNUMERICCampaign report Revenue Per RecipientCampaign report Revenue Per Recipientcampaign-reports
campaign_report_spam_complaint_ratePERCENTCampaign report Spam Complaint RateCampaign report Spam Complaint Ratecampaign-reports
campaign_report_spam_complaintsNUMERICCampaign report Spam ComplaintsCampaign report Spam Complaintscampaign-reports
campaign_report_unsubscribe_ratePERCENTCampaign report Unsubscribe RateCampaign report Unsubscribe Ratecampaign-reports
campaign_report_unsubscribe_uniquesNUMERICCampaign report Unsubscribe UniquesCampaign report Unsubscribe Uniquescampaign-reports
campaign_report_unsubscribesNUMERICCampaign report UnsubscribesCampaign report Unsubscribescampaign-reports
cancelled_orderNUMERICCancelled OrderTotal amount of Cancelled Ordermetrics
cancelled_order_valueNUMERICCancelled Order ValueCancelled Order valuemetrics
checkout_completedNUMERICCheckout CompletedCheckout Completedmetrics
checkout_start_to_order_rateNUMERICCheckout Start to Order RateCompleted checkouts as ratio of checkout startsmetrics
checkout_startedNUMERICCheckout StartedTotal amount of Checkout Startedmetrics
checkout_started_valueNUMERICCheckout Started ValueCheckout Started valuemetrics
cityCITYCityThe city of the objectmembers
click_ratePERCENTClick rateClick rate of e-mailsmetrics
clicksNUMERICClicksNumber of unique e-mail clicksmetrics
conversionsNUMERICConversionsTotal Value of placed ordersmetrics
conversions_avg_valuePERCENTAverage Conversion ValueAverage value of placed ordersmetrics
countryCOUNTRYCountryThe country of the objectmembers
createdTEXTCampaign Created atCampaign creation timecampaigns
created_atDATECreated Date/TimeThe time stamp of the object creationmembers
datasourceTEXTData SourceThe name of the Windsor connector returning the row
dateDATEDateDate of metric type datageneral
day_of_monthTEXTDay of monthDay of the month
dimensionsTEXTFlow dimensionsFlow dimensionsmetrics
emailTEXTEmail addressThe email address of the objectmembers
firstnameTEXTFirst NameThe first name of the objectmembers
flow_archivedTEXTFlow ArchivedFlow Archivedflows
flow_average_order_valueNUMERICFlow Average order valueFlow Average order value. Default conversion metric for this field is Placed Orderflows
flow_bounce_ratePERCENTFlow Bounce rateFlow Bounce rateflows
flow_bouncedNUMERICFlow BouncedFlow Bouncedflows
flow_bounced_or_failedNUMERICFlow Bounced or failedFlow Bounced or failedflows
flow_bounced_or_failed_ratePERCENTFlow Bounced or failed rateFlow Bounced or failed rateflows
flow_click_ratePERCENTFlow Click rateFlow Click rateflows
flow_click_to_open_ratePERCENTFlow Click to open rateFlow Click to open rateflows
flow_clicksNUMERICFlow ClicksFlow Clicksflows
flow_clicks_uniqueNUMERICFlow Clicks uniqueFlow Clicks uniqueflows
flow_conversion_metric_active_on_siteTEXTFlow Conversion Metric Active on SiteActive on Site - to be used for conversion metrics in flows statsflows
flow_conversion_metric_bounced_emailTEXTFlow Conversion Metric Bounced EmailBounced Email - to be used for conversion metrics in flows statsflows
flow_conversion_metric_clicked_emailTEXTFlow Conversion Metric Clicked EmailClicked Email - to be used for conversion metrics in flows statsflows
flow_conversion_metric_clicked_smsTEXTFlow Conversion Metric Clicked SMSClicked SMS - to be used for conversion metrics in flows statsflows
flow_conversion_metric_opened_emailTEXTFlow Conversion Metric Opened EmailOpened Email - to be used for conversion metrics in flows statsflows
flow_conversion_metric_received_smsTEXTFlow Conversion Metric Received SMSReceived SMS - to be used for conversion metrics in flows statsflows
flow_conversion_metric_sent_smsTEXTFlow Conversion Metric Sent SMSSent SMS - to be used for conversion metrics in flows statsflows
flow_conversion_metric_subscribed_to_listTEXTFlow Conversion Metric Subscribed to ListSubscribed to List - to be used for conversion metrics in flows statsflows
flow_conversion_metric_unsubscribedTEXTFlow Conversion Metric UnsubscribedUnsubscribed - to be used for conversion metrics in flows statsflows
flow_conversion_ratePERCENTFlow Conversion rateFlow Conversion rateflows
flow_conversion_uniquesNUMERICFlow Conversion uniquesFlow Conversion uniquesflows
flow_conversion_valueNUMERICFlow Conversion valueFlow Conversion value. Default conversion metric for this field is Placed Orderflows
flow_conversionsNUMERICFlow ConversionsFlow Conversionsflows
flow_created_timeTIMESTAMPFlow Created TimeFlow Created Timeflows
flow_deliveredNUMERICFlow DeliveredFlow Deliveredflows
flow_delivery_ratePERCENTFlow Delivery rateFlow Delivery rateflows
flow_failedNUMERICFlow FailedFlow Failedflows
flow_failed_ratePERCENTFlow Failed rateFlow Failed rateflows
flow_idTEXTFlow IDFlow IDflows
flow_nameTEXTFlow NameFlow Nameflows
flow_open_ratePERCENTFlow Open rateFlow Open rateflows
flow_opensNUMERICFlow OpensFlow Opensflows
flow_opens_uniqueNUMERICFlow Opens uniqueFlow Opens uniqueflows
flow_recipientsNUMERICFlow RecipientsFlow Recipientsflows
flow_revenue_per_recipientNUMERICFlow Revenue per recipientFlow Revenue per recipientflows
flow_spam_complaint_ratePERCENTFlow Spam complaint rateFlow Spam complaint rateflows
flow_spam_complaintsNUMERICFlow Spam complaintsFlow Spam complaintsflows
flow_statusTEXTFlow StatusFlow Statusflows
flow_trigger_typeTEXTFlow Trigger TypeFlow Trigger Typeflows
flow_unsubscribe_ratePERCENTFlow Unsubscribe rateFlow Unsubscribe rateflows
flow_unsubscribe_uniquesNUMERICFlow Unsubscribe uniquesFlow Unsubscribe uniquesflows
flow_unsubscribesNUMERICFlow UnsubscribesFlow Unsubscribesflows
flow_updated_timeTIMESTAMPFlow Updated TimeFlow Updated Timeflows
flow_urlTEXTFlow URLFlow Urlflows
from_emailTEXTFrom E-mailFrom e-mailcampaigns
from_nameTEXTFrom NameFrom namecampaigns
fulfilled_orderNUMERICFulfilled OrderTotal amount of Fulfilled Ordermetrics
fulfilled_order_valueNUMERICFulfilled Order ValueFulfilled Order valuemetrics
fulfilled_partial_orderNUMERICFulfilled Partial OrderTotal amount of Fulfilled Partial Ordermetrics
fulfilled_partial_order_valueNUMERICFulfilled Partial Order ValueFulfilled Order valuemetrics
idTEXTIDThe ID of the objectmembers
lastnameTEXTLast NameThe last name of the objectmembers
latitudeTEXTLatitudeThe latitude of the objectmembers
longitudeTEXTLongitudeThe longitude of the objectmembers
members_countNUMERICMembersTotal number of members in lists for the periodmembers
message_channelTEXTMessage ChannelMessage Channelcampaigns
monthTEXTMonthNumber of the month
objectTEXTObject TypeThe type of the object (e.g. Person)members
open_ratePERCENTOpen rateOpen rate of E-mailsmetrics
opensNUMERICOpensNumber of unique e-mail opensmetrics
ordered_productNUMERICOrdered ProductTotal amount of Ordered productmetrics
ordered_product_avg_valuePERCENTOrdered Product Average ValueOrdered product average valuemetrics
ordered_product_valueNUMERICOrdered Product ValueOrdered product valuemetrics
organization_nameTEXTOrganization NameThe organization of the objectmembers
phoneTEXTPhone NumberThe phone number of the objectmembers
received_emailsNUMERICReceived e-mailsNumber of e-mails receivedmetrics
refunded_orderNUMERICRefunded OrderTotal amount of Refunded Ordermetrics
refunded_order_valueNUMERICRefunded Order ValueRefunded Order valuemetrics
regionREGIONRegionThe region of the objectmembers
revenueNUMERICRevenueTotal Value of placed ordersmetrics
revenue_per_recipientNUMERICRevenue per RecipientThe amount of revenue attributed to a campaign divided by the number of recipientsmetrics
sent_atTEXTSent atCampaign sent timecampaigns
sent_emailsNUMERICSent EmailsThe number of recipients the email was sent tometrics
shopify_cancelled_orderNUMERICShopify Cancelled OrderThis event is tracked when a customer creates an order in your Shopify store but then cancels the order before fulfillmentmetrics
shopify_checkout_startedNUMERICShopify Checkout StartedShopify checkout completedmetrics
shopify_confirmed_shipmentNUMERICShopify Confirmed ShipmentShopify Confirmed Shipmentmetrics
shopify_delivered_shipmentNUMERICShopify Delivered ShipmentShopify Delivered Shipmentmetrics
shopify_fulfilled_orderNUMERICShopify Fulfilled OrderThis event is tracked when an order is marked as 'fulfilled' in your Shopify storemetrics
shopify_fulfilled_partial_orderNUMERICShopify Fulfilled Partial OrderThis event is tracked when an order is marked as 'fulfilled' in your Shopify storemetrics
shopify_marked_out_for_deliveryNUMERICShopify Marked Out for DeliveryShopify Marked Out for Deliverymetrics
shopify_ordered_productNUMERICShopify Ordered ProductThe total quantity ordered of the productmetrics
shopify_placed_orderNUMERICShopify Placed OrderThis event is tracked when a customer completes the checkout process and creates an order in your Shopify storemetrics
shopify_refunded_orderNUMERICShopify Refunded OrderThis event is tracked when a customer completes the checkout process in your Shopify store and a payment is made, but the customer requests the payment to be returned. Klaviyo only receives events from fully refunded orders (not partially refunded orders)metrics
shopify_revenueNUMERICShopify RevenueRevenue value from Shopify Placed Order events.metrics
sourceTEXTSourceThe name of the Windsor connector returning the row
statusTEXTStatusCampaign statuscampaigns
subjectTEXTSubjectCampaign subjectcampaigns
subscribedNUMERICSubscribed to ListSubscribed to Listmetrics
subscription_statusTEXTSubscription statusEmail subscriptions statuscampaigns
timezoneTEXTTime ZoneThe time zone of the objectmembers
titleTEXTTitleThe title of the objectmembers
todayDATETodayToday's date
total_clicksNUMERICTotal ClicksTotal number of e-mail clicksmetrics
total_conversionsNUMERICTotal ConversionsTotal amount of placed ordersmetrics
total_opensNUMERICTotal OpensTotal number of e-mail opensmetrics
unsubscribedNUMERICUnsubscribed From ListUnsubscribed from listmetrics
unsubscribed_from_listNUMERICUnsubscribed From List (duplicate)Unsubscribed from listmetrics
unsubscribed_rateNUMERICUnsubscribed Rate From List (duplicate)Unsubscribed from list Ratemetrics
unsubscribed_rate_from_listNUMERICUnsubscribed Rate From ListUnsubscribed from list Ratemetrics
weekTEXTWeekWeek (Sun-Sat).
week_dayTEXTDay of week and day numberWeekday number and name combined (Sun-Sat).Numbered from 0 Sunday to 6 Saturday.
week_day_isoTEXTDay of week and day number, ISOWeekday number and name combined, ISO format (Mon-Sun).Numbered from 1 Monday to 7
week_isoTEXTWeek ISOWeek, ISO format (Mon-Sun).
yearTEXTYearYear
year_monthTEXTYearmonthYear and month, e.g. 2024|3
year_of_weekTEXTYear of weekThe year that contains first day of the week (Sun-Sat).
year_of_week_isoTEXTYear of week, ISOThe year that contains first day of the ISO week (Mon-Sun).
year_weekTEXTYear weekYear and week for US weeks (Sun-Sat), e.g. 2024|15
year_week_isoTEXTYear week ISOYear and week for ISO weeks (Mon-Sun), e.g. 2024|20
zipTEXTZIP CodeThe zip code of the objectmembers