Returns the history of changes made to contact properties, useful for auditing and understanding contact evolution.

Select

The PropertyName filter is required to retrieve data from this view. When querying ContactPropertiesHistory, filtering can be applied to columns marked as "Filterable." For these columns, the supported server-side operators are = and IN.

SELECT * FROM ContactPropertiesHistory WHERE PropertyName = 'Create Date'

Columns

Name	Type	References	Filterable	Description
PropertyName	String		True	Name of the contact property whose historical value is being recorded.
Value	String		False	Previous value of the property before it was updated.
SourceType	String		False	Indicates the method or source responsible for changing the property value, such as API, user action, or workflow.
SourceId	String		False	Additional identifier related to the source of the change. May be empty depending on the source type.
Timestamp	Datetime		False	Timestamp of when the property value was updated.
ContactId	Long		False	Unique identifier of the contact associated with the property history.
ContactEmail	String		False	Email address of the contact linked to this property change.
ContactPhoneNumber	String		False	Primary phone number of the contact linked to this property change.