Re: Filter all contacts of accounts with opportunities

Anonymous
Not applicable

Filter all contacts of accounts with opportunities

Our Team has been struggling since quite sometime now to filter out leads, contacts of accounts that has opportunity (SFDC) above certain stage. We would want to avoid sending emails to these contacts who are already engaged with active opportunities. I do understand that we can filter out contacts that are associated with opportunities but we do not normally have all contacts associated with the opportunity.

Is there any possible work around to filter out contacts from sending emails who has opportunities.

6 REPLIES 6
Julz_James
Level 10

Re: Filter all contacts of accounts with opportunities

Hi,

You should be able to use the filter in the Smart List Step of 'Not Has opportunity' and then you can say true and what stage I believe using the constraints.  I think that removes anyone who is at that stage of the opp or above?

Thanks

Juli

Rebecca_Allen
Level 2

Re: Filter all contacts of accounts with opportunities

There is no "Not Has Opportunity" step and apparently if you use  "Has Opportunity: False" and then select any sub-filters it becomes illogical and rules itself out of smart lists. Still looking for workarounds for this exact use-case if anyone has found one.

Anonymous
Not applicable

Re: Filter all contacts of accounts with opportunities

We are using account based marketing and I am thinking we are going to have this same problem. If you filter out an opportunity with Stage it will only filter people who are associated with an Opp. Anyone not associated with an opp from the same company would still get an email. My only idea is to create a smart list with all of the companies/accounts in SFDC using company name, with an open opportunity and use that as a suppression list.

However this isn't scale-able, there doesn't seem to be a good way to update the list when a new opp is created. Seems like a big hole for account based marketing.

Darrell_Alfons2
Level 10 - Champion Alumni

Re: Filter all contacts of accounts with opportunities

You could try having a trigger campaign that listens for "added to an opportunity" and then add that lead/contact to a smart list, and always exclude that smart list.

The other thing I am thinking about is a work flow (on the SFDC side) that automatically checks off marketing suspended if an opportunity is created, but you would have to have a pretty savvy SFDC admin.

Anonymous
Not applicable

Re: Filter all contacts of accounts with opportunities

Hi Darrell,

I think the Trigger campaign would only cover people who are attached to the Opp and still miss people who are not.

I was thinking the same thing about tagging all of the contacts if an opp is created. You would need a cross object trigger on Opp and Contact to make it work.

Grégoire_Miche2
Level 10

Re: Filter all contacts of accounts with opportunities

This question belongs to the Products  section. Marketing central is for generic marketing questions. Read this: ** PLEASE READ BEFORE POSTING YOUR MARKETO PRODUCT QUESTIONS HERE **

The answer to your question is that you can create a couple of fields on the account object and a workflow that does the trick:

  1. Create a rollup summary field on the account object that counts the number of open opportunities. Name that field "NOO" Hide it from the Marketo sync user and do not display it on the account page layouts
  2. Create a number (18,0) field on account, name it "Nb of Open Oppies" and make it accessible from the Marketo sync object
  3. Create a workflow on the OPPORTUNITY object. Make sure that workflow fire every time an oppy is created or edited, with a formula rule = True so that always fires. In that workflow, add a field update that updates the field account.Nb of Open Oppies and copies to it the value of account.NOO__c

This will make sure that each time an opportunity is updated, the accounts is updated and sync"ed with Marketo, and the account.Nb of Open Oppies is always up to date in SFDC and Marketo.

The field account.Nb of Open Oppies will be updated in Marketo each time an opportunity is added to an account or updated. You will be able to user filters on this field as well as Data Value Changes triggers and Data Valued Changed triggers.

-Greg