Hey all,
Could use some help thinking this one out. What's the best way to go about grabbing a list of donors who have donated every year for the last ten years to a specific campaign?
My favorite (inelegant) method to get this is to make a list/segment like "Contribution Campaign IN Individual FY17, Contribution Campaign HAS Individual FY16, Contribution Campaign HAS Individual FY15..." and so on. It falls apart if you want specific amounts, this fund but not that fund, etc., but if you just want to know they supported the same campaign every year it works.
-- Mike