Access event attendee data

Access event attendee data

Attendee data from your event can be downloaded as a CSV (comma-separated values) file. The data set will include your attendees' first and last names, tickets purchased and answers to any additional questions you asked during checkout.

To download a CSV:

1. Log in to the Nonprofit Admin Portal and click "Events" in the top navigation bar.
2. Select the event whose data you would like to download as a CSV. Take note of the “Upcoming” and “Past” tabs to choose among future and past events, respectively. If needed, use the search tool to pull up results only within a tab. Search results will include the desired term, whether it is all or part of a word or phrase in the event name or slug.
3. Click the “Manage” button to the right of the event link.
4. Scroll down the next page until you see "Export Attendee Data" on the right.
5. Click the "Export" button.

This leads to two possible scenarios:

• For any requested report with fewer than 1,000 charges, the download will begin automatically a few moments later.
• For any requested report with 1,000 or more charges, a popup alert will advise that the report can be downloaded via an email once the report is ready. This email will be sent to the address associated with the Nonprofit Admin Portal user account. Each report will be available for 72 hours from the time the email is sent; if that time expires, a new export must be launched.

Use the "Shareable CSV" feature

As an alternative to a downloaded CSV, a shareable CSV makes it possible for multiple people to see your event data via a URL. The data is refreshed every minute and access can be revoked (see below) at any time.

A key benefit of this feature is the ability to import the data from the URL into a spreadsheet, like Google Sheet, which updates hourly. This  eliminates the need to download a new CSV every time new event data is captured.

To set up a shareable CSV link

1. Log in to the Nonprofit Admin Portal and click "Events" in the top navigation bar.
2. Select the event whose data you would like to have available as a shareable CSV. Take note of the “Upcoming” and “Past” tabs to choose among future and past events, respectively. If needed, use the search tool to pull up results only within a tab. Search results will include the desired term, whether it is all or part of a word or phrase in the event name or slug.
3. Click the “Manage” button to the right of the event link.
4. Scroll down the next page until you see “Create Shareable CSV" on the right.
5. Click the “Create Shareable Link" button.
6. Copy the link.
7. Share as needed.

‍

To create a self-updating Google Sheet containing the data from the shareable CSV

1. Create a new Google Sheet.
2. Copy this function into the first cell:
   

=IMPORTDATA("URL COPIED FROM ADMIN PORTAL”)

For additional details, see Google’s instructions here.

To revoke access to the shareable CSV

1. Log in to the Nonprofit Admin Portal and click "Events" in the top navigation bar.
2. Find your event and click the "Manage" button next to that event.
3. Scroll down the next page until you see “Shareable CSV Link" on the right.
4. Click the “Revoke Access" button.