Advanced Outreach dynamic exclusion list

Hi Dale,

One question. Have you tried using Bionic Query as a data source. If so, can this exclusion criteria be set as a task within the bionic query as a source and configured so that the contacts are automatically excluded and only the right contacts are brought into the advanced outreach?

Thanks
Abhishek S

Hi Abhishek,

I did try this but I can only retain records using the Merge task in the query builder, not exclude. I could flip the logic on the opportunity object filter to only include accounts that have not had opportunities in the past 6 months.  However, I expect that would not include accounts with no opportunities on record because they would not exist in the opportunity object.
Did you have some workaround in mind?

Thanks for your feedback

Hi Dale, One way to get a set of accounts with zero opportunities is to query the opportunity object for the last six months and do a pivot task grouped by account.   This gives you fields like "Acct Name || Number of Opps".  Doing an outer join (Merge) of this with the Account table and then filtering for Number of Opps = Niull will give you accounts with no Opps. Doing an inner join between this data set and your contacts will limit you to only contacts that don't have any opps.  By the way, here is a video on the joint types that ends with an example somewhat similar to 'accounts with zero opps.'  https://community.gainsight.com/gainsight/topics/join-types-in-merge-tasks-made-easy .  You may also want to refer to the following video on Pivot task: https://community.gainsight.com/gainsight/topics/create-pivot-tasks-in-bionic-rules