Exporting data as CSV file
Exporting raw eye-tracking test results and using them.
You may get all test results from any study as CSV file.
To get the CSV file, simply click the "Save Results CSV" button on the study's dashboard (see also: Export AOI data).
CSV file contains following fields:
- string tester_id - UUID
- int tester_age - Could be undefined if tester did not provide this info
- int tester_gender - 1 - male, 0 - female. Could be undefined if tester did not provide this info
- string item_id - UUID
- string test_id - UUID
- timestamp test_created_at
- int test_duration - stimuli view time in ms (may be shorter than defined in settings sue to image mapping with clicks)
- int test_browser_width - tester’s screen width in pixels
- int test_browser_height - tester’s screen height in pixels
- JSON ARRAY test_raw_data - gazeInfo, array of info about gaze as shown below
- int gazeInfo - gaze point position on the screen (X-axis pixels from top-left corner). NOTE: It could be less than 0 or more than test_browser_width. Tester could be looking out of the screen.
- int gazeInfo - gaze point position on the screen (Y-axis pixels from top-left corner). NOTE: It could be less than 0 or more than test_browser_height. Tester could be looking out of the screen.
- int gazeInfo - time in ms since the beginning of the test
- float gazeInfo - Y scroll offset in pixels (in case tester was using scroll)
- float gazeInfo - X position of mouse cursor in pixels (from top-left corner)
- float gazeInfo - Y position of mouse cursor in pixels (from top-left corner)
- boolean|undefined gazeInfo - Indicating if tester has clicked at that time. If not clicked then this data is not included.
Please be aware that test_raw_data for every tester will most likely contain a different number of gazeInfo. That's because the gaze-tracking sampling rate varies depending on the webcam, tester's computer performance and subscribed plan.
Example CSV file:
tester_id,tester_age,tester_gender,item_id,test_id,test_created_at,test_duration_ms,test_browser_width_px,test_browser_height_px,test_raw_data 660ea005-d031-4c20-914c-b94d13c94497,34,1,4f6b3515-71f4-4fa3-b9ca-4fdfc1dee4ad,0c81e7a0-360d-4183-8345-5dabbeddbd90,2019-07-09T10:34:12+00:00,20000,2048,1019,"[1097,98,333,0,1073,725],[964,62,350,0,1073,725],[933,47,365,0,1073,725],[933,47,382,0,1073,725],[933,47,400,0,1073,725],[991,175,416,0,1073,725],[991,175,438,0,1073,725],[1019,97,450,0,1073,725],[1019,97,466,0,1073,725],[861,-39,489,0,1073,725],[744,170,506,0,1073,725],[744,170,516,0,1073,725], ... [359,550,19868,212.8000030517578,1036,689.1999969482422],[359,550,19884,212.8000030517578,1036,689.1999969482422],[334,648,19901,212.8000030517578,1036,689.1999969482422],[334,648,19919,212.8000030517578,1036,689.1999969482422],[400,618,19934,212.8000030517578,1036,689.1999969482422],[400,618,19951,212.8000030517578,1036,689.1999969482422],[916,629,19968,212.8000030517578,1036,689.1999969482422],[916,629,19983,212.8000030517578,1036,689.1999969482422],[793,559,20000,212.8000030517578,1036,689.1999969482422]]"
From following data
we can tell for example that tester id was "660ea005-d031-4c20-914c-b94d13c94497", age "35", "male", whole test took 20000 ms, screen resolution was "2048 x 1019".
Now let's take a single gazeInfo
This data tells us that tester was looking around "933 x 47" pixel of his screen, "365" ms since the test item has been exposed. "0" means the image has not been scrolled. His mouse cursor was at the "1073 x 725" pixel of his screen. Tester has not clicked a mouse at that moment.
Please note that data export to CSV file is available only for plans with the "Export to CSV" feature.