August 11, 2020 The BMS lab

Metrics and export data

Quick guide

Analysing data

The Sociometry app allows for the recording of a conversation through a smartphone and enables analysis on wide array of aspects, such as the dominance of speakers, their tempo and tone. After finishing a session, you can now use the transcription and analysis tools of Sociometry.

Step 1.


To transcribe the audio file, select the spoken language, and click on “Process Data”. Depending on the length of the interview, this might take some time. While the transcription takes place, you can follow the status of the transcript. Once it shows “Done”, your audio file is transcribed.  

Step 2.


Once the audio is transcribed, the Sociometry software can do the analysis. To do so, click on “Process Data”. Under “Status”, you can check the status of the analysis. Once this shows “Done”, the analysis of your audio files is completed.  

Additionally, you can check the data in a graph. Go to “Graph” on the top of the page and click on graphs. You can see the turn talking and personality insight graphs.  

Metrics and Exporting Data

Step 1.


Go to “Metrics” on the left of the menu. Your data metrics consists of the audio files, transcription files and information your participants provide during their answering of your modules. The metrics page shows you an overview of data for all the participants in your study.

Select the session of which you want to download the data.

Checking the “Show Timings” checkbox will show you the length of time it took each participant to answer in a box to the right of the item.  

Step 2.


You can download the data from each session. If you have multiple participants, you can download the information separately or download all the files in one go. 

Importing Data in Excel

Step 1.


Open Excel. Go to the Data tab, in the Get & Transform Data group, click From Text/CSV. This will open a preview screen. Look for your data file and click on “Import”.

Step 2.


In the preview screen, the delimiter should be set to a comma. Select load to import the data into a new worksheet.

Importing Data in SPSS

Step 1.


Open SPSS. Go to file –> open –> data. This will open a new window. Make sure your files type is set to CVS. Find your data, select your data and open. This will open the “Text import Wizard” with six steps.

Step 2.


Step 1. Going through the steps of the import wizard, do not change any of the settings in the first step.
Step 2. Set the variables arranged to “Delimited”, set the question “Are variable names included at the top of your file” to “Yes”. Click on “Next”.
Step 3. Set “The first cases of data begins on which line number” to “2”.
Step 4. Set the delimiter to a comma. Click on “Next”.
Step 5. Here you can change the variable names, this can also be done on a later time.
Step 6. Do not change any of the settings. Click on “Finish” and your data will appear in a new SPSS worksheet.