Query loyal donors

Christina Greene

Does anyone know an easy way to query on donors who have given in eight of the last 10 years? It doesn't have to be consecutive.

Alan French

This question comes up quite often on the forum ?  There are some ideas in this thread, this thread, this thread, this thread, and this thread that might help you.

Christina Greene

Hi Alan,

 

This is great - thanks so much! I was pretty
sure there was no easy way, but this is very helpful.

 

Best,

Christina

 

Christina Greene​

Database Administrator & Analytics Manager

1085 North Main St Providence, RI 02904

401-415-4620 Direct:

401-215-6664

Mobile:

cgreene@hopehealthco.org

HopeHealthCo.org

This message contains confidential information and is intended only for the intended recipients. If you are not an intended recipient you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake and delete this e-mail from your system. E-mail transmission cannot be guaranteed to be secure or error-free as information could be intercepted, corrupted, lost, destroyed, arrive late or incomplete, or contain viruses. The sender therefore does not accept liability for any errors or omissions in the contents of this message, which arise as a result of e-mail transmission. If verification is required please request a hard-copy version.

Joanne Felci 2

Alan French:

This question comes up quite often on the forum ?  There are some ideas in this thread, this thread, this thread, this thread, and this thread that might help you.

Alan French‍ - probably just my exhausted brain but your posted reminded me so much of the Genie in Aladdin...you can exit the carpet here, here, here, here and here  ;-)

Alan French

Joanne Felci‍ I would love to say that's what I was aiming for, but alas it's just a coincidence. Also, my emoji was meant to look friendly but kind of looks like it's baring its teeth... not really the impression I was going for!

Christina Greene

Just circling back to this. I used one of the solutions in Alan's thread and it worked like a dream.

Since we were looking for those that gave in 8 of the last 10 years I pulled a query of all donors who gave from 10/1/17 on (our fiscal year starts in October). I used that query to export their total number of gifts for each of the last 10 fiscal years. I used the =countif (cell range, ">0") formula. This gave me the total number of years they gave over the past 10 years. I sorted from largest to smallest only keeping the ones that were 8 and above.

Thanks so much!