Beacon Administrators can export a list of users and their connected students. Navigate to Settings, User Management, and click on the down arrow. This will reveal the Export section of the page.
From there, click on an existing file to download or click “New Export” to create a new file.
The exported CSV file will contain a list of all Peer Advisors, Advisors, Generalists, Executives, and Administrators who have connections. Any users without connections will not appear in the file.
Note: Filters on the User Management page will not impact the Export. The Export will always generate a list of all users who have connections.
If a user is connected to multiple students, they will appear on multiple rows in the file.
Example CSV File:
Excel PivotTable Tips
You can follow the instructions below to create PivotTables in Excel to view the data in different formats:
In Excel, click CTRL + A to select all data. Click Insert > PivotTable. When the Create PivotTable dialog box appears, click OK. Excel will bring you to a new tab with a PivotTable Fields menu.
If you want to view the number of connections per user, drag and drop the fields into the boxes as shown below:
You will now have a table that looks like this, which shows the number of connected students per user:
If you want to view a list of students who have connections, drag and drop the fields into the boxes as shown below:
You will now have a table that looks like this, which shows a list of students (by External ID) and the number of other users they are connected to:
