Finding companies with 3 or more contacts from marketing sources

[JonasRytter]

Hello! 

We want to set up a way to hand over a company to the Sales department when we have 3 or more contacts/leads (not yet MQLs) from the same company.

Example: 3 middle managers from the same company has downloaded some of our content. We would like to notify Sales that the company could be unhappy with their current solution and it might be worth looking into them.

I have been trying to make a list so we can connect this to a workflow, but I have yet to find the best filtering combination for this. Any thoughts?

[karstenkoehler · Accepted solution]

Hi @JonasRytter,

Depending on what exactly the criterion is (you're mentioning both Lifecycle stage but also content downloads), this can be achieved with calculation properties: https://knowledge.hubspot.com/crm-setup/create-calculation-properties

For example, the below company calculation property would count how many contacts with Lifecycle stage 'Marketing Qualified Lead' are associated with a company. You could then enroll this company in a workflow when the value of this calculation property is greater than or equal to 3.

If you want to count how many contacts have downloaded a specific content piece, you could either set a value in a custom property which you then refer under Additional condition (see screenshot). Alternatively, you could set up a workflow which sets contacts to 'Marketing qualified lead' when they submit a required number of forms.

Best regards!

[JonasRytter]

This was exactly what I was looking for. Thank you so much!