thankQ Help

Search Criteria

Contacts with an email address

Have donated after 1 July 2010

Contacts that have donated between $100 and $500 between 1 Jan 2010 and 31 Jan 2010 in one payment

Have home phone numbers

Want to receive mail

Want to receive phone calls

Individual contacts that came onto the system after June last year

Only include contacts that have an address

How many contacts in the database are interstate contacts

 or

All contacts with contact type individual

Sum of Donations is more than $1000 and the donation dates are between 1 January 2006 and 31 December 2006 and the Source Code type is Appeal

All contacts with contact type individual

Sum of Donations is more than $1000 and the donation dates are between 1 January 2006 and 31 December 2006 and the Source Code type is Appeal.  

Exclude:

All Profile/Parameter Values containing Asthma

All with Do Not Mail set

All contacts with contact type individual

Sum of Donations of more than $1000 between 1 January 2006 and 31 December 2006

AND

Has a Mailing Preference of Appeal.

Exclude:

All records where DO Not Mail is Set

All VIP and Anonymous records

All contacts with a Credit Card Pledge that expires in one month from now

All contacts that have NOT donated

Exclude:

Does not want to receive Appeals

Do Not Mail is set

All contacts with last donation date of the last financial year less than $200

Exclude:

Does not want to receive Appeals

Do Not Mail is set

All contacts with last donation date of the last financial year greater than $200

Exclude:

Does not want to receive Appeals

Do Not Mail is set

All contacts with last donation date 3 years ago

Exclude:

Does not want to receive Appeals

Do Not Mail is set