LeadPropertiesHistory
Retrieves the history of changes made to lead properties for auditing lead data updates.
Table Specific Information
Select
The add-in uses the HubSpot API to retrieve the property history for leads.
Note: PropertyName must be included in the WHERE clause to retrieve any data from the LeadPropertiesHistory view. This filter is required by the API and is evaluated server-side.
The following is an example query:
SELECT * FROM LeadPropertiesHistory WHERE PropertyName = 'my_property'
Columns
| Name | Type | References | Filterable | Description |
| PropertyName | String | False | The internal name of the property that was updated. | |
| Value | String | False | The previous value of the property before it was changed. | |
| SourceType | String | False | Indicates how the property change was triggered, such as by user action or integration. | |
| SourceId | String | False | Optional metadata providing additional context about the source of the update. | |
| Timestamp | Datetime | False | The date and time the property change occurred. | |
| LeadId | Long | False | Unique identifier of the lead whose property was updated. |