Event Data Improvements #182
Description
The event data available for download could be made much more clear.
Example current exports:
Example improved exports:
Registration Data
- Change "Frankly ID" to "User ID"
- Change "Member status" to "Member Status" for consistency
- Add "Join Time" column after "RSVP Time". (Leave blank if they did not attend event. If they joined multiple times, use the first time.)
- Add "Room Assigned" column to indicate what breakout room participants were assigned to when breakouts began. (If they join after breakouts are assigned, this will be "Waiting room". Admins/moderators who opt out of breakouts will have this field blank. If they are manually moved after breakouts begin, that will not be reflected here. We may add this nuance later if users request it.)
- Change "Answer 1" etc headings to the actual matching question text. (Alternatively, add "Question 1" column to the left of the "Answer 1" column so that the question text is visible in context.)
Polls & Suggestions
(Note: we plan to change what "Suggestions" are called and will update this accordingly.)
(Question: should polls and suggestions be separate exports?)
- Add poll data
- Remove chat data (move to separate export)
- Change "Created" to "Time"
- Remove Name and Email columns, replace with User ID column
- Add Prompt column and populate with prompt text from the agenda item.
- Change "RoomId" to "Room". Show room numbers (Main room, Waiting room, 1, 2, 3, etc) instead of IDs.
Chats
- Currently lumped in with suggestions, would like to separate out.
- Remove Type, #, Name, Email, Upvotes, Downvotes & AgendaItemId columns
- Change "Created" to "Time"
- Add User ID column