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
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 datametrics
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 valueflows
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 valueflows
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 RevenueThis event is tracked when a customer completes the checkout process and creates an order in your Shopify storemetrics
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
unsubscribedNUMERICUnsubscribedUnsubscribedmetrics
unsubscribed_from_listNUMERICUnsubscribed From ListUnsubscribed from listmetrics
unsubscribed_rateNUMERICUnsubscribed RateUnsubscribed 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