Quite a few Usabilla users have asked us in recent weeks, how to select notes in a certain field range within a completed test page. In response we have created a new Google doc spreadsheet template to help facilitate this need, for a more thorough analysis of note comments within a test. Using the XML export option in conjunction with your unique API token, you are able to access the data you have collected with Usabilla in other tools. For more information how to XML export your data, please view our previous blog post on the topic.
Lookup your test ID and API token
To get started you need to located the Test ID # of the test you wish to analyze. Each test in Usabilla has an unique identifier, you can find this identifier in the URL of your test (/rate/#######). Just click the button ‘Invite Participants’ (for an active test) or ‘Preview’ (for draft tests) buttons to open your test and see the URL. The identifier is a 13 digit variable made up of letters and numbers (eg. 17648937944ae).
Next you must obtain your generated API token, which is located in your account settings, you need this to access your data (eg. 2552b3ebcad773bf186196407431c87b). We use this token to secure access to your data, so please be careful when sharing your token with others.
Once you have correctly found these two specific numbers plug them into the spreadsheet.
Selecting an area
The last step is to select the X and Y pixel boundary coordinates of the desired area. There are many free web applications and browser extensions that can help you locate the X and Y pixel boundary coordinates using just your cursor, such as WebDeveloper add-on for Firefox.
If entered correctly your desired selection of notes should appear.
Feel free to contact us (firstname.lastname@example.org) if you need any help or assistance with setting up your spreadsheet or test.
In our previous ‘Trust’ sample test case, we wanted to see all the commented notes in regards to the photo of Phil Black on about.me’s homepage. By entering the Test ID #, API token, X and Y pixel boundary coordinates of the photo into the spreadsheet. We were able to view the 11 notes left on this specific item with ease.
An additional way that this spreadsheet tool can be best utilized to help you get most out of your test data, is that it allows you to see all note comments in densely commented area, where notes could potentially be placed on top of one another, ie a call-to-action button. A perfect example of this scenario is in our Polldaddy Demo Test. With 10+ notes in a small area, the spreadsheet allows you to better view your the test notes.
How do I get my own spreadsheet?
For your convenience we have upload a public version of the spreadsheet and have allowed you to create your own copy of it, that can be used in your own test cases or adapted to fit your own needs. Simply log in to your Google Account, open the spreadsheet, and create a copy of the sheet (File / Make a Copy).
Again feel free to contact us (email@example.com) if you need any help with your tests or customizing a spreadsheet to meet your specific needs.