Reverting Bulk Property Changes by Importing Historical Property Values

jleow
HubSpot Employee

HubSpot makes it simple to update and maintain databases with bulk property editing and updating properties via workflows. But at the same time, it's also easy to incorrectly bulk edit records.

 

Is it possible to revert property changes? The short answer is no - at the moment, we aren't able to automatically 'revert' these properties to the values that they were before the edits were made. 

 

But that said, we can export the historical values of a property, clean up the data to the time before these changes,  then import these values back into your portal to update the object. Here is how you can do so:

 

Part 1: Exporting the Property History

  1. In your HubSpot account, click the settings icon in the main navigation bar.
  2. In the left sidebar menu, navigate to ‘Properties’.
  3. In the 'Search Properties' text-box, type in the name of the property that you are looking to revert. 
  4. When the property appears, hover over the name of the property then click on 'More > Export Property History'.

Export Property HistoryExport Property History

 

 

Part 2: Editing the Export File 

  1. From the property history file, apply filters to your excel sheet – this sheet can be read from left to right, from the most recent property value to the oldest property value.

    Add filter to excelAdd filter to excel

     

  2. Using the column with the most recent values (usually column D), filter to the date where the changes were made. 
    1. As a quick example, if I made an incorrect bulk property change to a set of contacts on 1st April – I would select the checkboxes for ‘April’, and ‘01’.

      Filter by date of property changeFilter by date of property change
    2. Once these filters are applied, we will be left with only the contacts that were affected by this change.
    3. We can then retrieve the last most recent set of values, which would be in column E.
  3. Copy these values, as well as the corresponding Object ID (Contact/Company/Deal/Ticket ID) into a new excel file (.csv or .xlsx) and save it. In this example, I’ve also copied the contact’s email addresses to easily identify them.

    Columns to be copiedColumns to be copied

This is an example of what the new excel would look like:

 

Example of a new excel file for importExample of a new excel file for import

 

 

Part 3: Import these values back into your portal

  1. Once the Excel File has been cleaned up to contain the correct values, you can import these companies back into HubSpot.
  2. From the Imports page, click on the ‘Start an Import’ button to begin your import – you will want to import one file with one object type. You can follow this guide on how to do so.
  3. During the import process, select the 'Update Object using 'Object ID' exported from Hubspot' option to de-duplicate the Object and ensure that the existing Objects are updated and no duplicates are created

 Update existing contacts using Contact ID exported from HubSpot checkboxUpdate existing contacts using Contact ID exported from HubSpot checkbox

 

Things to note:

Do note that you won’t be able to do this if the property values before the update were null. Instead, you can follow this guide up to Part 2. Here are the steps for objects with no value:

  1.     Copy only the Object ID and email or other identifiers into the new excel.
  2.     Import as per ‘Part 3’ - from the Imports page, create a list from these imported objects.
  3.     Go into the list and bulk edit your properties to a blank value.
  4.     You may not be able to do this with all properties - for the contact properties that you are not able to find under the bulk edit option, you will want to enroll the list into a workflow and use the ‘Clear Property Value’ action.

 Clear property value action in a workflowClear property value action in a workflow

Hope this helps!

0 Replies

No replies on this post just yet

No one has replied to this post quite yet. Check back soon to see if someone has a solution, or submit your own reply if you know how to help! Karma is real.

Reply to post

Need help replying? Check out our Community Guidelines

0 Replies 0