Klaviyo data warehouse table groups

  • Updated on Sep 11, 2025
  • Published on Aug 5, 2025
Prev Next

Table: CAMPAIGN

account_name
Display name Account name
Description Name of the Klaviyo account as you have provided during the login process
Field type dimension
Data type string.text.value
ad_campaign_name
Display name Ad campaign name
Field type dimension
Data type string.text.value
ad_form_name
Display name Ad form name
Field type dimension
Data type string.text.value
ad_id
Display name Ad ID
Field type dimension
Data type string.text.value
ad_name
Display name Ad name
Field type dimension
Data type string.text.value
ad_platform
Display name Ad platform
Description Platform where the ad was ran
Field type dimension
Data type string.text.value
ad_set_id
Display name Ad set ID
Field type dimension
Data type string.text.value
ad_set_name
Display name Ad set name
Field type dimension
Data type string.text.value
campaign_from_email
Display name From email
Field type dimension
Data type string.text.email
campaign_from_name
Display name From name
Field type dimension
Data type string.text.value
campaign_html
Display name Content HTML
Field type dimension
Data type string.text.value
campaign_id
Display name Campaign ID
Field type dimension
Data type string.text.value
campaign_is_part_of_flow
Display name Campaign is part of a flow
Description You can use this dimension to distinguish campaigns that are part of a flow from ones that are not
Field type dimension
Data type bool
campaign_is_segmented
Display name Campaign is segmented
Field type dimension
Data type string.text.value
campaign_message_type
Display name Message type
Field type dimension
Data type string.text.value
campaign_name
Display name Campaign name
Field type dimension
Data type string.text.value
campaign_status
Display name Content status
Field type dimension
Data type string.text.value
campaign_subject
Display name Subject
Field type dimension
Data type string.text.value
campaign_template_id
Display name Template ID
Field type dimension
Data type string.text.value
campaign_type
Display name Content type
Field type dimension
Data type string.text.value
dataSourceName
Display name Data source
Description The name of the source for this data, as listed on supermetrics.com/docs
Field type dimension
Data type string.text.value
date
Display name Date
Description Date, e.g. 2017-01-31
Field type dimension
Data type string.time.date
email_client
Display name Email client
Field type dimension
Data type string.text.value
email_client_os
Display name Email client OS
Field type dimension
Data type string.text.value
email_client_type
Display name Email client type
Field type dimension
Data type string.text.value
facebook_advertising_filled_out_lead_ad
Display name Filled out Facebook lead ad
Description This event is tracked when a someone fills in a Facebook lead ad
Field type metric
Data type int.number.value
flow_id
Display name Flow ID
Field type dimension
Data type string.text.value
flow_name
Display name Flow name
Field type dimension
Data type string.text.value
flow_url
Display name Flow URL
Field type dimension
Data type string.text.value
klaviyo_bounced_email
Display name Emails bounced
Description Number of times when an email soft or hard bounced
Field type metric
Data type int.number.value
klaviyo_clicked_email
Display name Emails clicked
Description Number of times when a recipient clicked an email
Field type metric
Data type int.number.value
klaviyo_clicked_email_unique
Display name Emails clicked (unique)
Description Number of recipients that clicked an email
Field type metric
Data type int.number.value
klaviyo_dropped_email
Display name Emails dropped
Description Number of times when an email was not sent because the email address is suspicious
Field type metric
Data type int.number.value
klaviyo_marked_email_as_spam
Display name Emails marked as spam
Description Number of times when a recipient marks an email as spam
Field type metric
Data type int.number.value
klaviyo_opened_email
Display name Emails opened
Description Number of times when a recipient opens an email
Field type metric
Data type int.number.value
klaviyo_opened_email_unique
Display name Emails opened (unique)
Description Number of recipients that opened an email
Field type metric
Data type int.number.value
klaviyo_received_email
Display name Emails received
Description Number of times when a recipient receives an email
Field type metric
Data type int.number.value
klaviyo_subscribed_to_back_in_stock
Display name New subscriptions to Back in Stock
Description Number of times when a recipient subscribes to be notified about an item being back in stock
Field type metric
Data type int.number.value
klaviyo_subscribed_to_list
Display name New subscriptions to list
Description Number of times when someone opts in to a list
Field type metric
Data type int.number.value
klaviyo_unsubscribed
Display name Unsubscribes from all emails
Description Number of times when someone unsubscribes from emails globally. Please note that this field will be removed on 2024-07-22
Field type metric
Data type int.number.value
klaviyo_unsubscribed_from_list
Display name Unsubscribes from list
Description Number of times when someone unsubscribes from a specific list
Field type metric
Data type int.number.value
landing_page_url
Display name Landing page URL
Description Landing page URL link that brought the buyer to the store
Field type dimension
Data type string.text.url
list_id
Display name List ID
Field type dimension
Data type string.text.value
list_name
Display name List
Field type dimension
Data type string.text.value
magento_average_order_value
Display name Magento average order value
Description The average value of the placed order, inclusive of shipping and any applied discounts
Field type metric
Data type float.currency.value
magento_cancelled_order
Display name Magento cancelled orders
Description This event is tracked when a customer creates an order in your Magento store but then cancels the order before fulfillment
Field type metric
Data type int.number.value
magento_cancelled_order_value
Display name Magento cancelled order value
Description This event is tracked when a customer creates an order in your Magento store but then cancels the order before fulfillment
Field type metric
Data type float.currency.value
magento_checkout_started
Display name Magento checkout starts
Description This event is tracked when a customer enters his/her contact and shipping information on the first page of the Magento checkout process and clicks continue
Field type metric
Data type int.number.value
magento_checkout_started_value
Display name Magento checkout start value
Description This event is tracked when a customer enters his/her contact and shipping information on the first page of the Magento checkout process and clicks continue
Field type metric
Data type float.currency.value
magento_fulfilled_order
Display name Magento fulfilled orders
Description This event is tracked when an order is marked as "fulfilled" in your Magento store
Field type metric
Data type int.number.value
magento_fulfilled_order_value
Display name Magento fulfilled order value
Description This event is tracked when an order is marked as "fulfilled" in your Magento store
Field type metric
Data type float.currency.value
magento_ordered_product_quantity
Display name Magento item quantity
Description The total quantity ordered of the product
Field type metric
Data type int.number.value
magento_placed_order
Display name Magento orders
Description This event is tracked when a customer completes the checkout process and creates an order in your Magento store
Field type metric
Data type int.number.value
magento_placed_order_value
Display name Magento order value
Description The total value of the placed order, inclusive of shipping and any applied discounts
Field type metric
Data type float.currency.value
magento_refunded_order
Display name Magento refunded orders
Description This event is tracked when a customer completes the checkout process in your Magento 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)
Field type metric
Data type int.number.value
magento_refunded_order_value
Display name Magento refunded order value
Description This event is tracked when a customer completes the checkout process in your Magento 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)
Field type metric
Data type float.currency.value
page
Display name Page URL
Field type dimension
Data type string.text.url
person_accepts_marketing
Display name Accepts marketing
Field type dimension
Data type bool
person_address1
Display name Person address line 1
Field type dimension
Data type string.text.value
person_address2
Display name Person address line 2
Field type dimension
Data type string.text.value
person_city
Display name City
Field type dimension
Data type string.geo.city
person_country
Display name Country
Field type dimension
Data type string.geo.country
person_created
Display name Profile created
Field type dimension
Data type string.time.datetime
person_email
Display name Email address
Field type dimension
Data type string.text.email
person_email_domain
Display name Email domain
Field type dimension
Data type string.text.email
person_id
Display name Profile ID
Description ID of the recipient profile
Field type dimension
Data type string.text.value
person_name
Display name Person name
Field type dimension
Data type string.text.value
person_phone
Display name Phone number
Field type dimension
Data type string.text.phone
person_profile_age
Display name Age of profile
Field type dimension
Data type int.number.value
person_region
Display name Region
Field type dimension
Data type string.geo.region
person_shopify_tags
Display name Shopify tags
Description A list of custom tags assigned to that customer in Shopify, e.g., Wholesale, VIP
Field type dimension
Data type string.text.value
person_source
Display name Source
Field type dimension
Data type string.text.value
person_title
Display name Title
Field type dimension
Data type string.text.value
person_zip
Display name Zip code
Field type dimension
Data type string.geo.zip
purchase_browser_ip
Display name Browser IP address
Field type dimension
Data type string.network.ip
purchase_confirmed
Display name Is confirmed
Field type dimension
Data type bool
purchase_currency
Display name Currency
Field type dimension
Data type string.text.value
purchase_customer_locale
Display name Customer locale
Field type dimension
Data type string.text.value
purchase_discount_codes
Display name Discount codes
Description Any discount or coupon codes someone used towards the order
Field type dimension
Data type string.text.value
purchase_financial_status
Display name Finacial status
Field type dimension
Data type string.text.value
purchase_gateway
Display name Payment gateway
Field type dimension
Data type string.text.value
purchase_id
Display name Purchase ID
Field type dimension
Data type string.text.value
purchase_is_shopify
Display name Is Shopify purchase
Field type dimension
Data type bool
purchase_item_category
Display name Item categories
Description The categories or collections of the ordered product
Field type dimension
Data type string.text.value
purchase_item_count
Display name Item count
Description Number of items bought
Field type dimension
Data type string.text.value
purchase_item_image_url
Display name Item image URL
Description URL to the image of the product
Field type dimension
Data type string.text.url
purchase_item_name
Display name Item name
Description The name or title of the ordered product, e.g., t-shirt
Field type dimension
Data type string.text.value
purchase_item_variant_name
Display name Item variant name
Description The name or title of the product variant in Shopify, e.g., red, size medium t-shirt
Field type dimension
Data type string.text.value
purchase_item_variant_option_color
Display name Item variant color
Field type dimension
Data type string.text.value
purchase_item_variant_option_size
Display name Item variant size
Field type dimension
Data type string.text.value
purchase_item_variant_option_title
Display name Item variant title
Field type dimension
Data type string.text.value
purchase_note
Display name Note
Field type dimension
Data type string.text.value
purchase_order_number
Display name Order number
Field type dimension
Data type string.text.value
purchase_order_status_url
Display name Status URL
Field type dimension
Data type string.text.url
purchase_processing_method
Display name Processing method
Field type dimension
Data type string.text.value
purchase_product_id
Display name Product ID
Description The ID associated with the product in your store
Field type dimension
Data type string.text.value
purchase_reference
Display name Purchase reference
Field type dimension
Data type string.text.value
purchase_shipping_rate
Display name Shipping rate
Field type dimension
Data type string.text.value
purchase_sku
Display name SKU
Description The stock keeping unit of the product variant
Field type dimension
Data type string.text.value
purchase_source
Display name Source
Description POS, Mobile etc
Field type dimension
Data type string.text.value
purchase_tags
Display name Tags
Field type dimension
Data type string.text.value
purchase_test
Display name Is test
Field type dimension
Data type bool
purchase_total_price
Display name Total price
Field type dimension
Data type float.currency.value
purchase_vendor
Display name Vendor
Field type dimension
Data type string.text.value
purchase_weight
Display name Weight
Field type dimension
Data type string.text.value
shopify_average_order_value
Display name Shopify average order value
Description The average value of the placed order, inclusive of shipping and any applied discounts
Field type metric
Data type float.currency.value
shopify_cancelled_order
Display name Shopify cancelled orders
Description This event is tracked when a customer creates an order in your Shopify store but then cancels the order before fulfillment
Field type metric
Data type int.number.value
shopify_cancelled_order_value
Display name Shopify cancelled order value
Description This event is tracked when a customer creates an order in your Shopify store but then cancels the order before fulfillment
Field type metric
Data type float.currency.value
shopify_checkout_started
Display name Shopify checkout starts
Description This event is tracked when a customer enters his/her contact and shipping information on the first page of the Shopify checkout process and clicks continue
Field type metric
Data type int.number.value
shopify_checkout_started_value
Display name Shopify checkout start value
Description This event is tracked when a customer enters his/her contact and shipping information on the first page of the Shopify checkout process and clicks continue
Field type metric
Data type float.currency.value
shopify_fulfilled_order
Display name Shopify fulfilled orders
Description This event is tracked when an order is marked as "fulfilled" in your Shopify store
Field type metric
Data type int.number.value
shopify_fulfilled_order_value
Display name Shopify fulfilled order value
Description This event is tracked when an order is marked as "fulfilled" in your Shopify store
Field type metric
Data type float.currency.value
shopify_ordered_product_quantity
Display name Shopify item quantity
Description The total quantity ordered of the product
Field type metric
Data type int.number.value
shopify_placed_order
Display name Shopify orders
Description This event is tracked when a customer completes the checkout process and creates an order in your Shopify store
Field type metric
Data type int.number.value
shopify_placed_order_value
Display name Shopify order value
Description The total value of the placed order, inclusive of shipping and any applied discounts
Field type metric
Data type float.currency.value
shopify_refunded_order
Display name Shopify refunded orders
Description This 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)
Field type metric
Data type int.number.value
shopify_refunded_order_value
Display name Shopify refunded order value
Description This 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)
Field type metric
Data type float.currency.value
utm_campaign
Display name utm_campaign parameter value
Description Value of the utm_campaign parameter in the link that brought the buyer to the store
Field type dimension
Data type string.text.value
utm_content
Display name utm_content parameter value
Description Value of the utm_content parameter in the link that brought the buyer to the store
Field type dimension
Data type string.text.value
utm_medium
Display name utm_medium parameter value
Description Value of the utm_medium parameter in the link that brought the buyer to the store
Field type dimension
Data type string.text.value
utm_source
Display name utm_source parameter value
Description Value of the utm_source parameter in the link that brought the buyer to the store
Field type dimension
Data type string.text.value
utm_term
Display name utm_term parameter value
Description Value of the utm_term parameter in the link that brought the buyer to the store
Field type dimension
Data type string.text.value
woocommerce_average_order_value
Display name Woocommerce average order value
Description The average value of the placed order, inclusive of shipping and any applied discounts
Field type metric
Data type float.currency.value
woocommerce_cancelled_order
Display name Woocommerce cancelled orders
Description This event is tracked when a customer creates an order in your Woocommerce store but then cancels the order before fulfillment
Field type metric
Data type int.number.value
woocommerce_cancelled_order_value
Display name Woocommerce cancelled order value
Description This event is tracked when a customer creates an order in your Woocommerce store but then cancels the order before fulfillment
Field type metric
Data type float.currency.value
woocommerce_checkout_started
Display name Woocommerce checkout starts
Description This event is tracked when a customer enters his/her contact and shipping information on the first page of the Woocommerce checkout process and clicks continue
Field type metric
Data type int.number.value
woocommerce_checkout_started_value
Display name Woocommerce checkout start value
Description This event is tracked when a customer enters his/her contact and shipping information on the first page of the Woocommerce checkout process and clicks continue
Field type metric
Data type float.currency.value
woocommerce_fulfilled_order
Display name Woocommerce fulfilled orders
Description This event is tracked when an order is marked as "fulfilled" in your Woocommerce store
Field type metric
Data type int.number.value
woocommerce_fulfilled_order_value
Display name Woocommerce fulfilled order value
Description This event is tracked when an order is marked as "fulfilled" in your Woocommerce store
Field type metric
Data type float.currency.value
woocommerce_ordered_product_quantity
Display name Woocommerce item quantity
Description The total quantity ordered of the product
Field type metric
Data type int.number.value
woocommerce_placed_order
Display name Woocommerce orders
Description This event is tracked when a customer completes the checkout process and creates an order in your Woocommerce store
Field type metric
Data type int.number.value
woocommerce_placed_order_value
Display name Woocommerce order value
Description The total value of the placed order, inclusive of shipping and any applied discounts
Field type metric
Data type float.currency.value
woocommerce_refunded_order
Display name Woocommerce refunded orders
Description This event is tracked when a customer completes the checkout process in your Woocommerce 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)
Field type metric
Data type int.number.value
woocommerce_refunded_order_value
Display name Woocommerce refunded order value
Description This event is tracked when a customer completes the checkout process in your Woocommerce 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)
Field type metric
Data type float.currency.value