Learning center

FAQ

All commonly asked questions are posted here. Questions are classified by gategories to help you quickly access answers - click on a category below. Feel free to contact us if you are not able to find the answer here.

What is the CSV export format?

Test results data can be exported as CSV files (comma-separated values), for easy importing into e.g. Excel or other spreadsheet applications. Below is a description of the CSV format. Let’s start with a couple of examples.

Example 1
a line logging the current number of active clients (4) that run the user scenario “Citerus JS-test” on the Ashburn load zone:

2011-11-22 16:13:51,__li_clients_active,,"Amazon US East (Ashburn, US)",Citerus JS-test (ID: 1005974),,,,,,4.0

Example 2
a line logging min/max/avg transaction times and number of transactions for the www.dom.ain/jquery.validate.js URL by clients running the user scenario “Citerus JS-test” on the Ashburn load zone and where the HTTP status (response) code for the transactions was 200:

2011-11-22 @16:13:51,__li_url_9fab2690b88546b3addf566e19af9dd9_200,http://www.dom.ain/jquery.validate.js,“Amazon US East (Ashburn, US)”,Citerus JS-test (ID: 1005974),200,58.82,178.21,85.68,112,


Detailed information about the CSV fields

All lines use the following column format (fields):

Time,Result ID,URL,Load zone,User scenario,Status code,RTT min,RTT max,RTT avg,Count,Value


Column name Description Example
Time UTC timestamp when the result was recorded. In ISO-8601 format (YYYY-MM-DD HH:MM:SS) 2011-11-22 16:12:17
Result ID Unique name for the result. For automatically generated metrics, it will start with “__li_” __li_requests_per_second
URL What URL the result value relates to, if the result is a URL result (has a Result ID that starts with “__li_url_”), otherwise this field will be empty http://www.dom.ain/jquery.validate.js
Load zone  The name of the load zone where the result was collected "Amazon US East (Ashburn, US)"
User scenario The name (and ID number) of the user scenario that collected the result  Citerus JS-test (ID: 1005974)
Status code What HTTP status code the result value relates to, if the result is a “__li_url_” result, otherwise this field will be empty 200
RTT min  The minimum transaction time (in milliseconds) seen for the URL since last report. This field is empty if the result not a “__li_url_” result 132.74
RTT max The maximum transaction time (in milliseconds) seen for the URL since last report. This field is empty if the result not a “__li_url_” result 2447.61
RTT avg The average transaction time (in milliseconds) seen for the URL since last report. This field is empty if the result not a “__li_url_” result 159.34
Count  The number of original transactions that were used to compute this aggregated result. I.e. in the case of reporting transaction times for status code 200 for URL X, the Count value shows how many such transactions occurred during the report interval  93
Value This is the actual measurement value for all results that do not begin with “__li_url_” (where transaction time reporting is usually not applicable)  12345

Note some string values have comma characters in them. Like “Amazon US East (Ashburn, US)”. These strings will be enclosed in quotation marks (”“) to make the string be parsed as one single field value, despite containing the separator character (comma).


See also: - What metrics are reported for a URL?


Permalink