LeadPropertiesHistory
Returns the history of changes to lead properties, useful for auditing lead data changes.
View Specific Information
SELECT
When querying LeadPropertiesHistory, filtering can be applied to columns marked as "Filterable." For these columns, the supported server-side operators are = and IN.
SELECT * FROM LeadPropertiesHistory; SELECT * FROM LeadPropertiesHistory WHERE PropertyName = 'hs_lead_is_new';
Columns
| Name | Type | References | Filterable | Description |
| PropertyName | String | True | The internal name of the lead property that was updated. | |
| Value | String | False | The historical value assigned to the property at the time of the update. | |
| SourceType | String | False | The method or system that initiated the property change, such as user action or an automated process. | |
| SourceId | String | False | Additional metadata or reference ID associated with the source of the property update. This might be null or empty in some cases. | |
| Timestamp | Datetime | False | The date and time when the property was modified. | |
| LeadId | Long | False | The unique identifier of the lead whose property history is being tracked. |