Klaviyo

Explore the interactive ERD

Table & Field Reference

email_template

Column	Type	Keys
`id`	String	PK
`created`	Instant
`editor_type`	String
`html`	String
`name`	String
`text`	String
`updated`	Instant

coupon_code

Column	Type	Keys
`id`	String	PK
`coupon_id`	String	FK
`person_id`	String	FK
`expires_at`	Instant
`status`	String
`unique_code`	String

flow

Column	Type	Keys
`id`	String	PK
`archived`	Boolean
`created`	Instant
`name`	String
`status`	String
`trigger_type`	String
`updated`	Instant

segment_person

Column	Type	Keys
`person_id`	String	PKFK
`segment_id`	String	PKFK

campaign_list

Column	Type	Keys
`campaign_id`	String	PKFK
`list_id`	String	PKFK
`list_included_or_excluded`	String

form_version

Column	Type	Keys
`id`	String	PK
`form_id`	String	FK
`ab_test_variation_name`	String
`created_at`	Instant
`form_type`	String
`status`	String
`updated_at`	Instant

account_history

Column	Type	Keys
`id`	String	PK
`observed_at`	Instant	PK
`contact_information_default_sender_email`	String
`contact_information_default_sender_name`	String
`contact_information_organization_name`	String
`contact_information_street_address_address_1`	String
`contact_information_street_address_address_2`	String
`contact_information_street_address_city`	String
`contact_information_street_address_country`	String
`contact_information_street_address_region`	String
`contact_information_street_address_zip`	String
`contact_information_website_url`	String
`industry`	String
`locale`	String
`preferred_currency`	String
`public_api_key`	String
`test_account`	Boolean
`timezone`	String

campaign_tracking_utm_param

Column	Type	Keys
`name`	String	PK
`campaign_id`	String	PKFK
`type`	String
`value`	String

list

Column	Type	Keys
`id`	String	PK
`created`	Instant
`list_name`	String
`updated`	Instant

list_exclusion

Column	Type	Keys
`id`	String	PKFK
`list_id`	String	PKFK
`created`	Instant
`reason`	String

segment_tag

Column	Type	Keys
`segment_id`	String	PKFK
`tag_id`	String	PKFK

metric

Column	Type	Keys
`id`	String	PK
`created`	Instant
`integration_category`	String
`integration_id`	String
`integration_name`	String
`integration_object`	String
`name`	String
`updated`	Instant

segment

Column	Type	Keys
`id`	String	PK
`created`	Instant
`definition`	Json
`name`	String
`updated`	Instant

flow_action

Column	Type	Keys
`id`	String	PK
`flow_id`	String	FK
`action_type`	String
`created`	Instant
`render_options_add_info_link`	Boolean
`render_options_add_opt_out_language`	Boolean
`render_options_add_org_prefix`	Boolean
`render_options_include_contact_card`	Boolean
`render_options_shorten_links`	Boolean
`send_options_is_transactional`	Boolean
`send_options_use_smart_sending`	Boolean
`status`	String
`tracking_options_add_utm`	Boolean
`tracking_options_is_tracking_clicks`	Boolean
`tracking_options_is_tracking_opens`	Boolean
`updated`	Instant

coupon

Column	Type	Keys
`id`	String	PK
`description`	String
`external_id`	String

campaign_message_send_time

Column	Type	Keys
`datetime`	Instant	PK
`campaign_message_id`	String	PKFK
`is_local`	Boolean

list_person

Column	Type	Keys
`list_id`	String	PKFK
`person_id`	String	PKFK
`joined_group_at`	Instant

tag_group

Column	Type	Keys
`id`	String	PK
`default`	Boolean
`exclusive`	Boolean
`name`	String

flow_action_tracking_utm_param

Column	Type	Keys
`name`	String	PK
`flow_action_id`	String	PKFK
`value`	String

campaign_tag

Column	Type	Keys
`campaign_id`	String	PKFK
`tag_id`	String	PKFK

event

Column	Type	Keys
`id`	String	PK
`campaign_id`	String	FK
`flow_id`	String	FK
`flow_message_id`	String	FK
`metric_id`	String	FK
`person_id`	String	FK
`_variation`	String
`datetime`	Instant
`timestamp`	Instant
`type`	String
`uuid`	String

flow_tag

Column	Type	Keys
`flow_id`	String	PKFK
`tag_id`	String	PKFK

list_tag

Column	Type	Keys
`list_id`	String	PKFK
`tag_id`	String	PKFK

global_exclusion

Column	Type	Keys
`person_id`	String	PKFK
`reason`	String
`timestamp`	Instant

campaign_message

Column	Type	Keys
`id`	String	PK
`campaign_id`	String	FK
`template_id`	String	FK
`channel`	String
`content_bcc_email`	String
`content_body`	String
`content_cc_email`	String
`content_from_email`	String
`content_from_label`	String
`content_media_url`	String
`content_preview_text`	String
`content_reply_to_email`	String
`content_subject`	String
`created`	Instant
`label`	String
`render_options_add_info_link`	Boolean
`render_options_add_opt_out_language`	Boolean
`render_options_add_org_prefix`	Boolean
`render_options_include_contact_card`	Boolean
`render_options_shorten_links`	Boolean
`updated`	Instant

person

Column	Type	Keys
`id`	String	PK
`address_1`	String
`address_2`	String
`city`	String
`country`	String
`created`	Instant
`email`	String
`external_id`	String
`first_name`	String
`image`	String
`ip`	String
`last_event_date`	Instant
`last_name`	String
`latitude`	String
`longitude`	String
`organization`	String
`phone_number`	String
`predictive_analytics_average_days_between_orders`	Double
`predictive_analytics_average_order_value`	Double
`predictive_analytics_churn_probability`	Double
`predictive_analytics_expected_date_of_next_order`	Instant
`predictive_analytics_historic_clv`	Double
`predictive_analytics_historic_number_of_orders`	Double
`predictive_analytics_predicted_clv`	Double
`predictive_analytics_predicted_number_of_orders`	Double
`predictive_analytics_total_clv`	Double
`region`	String
`subscriptions_email_marketing_can_receive_email_marketing`	Boolean
`subscriptions_email_marketing_consent`	String
`subscriptions_email_marketing_custom_method_detail`	String
`subscriptions_email_marketing_double_optin`	String
`subscriptions_email_marketing_last_updated`	Instant
`subscriptions_email_marketing_method`	String
`subscriptions_email_marketing_method_detail`	String
`subscriptions_email_marketing_timestamp`	Instant
`subscriptions_mobile_push_marketing_can_receive_push_marketing`	Boolean
`subscriptions_mobile_push_marketing_consent`	String
`subscriptions_mobile_push_marketing_last_updated`	Instant
`subscriptions_mobile_push_marketing_method`	String
`subscriptions_mobile_push_marketing_method_detail`	String
`subscriptions_mobile_push_marketing_timestamp`	Instant
`subscriptions_sms_marketing_can_receive_sms_marketing`	Boolean
`subscriptions_sms_marketing_consent`	String
`subscriptions_sms_marketing_last_updated`	Instant
`subscriptions_sms_marketing_method`	String
`subscriptions_sms_marketing_method_detail`	String
`subscriptions_sms_marketing_timestamp`	Instant
`timezone`	String
`title`	String
`updated`	Instant
`zip`	String

push_token

Column	Type	Keys
`id`	String	PK
`profile_id`	String	FK
`background`	String
`created`	Instant
`enablement_status`	String
`metadata_app_build`	String
`metadata_app_id`	String
`metadata_app_name`	String
`metadata_app_version`	String
`metadata_device_id`	String
`metadata_device_model`	String
`metadata_environment`	String
`metadata_klaviyo_sdk`	String
`metadata_manufacturer`	String
`metadata_os_name`	String
`metadata_os_version`	String
`metadata_sdk_version`	String
`platform`	String
`recorded_date`	Instant
`token`	String
`vendor`	String

flow_message

Column	Type	Keys
`id`	String	PK
`flow_action_id`	String	FK
`template_id`	String	FK
`channel`	String
`content_bcc_email`	String
`content_cc_email`	String
`content_from_email`	String
`content_from_label`	String
`content_preview_text`	String
`content_reply_to_email`	String
`content_subject`	String
`created`	Instant
`name`	String
`updated`	Instant

campaign

Column	Type	Keys
`id`	String	PK
`archived`	Boolean
`created`	Instant
`name`	String
`scheduled`	Instant
`send_option_ignore_unsubscribes`	Boolean
`send_option_use_smart_sending`	Boolean
`send_strategy_datetime`	Instant
`send_strategy_method`	String
`send_strategy_options_is_local`	Boolean
`send_strategy_options_send_past_recipients_immediately`	Boolean
`send_strategy_options_static_datetime`	Instant
`send_strategy_options_static_is_local`	Boolean
`send_strategy_options_static_send_past_recipients_immediately`	Boolean
`send_strategy_options_sto_date`	LocalDate
`send_strategy_options_throttled_datetime`	Instant
`send_strategy_options_throttled_throttle_percentage`	Double
`send_time`	Instant
`status`	String
`tracking_options_add_tracking_params`	Boolean
`tracking_options_is_add_utm`	Boolean
`tracking_options_is_tracking_clicks`	Boolean
`tracking_options_is_tracking_opens`	Boolean
`updated`	Instant

form

Column	Type	Keys
`id`	String	PK
`ab_test`	Boolean
`created_at`	Instant
`name`	String
`status`	String
`updated_at`	Instant

Klaviyo

Explore the interactive ERD

Table & Field Reference

email_template

coupon_code

flow

segment_person

campaign_list

form_version

account_history

campaign_tracking_utm_param

list

list_exclusion

segment_tag

metric

segment

flow_action

coupon

campaign_message_send_time

list_person

tag_group

flow_action_tracking_utm_param

campaign_tag

event

tags

flow_tag

list_tag

global_exclusion

campaign_message

person

push_token

flow_message

campaign

form