#mturkid

[bsrtips]

Need to Recover MTurk IDs?

orgot to ask your participants for an MTurk or Turk Prime ID and need to allocate specific bonuses?

While it’s not the speediest of processes, there is a way to recover this information.

1. Go into the survey flow of your Qualtrics survey and create a new Embedded field labeled “Referer” 

2. Re-download your data set. You will see that the “Referer” column will have a long URL for each participant.

3. Within each of these URLs is the workerID or MTurk ID for each participant:

Example: 

4. In Excel, use the formula to trim and/or extract a subset of characters from a string for each cell to capture only the workerID information (here is a link with more information on that formula if you need it).

5. Now re-pair these IDs with your original data and grant them bonuses :)

�