Data Dictionary

Field	Type	Notes
Archived	Boolean	True if the Email has been archived
CCO ID	Integer	The Connectorly Connection ID. If you group Connectorly's together, then you will see a CCO ID for each one. Organisations has the corresponding Connection Name for each CCO ID.
Created	Datetime	The date and time that a record was created.
Created Date	Date	The date that a record was created. This is useful so you can create a relationship with the Dates table, and analyze data over days, weeks, months and so on.
Data current as of	Datetime	Gives the date and time that this record was taken from HubSpot.
Email Direction	Text
Email ID	Text	ID
Email Sender Email	Text
Email Sender First Name	Text	Email Sender Firstname
Email Sender Last Name	Text	Email Sender Lastname
Email Sender Name	Text	Email To Name
Email Status	Text
Email Subject	Text
Email Text	Text
Email To Email	Text
Email To First Name	Text	Email To Firstname
Email To Last Name	Text	Email To Lastname
Email To Name	Text
First Company ID	Integer
First Contact ID	Integer
Owner ID	Integer	The Owner ID of the person that owns/is responsible for the record. Not necessarily the same as the Created By Owner ID. Find related details in the Owners table.
Timestamp	Datetime
Type	Text
Type	Text
Type	Text
Updated	Datetime	The date and time that the record was updated.
Updated Date	Date	The date that a record was updated. This is useful so you can create a relationship with the Dates table, and analyze data over days, weeks, months and so on.