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.
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.
Using these two filters you should be able to configure to your specific programs.
This only works if you created smart campaigns to update the Program Status and that equals Success.
thanks for the feedback Grant. Is it possible to filter by the date when 'Success' is enabled. I am trying to prepare a list of person which does not have a positive change (Success set to true) in the last 12 or 24 months - irrespective of the campaign executed date (email send date or webinar date etc.,) The above condition catches majority of records that i am looking for and i think i am missing a set which had responded in the time range, but the program was run outside the time range.
Let's say you have 20 programs. And members of your database did have success in some of these programs (but not all). Your filter will include those people here - even though they did have success is some programs. So this won't provide a list of people who never achieved success in all programs that they were members of. Also, are we trying to establish EMAIL success? Just trying to understand why the second filter is included.
This alternative approach should work, Grant.
Retrieving data ...