Question
How to exclude program participants from query?
Since a duplicated program doesn't carry a historical exclusion setting and due to our query doing a 3 day look back we have constant erroneous failures reported in the participant activity.
To address both scenarios I'm looking to incorporate participant activity into the query so that I can filter out anyone who either already entered a Program containing a phrase [i]or received specific emails but am having trouble determining the right object/fields to use.
There's: AO Advanced Outreach, AO Participant Activity, AO Participants, etc.
I'm essentially just looking for a statement such as 'Has not entered Program X in 180 days from run date' or 'Has not received Email X in 180 days from run date'
Has anyone done anything similar?
To address both scenarios I'm looking to incorporate participant activity into the query so that I can filter out anyone who either already entered a Program containing a phrase [i]or received specific emails but am having trouble determining the right object/fields to use.
There's: AO Advanced Outreach, AO Participant Activity, AO Participants, etc.
I'm essentially just looking for a statement such as 'Has not entered Program X in 180 days from run date' or 'Has not received Email X in 180 days from run date'
Has anyone done anything similar?