TGIF.
Our team is looking to segment donors who have given 3+ years consecutively. What criteria yields this, and would you build the segment in List Manager or elsewhere? I think we will do special communications with them, but it's all still being discussed...
Please let me know how you handle (technically in Tessitura or from a stewardship/donor touchpoints perspective) these types of loyal donors.
So we actually have an attribute that calculates consecutive number of years of donations (I don't know the back end part, unfortunately!) If I didn't have that, I'd probably build a pivot table in Analytics with each year as a column, export it into an excel, delete out anyone with a blank spot for one of the years, then import the list into List Manager. This is a very circuitous route of getting the information, unfortunately, but that's my first instinct. I'd love to hear some ideas from others!