Flex plan: Export session data as a CSV

Admins on the Flex plan can export session data as a CSV file from the Usage and history dashboard. Exporting data allows you to conduct further analysis in various tools like Google Sheets and Excel.

 

This article applies to: ut logo tiny.pngUserTesting 

 

On this page:

 


 

How it works

  1. Navigate to the Usage and history tab.
  2. Click Export as CSV.
  3. Select Session data
    csv_export.png

 

Inside the CSV export

In the CSV export, the Session data contains a row for each session and includes the following columns: 

Test ID Session ID Operating System
Test Name Contributor Username Removed
Creator Name Launch Date (timezone in UTC) Template
Creator Email Completed Date (timezone in UTC) Short Test
Launcher Name Status Test Type
Launcher Email Booked Duration (min) Network Type
Approver Name Actual Duration (min) Session Units Used (completed date)
Approver Email Removed Session Units Pending (launch date)
Workspace Browser Version  

 

Note:

  • Sessions are removed from the dashboard when replaced by another session, refunded, or hidden.
  • The session removed from the dashboard might have contained Personally Identifiable Information or have been canceled due to pending session cancellation or completed session refund/replace.

 

 

The Status column

The Status column contains a variety of statuses. The table below illustrates the different session statuses and what they are.

Status Description
Pending

A session is waiting for a contributor. Read this article for more information about how to cancel pending sessions from your dashboard.

Reserved

A Live Conversation session that a contributor has reserved.

Accepted A contributor has accepted the session but hasn't started recording yet.
Started A session that a contributor has started but hasn't completed yet.
Problem A contributor has reported a problem with the session and cannot continue unless the test is fixed and restarted. Read this article for more information.
On Hold A session was put on hold because of a technical issue. No contributor can take the test until the test is fixed and restarted. Read this article for more information.
Uploading The video from a session is currently in the process of uploading.
Uploaded The video from a session is uploaded, but processing is still underway. This should be a transitory state, but please contact Support if the session is in the Uploaded status longer than a day.
Completed

A contributor finished a test session.

Expired The contributor didn't start or finish the test in the given time frame. A replacement session will automatically be created for you.
Refunded The test session was canceled due to a low rating or your request.
Canceled

A pending session that you or Support canceled.

 

 

Pending Session Units

If you have disabled flex and cannot launch new tests because you have no Session Units remaining, you may want to use the CSV export to identify Pending Session Units to cancel. To do this:

  1. Filter for the Session Units Pending that have a value greater than zero in the CSV export.
  2. Decide to cancel these pending sessions from your dashboard.
    Note: This process does not apply to sessions with the status of on hold, problem, uploading, or uploaded; please contact Support to cancel these types of sessions.
    For Live Conversation sessions, you can cancel sessions with the status of uploaded.

 

 

Related content

information icon.png

knowledge icon.png

Want to learn more? Check out these Knowledge Base articles... 

Interested in growing your skills? Check out our University courses...

video icon 2.png

team icon.png

Need hands-on training?

Can't find your answer?

 

Please provide any feedback you have on this article. Your feedback will be used to improve the article and should take no more than 5 minutes to complete. Article evaluations will remain completely confidential unless you request a follow-up. 

Was this article helpful?