Compare leads in a static list with Members in a Program

[Anonymous]

Hi there,

I have a Program with members in it. I also have a static list of leads.
Some of the leads in the list are members of the program.

I would like to find out from my list > who are not members of the Program.

Once i can determine this >  i would like to import these leads into the Program.

If anyone can share a way on how to do this that would be great.  

[Anonymous]

Thanks - worked perfectly! Very clever.

Cheers, John 

[Anonymous]

I fully endorse Adam's clever suggestion. 

[Anonymous · Accepted solution]

Try creating a Smart Campaign with the following in the Smart List:



Then in the flow you can Change Program Status/Request Campaign etc. 

Hope this helps!