Intercom: Contact Enhanced

Description

• Each record represents a single contact, enriched with data identifying the contacts role, if they have unsubscribed from the email list, last contacted information, and which company they belong to.

Supported Data Sources

• Intercom

Columns

Type	Name	Description
STRING	contact_id	The unique identifier for the contact which is given by Intercom.
INTEGER	admin_id	The unique identifier representing the admin which has been assigned ownership of the contact.
DATETIME	created_at	The time when the contact was created within Intercom.
DATETIME	updated_at	The time when the contact was last updated.
DATETIME	signed_up_at	The time the contact signed up.
STRING	contact_name	The name of the contact.
STRING	contact_role	The role of the contact (user or lead).
STRING	contact_email	The contacts email.
DATETIME	last_replied_at	The time when the contact last messaged in.
DATETIME	last_email_clicked_at	The time when the contact last clicked a link in an email.
DATETIME	last_email_opened_at	The time when a contact last opened an email.
DATETIME	last_contacted_at	The time when the contact was last messaged.
BOOLEAN	is_unsubscribed_from_emails	Boolean indicating whether the contact has unsubscribed from emails.
BOOLEAN	_fivetran_active	Boolean to identify an active record.
DATETIME	_fivetran_start	Timestamp to record the time that a record is ingested by Fivetran. This value may not be identical to the time the record was created in the source system.
DATETIME	_fivetran_end	Timestamp to record the time when a record became inactive in the source system.
STRING	all_contact_tags	String aggregation of all tags associated with the contact.
STRING	all_contact_company_names	String aggregation of all companies the contact is associated with.