Legend
🔑 = primary key
➤ = foreign key relation
⇱ = external link
id 🔑
extid
domain
engagement
email_hash
email_message
email_status
email_status_time
geolocation_city
geolocation_country
geolocation_state
geolocation_zip
last_pageview
opens
optout_time
pageviews
profile_created_date
purchase_incomplete
top_device
view_time
login_time
create_time
device
lifetime_pv
optout_email
custom_*
USER ⇱
list_id🔑 ➤ LIST
user_id🔑 ➤ USER
list_signup
USER_LIST ⇱
list🔑 ➤ LIST
count_time 🔑
dormant_count
hardbounce_count
lists_remove_count
spam_count
spam_loss_count
optout_loss_count
new_count
active_count
disengaged_count
email_count
emailable_count
engaged_count
lists_count
lists_signup_count
optout_count�passive_count�valid_count
custom_*
LIST_STAT ⇱
list_id🔑
list
create_time
send_time
type
primary
public_name
description
LIST ⇱
blast_id🔑
template_id ➤ TEMPLATE
list_id ➤ LIST
name
subject
list
mode
modify_user
copy_template
data_feed_url
status
start_time
modify_time
schedule_time
email_count
from_name
from_email
reply_to
content_html
context_text
is_google_analytics
is_link_tracking
report_email
content_app
app_id
app_badge
app_sound
app_data
is_public
email_hour_range
end_time
CAMPAIGN ⇱
_fivetran_purchase_id 🔑
date
user_id ➤ USER
campaign_id ➤ CAMPAIGN
extid
channel
PURCHASE ⇱
_fivetran_campaign_query_id 🔑
user_id ➤ USER
campaign_id ➤ CAMPAIGN
send_time
open_time
click_time
purchase_time
device
CAMPAIGN_QUERY ⇱
campaign_id🔑 ➤ CAMPAIGN
label_id🔑
label_name
CAMPAIGN_LABEL ⇱
campaign_id🔑 ➤ CAMPAIGN
seed_email_id🔑
CAMPAIGN_SEED_EMAIL ⇱
template_id🔑
name
subject
modify_time
mode
data_feed_url
is_disabled
sample
TEMPLATE ⇱
template_id🔑 ➤ TEMPLATE
label_id🔑
label_name
TEMPLATE_LABEL ⇱
template_id🔑 ➤ TEMPLATE
team_id🔑
team_name
TEMPLATE_TEAM ⇱
template_id🔑 ➤ TEMPLATE
tag_id🔑
tag_name
TEMPLATE_TAG ⇱
repeat_id🔑
list ➤ LIST
template ➤ TEMPLATE
name
data_feed_url
send_time
generate_time
report_email
start_date
end_date
status
create_time
modify_time
create_user
modify_user
error_time
CAMPAIGN_REPEAT ⇱
campaign_repeat_id🔑 ➤ CAMPAIGN_REPEAT
day🔑
CAMPAIGN_REPEAT_DAY_OF_MONTH ⇱
campaign_repeat_id🔑 ➤ CAMPAIGN_REPEAT
day🔑
CAMPAIGN_REPEAT_DAY_OF_WEEK ⇱
campaign_repeat_id🔑 ➤ CAMPAIGN_REPEAT
error_id🔑
error
CAMPAIGN_REPEAT_ERROR ⇱
plan_id🔑
list ➤ LIST
name
AD_PLAN ⇱
plan_id🔑 ➤ AD_PLAN
day 🔑
AD_PLAN_SCHEDULE ⇱
plan_id🔑 ➤ AD_PLAN
zone 🔑
name
width
height
AD_PLAN_ZONE ⇱
_fivetran_purchase_id🔑 ➤ PURCHASE
index 🔑
item
quantity
unit_price
url
PURCHASE_ITEM ⇱
_fivetran_campaign_query_id 🔑 ➤ CAMPAIGN_QUERY
click_id 🔑
click_url
click_time
CAMPAIGN_CLICK ⇱
Some column names for ‘USER’ and ‘LIST_STAT’ table might be prefixed with custom_
campaign_repeat_id🔑 ➤ CAMPAIGN
list_id🔑➤ LIST
CAMPAIGN_REPEAT_SUPPRESS_LIST ⇱
campaign_id🔑 ➤ CAMPAIGN
list_id🔑➤ LIST
CAMPAIGN_SUPPRESS_LIST ⇱
Custom fields are added separately with the prefix custom_ if the packing mode is UNPACKED. All custom fields are combined in custom_attributes if packing mode is PACKED. For more information, please see here.
Custom fields are added separately with the prefix custom_ if the packing mode is UNPACKED. All custom fields are combined in custom_attributes if packing mode is PACKED. For more information, please see here.
client_id🔑
account_id
name
ES_CLIENT
flow_id🔑
name
create_time
modify_time
version
client_id
ES_LIFECYCLE_OPTIMIZER_FLOW
campaign_id 🔑
client_id ➤ ES_CLIENT
template_id ➤ ES_TEMPLATE�name
from_name
from_email
replyto_email
subject�list_name�data_feed_url�preheader
schedule_time
report_email
supress_list
email_hour_range
create_time
start_time
ES_CAMPAIGN
template_id 🔑
client_id ➤ ES_CLIENT
name
create_time
modify_time
create_user
modify_user
from_name
from_email
replyto_email
subject�preheader
is_basic�data_feed_url
ES_TEMPLATE
message_id 🔑
campaign_id ➤ ES_CAMPAIGN
client_id ➤ ES_CLIENT
event_id
event_time
send_time
profile_id
email_sha256
email_md5
engagement
signup_time
list_id
browser�url
index
count
url_count
ip
ip_type
user_agent
is_real_click
ES_CAMPAIGN_CLICKS
message_id 🔑
campaign_id ➤ ES_CAMPAIGN
client_id ➤ ES_CLIENT
event_id
event_time
send_time
profile_id
email_sha256
email_md5
engagement
signup_time
list_id
browser
count
ip
ip_type
user_agent
is_real_open
ES_CAMPAIGN_OPENS
message_id🔑
campaign_id ➤ ES_CAMPAIGN
template_id ➤ ES_TEMPLATE
client_id ➤ ES_CLIENT
event_id
event_time
send_time
profile_id
email_sha256
email_md5
engagement
signup_time
list_name
list_id
subject
ES_CAMPAIGN_SENDS
message_id 🔑
campaign_id ➤ ES_CAMPAIGN
client_id ➤ ES_CLIENT
event_id
event_time
send_time
profile_id
email_sha256
email_md5
engagement
signup_time
list_id
message_type
ES_CAMPAIGN_UNSUBSCRIBES
message_id 🔑
campaign_id ➤ ES_CAMPAIGN
client_id ➤ ES_CLIENT
event_id
event_time
send_time
profile_id
email_sha256
email_md5
engagement
signup_time
list_id
reason_log
message_type
ES_CAMPAIGN_BOUNCES
message_id 🔑�client_id ➤ ES_CLIENT
template_id ➤ ES_TEMPLATE
flow_id ➤ ES_FLOW
event_id
event_time
send_time
profile_id
email_sha256
email_md5
engagement
signup_time
is_basic
ES_TRIGGERED_SENDS
message_id 🔑
client_id ➤ ES_CLIENT
template_id ➤ ES_TEMPLATE
event_id
event_time
send_time
profile_id
email_sha256
email_md5
engagement
signup_time
is_basic
message_type
ES_TRIGGERED_UNSUBSCRIBES
message_id 🔑
client_id ➤ ES_CLIENT
template_id ➤ ES_TEMPLATE
event_id
event_time
send_time
profile_id
email_sha256
email_md5
engagement
signup_time
is_basic
reason_log
message_type
ES_TRIGGERED_BOUNCES
Legend
🔑 = primary key
➤ = foreign key relation
ES_LIFECYCLE_OPTIMIZER_FLOW is being referred to as ES_FLOW
SAILTHRU CONNECT
ES is abbreviated form of EVENT_STREAM
message_id 🔑
client_id ➤ ES_CLIENT
template_id ➤ ES_TEMPLATE
flow_id ➤ ES_FLOW
event_id
event_time
send_time
profile_id
email_sha256
email_md5
engagement
signup_time
is_basic
browser
count
ip
ip_type
user_agent
is_real_open
ES_TRIGGERED_OPENS
message_id 🔑
client_id ➤ ES_CLIENT
template_id ➤ ES_TEMPLATE
flow_id ➤ ES_FLOW
event_id
event_time
send_time
profile_id
email_sha256
email_md5
engagement
signup_time
is_basic
browser�url
index
count
url_count
ip
ip_type
user_agent
is_real_click
ES_TRIGGERED_CLICKS