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
createdTEXTCreated atCampaign creation timecampaigns
created_atDATECreated Date/TimeThe time stamp of the object creationmembers
dateDATEDateDate of metric type datametrics
dimensionsTEXTFlow dimensionsFlow dimensionsmetrics
emailTEXTEmail addressThe email address of the objectmembers
firstnameTEXTFirst NameThe first name of the objectmembers
flow_idTEXTFlow IDFlow IDflows
flow_nameTEXTFlow NameFlow Nameflows
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
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
statusTEXTStatusCampaign statuscampaigns
subjectTEXTSubjectCampaign subjectcampaigns
subscribedNUMERICSubscribedSubscribed to Listmetrics
subscription_statusTEXTSubscription statusEmail subscriptions statuscampaigns
timezoneTEXTTime ZoneThe time zone of the objectmembers
titleTEXTTitleThe title of the objectmembers
total_clicksNUMERICTotal ClicksTotal number of e-mail clicksmetrics
total_conversionsNUMERICTotal ConversionsTotal amount of placed ordersmetrics
total_opensNUMERICTotal OpensTotal number of e-mail opensmetrics
unsubscribedNUMERICUnsubscribedUnsubscribed from listmetrics
unsubscribed_rateNUMERICUnsubscribed RateUnsubscribed from list Ratemetrics
zipTEXTZIP CodeThe zip code of the objectmembers
todayDATETodayToday's date