I am trying to run a report to get the email addresses of any one who attend a program in 2018. I have tried various options in the reporting section but the report is not correct. I've watched the videos online, none of them focus on pulling from there is not assistance for pulling from the Event Attendance Schema which is where I am assuming I am starting. Has anyone pulled this type of report or know how to pull the report? Help!
Hi Angie, do you need help with building the report criteria or getting email addresses in the output? Happy to help if I can.
Hi, thanks so much! Building the criteria is what I need help with.
Here are two screenshots. The simplest way is to use attendance date. If you track volunteers in events and want to filter them out, you will want to add in that criteria as well ( is volunteer equals false). Also, if you have non-program events that you track you may want to filter them out using Event Category ID. At least that's how we do it at GC Louisville.
Let me know if you have any questions!
OMG that is so much easier that what I have been trying! Thank you! It worked!
Next question, now if I want this same information for people who are only in Contact Management, what would you do?
I think you need to switch schemas for that one. Then go to Contact Events and try Contact Logged Date. I hope works for you!
Please sign in to leave a comment.