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 internal name of the company property that was updated.
Value	String		False	The historical value that the company property was set to after the update.
SourceType	String		False	The method or system that made the change to the company property, such as a user action, workflow, or integration.
SourceId	String		False	Additional information identifying the source of the update, if available.
Timestamp	Datetime		False	The date and time when the property change occurred.
CompanyId	Long		False	Unique identifier of the company whose property history is being tracked.