• Replies 2 replies
  • Subscribers 413 subscribers
  • Views 47 views
  • Users 0 members are here
Related

Extraction Help

Former Member
Former Member $organization

I am trying to pull a list of donors who have given consecutively over the last four years.  I am suppressing brand new current year donors, too.  Not having luck.  Lapsed donors from past seasons seem to keep finding their way into the mix.

08-09

07-08

06-07

05-06

Any help would be most appreciated.

 

Thanks.

Stacy Youkilis
Development Manager
Stanford Lively Arts
537 Lomita Mall 2250
Stanford, CA 94305
ph: 650.736.1251
mobile: 415.425.7536
fax 650.723.8231
youkilis@stanford.edu

Parents
  • $organization

    Stacy,

    I think this will work. In List Manager, make a separate list for each contribution year (Contribution date is between start and end of your financial periods).

    Then in either List Manager or Extraction Manager, pull all 4 lists together using "Has" as the Operator:

    List - Has - 2005/2006

    List - Has - 2006/2007

    List- Has - 2007/2008

    List - Has - 2008/2009

     

    Steven

     

     

     

     

Reply
  • $organization

    Stacy,

    I think this will work. In List Manager, make a separate list for each contribution year (Contribution date is between start and end of your financial periods).

    Then in either List Manager or Extraction Manager, pull all 4 lists together using "Has" as the Operator:

    List - Has - 2005/2006

    List - Has - 2006/2007

    List- Has - 2007/2008

    List - Has - 2008/2009

     

    Steven

     

     

     

     

Children
No Data