I am trying to pull a list of donors who gave to a particular source group, which has multiple non-concurrently- numbered sources attached to it. I'd rather not have to make a list of each of the sources and then make a list of the lists, as the number of these sources will continue to grow throughout the season and this will get unwieldy quickly. I'd like to have a dynamic list.
It seems to me that there should be a way to add Source Group as a List Manager element, but I can't find it in the Cookbooks. I do not speak SQL. Does anyone have any suggestions as to how to add this element?
Thanks-
Kendra
Kendra Struthers
Individual Giving/Stewardship Manager
Cincinnati Playhouse in the Park
kendra.struthers@cincyplay.com
513-977-2024
Hi Kendra,
While we don't use source group for Contributions, we do use it for Ticket Orders. We've created a local view that pulls in appeal, source, source name, media type, campaign, response, response date, promote date, and source group. I imagine you can use the same type of thing for contributions.
Michele