Introduction

Datasources and destinations

Fields listing for Klaviyo

Campaign ID
The Campaign ID
Field IDcampaign.campaign_id
TypeTEXT
Data Typedimension
Campaign Name
The Campaign Name
Field IDcampaign.campaign_name
TypeTEXT
Data Typedimension
Campaign Created Date
The Campaign Created Date
Field IDcampaign.campaign_created
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
FLOW ID
The Flow ID
Field IDflow.id
TypeTEXT
Data Typedimension
Flow Name
The Flow Name
Field IDflow.name
TypeTEXT
Data Typedimension
Flow URL
The Flow URL
Field IDflow.url
TypeTEXT
Data Typedimension
Campaign Scheduled Date
The Campaign Scheduled Date
Field IDcampaign.campaign_scheduled
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Campaign Updated Date
The Campaign Updated Date
Field IDcampaign.campaign_updated
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Campaign Send Date
The Campaign Send Date
Field IDcampaign.campaign_send
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Campaign Type
The Campaign Type
Field IDcampaign.campaign_type
TypeTEXT
Data Typedimension
Campaign Message Type
The Campaign Message Type
Field IDcampaign.campaign_message_type
TypeTEXT
Data Typedimension
Campaign Subject
The Campaign Subject
Field IDcampaign.campaign_subject
TypeTEXT
Data Typedimension
Campaign is part of flow
TIs the campaign a part of flow
Field IDcampaign.campaign_is_part_of_flow
TypeBOOLEAN
Data Typedimension
Campaign is segmented
Is the campaign segmented
Field IDcampaign.campaign_is_segmented
TypeBOOLEAN
Data Typedimension
Campaign From Email
The campaign From Email
Field IDcampaign.campaign_from_email
TypeTEXT
Data Typedimension
Campaign From Name
The campaign From Name
Field IDcampaign.campaign_from_name
TypeTEXT
Data Typedimension
Campaign Status
The campaign Status
Field IDcampaign.campaign_status
TypeTEXT
Data Typedimension
Campaign Template ID
The campaign template ID
Field IDcampaign.campaign_temeplate_id
TypeTEXT
Data Typedimension
Campaign HTML
The campaign HTML
Field IDcampaign.campaign_html
TypeTEXT
Data Typedimension
Emails Opened
The number of time the email as been opened
Field IDmail_open
TypeNUMBER
Data Typemetric
Emails Opened Unique
The number of time the email as been opened unique
Field IDmail_open_unique
TypeNUMBER
Data Typemetric
Emails Recipients
Total Number of unique recipients
Field IDmail_total_send
TypeNUMBER
Data Typemetric
Emails Received
Total Number of email received
Field IDmail_received
TypeNUMBER
Data Typemetric
Emails Received Rate
Emails Received Rate
Field IDmail_received_rate
TypePERCENT
Data Typemetric
API - Active On Site
API - Active On Site
Field IDapi_active_on_site
TypeNUMBER
Data Typemetric
API - Viewed Product
API - Viewed Product
Field IDapi_viewed_product
TypeNUMBER
Data Typemetric
API - Added To Card
API - Added To Card
Field IDapi_added_to_cart
TypeNUMBER
Data Typemetric
Subscribed to List
Subscribed to List
Field IDklaviyo_subscribed_to_list
TypeNUMBER
Data Typemetric
Closed Form
Closed Form
Field IDklaviyo_closed_form
TypeNUMBER
Data Typemetric
Submitted Form
Submitted Form
Field IDklaviyo_submitted_form
TypeNUMBER
Data Typemetric
Viewed Form
Viewed Form
Field IDklaviyo_viewed_form
TypeNUMBER
Data Typemetric
Qualified Form
Qualified Form
Field IDklaviyo_qualified_form
TypeNUMBER
Data Typemetric
Unsubscribe Page Submit
Unsubscribe Page Submit
Field IDklaviyo_unsubscribe_page_submit
TypeNUMBER
Data Typemetric
Updated Email Preferences
Updated Email Preferences
Field IDklaviyo_updated_email_preference
TypeNUMBER
Data Typemetric
Unsubscribed from List
Unsubscribed from List
Field IDklaviyo_unsubscribed_from_list
TypeNUMBER
Data Typemetric
Unsubscribed
Unsubscribed
Field IDklaviyo_unsubscribed
TypeNUMBER
Data Typemetric
Bounced Push
Bounced Push
Field IDklaviyo_bounced_push
TypeNUMBER
Data Typemetric
Opened Push
Opened Push
Field IDklaviyo_opened_push
TypeNUMBER
Data Typemetric
Received Push
Received Push
Field IDklaviyo_received_push
TypeNUMBER
Data Typemetric
Clicked SMS
Clicked SMS
Field IDklaviyo_clicked_sms
TypeNUMBER
Data Typemetric
Subscribed to SMS Marketing
Subscribed to SMS Marketing
Field IDklaviyo_subscribed_to_sms_marketing
TypeNUMBER
Data Typemetric
Unsubscribed from SMS Marketing
Unsubscribed from SMS Marketing
Field IDklaviyo_unsubscribed_from_sms_marketing
TypeNUMBER
Data Typemetric
Received SMS
Received SMS
Field IDklaviyo_received_sms
TypeNUMBER
Data Typemetric
Sent SMS
Sent SMS
Field IDklaviyo_sent_sms
TypeNUMBER
Data Typemetric
Failed to deliver Automated Response SMS
Failed to deliver Automated Response SMS
Field IDklaviyo_failed_to_deliver_automated_response_sms
TypeNUMBER
Data Typemetric
Received Automated Response SMS
Received Automated Response SMS
Field IDklaviyo_received_automated_response_sms
TypeNUMBER
Data Typemetric
Failed to deliver SMS
Failed to deliver SMS
Field IDklaviyo_failed_to_deliver_sms
TypeNUMBER
Data Typemetric
Woocommerce - Cancelled Order
Woocommerce - Cancelled Order
Field IDwoocommerce_cancelled_order
TypeNUMBER
Data Typemetric
Woocommerce - Cancelled Order Value
Woocommerce - Cancelled Order Value
Field IDwoocommerce_cancelled_order_value
TypeNUMBER
Data Typemetric
Shopify - Cancelled Order
Shopify - Cancelled Order
Field IDshopify_cancelled_order
TypeNUMBER
Data Typemetric
Shopify - Cancelled Order Value
Shopify - Cancelled Order Value
Field IDshopify_cancelled_order_value
TypeNUMBER
Data Typemetric
Shopify - Checkout Started
Shopify - Checkout Started
Field IDshopify_checkout_started
TypeNUMBER
Data Typemetric
Shopify - Checkout Started Value
Shopify - Checkout Started Value
Field IDshopify_checkout_started_value
TypeNUMBER
Data Typemetric
Shopify - Confirmed Shipment
Shopify - Confirmed Shipment
Field IDshopify_confirmed_shipment
TypeNUMBER
Data Typemetric
Shopify - Delivered Shipment
Shopify - Delivered Shipment
Field IDshopify_delivered_shipment
TypeNUMBER
Data Typemetric
Shopify - Fulfilled Order
Shopify - Fulfilled Order
Field IDshopify_fulfilled_order
TypeNUMBER
Data Typemetric
Shopify - Fulfilled Order Value
Shopify - Fulfilled Order Value
Field IDshopify_fulfilled_order_value
TypeNUMBER
Data Typemetric
Shopify - Fulfilled Partial Order
Shopify - Fulfilled Partial Order
Field IDshopify_fulfilled_partial_order
TypeNUMBER
Data Typemetric
Shopify - Fulfilled Partial Order Value
Shopify - Fulfilled Partial Order Value
Field IDshopify_fulfilled_partial_order_value
TypeNUMBER
Data Typemetric
Shopify - Ordered Product
Shopify - Ordered Product
Field IDshopify_ordered_product
TypeNUMBER
Data Typemetric
Shopify - Placed Order
Shopify - Placed Order
Field IDshopify_placed_order
TypeNUMBER
Data Typemetric
Shopify - Placed Order Value
Shopify - Placed Order Value
Field IDshopify_placed_order_value
TypeNUMBER
Data Typemetric
Shopify - Refunded Order
Shopify - Refunded Order
Field IDshopify_refunded_order
TypeNUMBER
Data Typemetric
Shopify - Refunded Order Value
Shopify - Refunded Order Value
Field IDshopify_refunded_order_value
TypeNUMBER
Data Typemetric
Woocommerce - Started Checkout
Woocommerce - Started Checkout
Field IDwoocommerce_started_checkout
TypeNUMBER
Data Typemetric
Woocommerce - Started Checkout Value
Woocommerce - Started Checkout Value
Field IDwoocommerce_started_checkout_value
TypeNUMBER
Data Typemetric
Woocommerce - Fulfilled Order
Woocommerce - Fulfilled Order
Field IDwoocommerce_fulfilled_order
TypeNUMBER
Data Typemetric
Woocommerce - Fulfilled Order Value
Woocommerce - Fulfilled Order Value
Field IDwoocommerce_fulfilled_order_value
TypeNUMBER
Data Typemetric
Woocommerce - Ordered Product
Woocommerce - Ordered Product
Field IDwoocommerce_ordered_product
TypeNUMBER
Data Typemetric
Woocommerce - Ordered Product Value
Woocommerce - Ordered Product Value
Field IDwoocommerce_ordered_product_value
TypeNUMBER
Data Typemetric
Woocommerce - Placed Order
Woocommerce - Placed Order
Field IDwoocommerce_placed_order
TypeNUMBER
Data Typemetric
Woocommerce - Placed Order Value
Woocommerce - Placed Order Value
Field IDwoocommerce_placed_order_value
TypeNUMBER
Data Typemetric
Woocommerce - Refunded Order
Woocommerce - Refunded Order
Field IDwoocommerce_refunded_order
TypeNUMBER
Data Typemetric
Woocommerce - Refunded Order value
Woocommerce - Refunded Order Value
Field IDwoocommerce_refunded_order_value
TypeNUMBER
Data Typemetric
Emails Clicked
Total email clicked
Field IDmail_clicked
TypeNUMBER
Data Typedimension
Emails Clicked Unique
Total email clicked unique
Field IDmail_clicked_unique
TypeNUMBER
Data Typedimension
Emails Clicked Rate
Emails Clicked Rate
Field IDmail_clicked_rate
TypePERCENT
Data Typemetric
Emails Open Rate
Emails Open Rate
Field IDmail_open_rate
TypePERCENT
Data Typemetric
Emails Bounced
Email Bounced
Field IDmail_bounced
TypeNUMBER
Data Typedimension
Emails Bounced Rate
Emails Bounced Rate
Field IDmail_bounced_rate
TypePERCENT
Data Typemetric
Email Dropped
Emails Dropped
Field IDmail_dropped
TypeNUMBER
Data Typedimension
Emails Dropped Rate
Emails Dropped Rate
Field IDmail_dropped_rate
TypePERCENT
Data Typemetric
Email Mark as spam
Emails Mark As Spam
Field IDmail_mark_as_spam
TypeNUMBER
Data Typedimension
Emails Mark As Spam Rate
Emails Mark As Spam Rate
Field IDmail_mark_as_spam_rate
TypePERCENT
Data Typemetric
Person name
The Person name
Field IDperson.name
TypeTEXT
Data Typedimension
Person Id
The Person id
Field IDperson.id
TypeTEXT
Data Typedimension
Person Email
The Person email
Field IDperson.email
TypeTEXT
Data Typedimension
Person Email Domain
The Person email domain
Field IDperson.email_domain
TypeTEXT
Data Typedimension
Person Phone
The Person phone
Field IDperson.phone
TypeTEXT
Data Typedimension
Person Address 1
The Person Address 1
Field IDperson.address_1
TypeTEXT
Data Typedimension
Person Address 2
The Person Address 2
Field IDperson.address_2
TypeTEXT
Data Typedimension
Person title
The Person title
Field IDperson.title
TypeTEXT
Data Typedimension
Person Organization
The Person organization
Field IDperson.organization
TypeTEXT
Data Typedimension
Person Country
The Person Country
Field IDperson.country
TypeCOUNTRY
Data Typedimension
Person Region
The Person Region
Field IDperson.region
TypeCOUNTRY
Data Typedimension
Person City
The Person city
Field IDperson.city
TypeCITY
Data Typedimension
Person Created
The Person created
Field IDperson.created
TypeCITY
Data Typedimension
Person Accepts Marketing
The Person link
Field IDperson.accepts_marketings
TypeTEXT
Data Typedimension
List Name
The List Name
Field IDlist.name
TypeTEXT
Data Typedimension
List Type
The List Type
Field IDlist.type
TypeTEXT
Data Typedimension
List ID
The List ID
Field IDlist.id
TypeTEXT
Data Typedimension
Year
Year such as 2017.
Field ID_NORMALIZED_DATE_FIELD_YEAR
TypeYEAR
Data Typedimension
Year Quarter
Year and quarter.
Field ID_NORMALIZED_DATE_FIELD_YEAR_QUARTER
TypeYEAR_QUARTER
Data Typedimension
Year month
Year and month.
Field ID_NORMALIZED_DATE_FIELD_YEAR_MONTH
TypeYEAR_MONTH
Data Typedimension
Year week
Year and week.
Field ID_NORMALIZED_DATE_FIELD_YEAR_WEEK
TypeYEAR_WEEK
Data Typedimension
Date
Year, month, and day.
Field ID_NORMALIZED_DATE_FIELD_YEAR_MONTH_DAY
TypeYEAR_MONTH_DAY
Data Typedimension
Year month day hour
Year, month, day, and hour.
Field ID_NORMALIZED_DATE_FIELD_YEAR_MONTH_DAY_HOUR
TypeYEAR_MONTH_DAY_HOUR
Data Typedimension
Quarter of the year
Quarter of the year
Field ID_NORMALIZED_DATE_FIELD_QUARTER
TypeQUARTER
Data Typedimension
Month of the year
Month of the year
Field ID_NORMALIZED_DATE_FIELD_MONTH
TypeMONTH
Data Typedimension
Week of the year
Week of the year
Field ID_NORMALIZED_DATE_FIELD_WEEK
TypeWEEK
Data Typedimension
Month and day
Month and day
Field ID_NORMALIZED_DATE_FIELD_MONTH_DAY
TypeMONTH_DAY
Data Typedimension
Day of the week
Week of the year
Field ID_NORMALIZED_DATE_FIELD_DAY_OF_WEEK
TypeDAY_OF_WEEK
Data Typedimension
Day of the month
Day of the year
Field ID_NORMALIZED_DATE_FIELD_DAY
TypeDAY
Data Typedimension
Extracted Date
The date where the extraction take times.
Field ID_catchr_date_extract
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Platform Name
Return the platform name
Field ID_catchr_platform_name
TypeTEXT
Data Typedimension