NOTE: At this time, the Event Attendance Export report should only be utilized by our customers who are part of the Early Adopter Program for a new feature. If you are not part of the Early Adopter Program for the Attendee Check-In module, then this export is essentially the Registration Summary Export.
NOTE: This report can be useful to build an Email List to communicate with people after the Event. It's ideal to collect walk up attendee email addresses via Attendee Check-In.
Event Attendance Export - collects all attendee activity. Each row represents an event attendee - including registrants, guests, and walk ups (offline attendees).
There are several ways to access Event Reports/Exports.
1. From the Events homepage, use the gear icon by the event you want to pull reports for and choose Create Reports.
2. While working in the Event as an admin, choose Form Reporting from Manage Form. Click Create New Export. This will move you directly into the reporting options for the specific event you are working in.
3. From the Events menu, choose Reporting. From the Single Event Reports dropdown, select your event.
4. From the Events homepage, click on the Reports tab.
From the Single Event Reports dropdown, select your event.
Click the Create New Export button under the Optimized Event Exports heading.
Custom Event Data Export: From the Export Type dropdown, you will select Event Attendance Export.
When should this export be run: The only option is On-Demand. This option allows the admin to generate and save an export without scheduling the export. When this option is selected, there will not be a 'File Retrieval' option to select because the export is not scheduled.
Click Next to save and move on.
There won't be any options for you to work with on this screen, so click the Next button to move on.
You will have the following options:
Click Download Export File in order to access the file.
The columns included in the export are intended to provide key attendance information.
No additional columns can be added to this export.
There is no opportunity to arrange the columns prior to export.
Columns included and their order:
Constituent ID (will be empty for non-member records that don't have an ID as well as walk up attendees added via Attendee Check-In)
Member ID (will show a 0 for walk up attendees added via Attendee Check-In)
Offline Attendee ID (will show a 0 for attendees who exist in Encompass as constituents or non-members)
checked_in (will show a 1 for a person who has been checked in)
checked_in_by (will show the name of the person who checked the individual in)
last_updated (will show the last time the attendance was worked with for the individual)
A sample export is shown below and assumes the Attendee Check-In module was used.