On-Demand AMA: HubSpot Portal Audits and CRM Health

Hi @Levi, @johnelmer, @Olivia_Bagnall, @jforte, @TomM2, @EmmaAtKiwi, @DAnaGuiloff, @elizheleva, @MrJustinGivens, @HubDoPete - Do you have any HubSpot portal audits or CRM health questions or comments for @Mike_Eastwood?

Hey @Mike_Eastwood not sure if I’m too late or not, but how would you address the idea of property consolidation/minimisation?

It’s quite often for a new CRM user to create properties for specific questions and not have the mindset of them being scalable datapoints. What’s the best way to approach a CRM and define which properties/fields can be merged and what is needed?

Good question @TomM2

Unfortunately, merging properties often ends up being long, tediuos and manual job – property by property.

Consolidating Custom Properties is an 9 Step process per Property:

1. Identify the duplicates, triplcates, sometime manyplicates (yes, I just made that word up). Check each property use (e.g how many Contacts) and where it’s used (e.g. Workflow, Form, etc.). You can see in this screenshot this test property is only used in 1 Form, and 0 Contacts, so it’s easy to remove.

2. Decide which property will be the one you continue to use (usually the Property that’s used the most in Forms, Workflows, etc. because it’s a pain to replace the Property everywhere it’s used).

3. Check the name of new property (or the one you are keeping) has a sensible Property Name, a Property Description and is in a Property Group that makes it easier for everyone to understand.

4. Back up the data. I like to create a filter, with all the properties I want to delete, then edit the columns to show the Object ID and all the Properties I want to delete (and no personally idenetifiable information i.e. I do not include email, nor names. I only use the ID to matcht he data if I need to revert any data). I then export the filtered data to excel.

5. Append the other property names (the ones you will delete) with DEPRECATED or DO NOT USE so other people don’t make the mess bigger while you are working.

6. Work through each property you’re going to delete, replacing where it’s used, with the property you want to use. In the example above I only have to replace the Property in the “Test Onboarding Programme…” Form. But, it could be in multiple Forms, Workflows, Lists, etc.

7. Migrate the data once you’ve removed the places the property is used. There’s a few ways to migrate data:

  • filters are good if it’s a simple property e.g. yes/no. Simply filter all the Objects (e.g. Contacts) that have the old property as “yes” then bulk select the Objects and set the new property to “yes”. Repeat for “no”.
  • workflows are better for more complicate properties. Enroll the Object if the old Property is known. Then set the new Property to the same values. Then unset the old property to unknown. You can then filter to see if the Workflow worked properly.
    IMPORTANT the properties will need to be exatcly the same, otherwise you will need to set up conditional branches in your Workflow (which isn’t difficult and it’s still easier than manually changing things).
  • export, then import, the data. You can export the old property value(s), rename the column header, and reimport the data. I recommend you use the Object ID in the import to make sure your import is 100% matched. IMPORTANT your property names and values will need to be exactly the same for this method to work. If your property values are even slightly different you will get an error.

8. Quality check your data to make sure everything has been migrated before deleting the old property.

9. Delete the old property!

And…

0. Optional step, before step 1, put on your headphones and crank up some fast repetitive music for example Connecting the Dots by Jonathan Kaspar

Have fun

Mike

Hi Mike,

Thanks for hosting this AMA! Your expertise is impressive. I have a couple of questions:

  1. When is it a good time to run a full HubSpot audit?
  2. What are some of the common mistakes people make with HubSpot?

Also, as someone who inherited a messy HubSpot Portal, where should I start with cleaning it up?

Looking forward to your insights!

Best,

Emma lily

Hi @SFreek

As a HubSpot Partner Agency we run an audit before we do any work in a customers HubSpot Portal. Then we can discuss what’s urgent and important and make a plan (Do It Yourself, Done With You or Done For You).

Several of the HubSpot Partners I work with run Quarterly and Annual reviews to ensure everything is kept in a good state.

Unfortunately intergrations can automate boring tasks, but they can also automate mess creation, fast., so it’s good to keep an eye on your portal health with dashboards to reports.

Here’s a link to my calendar if you’d like to discuss your plan.

Thank you for connecting,

Mike

Here to learn more about HubSpot and share my HubSpot Knowledge. I’m the founder of Webalite a Gold HubSpot Partner Agency based in Wellington, New Zealand and the founder of Portal-iQ the world’s first automated HubSpot Portal Audit that helps you work smarter with HubSpot.