Querying for Constituents who have never attended an event

Daniel Noga 2

Hi everyone,


I'm doing some purging of records that have no reason to be in our system--i.e., they've never given a gift, attended an event, are not an Honor/Memorial, have no Actions on record or relevant Notes, etc.


I'm stuck on the Events portion of this. I don't see a good way to query for Constituents who have simply never attended an event. I'm hoping I'm just missing something obvious and someone else will know what I can do to get that information. I don't use canned reports often, so for all I know, there's one that can help me with this.


EDIT: For my purposes, this would mean any Constituent that has nothing listed on the Events tab of their record--we don't make use of the "Participant has attended" checkbox. I'm just looking for Constituents who have no links to existing Event records at all.


Any thoughts?

Alan French

I'm a recent convert to query lists, and I'd be tempted to use one for this. It should be relatively straight-forward to create separate queries for people who HAVE given a gift, HAVE attended an event etc., and then use a query list to subtract all these groups from your overall constituent population. Whoever's left is the group you want to purge.

Gina Gerhard

I think this would work -


Event Participations/Import ID blank



 

Daniel Noga 2

Gina Gerhard:

I think this would work -


Event Participations/Import ID blank

 

You rock, Gina! I think you're right. When I run the same query, but change Event Participations/Import ID to "not blank," then the number of times a given Constituent's name appears in the results corresponds with the number of events listed on their events tab. Seems solid to me. Thank you!

Daniel Noga 2

Alan French:

I'm a recent convert to query lists, and I'd be tempted to use one for this. It should be relatively straight-forward to create separate queries for people who HAVE given a gift, HAVE attended an event etc., and then use a query list to subtract all these groups from your overall constituent population. Whoever's left is the group you want to purge.

Thanks, Alan. That will be a big help to me. I'm reluctant to trust a single Constituent query with so many varying criteria, and it would be really tedious chaining a bunch of SUB merged queries together. What a cool feature!