This article describes the “Area of Interest” statistics export function.
You may want to read more about how to access the aggregate statistical analysis tools.
How to export an analysis as CSV
When you have drawn Areas of Interest (AOIs) in a media item analysis, and clicked ‘Calculate’, you can export the statistics as a CSV file by clicking the ‘Download CSV’ button in the analysis editor. This will download to your computer.
The CSV file has one ROW per selected viewing (when you created the analysis, you picked a media item and some compatible viewings).
The CSV file has the same COLUMNS for every viewing.
These columns include details of the study, the view, and the media.
For each AOI, there are an additional set of columns. These include the location and size of the AOI in image pixels, relative to the top-left corner of the media item; and the statistics about each AOI that you saw on-screen.
Individual viewer statistics
The statistics displayed on screen in the AOI editor are aggregated over all viewers.
The statistics export tool allows you to download a more in-depth range of statistics for each individual viewer, meaning you can run complex analyses including t-tests and ANOVAs as well.
Compatibility with other software
When you import the CSV file into a spreadsheet editor such as Microsoft Excel, the program will ask you to specify the delimiters in the file. Please select only ‘commas’ as the delimiter.
In general the CSV file should import into most spreadsheet software.
Note that if you have used commas in meta-data (such as media names) this may disrupt the formatting of the file when loaded by third-party software.