How to do detailed first click analysis on UsabilityHub data

What is UsabilityHub?

UsabilityHub is a user research tool where you can build surveys and various simple tests.

The story

I recently used UsabilityHub to evaluate four variations of a fundamental design system change. I wrote about this in Expert Quant UXR advice from Sauro and Lewis.

The study was set up as a Variation Set, meaning that we ran the same test on four different designs. There were several questions, including a couple of First Click Tests and Short Text Questions. These all had clear right or wrong answers.

After we received all of our responses, I played around briefly in UsabilityHub. I highlighted the correct answers on the First Click Tests and tagged some of the Short Text Question responses as “correct”.

Then I exported my results as CSV.

The problem

When I opened the CSV, I saw my tags from the Short Text Questions, but my highlights weren’t included in the export.

The workaround

When I got in touch with UsabilityHub support, they suggested a workaround.

  1. Filter your results to only include correct First Click responses
  2. Export the filtered results

The problem with this workaround is that I wanted to analyze all the responses; not just the responses with correct First Click answers. So to work around this, I could have done the following:

  1. Filter the results to only include incorrect First Click responses
  2. Export the filtered results
  3. Combine the two exported files, adding a column to show whether the First Click Test was correct for that response.

The problem with this workaround is that I had two First Click Tests and four design variations. Multiply that by the two types of responses (correct or incorrect) and you get 16 different files that you have to stitch together. Also, the four design variations had identical “correct” hit areas, so I wanted their highlight dimensions to be identical, which is hard when you’re just clicking and dragging on an image.

The solution

While UsabilityHub doesn’t export highlights, it does export First Click Test coordinates. The exported coordinates are fractional, meaning that (0,0) is the top-left of the image and (1,1) is the bottom-right.

Knowing this, you can convert your “correct” area to a fractional bounding box, then use Excel or Google Sheets to calculate whether or not a given pair of coordinates are correct.

Here’s how:

  1. View the Click Map for your First Click Results then Export click map as image
  2. Open the image in your favorite image editor, such as Sketch, and draw the “correct answer” box on top of the click map
  3. Take note of the dimensions (W and H) of the image, making sure that X and Y are both 0
Example Click Map dimensions from Sketch’s Inspector panel
  1. Take note of the pixel values for xmin, xmax, ymin, and ymax of the box you drew
Example “Correct” rectangle dimensions from Sketch’s Inspector panel

Using the numbers in the example above,

  • xmin = X = 493
  • xmax = xmin + W = 493 + 86 = 579
  • ymin = Y = 359
  • ymax = ymin + H = 359 + 19 = 378
  1. Convert these dimensions to fractional by dividing by the overall image dimensions
  • xFracmin = xmin / W = 493 / 932 = 0.529
  • xFracmax = xmax / W = 579 / 932 = 0.621
  • yFracmin = ymin / H = 359 / 557 = 0.645
  • yFracmax = ymax / H = 378 / 557 = 0.679
  1. Using Google Sheets or Excel, add a column to your CSV file with the following formula
=IF(AND(A1>=xFracMin, A1<=xFracMax, B1>=yFracMin, B1<=yFracMax),1,0)

where A is the column containing the X coordinate of the click and B is the column with the Y coordinate.

And there you have it! Now you can calculate whether or not a First Click Test response is correct or not!

How was that?

On second thought, that was quite a bit of work. Maybe I should have used the workaround that the experts suggested! Oh well. I found it fun. And if you got this far, I hope you did too. If you didn’t find it fun, let me know what questions you have or how I can help! If there’s enough interest, I’ll add a Google Sheets template to this post that you can just fill in the blanks on.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s