Hubspot: Contact Lists

Description

• Each record represents a contact list in Hubspot.

Supported Data Sources

• HubSpot

Columns

Type	Name	Description
BOOLEAN	is_contact_list_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.
DATETIME	_fivetran_synced	Timestamp of when Fivetran synced a record.
DATETIME	created_timestamp	A timestamp of the time the list was created.
BOOLEAN	is_deletable	If this is false, this is a system list and cannot be deleted.
BOOLEAN	is_dynamic	Whether the contact list is dynamic.
INTEGER	contact_list_id	The ID of the contact list.
INTEGER	metadata_error	Any errors that happened the last time the list was processed.
DATETIME	metadata_last_processing_state_change_at	A timestamp of the last time that the processing state changed.
DATETIME	metadata_last_size_change_at	A timestamp of the last time that the size of the list changed.
STRING	metadata_processing	One of DONE, REFRESHING, INITIALIZING, or PROCESSING. DONE indicates the list has finished processing, any other value indicates that list membership is being evaluated.
INTEGER	metadata_size	The approximate number of contacts in the list.
STRING	contact_list_name	The name of the contact list.
INTEGER	portal_id	The hub ID.
DATETIME	updated_timestamp	A timestamp of the time that the list was last modified.
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.