# Zoho Campaigns schema ERD

Table and field reference for the Fivetran Zoho Campaigns connector.

## 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| list_key | Unknown | PK, FK |
| 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 | PK, FK |
| current_zuid | Unknown |  |
| list_name | Unknown |  |

### campaign_location

| Column | Type | Keys |
| --- | --- | --- |
| name | Unknown | PK |
| campaign_campaign_key | Unknown | PK, FK |
| value | Unknown |  |

### campaign

| Column | Type | Keys |
| --- | --- | --- |
| campaign_key | Unknown | PK, FK |
| 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 |  |

## Relationships

- contact_count(mailing_list_list_key) → mailing_list(list_key)
- advanced_campaign_detail(campaign_key) → campaign_detail(campaign_key)
- list_advanced_detail(listkey) → mailing_list(list_key)
- contact(mailing_list_list_key) → mailing_list(list_key)
- campaign_recipient_data(campaign_key) → recent_campaign(campaign_key)
- campaign_detail(campaign_key) → campaign(campaign_key)
- associated_mailing_list(list_key) → mailing_list(list_key)
- associated_mailing_list(campaign_key) → campaign(campaign_key)
- campaign_report(campaign_key) → campaign(campaign_key)
- campaign_reach(campaign_key) → campaign(campaign_key)
- segment(segment_zuid) → segment_info(list_zuid)
- segment_info(campaign_key) → campaign(campaign_key)
- campaign_location(campaign_campaign_key) → campaign(campaign_key)
- campaign(campaign_key) → recent_campaign(campaign_key)