Fivetran documentation

Search the docs

/

Campaign Monitor

Explore the interactive ERD

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	PKFK
`client_sent_campaign_campaign_id`	String	PKFK
`sent_tag`	String	PKFK

client_sent_campaign

Column	Type	Keys
`campaign_id`	String	PK
`client_id`	Unknown	PKFK
`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	PKFK
`scheduled_tag`	String	PKFK
`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	PKFK
`draft_tag`	String	PKFK
`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	PKFK
`client_id`	Unknown	PKFK
`list_id`	String	FK
`title`	String

campaign_list

Column	Type	Keys
`list_id`	String	PK
`campaign_id`	String	PKFK
`client_id`	Unknown	PKFK
`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	PKFK
`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