Identifying how many companies do not have associated contacts, and vice versa

[#1]

I want to generate a dashboard report that shows me how many companies I have that are not linked to a contact record, and vice versa. This is for data management purposes so we can see if we have companies that have no associated contacts, and are thus in our DB, but not being prospected, or we are failing to link correctly or generally not managing some aspects of our data as well as we can. How do I do this.

[#2 · Accepted solution]

(see gif)

Help answer your question? If so, remember to accept this solution now.

Best,
Frank

Author the Perfect HubSpot Series

---

MFrankJohnson.com | Connect on LinkedIn

Help find posts quickly ... accept this solution now.

[#3]

Thanks Frank, is there a way to do it the other way around, identify how many contacts i have that are not associated with a company record. I found a field called 'Company Name' but that is a text entry field which is not what i am looking for.

[#4]

[#5]

I just tried and I am able to set the filter on the contact list so i can have it as a saved contact list filter, but this field does not show up on the report builder for dashboards. Any idea why this might be, i did not see this problem when doing it for company records on the dashboad.

[#6]

HubSpot dashboard reporting, filters, workflows, and even lists are very separate animals. It would be nice if they all lived by the same rules, but no such luck (currently).

We have noticed that the product team is working hard to better align functionality and reporting between the different HubSpot features. With over 150 feature updates and over 50 new integrations partners in 2018, HubSpot will no doubtedly introduce lots to keep us busy n 2019!

Happy to help.

Best,

Frank

(nite)