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 YoukilisDevelopment ManagerStanford Lively Arts537 Lomita Mall 2250Stanford, CA 94305ph: 650.736.1251mobile: 415.425.7536fax 650.723.8231youkilis@stanford.edu
Stacy,
When you are pulling consecutive details you have to put the data in new rows for each year. For example if you were using campaign you would want the following in a single criteria set for the list or segment:
Contribution Campaign HAS 08-09
Contribution Campaign HAS 07-08
Contribution Campaign HAS 06-07
Contribution Campaign HAS 05-06
In the new T-Classes there is some more detail on this. If you look at Lesson 8 from the Criteria and Criteria Sets class you will find information about joining criteria. http://www.tessituranetwork.com/en/network/Learning/E-Learning/Lists%20and%20Extractions.aspx
Best,
Anna
Anna E. Wessely
Manager Asia Pacific/Senior Application Specialist
Tessitura Network, Inc
+1 888 643 5778 x 308
awessely@tessituranetwork.com
www.tessituranetwork.com
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