How to exclude program participants from query?

  • 1
  • Question
  • Updated 3 weeks ago
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 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? 

















Photo of Kelly

Kelly

  • 1,636 Points 1k badge 2x thumb

Posted 3 weeks ago

  • 1

Be the first to post a reply!