Retrieves the history of property changes for contacts in HubSpot for auditing and tracking purposes.

Select

The PropertyName filter is required to retrieve data from this view:

SELECT * FROM ContactPropertiesHistory WHERE PropertyName = 'Create Date'

Columns

Name	Type	References	Filterable	Description
PropertyName	String		False	The internal name of the contact property that was updated.
Value	String		False	The historical value of the contact property before the change.
SourceType	String		False	The method through which the property was updated, such as a form submission, import, or API.
SourceId	String		False	Additional identifier related to the source of the change, if available.
Timestamp	Datetime		False	The date and time when the property was updated.
ContactId	Long		False	The unique identifier of the contact whose property history is being tracked.
ContactEmail	String		False	The email address associated with the contact at the time of the property update.
ContactPhoneNumber	String		False	The primary phone number associated with the contact at the time of the property update.