Build your own Data Cleanse Dashboard in HubSpot
04 / 12 / 2021

Build your own Data Cleanse Dashboard in HubSpot

Keep your HubSpot CRM data in optimum health with your very own data cleanse dashboard to keep track of things like unsubscribes, missing data and more...

We love a good HubSpot hack, especially when it revolves around cleaning up bad data!

So you can imagine how excited we were when Gem Rugg-Dunn from HubSpot partner BabelQuest shared a little insight into how she builds out a data cleanse dashboard.

Taking this idea and running with it, we’ve now created our own version and provided a quick tutorial for you to follow so that you can create your very own data cleanse dashboard to sweep away those outdated records, pesky unsubscribes and potential gaps in your database.

Every business is unique, so you’ll really want to customise this to fit your needs. We'd be happy to help you get started if you're not sure! 

How to build your own data cleanse dashboard: step-by-step

  1. Within your HubSpot portal, head to Reports > Dashboards
  2. Select Create dashboard > Blank Dashboard and give it a name e.g. ‘Data Hygiene Dashboard’
  3. Set the necessary permissions to determine who can access the dashboard
  4. Select Create dashboard
  5. Begin creating your reports by pressing Add report > Build a new report
  6. Select Single object
  7. Select the object you want to report on (as standard, most reports will only use the Contact or Companies objects)
  8. Once you’ve chosen your chart type, properties and filters select Save
  9. Give your report a practical name then select Add to the existing dashboard (choosing your newly created Data Hygiene Dashboard)
  10. Select Save & add
  11. On the Dashboard, you can adjust the dimensions of the embedded report by manoeuvring the bottom right corner

Data Hygiene Dashboard Blog Image-1

Some example reports you could include...

So you might not be entirely sure what you want to include in your data cleanse dashboard. Every business is unique and there'll be types of data you hold, whether it's a custom object or specific property that's important to your aims, that you'll likely want to have a view of that's not included here.

But these top 10 most common reports can give you a good head start...

  • Total number of Unsubscribes (contact object | summary chart type)
  • Total number of Bounces (contact object | summary chart type)
  • Total number of No Contact Owner (contact object | summary chart type)
  • No subscription type by Lifecycle Stage (contact object | summary chart type)
  • Contacts with Mismatching Lead Status x Lifecycle Stage (contact object | bar chart type)
  • Contact Created Compared to Last Year (contact object | area chart type)
  • No Associated Company by Source (company object | column chart type)
  • Contacts by Country (contact object | bar chart type)
  • Missing Job Title by Source (contact object | column chart type)
  • No First Name (contact object | summary chart type)

Top Tip: For maximum efficency and to help you keep on top of your data hygiene, you can set up an automated email to deliver a copy of this dashboard from HubSpot each week/month!

Take a look at this demo dashboard we've built below for some additional examples of more spceific reports: 

Data Hygiene Dashboard Blog Image-2

 

Want to make sure you're making the most out of your HubSpot investment? We've got 12 tips, strategies and hacks to supercharge your portalget them sent straight to your inbox

Header image source: Unsplash

04 / 12 / 2021 -

HubSpot

Get 12 HubSpot hacks straight to your inbox

Zendesk vs HubSpot Service Hub

The customer experience is more important than ever when it comes to growing

Find Out More
23 / 03 / 2022 -

HubSpot

What is HubSpot Service Hub: Features and benefits

In today’s world, customer is king.

Find Out More
16 / 03 / 2022 -

HubSpot

What is HubSpot CMS Hub: Features and benefits

In 2020, HubSpot announced CMS Hub. If you’ve known and loved the HubSpot CMS

Find Out More
15 / 03 / 2022 -

HubSpot