3/27 – SURVEYS

Sarah W -

We finally sent out the emails! It was a lot more work than I thought it would be. 

 

Sending them out:

Kei and I had to group all the emails into 12 groups of 50 email addresses. We already typed up all the emails from the sign-in sheets into a spreadsheet the first few days we were here, so all we had to do was copy-paste 50 names at a time into a Google doc. The only problem was when I tried to copy the emails, it would copy the spreadsheet boxes as well, so I had to copy one at a time. After that was done, we sent the batches and the email (the one in my last post) to one of my external advisors and she sent them out through the company email. 

After we sent the first 5 emails out (each with 50 people included), we realized that the link to the survey didn’t work. That was nice. We noticed the link was to a previous survey that was deleted and was quickly fixed by sending out another email including the correct link. After that, sending out the emails went smoothly.

 

After the survey:

After all the emails were sent, a lot of them bounced back. It could be that some of them moved to a new job/school (because a lot of people used work/school emails) or we wrote it wrong (because the handwriting was atrocious). I organized the emails that bounced back into a new document, so we don’t keep sending the survey to bad emails. After I had all the correct email addresses, I separated them into more batches of 50 for the second email to go out. Each time I make new batches, edit emails, or delete emails, I add all that information to the original spreadsheet that has the sign-in sheet information. 

More Posts

Comments:

All viewpoints are welcome but profane, threatening, disrespectful, or harassing comments will not be tolerated and are subject to moderation up to, and including, full deletion.

    nathan_c
    Wow, that seems like so much work! Which part was the worst? Also, what are your plans after the second batch is sent out?
    March 28, 2024 at 9:53 am -
      sarah_w
      The worst part was probably finding out which batch the bad emails came from because my external only gave me a document of which were bad and not what email they came from.
      April 3, 2024 at 9:54 am -
    sedona_o
    Hi Serra, so you had to copy and paste 50 emails individually??? Props to you! I don't think I would have had the patience. Will the second email just be a reminder for people to complete the survey? What are your plans for that?
    March 28, 2024 at 10:00 am -
    delaney_f
    Wow! I would not have the patience for that!! Do you know if more of the emails bounced back because of the change in job/school or because of the bad handwriting issue? It would be interesting to look at as a source of error.
    March 29, 2024 at 8:47 am -
    kei_s
    Hi Sarah! What do you expect your next couple of weeks will look like? I know you’re going to be looking into what goes into making a good survey, but do you know anything more specific? Thanks! - Kei
    March 30, 2024 at 7:35 pm -
      sarah_w
      I will be sending out the reminder email in the next week as well as more organizing emails. After that, I have the final presentation to think about. Right now, I am waiting for you to analyze more so you can help me know what could be improved such as if there was an extra question you would like to know or if a question didn't tell you as much as I thought it would.
      April 3, 2024 at 10:04 am -

Leave a Reply