• Replies 4 replies
  • Subscribers 413 subscribers
  • Views 41 views
  • Users 0 members are here
Related

How to track Anniversary Donors

Christopher
$organization

Hello, 

At Pacific Symphony, we are getting ready to celebrate Music Director Carl St.Clair's 25th anniversary. One of the projects we are currently working on is pulling a list of donors who have donated each year for 25 years. I have attempted an assortment of List and Extraction Manager acrobatics and nothing seems to be working. 

Has anyone out there attempted a similar project? Any pointers would be greatly appreciated! 

Parents
  • Former Member
    Former Member $organization

    I've done blunt-force, recursive List Manager lists to get data like this, something like:

    LIST 1
    Contribution Campaign IN First Year Campaign.

    LIST 2
    Contribution Campaign IN Second Year Campaign.
    List IN LIST 1

    LIST 3
    Contribution Campaign IN Third Year Campaign
    List IN LIST 2

    And do that until you get to the 25th year.  But there are more elegant SQL ways to do it beyond my grasp.

Reply
  • Former Member
    Former Member $organization

    I've done blunt-force, recursive List Manager lists to get data like this, something like:

    LIST 1
    Contribution Campaign IN First Year Campaign.

    LIST 2
    Contribution Campaign IN Second Year Campaign.
    List IN LIST 1

    LIST 3
    Contribution Campaign IN Third Year Campaign
    List IN LIST 2

    And do that until you get to the 25th year.  But there are more elegant SQL ways to do it beyond my grasp.

Children
No Data