Meeting Attendance Report Best Practices
Hi, I use Zoom for our nonprofit for senior citizens and we often have meeting with over 50 attendees. My demographic has an average age of about 72 so requiring registration is out of the question, we will lose participants. After each meeting I download the attendance list and spend a long time trying to parse the user names into first name, last name, and location. We do ask everyone to rename themselves and as hosts, we help them to make sure first, last, and location are listed. Even so.... the .csv file is a mess of jumbled up names that they have used for the meeting and their account names. It takes hours to manually transfer the information to columns. Since the information that downloads is not consistent, trying to ask Excel to separate the data using spaces or punctuation also makes a mess of things. Any ideas how how to better collect meeting attendance? Examples of what shows up on the csv download: Peter Green - City (peter) Some kind of "join meeting form" where the participant answers the questions as they join like "What is your first and last name?" What is your location?" - would solve it!
Merle Doe# City (Merle Doe)
Charlotte Doe# City
George Doe# City City (George)
David Do# City(David Doe)
Steve Doe# City (Steve Doe)
margaret
Dorothy Doe City
Sue Doe she/her
Mary Ann Doe#City (Mary Ann Doe)
Show less