List of Continuous Donors

HI,

I am trying to pull a list of donors who have donated for the past consecutive 5 years. I am having trouble figuring out the best way to pull this list. Any ideas?


Thanks!

Parents
  • One way could be using a combination of lists. You would create 5 individual lists of total donors in each year. Then in a sixth list you would ask for people that have all 5 of those lists. So your criteria would look like:
    List IN (list 1)
    List HAS (list 2)
    List HAS (list 3)
    List HAS (list 4)
    List HAS (list 5)

Reply
  • One way could be using a combination of lists. You would create 5 individual lists of total donors in each year. Then in a sixth list you would ask for people that have all 5 of those lists. So your criteria would look like:
    List IN (list 1)
    List HAS (list 2)
    List HAS (list 3)
    List HAS (list 4)
    List HAS (list 5)

Children
No Data