JSData & Media Start a project

← All connectors

Schema · Entity relationship diagram

Klaviyo tables and relationships

Email and SMS campaigns, flows and their messages, lists, segments, metrics, profiles and every event, plus per-campaign and daily per-flow-message performance (recipients, opens, clicks, conversions, revenue).

Live12 tables · 15 relationships
ConnectPaste an API key
Default schemaklaviyo
Source API docshelp.klaviyo.com
DestinationsAmazon Redshift, Google BigQuery, Snowflake, PostgreSQL, Amazon S3
  • One table per Klaviyo API resource; nested attributes are flattened with _ (e.g. send_strategy.options.is_local is send_strategy_options_is_local).
  • campaign_values_report and flow_series_report (daily) come from Klaviyo's Reporting API (the numbers Klaviyo shows in its UI).
  • event.datetime holds the event time (Klaviyo's timestamp; renamed because TIMESTAMP is a reserved word in Redshift).
LISTS & SEGMENTScampaign_message.campaign_id → campaign.idflow_action.flow_id → flow.idflow_message.flow_action_id → flow_action.idflow_message.flow_id → flow.idevent.metric_id → metric.idevent.profile_id → profile.idevent.campaign_id → campaign.idevent.flow_id → flow.idevent.flow_message_id → flow_message.idcampaign_values_report.campaign_id → campaign.idcampaign_values_report.campaign_message_id → campaign_message.idflow_series_report.flow_id → flow.idflow_series_report.flow_message_id → flow_message.idcampaign_values_report.conversion_metric_id → metric.idflow_series_report.conversion_metric_id → metric.idcampaigncampaign22id VARCHAR(64) · primary keyidvarcharname VARCHAR(1024)namevarcharstatus VARCHAR(64)statusvarchararchived BOOLEANarchivedboolaudiences VARCHAR(65535)audiencesvarcharsend_options_use_smart_sending BOOLEANsend_options_use_smart_sendingbooltracking_options_add_tracking_params BOOLEANtracking_options_add_tracking_paramsbooltracking_options_custom_tracking_params VARCHAR(65535)tracking_options_custom_tracking_paramsvarchartracking_options_is_tracking_clicks BOOLEANtracking_options_is_tracking_clicksbooltracking_options_is_tracking_opens BOOLEANtracking_options_is_tracking_opensboolsend_strategy_method VARCHAR(64)send_strategy_methodvarcharsend_strategy_datetime TIMESTAMPsend_strategy_datetimetimestampsend_strategy_options_is_local BOOLEANsend_strategy_options_is_localboolsend_strategy_options_send_past_recipients_immediately BOOLEANsend_strategy_options_send_past_recipients_immediate…boolsend_strategy_throttle_percentage DECIMAL(9,4)send_strategy_throttle_percentagedecimalsend_strategy_date DATEsend_strategy_datedatecreated_at TIMESTAMPcreated_attimestampscheduled_at TIMESTAMPscheduled_attimestampupdated_at TIMESTAMPupdated_attimestampsend_time TIMESTAMPsend_timetimestampchannel VARCHAR(32)channelvarchar_jsdata_synced TIMESTAMP_jsdata_syncedtimestampcampaign_messagecampaign_message22id VARCHAR(64) · primary keyidvarcharcampaign_id VARCHAR(64) · → campaign.idcampaign_idvarchartemplate_id VARCHAR(64)template_idvarcharchannel VARCHAR(32)channelvarcharlabel VARCHAR(1024)labelvarcharcontent_subject VARCHAR(2048)content_subjectvarcharcontent_preview_text VARCHAR(2048)content_preview_textvarcharcontent_from_email VARCHAR(512)content_from_emailvarcharcontent_from_label VARCHAR(512)content_from_labelvarcharcontent_reply_to_email VARCHAR(512)content_reply_to_emailvarcharcontent_cc_email VARCHAR(512)content_cc_emailvarcharcontent_bcc_email VARCHAR(512)content_bcc_emailvarcharcontent_body VARCHAR(65535)content_bodyvarcharcontent_media_url VARCHAR(2048)content_media_urlvarcharrender_options_shorten_links BOOLEANrender_options_shorten_linksboolrender_options_add_org_prefix BOOLEANrender_options_add_org_prefixboolrender_options_add_info_link BOOLEANrender_options_add_info_linkboolrender_options_add_opt_out_language BOOLEANrender_options_add_opt_out_languageboolrender_options_include_contact_card BOOLEANrender_options_include_contact_cardboolcreated_at TIMESTAMPcreated_attimestampupdated_at TIMESTAMPupdated_attimestamp_jsdata_synced TIMESTAMP_jsdata_syncedtimestamplistlist6id VARCHAR(64) · primary keyidvarcharname VARCHAR(1024)namevarcharcreated TIMESTAMPcreatedtimestampupdated TIMESTAMPupdatedtimestampopt_in_process VARCHAR(64)opt_in_processvarchar_jsdata_synced TIMESTAMP_jsdata_syncedtimestampsegmentsegment9id VARCHAR(64) · primary keyidvarcharname VARCHAR(1024)namevarchardefinition VARCHAR(65535)definitionvarcharcreated TIMESTAMPcreatedtimestampupdated TIMESTAMPupdatedtimestampis_active BOOLEANis_activeboolis_processing BOOLEANis_processingboolis_starred BOOLEANis_starredbool_jsdata_synced TIMESTAMP_jsdata_syncedtimestampcampaign_values_reportcampaign_values_report43_jsdata_key VARCHAR(32) · primary key_jsdata_keyvarcharcampaign_id VARCHAR(64) · → campaign.idcampaign_idvarcharcampaign_message_id VARCHAR(64) · → campaign_message.idcampaign_message_idvarcharconversion_metric_id VARCHAR(64) · → metric.idconversion_metric_idvarcharsend_channel VARCHAR(32)send_channelvarcharvariation VARCHAR(128)variationvarcharvariation_name VARCHAR(1024)variation_namevarcharcampaign_name VARCHAR(1024)campaign_namevarcharcampaign_message_name VARCHAR(1024)campaign_message_namevarcharsend_time TIMESTAMPsend_timetimestampsend_date DATEsend_datedaterecipients BIGINTrecipientsbigintdelivered BIGINTdeliveredbigintdelivery_rate DECIMAL(18,6)delivery_ratedecimalbounced BIGINTbouncedbigintbounce_rate DECIMAL(18,6)bounce_ratedecimalfailed BIGINTfailedbigintfailed_rate DECIMAL(18,6)failed_ratedecimalbounced_or_failed BIGINTbounced_or_failedbigintbounced_or_failed_rate DECIMAL(18,6)bounced_or_failed_ratedecimalopens BIGINTopensbigintopens_unique BIGINTopens_uniquebigintopen_rate DECIMAL(18,6)open_ratedecimalclicks BIGINTclicksbigintclicks_unique BIGINTclicks_uniquebigintclick_rate DECIMAL(18,6)click_ratedecimalclick_to_open_rate DECIMAL(18,6)click_to_open_ratedecimalconversions BIGINTconversionsbigintconversion_uniques BIGINTconversion_uniquesbigintconversion_rate DECIMAL(18,6)conversion_ratedecimalconversion_value DECIMAL(18,4)conversion_valuedecimalaverage_order_value DECIMAL(18,4)average_order_valuedecimalrevenue_per_recipient DECIMAL(18,6)revenue_per_recipientdecimalunsubscribes BIGINTunsubscribesbigintunsubscribe_uniques BIGINTunsubscribe_uniquesbigintunsubscribe_rate DECIMAL(18,6)unsubscribe_ratedecimalspam_complaints BIGINTspam_complaintsbigintspam_complaint_rate DECIMAL(18,6)spam_complaint_ratedecimalmessage_segment_count_sum BIGINTmessage_segment_count_sumbiginttext_message_credit_usage_amount DECIMAL(18,4)text_message_credit_usage_amountdecimaltext_message_spend DECIMAL(18,4)text_message_spenddecimaltext_message_roi DECIMAL(18,6)text_message_roidecimal_jsdata_synced TIMESTAMP_jsdata_syncedtimestampevent — metric_name: the event's metric (denormalised from metric.name). flow_id, flow_message_id, campaign_id, variation and value come from the event's $flow / $message / $campaign / $variation / $value proevent13id VARCHAR(64) · primary keyidvarcharmetric_id VARCHAR(64) · → metric.idmetric_idvarcharprofile_id VARCHAR(64) · → profile.idprofile_idvarcharcampaign_id VARCHAR(64) · → campaign.idcampaign_idvarcharflow_id VARCHAR(64) · → flow.idflow_idvarcharflow_message_id VARCHAR(64) · → flow_message.idflow_message_idvarcharuuid VARCHAR(64)uuidvarchardatetime TIMESTAMPdatetimetimestampmetric_name VARCHAR(512)metric_namevarcharvariation VARCHAR(128)variationvarcharvalue DECIMAL(18,4)valuedecimalevent_properties VARCHAR(65535)event_propertiesvarchar_jsdata_synced TIMESTAMP_jsdata_syncedtimestampprofileprofile54id VARCHAR(64) · primary keyidvarcharemail VARCHAR(512)emailvarcharphone_number VARCHAR(64)phone_numbervarcharexternal_id VARCHAR(256)external_idvarcharfirst_name VARCHAR(512)first_namevarcharlast_name VARCHAR(512)last_namevarcharorganization VARCHAR(512)organizationvarcharlocale VARCHAR(64)localevarchartitle VARCHAR(512)titlevarcharimage VARCHAR(2048)imagevarcharcreated TIMESTAMPcreatedtimestampupdated TIMESTAMPupdatedtimestamplast_event_date TIMESTAMPlast_event_datetimestamplocation_address1 VARCHAR(512)location_address1varcharlocation_address2 VARCHAR(512)location_address2varcharlocation_city VARCHAR(256)location_cityvarcharlocation_country VARCHAR(256)location_countryvarcharlocation_region VARCHAR(256)location_regionvarcharlocation_zip VARCHAR(64)location_zipvarcharlocation_timezone VARCHAR(128)location_timezonevarcharlocation_ip VARCHAR(64)location_ipvarcharlocation_latitude VARCHAR(64)location_latitudevarcharlocation_longitude VARCHAR(64)location_longitudevarcharproperties VARCHAR(65535)propertiesvarcharsubscriptions_email_marketing_can_receive_email_marketing BOOLEANsubscriptions_email_marketing_can_receive_email_mark…boolsubscriptions_email_marketing_consent VARCHAR(64)subscriptions_email_marketing_consentvarcharsubscriptions_email_marketing_consent_timestamp TIMESTAMPsubscriptions_email_marketing_consent_timestamptimestampsubscriptions_email_marketing_last_updated TIMESTAMPsubscriptions_email_marketing_last_updatedtimestampsubscriptions_email_marketing_method VARCHAR(128)subscriptions_email_marketing_methodvarcharsubscriptions_email_marketing_method_detail VARCHAR(512)subscriptions_email_marketing_method_detailvarcharsubscriptions_email_marketing_custom_method_detail VARCHAR(512)subscriptions_email_marketing_custom_method_detailvarcharsubscriptions_email_marketing_double_optin VARCHAR(16)subscriptions_email_marketing_double_optinvarcharsubscriptions_sms_marketing_can_receive_sms_marketing BOOLEANsubscriptions_sms_marketing_can_receive_sms_marketingboolsubscriptions_sms_marketing_consent VARCHAR(64)subscriptions_sms_marketing_consentvarcharsubscriptions_sms_marketing_consent_timestamp TIMESTAMPsubscriptions_sms_marketing_consent_timestamptimestampsubscriptions_sms_marketing_last_updated TIMESTAMPsubscriptions_sms_marketing_last_updatedtimestampsubscriptions_sms_marketing_method VARCHAR(128)subscriptions_sms_marketing_methodvarcharsubscriptions_sms_marketing_method_detail VARCHAR(512)subscriptions_sms_marketing_method_detailvarcharsubscriptions_mobile_push_marketing_can_receive_push_marketing BOOLEANsubscriptions_mobile_push_marketing_can_receive_push…boolsubscriptions_mobile_push_marketing_consent VARCHAR(64)subscriptions_mobile_push_marketing_consentvarcharsubscriptions_mobile_push_marketing_consent_timestamp TIMESTAMPsubscriptions_mobile_push_marketing_consent_time…timestampsubscriptions_mobile_push_marketing_last_updated TIMESTAMPsubscriptions_mobile_push_marketing_last_updatedtimestampsubscriptions_mobile_push_marketing_method VARCHAR(128)subscriptions_mobile_push_marketing_methodvarcharsubscriptions_mobile_push_marketing_method_detail VARCHAR(512)subscriptions_mobile_push_marketing_method_detailvarcharpredictive_analytics_historic_clv DECIMAL(18,4)predictive_analytics_historic_clvdecimalpredictive_analytics_predicted_clv DECIMAL(18,4)predictive_analytics_predicted_clvdecimalpredictive_analytics_total_clv DECIMAL(18,4)predictive_analytics_total_clvdecimalpredictive_analytics_historic_number_of_orders DECIMAL(18,4)predictive_analytics_historic_number_of_ordersdecimalpredictive_analytics_predicted_number_of_orders DECIMAL(18,4)predictive_analytics_predicted_number_of_ordersdecimalpredictive_analytics_average_days_between_orders DECIMAL(18,4)predictive_analytics_average_days_between_ordersdecimalpredictive_analytics_average_order_value DECIMAL(18,4)predictive_analytics_average_order_valuedecimalpredictive_analytics_churn_probability DECIMAL(18,6)predictive_analytics_churn_probabilitydecimalpredictive_analytics_expected_date_of_next_order TIMESTAMPpredictive_analytics_expected_date_of_next_ordertimestamp_jsdata_synced TIMESTAMP_jsdata_syncedtimestampmetricmetric9id VARCHAR(64) · primary keyidvarcharname VARCHAR(512)namevarcharcreated TIMESTAMPcreatedtimestampupdated TIMESTAMPupdatedtimestampintegration_id VARCHAR(64)integration_idvarcharintegration_name VARCHAR(256)integration_namevarcharintegration_category VARCHAR(256)integration_categoryvarcharintegration_object VARCHAR(128)integration_objectvarchar_jsdata_synced TIMESTAMP_jsdata_syncedtimestampflow_series_reportflow_series_report41_jsdata_key VARCHAR(32) · primary key_jsdata_keyvarcharflow_id VARCHAR(64) · → flow.idflow_idvarcharflow_message_id VARCHAR(64) · → flow_message.idflow_message_idvarcharconversion_metric_id VARCHAR(64) · → metric.idconversion_metric_idvarchardate DATEdatedatesend_channel VARCHAR(32)send_channelvarcharvariation VARCHAR(128)variationvarcharvariation_name VARCHAR(1024)variation_namevarcharflow_name VARCHAR(1024)flow_namevarcharrecipients BIGINTrecipientsbigintdelivered BIGINTdeliveredbigintdelivery_rate DECIMAL(18,6)delivery_ratedecimalbounced BIGINTbouncedbigintbounce_rate DECIMAL(18,6)bounce_ratedecimalfailed BIGINTfailedbigintfailed_rate DECIMAL(18,6)failed_ratedecimalbounced_or_failed BIGINTbounced_or_failedbigintbounced_or_failed_rate DECIMAL(18,6)bounced_or_failed_ratedecimalopens BIGINTopensbigintopens_unique BIGINTopens_uniquebigintopen_rate DECIMAL(18,6)open_ratedecimalclicks BIGINTclicksbigintclicks_unique BIGINTclicks_uniquebigintclick_rate DECIMAL(18,6)click_ratedecimalclick_to_open_rate DECIMAL(18,6)click_to_open_ratedecimalconversions BIGINTconversionsbigintconversion_uniques BIGINTconversion_uniquesbigintconversion_rate DECIMAL(18,6)conversion_ratedecimalconversion_value DECIMAL(18,4)conversion_valuedecimalaverage_order_value DECIMAL(18,4)average_order_valuedecimalrevenue_per_recipient DECIMAL(18,6)revenue_per_recipientdecimalunsubscribes BIGINTunsubscribesbigintunsubscribe_uniques BIGINTunsubscribe_uniquesbigintunsubscribe_rate DECIMAL(18,6)unsubscribe_ratedecimalspam_complaints BIGINTspam_complaintsbigintspam_complaint_rate DECIMAL(18,6)spam_complaint_ratedecimalmessage_segment_count_sum BIGINTmessage_segment_count_sumbiginttext_message_credit_usage_amount DECIMAL(18,4)text_message_credit_usage_amountdecimaltext_message_spend DECIMAL(18,4)text_message_spenddecimaltext_message_roi DECIMAL(18,6)text_message_roidecimal_jsdata_synced TIMESTAMP_jsdata_syncedtimestampflowflow8id VARCHAR(64) · primary keyidvarchararchived BOOLEANarchivedboolcreated TIMESTAMPcreatedtimestampname VARCHAR(1024)namevarcharstatus VARCHAR(64)statusvarchartrigger_type VARCHAR(128)trigger_typevarcharupdated TIMESTAMPupdatedtimestamp_jsdata_synced TIMESTAMP_jsdata_syncedtimestampflow_messageflow_message17id VARCHAR(64) · primary keyidvarcharflow_action_id VARCHAR(64) · → flow_action.idflow_action_idvarcharflow_id VARCHAR(64) · → flow.idflow_idvarchartemplate_id VARCHAR(64)template_idvarcharname VARCHAR(1024)namevarcharchannel VARCHAR(32)channelvarcharcontent_subject VARCHAR(2048)content_subjectvarcharcontent_preview_text VARCHAR(2048)content_preview_textvarcharcontent_from_email VARCHAR(512)content_from_emailvarcharcontent_from_label VARCHAR(512)content_from_labelvarcharcontent_reply_to_email VARCHAR(512)content_reply_to_emailvarcharcontent_cc_email VARCHAR(512)content_cc_emailvarcharcontent_bcc_email VARCHAR(512)content_bcc_emailvarcharcontent_body VARCHAR(65535)content_bodyvarcharcreated TIMESTAMPcreatedtimestampupdated TIMESTAMPupdatedtimestamp_jsdata_synced TIMESTAMP_jsdata_syncedtimestampflow_actionflow_action17id VARCHAR(64) · primary keyidvarcharflow_id VARCHAR(64) · → flow.idflow_idvarcharaction_type VARCHAR(128)action_typevarcharstatus VARCHAR(64)statusvarcharcreated TIMESTAMPcreatedtimestampupdated TIMESTAMPupdatedtimestamptracking_options_add_tracking_params BOOLEANtracking_options_add_tracking_paramsbooltracking_options_is_tracking_clicks BOOLEANtracking_options_is_tracking_clicksbooltracking_options_is_tracking_opens BOOLEANtracking_options_is_tracking_opensboolsend_options_use_smart_sending BOOLEANsend_options_use_smart_sendingboolsend_options_is_transactional BOOLEANsend_options_is_transactionalboolrender_options_shorten_links BOOLEANrender_options_shorten_linksboolrender_options_add_org_prefix BOOLEANrender_options_add_org_prefixboolrender_options_add_info_link BOOLEANrender_options_add_info_linkboolrender_options_add_opt_out_language BOOLEANrender_options_add_opt_out_languageboolrender_options_include_contact_card BOOLEANrender_options_include_contact_cardbool_jsdata_synced TIMESTAMP_jsdata_syncedtimestamp
Primary keyForeign keyReferencesJoins on (not a key)

Drag to pan, scroll or pinch to zoom, click a table to see what it joins to.

Table reference

12 tables · click a table for its columns
campaign22 columns · Campaignsshow in diagram

Primary key: id

ColumnTypeKeyDescription
idPrimary key.varchar(64)PK Primary key.
namevarchar(1024)
statusvarchar(64)
archivedboolean
audiencesvarchar(65535)
send_options_use_smart_sendingboolean
tracking_options_add_tracking_paramsboolean
tracking_options_custom_tracking_paramsvarchar(65535)
tracking_options_is_tracking_clicksboolean
tracking_options_is_tracking_opensboolean
send_strategy_methodvarchar(64)
send_strategy_datetimetimestamp
send_strategy_options_is_localboolean
send_strategy_options_send_past_recipients_immediatelyboolean
send_strategy_throttle_percentagedecimal(9,4)
send_strategy_datedate
created_attimestamp
scheduled_attimestamp
updated_attimestamp
send_timetimestamp
channelvarchar(32)
_jsdata_syncedWhen jsdata last wrote this row.timestampWhen jsdata last wrote this row.
campaign_message22 columns · Campaignsshow in diagram

Primary key: id

ColumnTypeKeyDescription
idPrimary key.varchar(64)PK Primary key.
campaign_idReferences campaign.id.varchar(64)FKReferences campaign.id.
template_idvarchar(64)
channelvarchar(32)
labelvarchar(1024)
content_subjectvarchar(2048)
content_preview_textvarchar(2048)
content_from_emailvarchar(512)
content_from_labelvarchar(512)
content_reply_to_emailvarchar(512)
content_cc_emailvarchar(512)
content_bcc_emailvarchar(512)
content_bodyvarchar(65535)
content_media_urlvarchar(2048)
render_options_shorten_linksboolean
render_options_add_org_prefixboolean
render_options_add_info_linkboolean
render_options_add_opt_out_languageboolean
render_options_include_contact_cardboolean
created_attimestamp
updated_attimestamp
_jsdata_syncedWhen jsdata last wrote this row.timestampWhen jsdata last wrote this row.
campaign_values_report43 columns · Campaignsshow in diagram

Primary key: _jsdata_key

ColumnTypeKeyDescription
_jsdata_keyPrimary key.varchar(32)PK Primary key.
campaign_idReferences campaign.id.varchar(64)FKReferences campaign.id.
campaign_message_idReferences campaign_message.id.varchar(64)FKReferences campaign_message.id.
send_channelvarchar(32)
variationvarchar(128)
variation_namevarchar(1024)
campaign_namevarchar(1024)
campaign_message_namevarchar(1024)
send_timetimestamp
send_datedate
recipientsbigint
deliveredbigint
delivery_ratedecimal(18,6)
bouncedbigint
bounce_ratedecimal(18,6)
failedbigint
failed_ratedecimal(18,6)
bounced_or_failedbigint
bounced_or_failed_ratedecimal(18,6)
opensbigint
opens_uniquebigint
open_ratedecimal(18,6)
clicksbigint
clicks_uniquebigint
click_ratedecimal(18,6)
click_to_open_ratedecimal(18,6)
conversionsbigint
conversion_uniquesbigint
conversion_ratedecimal(18,6)
conversion_valuedecimal(18,4)
average_order_valuedecimal(18,4)
revenue_per_recipientdecimal(18,6)
unsubscribesbigint
unsubscribe_uniquesbigint
unsubscribe_ratedecimal(18,6)
spam_complaintsbigint
spam_complaint_ratedecimal(18,6)
message_segment_count_sumbigint
text_message_credit_usage_amountdecimal(18,4)
text_message_spenddecimal(18,4)
text_message_roidecimal(18,6)
conversion_metric_idReferences metric.id.varchar(64)FKReferences metric.id.
_jsdata_syncedWhen jsdata last wrote this row.timestampWhen jsdata last wrote this row.
flow8 columns · Flowsshow in diagram

Primary key: id

ColumnTypeKeyDescription
idPrimary key.varchar(64)PK Primary key.
archivedboolean
createdtimestamp
namevarchar(1024)
statusvarchar(64)
trigger_typevarchar(128)
updatedtimestamp
_jsdata_syncedWhen jsdata last wrote this row.timestampWhen jsdata last wrote this row.
flow_action17 columns · Flowsshow in diagram

Primary key: id

ColumnTypeKeyDescription
idPrimary key.varchar(64)PK Primary key.
flow_idReferences flow.id.varchar(64)FKReferences flow.id.
action_typevarchar(128)
statusvarchar(64)
createdtimestamp
updatedtimestamp
tracking_options_add_tracking_paramsboolean
tracking_options_is_tracking_clicksboolean
tracking_options_is_tracking_opensboolean
send_options_use_smart_sendingboolean
send_options_is_transactionalboolean
render_options_shorten_linksboolean
render_options_add_org_prefixboolean
render_options_add_info_linkboolean
render_options_add_opt_out_languageboolean
render_options_include_contact_cardboolean
_jsdata_syncedWhen jsdata last wrote this row.timestampWhen jsdata last wrote this row.
flow_message17 columns · Flowsshow in diagram

Primary key: id

ColumnTypeKeyDescription
idPrimary key.varchar(64)PK Primary key.
flow_action_idReferences flow_action.id.varchar(64)FKReferences flow_action.id.
flow_idReferences flow.id.varchar(64)FKReferences flow.id.
template_idvarchar(64)
namevarchar(1024)
channelvarchar(32)
content_subjectvarchar(2048)
content_preview_textvarchar(2048)
content_from_emailvarchar(512)
content_from_labelvarchar(512)
content_reply_to_emailvarchar(512)
content_cc_emailvarchar(512)
content_bcc_emailvarchar(512)
content_bodyvarchar(65535)
createdtimestamp
updatedtimestamp
_jsdata_syncedWhen jsdata last wrote this row.timestampWhen jsdata last wrote this row.
flow_series_report41 columns · Flowsshow in diagram

Primary key: _jsdata_key

ColumnTypeKeyDescription
_jsdata_keyPrimary key.varchar(32)PK Primary key.
datedate
flow_idReferences flow.id.varchar(64)FKReferences flow.id.
flow_message_idReferences flow_message.id.varchar(64)FKReferences flow_message.id.
send_channelvarchar(32)
variationvarchar(128)
variation_namevarchar(1024)
flow_namevarchar(1024)
recipientsbigint
deliveredbigint
delivery_ratedecimal(18,6)
bouncedbigint
bounce_ratedecimal(18,6)
failedbigint
failed_ratedecimal(18,6)
bounced_or_failedbigint
bounced_or_failed_ratedecimal(18,6)
opensbigint
opens_uniquebigint
open_ratedecimal(18,6)
clicksbigint
clicks_uniquebigint
click_ratedecimal(18,6)
click_to_open_ratedecimal(18,6)
conversionsbigint
conversion_uniquesbigint
conversion_ratedecimal(18,6)
conversion_valuedecimal(18,4)
average_order_valuedecimal(18,4)
revenue_per_recipientdecimal(18,6)
unsubscribesbigint
unsubscribe_uniquesbigint
unsubscribe_ratedecimal(18,6)
spam_complaintsbigint
spam_complaint_ratedecimal(18,6)
message_segment_count_sumbigint
text_message_credit_usage_amountdecimal(18,4)
text_message_spenddecimal(18,4)
text_message_roidecimal(18,6)
conversion_metric_idReferences metric.id.varchar(64)FKReferences metric.id.
_jsdata_syncedWhen jsdata last wrote this row.timestampWhen jsdata last wrote this row.
metric9 columns · Profiles & eventsshow in diagram

Primary key: id

ColumnTypeKeyDescription
idPrimary key.varchar(64)PK Primary key.
namevarchar(512)
createdtimestamp
updatedtimestamp
integration_idvarchar(64)
integration_namevarchar(256)
integration_categoryvarchar(256)
integration_objectvarchar(128)
_jsdata_syncedWhen jsdata last wrote this row.timestampWhen jsdata last wrote this row.
profile54 columns · Profiles & eventsshow in diagram

Primary key: id

ColumnTypeKeyDescription
idPrimary key.varchar(64)PK Primary key.
emailvarchar(512)
phone_numbervarchar(64)
external_idvarchar(256)
first_namevarchar(512)
last_namevarchar(512)
organizationvarchar(512)
localevarchar(64)
titlevarchar(512)
imagevarchar(2048)
createdtimestamp
updatedtimestamp
last_event_datetimestamp
location_address1varchar(512)
location_address2varchar(512)
location_cityvarchar(256)
location_countryvarchar(256)
location_regionvarchar(256)
location_zipvarchar(64)
location_timezonevarchar(128)
location_ipvarchar(64)
location_latitudevarchar(64)
location_longitudevarchar(64)
propertiesvarchar(65535)
subscriptions_email_marketing_can_receive_email_marketingboolean
subscriptions_email_marketing_consentvarchar(64)
subscriptions_email_marketing_consent_timestamptimestamp
subscriptions_email_marketing_last_updatedtimestamp
subscriptions_email_marketing_methodvarchar(128)
subscriptions_email_marketing_method_detailvarchar(512)
subscriptions_email_marketing_custom_method_detailvarchar(512)
subscriptions_email_marketing_double_optinvarchar(16)
subscriptions_sms_marketing_can_receive_sms_marketingboolean
subscriptions_sms_marketing_consentvarchar(64)
subscriptions_sms_marketing_consent_timestamptimestamp
subscriptions_sms_marketing_last_updatedtimestamp
subscriptions_sms_marketing_methodvarchar(128)
subscriptions_sms_marketing_method_detailvarchar(512)
subscriptions_mobile_push_marketing_can_receive_push_marketingboolean
subscriptions_mobile_push_marketing_consentvarchar(64)
subscriptions_mobile_push_marketing_consent_timestamptimestamp
subscriptions_mobile_push_marketing_last_updatedtimestamp
subscriptions_mobile_push_marketing_methodvarchar(128)
subscriptions_mobile_push_marketing_method_detailvarchar(512)
predictive_analytics_historic_clvdecimal(18,4)
predictive_analytics_predicted_clvdecimal(18,4)
predictive_analytics_total_clvdecimal(18,4)
predictive_analytics_historic_number_of_ordersdecimal(18,4)
predictive_analytics_predicted_number_of_ordersdecimal(18,4)
predictive_analytics_average_days_between_ordersdecimal(18,4)
predictive_analytics_average_order_valuedecimal(18,4)
predictive_analytics_churn_probabilitydecimal(18,6)
predictive_analytics_expected_date_of_next_ordertimestamp
_jsdata_syncedWhen jsdata last wrote this row.timestampWhen jsdata last wrote this row.
event13 columns · Profiles & eventsshow in diagram

metric_name: the event's metric (denormalised from metric.name). flow_id, flow_message_id, campaign_id, variation and value come from the event's $flow / $message / $campaign / $variation / $value properties.

Primary key: id

ColumnTypeKeyDescription
idPrimary key.varchar(64)PK Primary key.
uuidvarchar(64)
datetimetimestamp
metric_idReferences metric.id.varchar(64)FKReferences metric.id.
metric_namevarchar(512)
profile_idReferences profile.id.varchar(64)FKReferences profile.id.
campaign_idReferences campaign.id.varchar(64)FKReferences campaign.id.
flow_idReferences flow.id.varchar(64)FKReferences flow.id.
flow_message_idReferences flow_message.id.varchar(64)FKReferences flow_message.id.
variationvarchar(128)
valuedecimal(18,4)
event_propertiesvarchar(65535)
_jsdata_syncedWhen jsdata last wrote this row.timestampWhen jsdata last wrote this row.
list6 columns · Lists & segmentsshow in diagram

Primary key: id

ColumnTypeKeyDescription
idPrimary key.varchar(64)PK Primary key.
namevarchar(1024)
createdtimestamp
updatedtimestamp
opt_in_processvarchar(64)
_jsdata_syncedWhen jsdata last wrote this row.timestampWhen jsdata last wrote this row.
segment9 columns · Lists & segmentsshow in diagram

Primary key: id

ColumnTypeKeyDescription
idPrimary key.varchar(64)PK Primary key.
namevarchar(1024)
definitionvarchar(65535)
createdtimestamp
updatedtimestamp
is_activeboolean
is_processingboolean
is_starredboolean
_jsdata_syncedWhen jsdata last wrote this row.timestampWhen jsdata last wrote this row.

Connect Klaviyo All connectors