updated_at 🔑
id 🔑➤ TEMPLATES_HISTORY.id
campaign_id ➤ CAMPAIGN_HISTORY.id
cache_data_feed
data_feed_id
data_feed_ids
from_email
from_name
google_analytics_campaign_name
html
is_default_locale
locale
merge_data_feed_context
plain_text
preheader_text
reply_to_email
subject
EMAIL_TEMPLATE_HISTORY ⇱
updated_at 🔑
id 🔑➤ TEMPLATES_HISTORY.id
campaign_id ➤ CAMPAIGN_HISTORY.id
badge
buttons
cache_data_feed
data_feed_ids
deeplink_android
deeplink_ios
interruption_level�is_default_locale
is_silent_push
locale
merge_data_feed_context
message
payload
relevance_score
rich_media_andriod
rich_media_ios
sound
title
wake
PUSH_TEMPLATE_HISTORY ⇱
updated_at 🔑
id 🔑➤ TEMPLATES_HISTORY.id
campaign_id ➤ CAMPAIGN_HISTORY.id
google_analytics_campaign_name
image_url�is_default_locale
locale
message�tracking_domain
SMS_TEMPLATE_HISTORY ⇱
id 🔑
updated_at 🔑
recurring_campaign_id ➤ CAMPAIGN_HISTORY.id
template_id ➤ TEMPLATES_HISTORY.id�campaign_state
created_at
created_by_user_id
ended_at�message_medium
name
send_size
start_at
type
updated_by_user_Id
workflow_id
CAMPAIGN_HISTORY ⇱
id 🔑
updated_at 🔑
message_type_id ➤ MESSAGE_TYPE.id
client_template_id
created_at
creator_user_id
name
template_type
TEMPLATES_HISTORY ⇱
id 🔑 �created_at�description
list_type
name
LIST ⇱
Legend
🔑 = primary key
➤ = foreign key relation
⇱ = external link
id 🔑
channel_type
message_medium
name
CHANNEL ⇱
id 🔑
channel_id ➤ CHANNEL.id
created_at�frequency_cap�name�rate_limit_per_minute
subscription_policy�updated_at
MESSAGE_TYPE ⇱
_fivetran_id 🔑➤ USER_HISTORY._fivetran_id�message_type_id 🔑➤ MESSAGE_TYPE.id
USER_UNSUBSCRIBED_MESSAGE_TYPE ⇱
key 🔑
value 🔑
template_id 🔑➤ EMAIL_TEMPLATE_HISTORY.id
updated_at 🔑➤ EMAIL_TEMPLATE_HISTORY.updated_at
EMAIL_LINK_PARAM_HISTORY ⇱
email 🔑➤ USER_HISTORY.email
template_id 🔑➤ EMAIL_TEMPLATE_HISTORY.id
CC_EMAIL ⇱
email 🔑 ➤ USER_HISTORY.email
template_id 🔑➤ EMAIL_TEMPLATE_HISTORY.id
BCC_EMAIL ⇱
date 🔑
id 🔑➤ CAMPAIGN_HISTORY.id
average_order_value
purchases
revenue
revenue_m
total_app_uninstalls
total_complaints
total_email_bounced
total_email_clicked
total_email_delivered
total_email_opens
total_email_sends
total_hosted_unsubscribe_clicks
total_purchases
total_pushes_bounced
total_pushes_delivered
total_pushes_opened
total_pushes_sent
total_unsubscribes
unique_email_bounced
unique_email_clicks
unique_email_opens_or_clicks
unique_hosted_unsubscribe_clicks
unique_purchases
unique_pushes_bounced
unique_pushes_opened
unique_pushes_sent
unique_unsubscribes
Click here for the entire list.
CAMPAIGN_METRICS ⇱
_fivetran_id 🔑
updated_at 🔑�additional_properties
email_list_ids
first_name
iterable_user_id
last_name
phone_number
phone_number_details
phone_number_carrier
phone_number_country_code_iso
phone_number_line_type
phone_number_updated_at
signup_date
signup_source
user_id
USER_HISTORY ⇱
index 🔑 �_fivetran_id 🔑➤ USER_HISTORY._fivetran_id �additional_properties
application_name
endpoint_enabled
identifier_for_vendor
localized_model
model
platform
platform_endpoint
system_name
system_version
token
user_interface_idiom
USER_DEVICE ⇱
campaign_id 🔑 ➤ CAMPAIGN_HISTORY.id�list_id 🔑 ➤ LIST.id
updated_at 🔑➤ CAMPAIGN_HISTORY.updated_at
CAMPAIGN_LIST_HISTORY ⇱
campaign_id 🔑 ➤ CAMPAIGN_HISTORY.id�suppressed_list_id 🔑 ➤ LIST.id
updated_at 🔑➤ CAMPAIGN_HISTORY.updated_at
CAMPAIGN_SUPPRESSION_LIST_HISTORY ⇱
label 🔑
campaign_id 🔑 ➤ CAMPAIGN_HISTORY.id
updated_at 🔑➤ CAMPAIGN_HISTORY.updated_at
CAMPAIGN_LABEL_HISTORY ⇱
_fivetran_id 🔑➤ USER_HISTORY._fivetran_id�channel_id 🔑 ➤ CHANNEL.id
USER_UNSUBSCRIBED_CHANNEL ⇱
_fivetran_id 🔑�_fivetran_user_id 🔑➤ USER_HISTORY._fivetran_id
campaign_id ➤ CAMPAIGN_HISTORY.id
message_id
additional_properties�content_id
created_at
event_name
ip
is_custom_event
message_bus_id
message_type_id
recipient_state
status
transactional_data
unsub_source
user_agent
user_agent_device
EVENT ⇱
_fivetran_id 🔑➤ EVENT._fivetran_id�_fivetran_user_id 🔑➤ USER_HISTORY._fivetran_id
app_already_running
badge
browser_token
canonical_url_id�catalog_collection_count
catalog_lookup_count
content_available
content_id
city
clicked_url�country
deeplink_android
deeplink_ios
device
email_id
email_subject
error_code
expires_at
experiment_id
from_phone_number
from_phone_number_id
from_smssender_id�image_url
in_app_body
is_ghost_push
is_sms_estimation
labels
link_id
link_url
locale�message_context
message_status
mms_send_count
payload
platform_endpoint
product_recommendation_count
proxy_source
push_message�reason
region
sms_message
sms_provider_response_code
sms_provider_response_message
sms_provider_response_more_info
sms_provider_response_status
sms_send_count
sound
to_phone_number
url
workflow_id
workflow_name
web_push_body
web_push_click_action
web_push_icon
web_push_message
EVENT_EXTENSION ⇱
id 🔑 ➤ TEMPLATES_HISTORY.id
updated_at🔑 ➤ TEMPLATES_HISTORY.updated_at
campaign_id ➤ CAMPAIGN_HISTORY.id
buttons
client_template_id
content
content_version
dismissible
expiration_date_time
expiration_duration
frequency_cap
html
in_app_display_settings
inbox_metadata
is_default_locale
locale
locale_code
message_backend_content_id
message_class
message_format
message_format_id
message_id
message_name
messages
message_type_id
metadata
name
payload
state
web_in_app_display_settings
IN_APP_TEMPLATE_HISTORY ⇱
experiment_id 🔑➤ EVENT_EXTENSION.experiment_id
campaign_id 🔑 ➤ CAMPAIGN_HISTORY.id
template_id 🔑➤ TEMPLATES_HISTORY.id
date 🔑
name
type
created_by
creation_date
last_modified
subject
improvement
confidence
total_in_app_holdout
total_in_app_send_skips
total_in_app_sent
unique_in_app_sends
total_in_app_opens
unique_in_app_opens
total_in_app_clicks
unique_in_app_clicks
in_app_click_rate
total_in_apps_delivered
unique_in_apps_delivered
total_in_app_closes
total_in_app_deletes
total_unsubscribes
unique_unsubscribes
revenue
total_purchases
unique_purchases
average_order_value
total_inbox_impressions
Click here for the entire list.
EXPERIMENT_METRICS ⇱
key 🔑
value 🔑
template_id 🔑➤ SMS_TEMPLATE_HISTORY.id
updated_at 🔑➤ SMS_TEMPLATE_HISTORY.updated_at
SMS_LINK_PARAM_HISTORY ⇱
NOTE:�
index 🔑
_fivetran_id 🔑 ➤ USER_HISTORY.email
list_id 🔑 ➤ LIST.id
LIST_USER ⇱