Solved
How to prepare a list of people with no SUCCESS in last 24 months
Hi Team, How can i prepare a list of people with no 'Success' from all associated campaigns in the last 24 months? Please suggest the filters i should use?
Thanks @Dan Stevens
- Because I used Program "is any" all it takes is one program to have "Success = False" to qualify, darn it. Thanks for the reminder and catching that.
- I used the email filter for time constraint as he was looking for 2 years in past. My thinking is that he could have people in database but no longer actively targeting. Would you suggest another filter?
Ramesh V
I think with Dan's insight, you'll need to create a Positive Smart list, people who "Success = True" to then add as an exclusion in your main list. This is accurate as you will use the change from status that aren't success to ones that are plus the date of activity.
Then in your target list you'll just use "is not" the above smart list. I'm also using the "Not Program Status was Changed" with the same filters I used in the Positive smart list. I've added some other exclusions like email invalid... as a reminder to clean up the list.
