Please enable JavaScript to view this site.

thankQ Help

You can combine AND searches, OR searches and exclude search statements in any way to create powerful and effective searches.

Example: For the past three years our organisation has run an appeal to raise money to buy new computers for schools in need of new technology. Each year we have done a mailing and event to try and raise funds. Using the Power Search we can determine the following:

Find all the contact records who have donated to ANY of the last three campaigns.

Include SOURCE of donation is CFK04-EVENT-DON

Include SOURCE of donation is CFK04-MAILING1

Include SOURCE of donation is CFK05-EVENT-DON

Include SOURCE of donation is CFK05-MAILING1

Include SOURCE of donation is CFK06-EVENT-DON

Include SOURCE of donation is CFK06-MAILING1

 

SrchRprt_img77

 

Find all the contact records who have donated to ALL of the last three campaigns.

Include SOURCE of donation is CFK04-MAILING1

AND

Include SOURCE of donation is CFK05-MAILING1

AND

Include SOURCE of donation is CFK06-MAILING1

 

SrchRprt_img78

 

Find all the contact records that donated to EITHER of the last two appeals and have NOT yet donated to the current appeal.

Include SOURCE of donation is CFK04-MAILING1

AND

Include SOURCE of donation is NOT CFK06-MAILING1

 

Include SOURCE of donation is CFK05-MAILING1

AND

Include SOURCE of donation is NOT CFK06-MAILING1

SrchRprt_img79

 

Find all the contact records that donated to BOTH of the last two appeals and have NOT yet donated to the current appeal.

Include SOURCE of donation is CFK04-MAILING1

AND

Include SOURCE of donation is CFK05-MAILING1

AND

Include SOURCE of donation is NOT CFK06-MAILING1

 

SrchRprt_img80