Connect UserTesting to Condens

Metrics in UserTesting are data

• automatically collected during the test, for example time on task or clicks, or

• that participants enter, for example for rate scale questions or written responses

You can export such data from UserTesting and upload them to Condens for further analysis. Here is how:

1. Open a test in UserTesting, check the box for each session you want to export and from the menu icon on the lower left select Export to Excel. Choose the option that exports all sessions into one Excel workbook.

   

2. For a smooth import we recommend to clean up the file a bit. As you will only need the Metrics sheet move it to the first position or delete the other sheets. Additionally, remove the first few rows above the one which contains the Username. Also remove the columns which contain calculations such as mean and median.

   

3. Now you are ready to import the file via the CSV/Excel import on the Session screen in Condens. For the import settings choose New Session every column and First column is row-title.

   

You can now structure text responses using tags and create charts to visualize data.

Open a test in UserTesting, check the box for each session you want to download and from the menu icon on the lower left select Download videos.

Once downloaded from UserTesting you can upload the videos to sessions in Condens to transcribe and analyze them.

UserTesting generates transcripts which you can import to Condens as text. To do so, follow the steps explained in Use Case 1 above but use the sheet with the name Session details instead. As you import the data to Condens you can create sections to separate the transcript by task and facilitate analysis.