Hubspot: Contacts

Description

• Each record represents a contact in Hubspot.

Supported Data Sources

• HubSpot

Columns

Type	Name	Description
INTEGER	contact_id	The ID of the contact.
BOOLEAN	is_contact_deleted	Boolean indicating whether a record has been deleted in Hubspot and/or inferred deleted in Hubspot by Fivetran; _fivetran_deleted and is_deleted fields are equivalent.
STRING	calculated_merged_vids	List of mappings representing contact IDs that have been merged into the contact at hand. Format: <merged_contact_id>:<merged_at_in_epoch_time>;<second_merged_contact_id>:<merged_at_in_epoch_time> This field has replaced the CONTACT_MERGE_AUDIT table, which was deprecated by the Hubspot v3 CRM API.
STRING	email	The email address of the contact.
STRING	contact_company	The name of the contact's company
STRING	first_name	The contact's first name.
STRING	last_name	The contact's last name.
DATETIME	created_date	The date that the contact was created in your HubSpot account.
INTEGER	job_title	The contact's job title.
INTEGER	company_annual_revenue	The contact's annual company revenue.
DATETIME	_fivetran_synced	Timestamp of when Fivetran synced a record.
INTEGER	total_bounces	The total number of bounce email events.
INTEGER	total_unique_bounces	The total number of unique email sends with a bounce email event.
INTEGER	total_clicks	The total number of click email events.
INTEGER	total_unique_clicks	The total number of unique email sends with a click email event.
INTEGER	total_deferrals	The total number of deferral email events.
INTEGER	total_unique_deferrals	The total number of unique email sends with a deferral email event.
INTEGER	total_deliveries	The total number of delivery email events.
INTEGER	total_unique_deliveries	The total number of unique email sends with a delivery email event.
INTEGER	total_drops	The total number of drop email events.
INTEGER	total_unique_drops	The total number of unique email sends with a drop email event.
INTEGER	total_forwards	The total number of forward email events.
INTEGER	total_unique_forwards	The total number of unique email sends with a forward email event.
INTEGER	total_opens	The total number of open email events.
INTEGER	total_unique_opens	The total number of unique email sends with a opens email event.
INTEGER	total_prints	The total number of print email events.
INTEGER	total_unique_prints	The total number of unique email sends with a print email event.
INTEGER	total_spam_reports	The total number of spam report email events.
INTEGER	total_unique_spam_reports	The total number of unique email sends with a spam report email event.
INTEGER	total_unsubscribes	The total number of unsubscribe email events.
INTEGER	total_unique_unsubscribes	The total number of unique email sends with a unsubscribe email event.
INTEGER	count_engagement_notes	The total number of related note engagements.
INTEGER	count_engagement_tasks	The total number of related task engagements.
INTEGER	count_engagement_calls	The total number of related call engagements.
INTEGER	count_engagement_meetings	The total number of related meeting engagements.
INTEGER	count_engagement_emails	The total number of related email engagements.
INTEGER	count_engagement_incoming_emails	The total number of related incoming email engagements.
INTEGER	count_engagement_forwarded_emails	The total number of related forwarded email engagements.