Pulling list of all enews subscribers and donor v nondonor status

Kate Wiley

I'd like to pull all of the subscribers to our e-newsletter and know whether each person is a donor or a non-donor

Philip Nawrocki

Hi Kate,


You can do this in querybuilder. You will most likely need two queries if you want to save them or you can just edit the one over and over.


Go to Data Management -> Query -> Create a New Query


Fill in the Query Info and then get to the Query Builder.


Click Add a Group Clause and find the e-newsletter interest.


Then you can start adding field clauses to do the donor vs. non-donor. (The field type is System)


Here is a post on how to do that:
https://community.blackbaud.com/forums/viewtopic/1/30828


Let us know if that helps.


Thanks,


Phil