Tables
ERD
24 tables
Expand all
Collapse all
campaign
22 columns
campaign_ab_split_opt
15 columns
campaign_recipient
10 columns
campaign_report_summary
10 columns
campaign_rss_opt
15 columns
campaign_setting
18 columns
campaign_tracking
7 columns
campaign_variate_setting
11 columns
campaign_variate_setting_combination
8 columns
member
28 columns
member_interest
2 columns
member_last_note
5 columns
member_location
8 columns
member_marketing_permission
5 columns
member_tag
2 columns
list_activity
12 columns
tag
3 columns
interest_category
6 columns
campaign_member_recipient
9 columns
segment
10 columns
list
48 columns
interest
7 columns
segment_member
4 columns
member_activity
10 columns
Loading diagram…
campaign
campaign
id
string
web_id
string
parent_campaign_id
string
type
string
create_time
date
archive_url
string
long_archive_url
string
status
string
emails_sent
long
send_time
date
content_type
string
needs_block_refresh
boolean
resendable
boolean
social_card_image_url
string
social_card_description
string
social_card_title
string
delivery_status_enabled
boolean
delivery_status_can_cancel
boolean
delivery_status_status
string
delivery_status_emails_sent
long
delivery_status_emails_canceled
long
_weld_synced
date
campaign_ab_split_opt
campaign_id
string
split_test
string
pick_winner
string
wait_units
string
wait_time
int
split_size
int
from_name_a
string
from_name_b
string
reply_email_a
string
reply_email_b
string
subject_a
string
subject_b
string
send_time_a
date
send_time_b
date
send_time_winner
string
campaign_recipient
campaign_id
string
list_id
string
list_is_active
boolean
list_name
string
segment_text
string
recipient_count
long
segment_opts_saved_segment_id
string
segment_opts_prebuilt_segment_id
string
segment_opts_match
string
segment_opts_conditions
string
campaign_report_summary
campaign_id
string
opens
long
unique_opens
long
open_rate
double
clicks
long
subscriber_clicks
long
click_rate
double
ecommerce_total_orders
long
ecommerce_total_spent
double
ecommerce_total_revenue
double
campaign_rss_opt
campaign_id
string
feed_url
string
frequency
string
schedule_hour
int
schedule_daily_send_sunday
boolean
schedule_daily_send_monday
boolean
schedule_daily_send_tuesday
boolean
schedule_daily_send_wednesday
boolean
schedule_daily_send_thursday
boolean
schedule_daily_send_friday
boolean
schedule_daily_send_saturday
boolean
schedule_weekly_send_day
string
schedule_monthly_send_date
int
last_sent
date
constrain_rss_img
boolean
campaign_setting
campaign_id
string
subject_line
string
preview_text
string
title
string
from_name
string
reply_to
string
use_conversation
boolean
to_name
string
folder_id
string
authenticate
boolean
auto_footer
boolean
inline_css
boolean
auto_tweet
boolean
auto_fb_post
string
fb_comments
boolean
timewarp
boolean
template_id
string
drag_and_drop
boolean
campaign_tracking
campaign_id
string
opens
boolean
html_clicks
boolean
text_clicks
boolean
ecomm_360
boolean
google_analytics
string
clicktale
string
campaign_variate_setting
campaign_id
string
winning_combination_id
string
winning_campaign_id
string
winner_criteria
string
wait_time
int
test_size
int
subject_lines
string
send_times
string
from_names
string
reply_to_addresses
string
contents
string
campaign_variate_setting_combination
id
string
campaign_id
string
subject_line
long
send_time
long
from_name
long
reply_to
long
content_description
long
recipients
long
member
member
id
string
list_id
string
email_address
string
unique_email_id
string
contact_id
string
full_name
string
web_id
string
email_type
string
status
string
unsubscribe_reason
string
consents_to_one_to_one_messaging
boolean
merge_fields
string
stats_avg_open_rate
double
stats_avg_click_rate
double
stats_ecommerce_data_total_revenue
double
stats_ecommerce_data_number_of_orders
double
stats_ecommerce_data_currency_code
string
ip_signup
string
timestamp_signup
date
ip_opt
string
timestamp_opt
date
member_rating
int
last_changed
date
language
string
vip
boolean
email_client
string
source
string
_weld_synced
date
member_interest
interest_id
string
member_id
string
member_last_note
member_id
string
note_id
string
created_at
date
created_by
string
note
string
member_location
member_id
string
latitude
double
longitude
double
gmtoff
double
dstoff
double
country_code
string
timezone
string
region
string
member_marketing_permission
member_id
string
index
int
marketing_permission_id
string
text
string
enabled
boolean
member_tag
tag_id
string
member_id
string
list_activity
list_id
string
day
date
emails_sent
long
unique_opens
long
recipient_clicks
long
hard_bounce
long
soft_bounce
long
subs
long
unsubs
long
other_adds
long
other_removes
long
_weld_synced
date
tag
id
string
name
string
_weld_synced
date
interest_category
id
string
list_id
string
title
string
display_order
int
type
string
_weld_synced
date
campaign_member_recipient
member_id
string
campaign_id
string
list_id
string
status
string
open_count
int
last_open
date
absplit_group
string
gmt_offset
double
_weld_synced
date
segment
id
string
list_id
string
name
string
member_count
long
type
string
created_at
date
updated_at
date
options_match
string
options_conditions
string
_weld_synced
date
list
id
string
web_id
string
name
string
contact_company
string
contact_address_1
string
contact_address_2
string
contact_city
string
contact_state
string
contact_zip
string
contact_country
string
contact_phone
string
permission_reminder
string
use_archive_bar
boolean
campaign_defaults_from_name
string
campaign_defaults_from_email
string
campaign_defaults_subject
string
campaign_defaults_language
string
notify_on_subscribe
string
notify_on_unsubscribe
string
date_created
date
list_rating
int
email_type_option
boolean
subscribe_url_short
string
subscribe_url_long
string
beamer_address
string
visibility
string
double_optin
boolean
has_welcome
boolean
marketing_permissions
boolean
modules
string
stats_member_count
long
stats_total_contacts
long
stats_unsubscribe_count
long
stats_cleaned_count
long
stats_member_count_since_send
long
stats_unsubscribe_count_since_send
long
stats_cleaned_count_since_send
long
stats_campaign_count
long
stats_campaign_last_sent
date
stats_merge_field_count
int
stats_avg_sub_rate
double
stats_avg_unsub_rate
double
stats_target_sub_rate
double
stats_open_rate
double
stats_click_rate
double
stats_last_sub_date
date
stats_last_unsub_date
date
_weld_synced
date
interest
id
string
list_id
string
category_id
string
name
string
subscriber_count
string
display_order
int
_weld_synced
date
segment_member
member_id
string
segment_id
string
list_id
string
_weld_synced
date
member_activity
list_id
string
member_id
string
campaign_id
string
action
string
timestamp
date
url
string
type
string
title
string
parent_campaign
string
_weld_synced
date
Table
Sub table
Press enter or space to select a node. You can then use the arrow keys to move the node around. Press delete to remove it and escape to cancel.
Press enter or space to select an edge. You can then press delete to remove it or escape to cancel.