Klaviyo fields

Prev Next

Supermetrics brings all your Klaviyo data into Google Sheets, Looker Studio, Power BI, Excel, BigQuery, Snowflake, Redshift, Azure

83 metrics118 dimensionsCustom fields

ACCOUNT

account_name

AD

ad_platform
ad_campaign_name
ad_set_name
ad_set_id
ad_name
ad_id
ad_form_name
facebook_advertising_filled_out_lead_ad

API

api_active_on_site
api_viewed_product

CAMPAIGN

campaign_name
campaign_id
campaign_created_datetime
campaign_send_datetime
campaign_send_date
campaign_send_weekday
campaign_send_time
campaign_send_hour
campaign_type
campaign_message_type
campaign_subject
campaign_is_part_of_flow
campaign_is_segmented
campaign_from_email
campaign_from_name
campaign_status
campaign_template_id
campaign_html

DATASOURCE

dataSourceName
system_metadata.data_source_logins
system_metadata.data_source_login_owners

DEPRECATED

klaviyo_unsubscribed

EMAIL

klaviyo_total_recipients
klaviyo_received_email
klaviyo_opened_email
klaviyo_opened_email_unique
klaviyo_open_rate
klaviyo_clicked_email
klaviyo_clicked_email_unique
klaviyo_click_rate
klaviyo_bounced_email
klaviyo_bounce_rate
klaviyo_dropped_email
klaviyo_marked_email_as_spam
klaviyo_spam_rate

EMAIL CLIENT

email_client
email_client_os
email_client_type

FLOW

flow_name
flow_id
flow_url

LIST

list_name
list_id
list_type
klaviyo_subscribed_to_list
klaviyo_unsubscribed_from_list
klaviyo_clicked_email_to_unsubscribe
klaviyo_subscribed_to_back_in_stock

LIST MEMBERS

list_members

MAGENTO

magento_checkout_started
magento_checkout_started_value
magento_placed_order
magento_placed_order_value
magento_average_order_value
magento_ordered_product_quantity
magento_checkout_start_to_order_rate
magento_cancelled_order
magento_cancelled_order_value
magento_fulfilled_order
magento_fulfilled_order_value
magento_refunded_order
magento_refunded_order_value
magento_conversion_rate
magento_revenue_per_recipient

PERSON

person_name
person_id
person_email
person_email_domain
person_phone
person_address1
person_address2
person_title
person_organization
person_country
person_region
person_city
person_zip
person_created
person_profile_age
person_source
person_accepts_marketing
person_shopify_tags

PURCHASE

purchase_id
purchase_is_shopify
purchase_confirmed
purchase_financial_status
purchase_test
purchase_tags
purchase_note
purchase_currency
purchase_gateway
purchase_weight
purchase_source
purchase_discount_codes
purchase_shipping_rate
purchase_vendor
purchase_order_number
purchase_order_status_url
purchase_reference
purchase_processing_method
purchase_item_count
purchase_total_price
purchase_browser_ip
purchase_customer_locale

PURCHASE ITEM

purchase_item_name
purchase_item_category
purchase_item_image_url
purchase_item_image
purchase_item_variant_name
purchase_item_variant_option_title
purchase_item_variant_option_color
purchase_item_variant_option_size
purchase_sku
purchase_product_id

QUERY

system_metadata.query_date_range_start
system_metadata.query_date_range_end
system_metadata.query_timezone
system_metadata.query_filters
system_metadata.query_date_start
system_metadata.query_date_end
system_metadata.query_duration
system_metadata.query_accounts

SHOPIFY

shopify_checkout_started
shopify_checkout_started_value
shopify_placed_order
shopify_placed_order_value
shopify_average_order_value
shopify_ordered_product_quantity
shopify_checkout_completed
shopify_checkout_start_to_order_rate
shopify_cancelled_order
shopify_cancelled_order_value
shopify_fulfilled_order
shopify_fulfilled_order_value
shopify_fulfilled_partial_order
shopify_fulfilled_partial_order_value
shopify_refunded_order
shopify_refunded_order_value
shopify_conversion_rate
shopify_revenue_per_recipient

SMS

klaviyo_sms_recipients
klaviyo_received_sms
klaviyo_clicked_sms
klaviyo_failed_to_deliver_sms
klaviyo_unsubscribed_from_sms

SOURCE

utm_source
utm_medium
utm_campaign
utm_content
utm_term
landing_page_url

STRIPE

stripe_successfully_paid
stripe_successfully_paid_value
stripe_failed_payment
stripe_failed_payment_value
stripe_refunded_payment
stripe_refunded_payment_value
stripe_issued_invoice
stripe_issued_invoice_value

TIME

today
year
yearOfWeek
yearOfWeekIso
yearMonth
month
yearWeek
yearWeekIso
week
weekIso
dayOfMonth
dayOfWeekName
dayOfWeekNameIso
date

WEBSITE

page

WOOCOMMERCE

woocommerce_checkout_started
woocommerce_checkout_started_value
woocommerce_placed_order
woocommerce_placed_order_value
woocommerce_average_order_value
woocommerce_ordered_product_quantity
woocommerce_checkout_start_to_order_rate
woocommerce_cancelled_order
woocommerce_cancelled_order_value
woocommerce_fulfilled_order
woocommerce_fulfilled_order_value
woocommerce_refunded_order
woocommerce_refunded_order_value
woocommerce_conversion_rate
woocommerce_revenue_per_recipient