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?
How to exclude program participants from query?
Userlevel 6
+2
Hello Kelly,
I recently started going through all of the unanswered or unresolved problems and questions here. Was checking to see if this has been resolved or if it is an ongoing issue?
Thanks
Reply
Sign up
If you ever had a profile with us, there's no need to create another one.
Don't worry if your email address has since changed, or you can't remember your login, just let us know at community@gainsight.com and we'll help you get started from where you left.
Else, please continue with the registration below.
Welcome to the Gainsight Community
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.