Exclusions on the Membership Renewal Effort Template will only use Smart queries or Ad-Hoc queries built straight from the window. To do this :

 

1. Go to Marketing and Communications > Membership Renewal Efforts
2. Select the Templates tab and click the name of your membership renewal process
3. Select the Exclusions tab on your Membership Renewal Effort Template
4. Select Add
5. There will be another Add option, select that then select "ad-hoc" - then build the query needed