# Campaign Monitor schema ERD

Table and field reference for the Fivetran Campaign Monitor connector.

## Table & Field Reference

### campaign_bounce

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| campaign_id | String | FK |
| client_id | Unknown | FK |
| list_id | String | FK |
| bounce_type | String |  |
| date | String |  |
| email_address | String |  |
| reason | String |  |

### sent_campaign_tag

| Column | Type | Keys |
| --- | --- | --- |
| client_id | Unknown | PK, FK |
| client_sent_campaign_campaign_id | String | PK, FK |
| sent_tag | String | PK, FK |

### client_sent_campaign

| Column | Type | Keys |
| --- | --- | --- |
| campaign_id | String | PK |
| client_id | Unknown | PK, FK |
| from_email | String |  |
| from_name | String |  |
| name | String |  |
| reply_to | String |  |
| sent_date | String |  |
| subject | String |  |
| total_recipients | Long |  |
| web_version_text_url | String |  |
| web_version_url | String |  |

### client_segment

| Column | Type | Keys |
| --- | --- | --- |
| segment_id | String | PK |
| client_id | Unknown | FK |
| list_id | String | FK |
| title | String |  |

### scheduled_campaign_tag

| Column | Type | Keys |
| --- | --- | --- |
| client_scheduled_campaign_campaign_id | String | PK, FK |
| scheduled_tag | String | PK, FK |
| client_id | Unknown | FK |

### client_scheduled_campaign

| Column | Type | Keys |
| --- | --- | --- |
| campaign_id | String | PK |
| client_id | Unknown | FK |
| date_created | String |  |
| date_scheduled | String |  |
| from_email | String |  |
| from_name | String |  |
| name | String |  |
| preview_text_url | String |  |
| preview_url | String |  |
| reply_to | String |  |
| scheduled_time_zone | String |  |
| subject | String |  |

### campaign_recipient

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| campaign_id | String | FK |
| client_id | Unknown | FK |
| list_id | String | FK |
| email_address | String |  |

### campaign_click

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| campaign_id | String | FK |
| client_id | Unknown | FK |
| list_id | String | FK |
| city | String |  |
| country_code | String |  |
| country_name | String |  |
| date | String |  |
| email_address | String |  |
| ip_address | String |  |
| latitude | Double |  |
| longitude | Double |  |
| region | String |  |
| url | String |  |

### campaign_open

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| campaign_id | String | FK |
| client_id | Unknown | FK |
| list_id | String | FK |
| city | String |  |
| country_code | String |  |
| country_name | String |  |
| date | String |  |
| email_address | String |  |
| ip_address | String |  |
| latitude | Double |  |
| longitude | Double |  |
| region | String |  |

### client_suppression_list

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| client_id | Unknown | FK |
| date | String |  |
| email_address | String |  |
| state | String |  |
| suppression_reason | String |  |

### draft_campaign_tag

| Column | Type | Keys |
| --- | --- | --- |
| client_draft_campaign_campaign_id | String | PK, FK |
| draft_tag | String | PK, FK |
| client_id | Unknown | FK |

### client_draft_campaign

| Column | Type | Keys |
| --- | --- | --- |
| campaign_id | String | PK |
| client_id | Unknown | FK |
| date_created | String |  |
| from_email | String |  |
| from_name | String |  |
| name | String |  |
| preview_text_url | String |  |
| preview_url | String |  |
| reply_to | String |  |
| subject | String |  |

### account_client

| Column | Type | Keys |
| --- | --- | --- |
| client_id | Unknown | PK |
| base_delivery_rate | Double |  |
| base_design_spam_test_rate | Double |  |
| base_rate_per_recipient | Double |  |
| can_purchase_credits | Boolean |  |
| client_pays | Boolean |  |
| company_name | String |  |
| contact_email_address | String |  |
| contact_name | String |  |
| country | String |  |
| credits | Double |  |
| currency | String |  |
| markup_on_delivery | Double |  |
| markup_on_design_spam_test | Double |  |
| markup_per_recipient | Double |  |
| name | String |  |
| time_zone | String |  |

### client_subscriber_list

| Column | Type | Keys |
| --- | --- | --- |
| list_id | String | PK |
| client_id | Unknown | FK |
| name | String |  |

### campaign_summary

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| campaign_id | String | FK |
| client_id | Unknown | FK |
| bounced | Long |  |
| clicks | Long |  |
| forwards | Long |  |
| likes | Long |  |
| mentions | Long |  |
| name | String |  |
| recipients | Long |  |
| spam_complaints | Long |  |
| total_opened | Long |  |
| unique_opened | Long |  |
| unsubscribed | Long |  |
| webversion_text_url | String |  |
| webversion_url | String |  |
| worldview_url | String |  |

### campaign_unsubscribe

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| campaign_id | String | FK |
| client_id | Unknown | FK |
| list_id | String | FK |
| date | String |  |
| email_address | String |  |
| ip_address | String |  |

### campaign_segment

| Column | Type | Keys |
| --- | --- | --- |
| segment_id | String | PK |
| campaign_id | String | PK, FK |
| client_id | Unknown | PK, FK |
| list_id | String | FK |
| title | String |  |

### campaign_list

| Column | Type | Keys |
| --- | --- | --- |
| list_id | String | PK |
| campaign_id | String | PK, FK |
| client_id | Unknown | PK, FK |
| name | String |  |

### client_people

| Column | Type | Keys |
| --- | --- | --- |
| email_address | String | PK |
| client_id | Unknown | FK |
| access_level | Long |  |
| name | String |  |
| status | String |  |

### account_administrator

| Column | Type | Keys |
| --- | --- | --- |
| email_address | String | PK |
| name | String |  |
| status | String |  |

### client_tag

| Column | Type | Keys |
| --- | --- | --- |
| name | String | PK |
| client_id | Unknown | PK, FK |
| number_of_campaign | Long |  |

### campaign_spam_complaint

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| campaign_id | String | FK |
| client_id | Unknown | FK |
| list_id | String | FK |
| date | String |  |
| email_address | String |  |

### campaign_email_client

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| campaign_id | String | FK |
| client_id | Unknown | FK |
| client | String |  |
| percentage | Double |  |
| subscribers | Long |  |
| version | String |  |

### client_template

| Column | Type | Keys |
| --- | --- | --- |
| template_id | String | PK |
| client_id | Unknown | FK |
| name | String |  |
| preview_url | String |  |
| screenshot_url | String |  |

## Relationships

- campaign_bounce(list_id) → campaign_list(list_id)
- campaign_bounce(campaign_id) → client_sent_campaign(campaign_id)
- campaign_bounce(client_id) → client_sent_campaign(client_id)
- sent_campaign_tag(sent_tag) → client_tag(name)
- sent_campaign_tag(client_sent_campaign_campaign_id) → client_sent_campaign(campaign_id)
- sent_campaign_tag(client_id) → account_client(client_id)
- client_sent_campaign(client_id) → account_client(client_id)
- client_segment(list_id) → client_subscriber_list(list_id)
- client_segment(client_id) → account_client(client_id)
- scheduled_campaign_tag(scheduled_tag) → client_tag(name)
- scheduled_campaign_tag(client_scheduled_campaign_campaign_id) → client_scheduled_campaign(campaign_id)
- scheduled_campaign_tag(client_id) → account_client(client_id)
- client_scheduled_campaign(client_id) → account_client(client_id)
- campaign_recipient(list_id) → campaign_list(list_id)
- campaign_recipient(campaign_id) → client_sent_campaign(campaign_id)
- campaign_recipient(client_id) → client_sent_campaign(client_id)
- campaign_click(list_id) → campaign_list(list_id)
- campaign_click(campaign_id) → client_sent_campaign(campaign_id)
- campaign_click(client_id) → client_sent_campaign(client_id)
- campaign_open(list_id) → campaign_list(list_id)
- campaign_open(campaign_id) → client_sent_campaign(campaign_id)
- campaign_open(client_id) → client_sent_campaign(client_id)
- client_suppression_list(client_id) → account_client(client_id)
- draft_campaign_tag(draft_tag) → client_tag(name)
- draft_campaign_tag(client_draft_campaign_campaign_id) → client_draft_campaign(campaign_id)
- draft_campaign_tag(client_id) → account_client(client_id)
- client_draft_campaign(client_id) → account_client(client_id)
- client_subscriber_list(client_id) → account_client(client_id)
- campaign_summary(campaign_id) → client_sent_campaign(campaign_id)
- campaign_summary(client_id) → client_sent_campaign(client_id)
- campaign_unsubscribe(list_id) → campaign_list(list_id)
- campaign_unsubscribe(campaign_id) → client_sent_campaign(campaign_id)
- campaign_unsubscribe(client_id) → client_sent_campaign(client_id)
- campaign_segment(list_id) → campaign_list(list_id)
- campaign_segment(campaign_id) → campaign_list(campaign_id)
- campaign_segment(client_id) → campaign_list(client_id)
- campaign_list(campaign_id) → client_sent_campaign(campaign_id)
- campaign_list(client_id) → client_sent_campaign(client_id)
- client_people(client_id) → account_client(client_id)
- client_tag(client_id) → account_client(client_id)
- campaign_spam_complaint(list_id) → campaign_list(list_id)
- campaign_spam_complaint(campaign_id) → client_sent_campaign(campaign_id)
- campaign_spam_complaint(client_id) → client_sent_campaign(client_id)
- campaign_email_client(campaign_id) → client_sent_campaign(campaign_id)
- campaign_email_client(client_id) → client_sent_campaign(client_id)
- client_template(client_id) → account_client(client_id)