When Did My Property Value Update? [Keeping Track of Property Changes with Property History Values]

[jleow]

In HubSpot, certain dates of change are automatically logged, such as the ‘Became a [lifecycle stage] date properties. This makes it easier to report on - for example, we can then look at the number of contacts that became MQLs or SQLs in a specific month. 

However, most other properties don’t keep track of this date of change except in the details option of the property. New changes can be logged using a workflow, as outlined in this other community post. 

That said, to retrieve the historical date records of existing properties, you can follow the steps here:

Part 1: Create Custom Date Property

1. Follow the steps here to create a custom date property. 
2. You’ll want to create a date property that matches your original property’s record type. In this example, both properties are contact properties.

create date property

Part 2: Export Property History and Edit Export File 

1. Follow the steps here to export a property’s history across all records. 
   
   export property history
   
   
2. Once the property history has been exported, filter and edit the excel sheet to pull the dates of the most recent updated values. 
   
   exported property history file
   
3. Copy these dates, as well as the corresponding Object ID (Contact/Company/Deal/Ticket ID) into a new excel file (.csv or .xlsx) and save it. I’ve also copied the contact’s email addresses for easy identification. 
4. Set the column name to the label of the Custom Date property created in Part 1.
   
   new excel file

Part 3:Import these values into your portal

1. Once the excel file has been set up, you can import these records back into HubSpot. 
2. Follow the steps here to import your file - you will want to import one file with one object type. 
3. During the import process, select the ‘Update object using ‘Object ID’ exported from HubSpot’ option to de-duplicate the Object and ensure that existing objects are updated and no duplicates are created. 
   
   select checkbox during import
   

The most recent date of change for this property will then be logged to your custom date property. 

Please note:  

• This guide will only work for existing records, for property updates moving forward you can follow this other guide instead. 
• All property history datetimes are are exported in UTC, but this is can be adjusted to your timezone in excel - here’s a handy guide on how to do so. 

[PamCotton]

Welcome new Community users 

@JOByrne , @JMitchem 
@ABousley @ABoston, @AMcFarlane @ASon, @CReid, @DBrewster, @Elizabeth01, @GPereira, @HannahKnight, @KMiale, @Kthotland, @SquadWolder @LPeseski @LVeal @laurenanderson @LStrayer @BRobinson @LisaSenecal, wanted to share this new guide in our community.

Kindly,

Pam