Retrieves the history of property changes for companies in HubSpot, useful for tracking data updates over time.

Select

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

SELECT * FROM CompanyPropertiesHistory WHERE PropertyName = 'Create Date'

Columns

Name	Type	References	Filterable	Description
PropertyName	String		False	The name of the property.
Value	String		False	The historical value of the property.
SourceType	String		False	The method by which the property was changed.
SourceId	String		False	Additional data related to the source. May not be populated for all sources.
Timestamp	Datetime		False	Datetime when the property was updated.
CompanyId	Long		False	The company identifier.