Zoho Campaigns

Explore the interactive ERD

Table & Field Reference

product

Column	Type	Keys
`product_id`	Unknown	PK
`product_name`	Unknown

workflow

Column	Type	Keys
`_fivetran_id`	String	PK
`created_time`	Unknown
`trigger_key`	Unknown
`workflow_key`	Unknown
`workflow_name`	Unknown

recent_campaign

Column	Type	Keys
`campaign_key`	Unknown	PK
`campaign_name`	Unknown
`campaign_preview`	Unknown
`campaign_status`	Unknown
`campaign_type`	Unknown
`created_date_string`	Unknown
`created_time`	Unknown
`created_time_gmt`	Unknown
`folder_id`	Unknown
`from_email`	Unknown
`is_hybrid`	Unknown
`reply_to`	Unknown
`sent_date_string`	Unknown
`sent_time`	Unknown
`sent_time_gmt`	Unknown
`sent_time_zone`	Unknown
`subject`	Unknown
`updated_date_string`	Unknown
`updated_time`	Unknown
`updated_time_gmt`	Unknown
`zu_id`	Unknown

contact_field

Column	Type	Keys
`field_id`	Unknown	PK
`block_label`	Unknown
`block_sequence`	Unknown
`display_name`	Unknown
`field_display_name`	Unknown
`field_name`	Unknown
`is_mandatory`	Unknown
`is_otheruser_field`	Unknown
`max_length`	Unknown
`sequence`	Unknown
`type`	Unknown
`ui_type`	Unknown
`values`	Unknown

contact_count

Column	Type	Keys
`_fivetran_id`	String	PK
`mailing_list_list_key`	Unknown	FK
`no_of_contacts`	Unknown

advanced_campaign_detail

Column	Type	Keys
`campaign_key`	Unknown	PKFK
`campaignid`	Unknown
`cmp_status`	Unknown
`date`	Unknown
`is_deleted`	Unknown
`schedule_date`	Unknown
`scheduled_time`	Unknown
`service_type`	Unknown

list_advanced_detail

Column	Type	Keys
`_fivetran_id`	String	PK
`listkey`	Unknown	FK
`brower_type_chrome`	Unknown
`brower_type_firefox`	Unknown
`brower_type_internet_explorer`	Unknown
`brower_type_opera`	Unknown
`brower_type_others`	Unknown
`brower_type_safari`	Unknown
`contact_details_created_time_gmt`	Unknown
`contact_details_date`	Unknown
`contact_details_is_public`	Unknown
`contact_details_list_name`	Unknown
`contact_details_no_of_contacts`	Unknown
`contact_details_owner_email`	Unknown
`contact_details_owner_name`	Unknown
`contact_details_segments`	Json
`contact_details_zu_id`	Unknown
`contact_stats_no_of_active`	Unknown
`contact_stats_no_of_bounce`	Unknown
`contact_stats_no_of_unsub`	Unknown
`contact_stats_schedule_count`	Unknown
`contact_stats_sent_count`	Unknown
`device_type_computer`	Unknown
`device_type_mobile`	Unknown
`device_type_others`	Unknown
`device_type_tablet`	Unknown
`email_client_apple_mail`	Unknown
`email_client_lotus_notes`	Unknown
`email_client_others`	Unknown
`email_client_outlook`	Unknown
`email_client_thunderbird`	Unknown
`localsubscribers_city_count`	Unknown
`localsubscribers_country_count`	Unknown
`localsubscribers_region_count`	Unknown
`mobile_devices_android`	Unknown
`mobile_devices_blackberry`	Unknown
`mobile_devices_ios`	Unknown
`mobile_devices_others`	Unknown
`open_subscribers_location`	Json
`operating_system_linux`	Unknown
`operating_system_ma_os_x`	Unknown
`operating_system_others`	Unknown
`operating_system_windows`	Unknown
`status`	Unknown
`tablet_devices_android`	Unknown
`tablet_devices_blackberry`	Unknown
`tablet_devices_ios`	Unknown
`tablet_devices_others`	Unknown
`web_client_aol_webmail`	Unknown
`web_client_gmail`	Unknown
`web_client_hotmail`	Unknown
`web_client_others`	Unknown
`web_client_yahoo_mail`	Unknown
`web_client_zoho_mail`	Unknown

mailing_list

Column	Type	Keys
`list_key`	Unknown	PK
`created_time`	Unknown
`created_time_gmt`	Unknown
`date`	Unknown
`deletable`	Unknown
`editable`	Unknown
`is_public`	Unknown
`is_smart`	Unknown
`list_campaigns_count`	Unknown
`list_created_date`	Unknown
`list_created_time`	Unknown
`list_desc`	Unknown
`list_dgs`	Unknown
`list_name`	Unknown
`list_notifications`	Unknown
`list_type`	Unknown
`list_uni_no`	Unknown
`lock_status`	Unknown
`no_of_bounce_count`	Unknown
`no_of_contacts`	Unknown
`no_of_unsubcnt`	Unknown
`others_list`	Unknown
`owner`	Unknown
`s_no`	Unknown
`segments`	Json
`sent_count`	Unknown
`service_type`	Unknown
`updated_time_gmt`	Unknown
`zu_id`	Unknown
`zx`	Unknown

contact

Column	Type	Keys
`_fivetran_id`	String	PK
`mailing_list_list_key`	Unknown	FK
`added_time`	Unknown
`company_name`	Unknown
`contact_email`	Unknown
`first_name`	Unknown
`last_name`	Unknown
`phone`	Unknown
`zu_id`	Unknown

campaign_recipient_data

Column	Type	Keys
`contact_id`	Unknown	PK
`campaign_key`	Unknown	FK
`address`	Unknown
`beta_keys`	Unknown
`city`	Unknown
`company_name`	Unknown
`contact_email_address`	Unknown
`contact_first_name`	Unknown
`contact_last_name`	Unknown
`contact_status`	Unknown
`country`	Unknown
`facebook_handle`	Unknown
`import_file_name`	Unknown
`job_title`	Unknown
`linkedin_handle`	Unknown
`mobile`	Unknown
`note`	Unknown
`opted_in_at`	Unknown
`phone`	Unknown
`secondary_email`	Unknown
`sent_date`	Unknown
`sent_time`	Unknown
`state`	Unknown
`tags`	Unknown
`time_zone`	Unknown
`title`	Unknown
`twitter_handle`	Unknown
`website`	Unknown
`zip_code`	Unknown

campaign_detail

Column	Type	Keys
`index`	Unknown	PK
`campaign_key`	Unknown	PKFK
`advance_type_string`	Unknown
`campaign_name`	Unknown
`campaign_preview`	Unknown
`campaign_type`	Unknown
`created_date_string`	Unknown
`created_time`	Unknown
`created_time_gmt`	Unknown
`email_options`	Unknown
`email_subject`	Unknown
`email_type`	Unknown
`encode_name`	Unknown
`folder_id`	Unknown
`is_advance`	Unknown
`is_g_a_config`	Unknown
`is_hybrid`	Unknown
`is_reply_tracking_enabled`	Unknown
`is_to_name_config`	Unknown
`is_wistia`	Unknown
`modified_date`	Unknown
`modified_time`	Unknown
`modified_time_gmt`	Unknown
`preheader`	Unknown
`reply_to`	Unknown
`schedule_type`	Unknown
`sender_name`	Unknown
`sent_date_string`	Unknown
`sent_time`	Unknown
`sent_time_gmt`	Unknown
`sent_time_zone`	Unknown
`sent_time_zone_short`	Unknown
`topic_id`	Unknown
`topic_name`	Unknown
`updated_date_string`	Unknown
`updated_time`	Unknown
`updated_time_gmt`	Unknown
`web_auto_status`	Unknown
`zu_id`	Unknown

associated_mailing_list

Column	Type	Keys
`campaign_key`	Unknown	PKFK
`list_key`	Unknown	PKFK
`contacts_count`	Unknown
`list_name`	Unknown
`list_status`	Unknown
`no_of_bounce`	Unknown
`no_of_unsubcontacts`	Unknown

campaign_report

Column	Type	Keys
`_fivetran_id`	String	PK
`campaign_key`	Unknown	FK
`autoreply_count`	Unknown
`bounce_percent`	Unknown
`bounces_count`	Unknown
`clicks_per_openrate`	Unknown
`complaints_count`	Unknown
`complaints_percent`	Unknown
`delivered_count`	Unknown
`delivered_percent`	Unknown
`emails_sent_count`	Unknown
`forward_percent`	Unknown
`forwards_count`	Unknown
`hardbounce_count`	Unknown
`open_percent`	Unknown
`opens_count`	Unknown
`softbounce_count`	Unknown
`spam_percent`	Unknown
`spams_count`	Unknown
`unique_clicked_percent`	Unknown
`unique_clicks_count`	Unknown
`unopened`	Unknown
`unopened_percent`	Unknown
`unsent_count`	Unknown
`unsent_percent`	Unknown
`unsub_count`	Unknown
`unsubscribe_percent`	Unknown

campaign_reach

Column	Type	Keys
`_fivetran_id`	String	PK
`campaign_key`	Unknown	FK
`emails`	Unknown
`facebook`	Unknown
`gplus`	Unknown
`linkedin`	Unknown
`other`	Unknown
`pinterest`	Unknown
`total`	Unknown
`tumblr`	Unknown
`twitter`	Unknown

segment

Column	Type	Keys
`cvid`	Unknown	PK
`segment_zuid`	Unknown	FK
`category`	Unknown
`created_date`	Unknown
`created_zuid`	Unknown
`seg_criteira`	Json
`segment_id`	Unknown
`segment_name`	Unknown
`segment_owner`	Unknown
`segment_status`	Unknown

segment_info

Column	Type	Keys
`list_zuid`	Unknown	PK
`campaign_key`	Unknown	PKFK
`current_zuid`	Unknown
`list_name`	Unknown

campaign_location

Column	Type	Keys
`name`	Unknown	PK
`campaign_campaign_key`	Unknown	PKFK
`value`	Unknown

campaign

Column	Type	Keys
`campaign_key`	Unknown	PKFK
`campaign_status`	Unknown
`status`	Unknown
`total_subscribers_count`	Unknown
`useragentstats_browsers_percent_chrome`	Unknown
`useragentstats_browsers_percent_firefox`	Unknown
`useragentstats_browsers_percent_internet_explorer`	Unknown
`useragentstats_browsers_percent_opera`	Unknown
`useragentstats_browsers_percent_others`	Unknown
`useragentstats_browsers_percent_safari`	Unknown
`useragentstats_computer_percent_apple`	Unknown
`useragentstats_computer_percent_linux`	Unknown
`useragentstats_computer_percent_others`	Unknown
`useragentstats_computer_percent_windows`	Unknown
`useragentstats_emailclients_percent_apple_mail`	Unknown
`useragentstats_emailclients_percent_lotus_notes`	Unknown
`useragentstats_emailclients_percent_others`	Unknown
`useragentstats_emailclients_percent_outlook`	Unknown
`useragentstats_emailclients_percent_thunderbird`	Unknown
`useragentstats_mobile_percent_android`	Unknown
`useragentstats_mobile_percent_blackberry`	Unknown
`useragentstats_mobile_percent_i_o_s`	Unknown
`useragentstats_mobile_percent_others`	Unknown
`useragentstats_tablets_percent_android`	Unknown
`useragentstats_tablets_percent_blackberry`	Unknown
`useragentstats_tablets_percent_i_o_s`	Unknown
`useragentstats_tablets_percent_others`	Unknown

topic

Column	Type	Keys
`id`	Unknown	PK
`primary_list`	Unknown
`topic_desc`	Unknown
`topic_name`	Unknown