Hubspot: Contact History

Description

• Each record represents a change to contact record in Hubspot; the grain of this model is contact_id -> field_name -> valid_to.

Supported Data Sources

• HubSpot

Columns

Type	Name	Description
INTEGER	contact_id	The ID of the related contact record.
STRING	field_name	The name of the field being changed.
STRING	change_source	The source (reason) of the change.
STRING	change_source_id	The ID of the object that caused the change, if applicable.
DATETIME	valid_from	The timestamp the change was valid from.
STRING	new_value	The new value of the field.
DATETIME	valid_to	The timestamp the change was valid to. Null if still valid.
STRING	id	The ID of the change.