Lists, Lead Scoring & Workflows

iamathlete
Contributor | Platinum Partner
Contributor | Platinum Partner

Create List based on values for more than 1 deal

SOLVE

We are using Deals to determine events each person attends or items they purchase.  

 

One contact may have a Deal called "Conference 2018" AND another Deal called "Conference 2017".  This would mean they attended the Conference in 2017 and 2018 - but they are two distinct Deals under the contact record.

 

How do I make a list for all Contacts that have a Deal equal to Conference 2017 AND another Deal equal to Conference 2018?

 

I only see how I can create a list where the two terms are in one Deal (which doesn't exist in any of my contacts).  

 

 

 

 

0 Upvotes
1 Accepted solution
MFrankJohnson
Solution
Thought Leader

Create List based on values for more than 1 deal

SOLVE

_hubspot-button-accept-as-solution-gif-v00.gif

 

Q: How do I make a list for all Contacts that have a Deal equal to <one value> AND another Deal equal to <another value>?

 

Short A: n/a

 

Longer A:

You'll need multiple lists to get it sorted.

- see List of HubSpot Smart Lists

List of HubSpot Smart ListsList of HubSpot Smart Lists

 

 

- see List of Contacts Meeting Criteria 'A'

List of Contacts Meeting Criteria 'A'List of Contacts Meeting Criteria 'A'

 

 

- see List of Contacts Meeting Criteria 'B'

List of Contacts Meeting Criteria 'B'List of Contacts Meeting Criteria 'B'

 

 

- see List of Contacts Meeting BOTH Criteria 'A' AND Criteria 'B'

List of Contacts Meeting BOTH Criteria 'A' AND Criteria 'B'List of Contacts Meeting BOTH Criteria 'A' AND Criteria 'B'

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

 

Best,
Frank

Chief HubSpot Consultant


hubspot-solutions-signature-mfrankjohnson-v05.png

MFrankJohnson.com | Perfect HubSpot Series | Connect on LinkedIn

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

 

Note: Please search for recent posts as HubSpot evolves to be the #1 CRM platform of choice world-wide.

 

Hope that helps.

 

Be well,
Frank


www.mfrankjohnson.com

View solution in original post

4 Replies 4
MFrankJohnson
Solution
Thought Leader

Create List based on values for more than 1 deal

SOLVE

_hubspot-button-accept-as-solution-gif-v00.gif

 

Q: How do I make a list for all Contacts that have a Deal equal to <one value> AND another Deal equal to <another value>?

 

Short A: n/a

 

Longer A:

You'll need multiple lists to get it sorted.

- see List of HubSpot Smart Lists

List of HubSpot Smart ListsList of HubSpot Smart Lists

 

 

- see List of Contacts Meeting Criteria 'A'

List of Contacts Meeting Criteria 'A'List of Contacts Meeting Criteria 'A'

 

 

- see List of Contacts Meeting Criteria 'B'

List of Contacts Meeting Criteria 'B'List of Contacts Meeting Criteria 'B'

 

 

- see List of Contacts Meeting BOTH Criteria 'A' AND Criteria 'B'

List of Contacts Meeting BOTH Criteria 'A' AND Criteria 'B'List of Contacts Meeting BOTH Criteria 'A' AND Criteria 'B'

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

 

Best,
Frank

Chief HubSpot Consultant


hubspot-solutions-signature-mfrankjohnson-v05.png

MFrankJohnson.com | Perfect HubSpot Series | Connect on LinkedIn

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

 

Note: Please search for recent posts as HubSpot evolves to be the #1 CRM platform of choice world-wide.

 

Hope that helps.

 

Be well,
Frank


www.mfrankjohnson.com
iamathlete
Contributor | Platinum Partner
Contributor | Platinum Partner

Create List based on values for more than 1 deal

SOLVE

this seems to be the easiest way.  thanks!!!

 

it brings me to another question about organizing the data, but I will put that up under a separate post.  

MFrankJohnson
Thought Leader

Create List based on values for more than 1 deal

SOLVE

Yes. Please mark as solved. Thanks

 

Note: Please search for recent posts as HubSpot evolves to be the #1 CRM platform of choice world-wide.

 

Hope that helps.

 

Be well,
Frank


www.mfrankjohnson.com
0 Upvotes
Mike_Eastwood
Key Advisor | Gold Partner
Key Advisor | Gold Partner

Create List based on values for more than 1 deal

SOLVE

Hi @iamathlete 

 

Can you work in the opposite direction?

 

What if you created a Deal Filter (not a Contact Filter) where Deals were filtered by either "Conference 2018" or "Conference 2017" then add your Contact details to the columns, then filter the columns by name...

 

Does that work? 

-Mike

0 Upvotes