Governments; ISPs
This guide will walk you through how to use, read and understand raw data (if available to you).
Tip: Raw Data files are data files produced by our infrastructure to aid in in-depth analysis of complicated issues. If you are unsure how to access and view your raw data files, contact your account manager.
Attention: Depending on your test infrastructure, code-base, test schedule, and other factors there may be some minor variations in the csv files and definitions listed below. If you are unsure contact your account manager.
Here are some definitions to keep in mind when using & looking at raw data csv files;
curr_cdn.csv - Content Delivery Networks Test
unit_id |
Unique identifier for an individual unit |
dtime |
Time test finished in UTC |
provider |
Provider being tested (e.g. Apple, Akamai, etc) |
url |
Target URL |
address |
Target IP address |
http_code |
HTTP code returned by the target site |
dns_lookup_time |
Duration of the DNS lookup in microseconds |
time_connect |
How many microseconds it took to establish a TCP connection to the CDN |
time_starttransfer |
How many microseconds it took to transfer the first byte from the CDN |
time_total |
Total time in microseconds to complete the test run |
size_download |
Size in bytes of data transferred |
speed_download |
Throughput in bytes/sec |
successes |
Number of successes (always 1 or 0 for this test) |
failures |
Number of failures (always 1 or 0 for this test) |
location_id |
Please ignore (this is an internal key mapping to unit profile data) |
curr_dlping.csv – Downstream Latency Under Load
unit_id |
Unique identifier for an individual unit |
dtime |
Time test finished in UTC |
target |
Target hostname or IP address |
rtt_avg |
Average RTT in microseconds |
rtt_min |
Minimum RTT in microseconds |
rtt_max |
Maximum RTT in microseconds |
rtt_std |
Standard Deviation in Measured RTT in microseconds |
successes |
Number of successes |
failiures |
Number of failures |
location_id |
Please ignore (this is an internal key mapping to unit profile data) |
curr_dns.csv - DNS Resolution and Failure Rate
unit_id |
Unique identifier for an individual unit |
dtime |
Time test finished in UTC |
nameserver |
Nameserver used to handle the DNS request |
lookup_host |
Hostname to be resolved |
response_ip |
Field unused at present |
rtt |
DNS resolution time in microseconds |
successes |
Number of successes (always 1 or 0 for this test) |
failures |
Number of failures (always 1 or 0 for this test) |
location_id |
Please ignore (this is an internal key mapping to unit profile data) |
curr_httpget.csv - Download Speed Test (Single-Thread)
unit_id |
Unique identifier for an individual unit |
dtime |
Time test finished in UTC |
target |
Target hostname or IP address |
address |
The IP address of the server (resolved by the client's DNS) |
fetch_time |
Time the test ran for in microseconds |
bytes_total |
Total bytes downloaded across all connections |
bytes_sec |
Running total of throughput, which is sum of speeds measured for each stream (in bytes/sec), from the start of the test to the current interval |
bytes_sec_interval |
Throughput at this specific interval. In the US, we report only a single interval, so value matches bytes_sec. |
warmup_time |
Time consumed for all the TCP streams to arrive at optimal window size (Units: microseconds) |
warmup_bytes |
Bytes transferred for all the TCP streams during the warm-up phase. |
sequence |
The interval that this row refers to (in the US, this is always 0, as we report only one interval of 10 seconds) |
threads |
The number of concurrent TCP connections used in the test |
tcp_retransmissions |
Number of TCP Retransmissions during this test |
successes |
Number of successes (always 1 or 0 for this test) |
failures |
Number of failures (always 1 or 0 for this test) |
location_id |
Please ignore (this is an internal key mapping to unit profile data) |
curr_httpgetmt.csv - Download Speed Test (Multi-Thread)
unit_id |
Unique identifier for an individual unit |
dtime |
Time test finished in UTC |
target |
Target hostname or IP address |
address |
The IP address of the server (resolved by the client's DNS) |
fetch_time |
Time the test ran for in microseconds |
bytes_total |
Total bytes downloaded across all connections |
bytes_sec |
Running total of throughput, which is sum of speeds measured for each stream (in bytes/sec), from the start of the test to the current interval |
bytes_sec_interval |
Throughput at this specific interval. In the US, we report only a single interval, so value matches bytes_sec. |
warmup_time |
Time consumed for all the TCP streams to arrive at optimal window size (Units: microseconds) |
warmup_bytes |
Bytes transferred for all the TCP streams during the warm-up phase. |
sequence |
The interval that this row refers to (in the US, this is always 0, as we report only one interval of 10 seconds) |
threads |
The number of concurrent TCP connections used in the test |
tcp_retransmissions |
Number of TCP Retransmissions during this test |
successes |
Number of successes (always 1 or 0 for this test) |
failures |
Number of failures (always 1 or 0 for this test) |
location_id |
Please ignore (this is an internal key mapping to unit profile data) |
curr_httpgetmt6.csv - Download Speed Test (Multi-Thread, IPv6)
unit_id |
Unique identifier for an individual unit |
dtime |
Time test finished in UTC |
target |
Target hostname or IP address |
address |
The IP address of the server (resolved by the client's DNS) |
fetch_time |
Time the test ran for in microseconds |
bytes_total |
Total bytes downloaded across all connections |
bytes_sec |
Running total of throughput, which is sum of speeds measured for each stream (in bytes/sec), from the start of the test to the current interval |
bytes_sec_interval |
Throughput at this specific interval. In the US, we report only a single interval, so value matches bytes_sec. |
warmup_time |
Time consumed for all the TCP streams to arrive at optimal window size (Units: microseconds) |
warmup_bytes |
Bytes transferred for all the TCP streams during the warm-up phase. |
sequence |
The interval that this row refers to (in the US, this is always 0, as we report only one interval of 10 seconds) |
threads |
The number of concurrent TCP connections used in the test |
tcp_retransmissions |
Number of TCP Retransmissions during this test |
successes |
Number of successes (always 1 or 0 for this test) |
failures |
Number of failures (always 1 or 0 for this test) |
location_id |
Please ignore (this is an internal key mapping to unit profile data) |
curr_httppost.csv - Upload Speed Test (Single-Thread)
unit_id |
Unique identifier for an individual unit |
dtime |
Time test finished in UTC |
target |
Target hostname or IP address |
address |
The IP address of the server (resolved by the client's DNS) |
fetch_time |
Time the test ran for in microseconds |
bytes_total |
Total bytes downloaded across all connections |
bytes_sec |
Running total of throughput, which is sum of speeds measured for each stream (in bytes/sec), from the start of the test to the current interval |
bytes_sec_interval |
Throughput at this specific interval. In the US, we report only a single interval, so value matches bytes_sec. |
warmup_time |
Time consumed for all the TCP streams to arrive at optimal window size (Units: microseconds) |
warmup_bytes |
curr_youtubeinterim.csv |
sequence |
The interval that this row refers to (in the US, this is always 0, as we report only one interval of 10 seconds) |
threads |
The number of concurrent TCP connections used in the test |
tcp_retransmissions |
Number of TCP Retransmissions during this test |
successes |
Number of successes (always 1 or 0 for this test) |
failures |
Number of failures (always 1 or 0 for this test) |
Locationn_id |
Please ignore (this is an internal key mapping to unit profile data) |
curr_httppostmt.csv - Upload Speed Test (Multi-Thread)
unit_id |
Unique identifier for an individual unit |
dtime |
Time test finished in UTC |
target |
Target hostname or IP address |
address |
The IP address of the server (resolved by the client's DNS) |
fetch_time |
Time the test ran for in microseconds |
bytes_total |
Total bytes downloaded across all connections |
bytes_sec |
Running total of throughput, which is sum of speeds measured for each stream (in bytes/sec), from the start of the test to the current interval |
bytes_sec_interval |
Throughput at this specific interval. In the US, we report only a single interval, so value matches bytes_sec. |
warmup_time |
Time consumed for all the TCP streams to arrive at optimal window size (Units: microseconds) |
warmup_bytes |
Bytes transferred for all the TCP streams during the warm-up phase. |
sequence |
The interval that this row refers to (in the US, this is always 0, as we report only one interval of 10 seconds) |
threads |
The number of concurrent TCP connections used in the test |
tcp_retransmissions |
Number of TCP Retransmissions during this test |
successes |
Number of successes (always 1 or 0 for this test) |
failures |
Number of failures (always 1 or 0 for this test) |
location_id |
Please ignore (this is an internal key mapping to unit profile data) |
curr_httppostmt6.csv - Upload Speed Test (Multi-Thread, IPv6)
unit_id |
Unique identifier for an individual unit |
dtime |
Time test finished in UTC |
target |
Target hostname or IP address |
address |
The IP address of the server (resolved by the client's DNS) |
fetch_time |
Time the test ran for in microseconds |
bytes_total |
Total bytes downloaded across all connections |
bytes_sec |
Running total of throughput, which is sum of speeds measured for each stream (in bytes/sec), from the start of the test to the current interval |
bytes_sec_interval |
Throughput at this specific interval. In the US, we report only a single interval, so value matches bytes_sec. |
warmup_time |
Time consumed for all the TCP streams to arrive at optimal window size (Units: microseconds) |
warmup_bytes |
Bytes transferred for all the TCP streams during the warm-up phase. |
sequence |
The interval that this row refers to (in the US, this is always 0, as we report only one interval of 10 seconds) |
threads |
The number of concurrent TCP connections used in the test |
tcp_retransmissions |
Number of TCP Retransmissions during this test |
successes |
Number of successes (always 1 or 0 for this test) |
failures |
Number of failures (always 1 or 0 for this test) |
location_id |
Please ignore (this is an internal key mapping to unit profile data) |
curr_hulu.csv - Hulu Video QoE
unit_id |
The ID of the measurement probe |
dtime |
Timestamp (UTC) of the measurement |
bitrate |
Bitrate of emulated video in bytes/sec |
cdn |
CDN used for video (eg 'level3') |
codec |
Codec used for video (eg 'H264') |
video_length |
Length of video in microseconds |
prebuffer_time |
How long it took to fetch 2 seconds of video at the specified bitrate in microseconds |
test_duration |
Duration of the test in microseconds |
stalls |
How many times has it stalled at this bitrate |
total_stall_duration |
Sum of the durations of all the stalls, in microseconds |
avg_stall_duration |
Average of the durations of all the stalls, in microseconds |
download_bytes_sec |
Speed of total download, in bytes/sec |
download_bytes |
Total download bytes |
download_duration |
Total download duration in microseconds |
tcp_connect_time |
Time to establish connection with stream provider in microseconds |
ip_address |
IP address of target server |
error_code |
Error code produced by test |
error_msg |
Error message produced by test (eg 'MAXDOWNLOADLENGTH') |
successes |
Number of successes (always 1 or 0 for this test) |
failures |
Number of failures (always 1 or 0 for this test) |
location_id |
Please ignore (this is an internal key mapping to unit profile data) |
curr_lct_ul.csv - Lightweight Capacity Test – Download
unit_id |
Unique identifier for an individual unit |
dtime |
Time test finished in UTC |
target |
Target hostname |
address |
Target IP address |
packets_received |
Total number of packets received |
packets_sent |
Total number of packets sent |
packet_size |
Packet size |
bytes_total |
Total number of bytes |
duration |
Duration of the test in microseconds |
bytes_sec |
Throughput in bytes/sec |
error_code |
An internal error code from the test. |
successes |
Number of successes (always 1 or 0 for this test) |
failures |
Number of failures (always 1 or 0 for this test) |
location_id |
Please ignore (this is an internal key mapping to unit profile data) |
curr_lct_ul.csv - Lightweight Capacity Test – Upload
unit_id |
Unique identifier for an individual unit |
dtime |
Time test finished in UTC |
target |
Target hostname |
address |
Target IP address |
packets_received |
Total number of packets received |
packets_sent |
Total number of packets sent |
packet_size |
Packet size |
bytes_total |
Total number of bytes |
duration |
Duration of the test in microseconds |
bytes_sec |
Throughput in bytes/sec |
error_code |
An internal error code from the test. |
successes |
Number of successes (always 1 or 0 for this test) |
failures |
Number of failures (always 1 or 0 for this test) |
location_id |
Please ignore (this is an internal key mapping to unit profile data) |
curr_netusage.csv - Bandwidth Usage
unit_id |
Unique identifier for an individual unit |
dtime |
Time test finished in UTC |
wan_rx_bytes |
Total bytes recevied via the WAN interface on the unit (incl. Ethernet/IP headers) |
wan_tx_bytes |
Total bytes transmitted via the WAN interface on the unit (incl. Ethernet/IP headers) |
sk_rx_bytes |
Bytes received as a result of active performance measurements |
sk_tx_bytes |
Bytes transmitted as a result of active performance measurements |
location_id |
Please ignore (this is an internal key mapping to unit profile data) |
curr_nflx.csv - Netflix Video QoE
unit_id |
The ID of the measurement probe |
dtime |
Timestamp (UTC) of the measurement |
target |
Netflix OCA hostname |
address |
Netflix OCA IP address |
bitrate |
Bitrate of emulated video in bytes/sec |
max_bitrate |
The maximum bitrate supported by Netflix (currently always 15.6Mbps) in bytes/sec |
stall_events |
How many times has it stalled at this bitrate |
stall_duration_total |
Sum off the durations (usec) of all the stalls |
connect_time |
Time it took to establish the TCP connection with the content server in usec |
download_duration |
Duration of the test in usec |
prebuffering_duration |
How long it took to fetch 2 seconds of video at the specified bitrate in usec |
bytes_sec |
Download speed in bytes/sec after the prebuffering finished |
error |
Detailed error code: NO_ERROR / |
error_msg |
Detailed error message if a problem occurred fetching the content from Netflix |
successes |
1 if the test runs for the full duration (may have stalls though) i.e. it was not aborted and stepped down |
failures |
1 if the test was aborted for some reason |
location_id |
Please ignore (this is an internal key mapping to unit profile data) |
curr_ping.csv - ICMP Ping
unit_id |
Unique identifier for an individual unit |
dtime |
Time test finished in UTC |
target |
Target hostname or IP address |
rtt_avg |
Average RTT in microseconds |
rtt_min |
Minimum RTT in microseconds |
rtt_max |
Maximum RTT in microseconds |
rtt_std |
Standard Deviation in Measured RTT in microseconds |
successes |
Number of successes |
failiures |
Number of failures |
location_id |
Please ignore (this is an internal key mapping to unit profile data) |
curr_traceroute.csv - Traceroute
unit_id |
Unique identifier for an individual unit |
dtime |
Time test finished in UTC |
target |
The hostname of the traceroute destination |
address |
The IP address of the traceroute destination |
protocol |
Indicates whether we are using ICMP or TCP or UDP traceroutes |
hop |
The hop number of this row (one row is generated per hop in a traceroute) |
hop_address |
The IP address of the hop |
hop_name |
The reverse DNS entry for the hop |
sent |
Packets sent to this hop |
received |
Packets received from this hop |
rtt_avg |
Average RTT of the packets received back from this hop in microseconds |
successes |
Number of successes (always 1 or 0 for this test) |
failures |
Number of failures (always 1 or 0 for this test) |
location_id |
Please ignore (this is an internal key mapping to unit profile data) |
curr_udpjitter.csv - VoIP / UDP Jitter
unit_id |
Unique identifier for an individual unit |
dtime |
Time test finished in UTC |
target |
Target hostname or IP address |
packet_size |
Size of each UDP Datagram (Units: Bytes) |
stream_rate |
Rate at which the UDP stream is generated (Units: bits/sec) |
duration |
Total duration of test (Units: microseconds) |
packets_up_sent |
Number of packets sent in Upstream (measured by client) |
packets_down_sent |
Number of packets sent in Downstream (measured by server) |
packets_up_recv |
Number of packets received in Upstream (measured by server) |
packets_down_recv |
Number of packets received in Downstream (measured by client) |
jitter_up |
Upstream Jitter measured (Units: microseconds) |
jitter_down |
Downstream Jitter measured (Units microseconds) |
latency |
99th percentile of round trip times for all packets |
successes |
Number of successes (always 1 or 0 for this test) |
failures |
Number of failures (always 1 or 0 for this test) |
location_id |
Please ignore (this is an internal key mapping to unit profile data) |
curr_udplatency.csv - UDP Based Latency and Packet Loss
unit_id |
Unique identifier for an individual unit |
dtime |
Time test finished in UTC |
target |
Target hostname or IP address |
rtt_avg |
Average RTT in microseconds |
rtt_min |
Minimum RTT in microseconds |
rtt_max |
Maximum RTT in microseconds |
rtt_std |
Standard Deviation in Measured RTT in microseconds |
successes |
Number of successes (note: use failures/(successes+failures)) for packet loss) |
failiures |
Number of failures (packets lost) |
location_id |
Please ignore (this is an internal key mapping to unit profile data) |
curr_udplatency6.csv - UDP Based Latency and Packet Loss (IPv6)
unit_id |
Unique identifier for an individual unit |
dtime |
Time test finished in UTC |
target |
Target hostname or IP address |
rtt_avg |
Average RTT in microseconds |
rtt_min |
Minimum RTT in microseconds |
rtt_max |
Maximum RTT in microseconds |
rtt_std |
Standard Deviation in Measured RTT in microseconds |
successes |
Number of successes (note: use failures/(successes+failures)) for packet loss) |
failiures |
Number of failures (packets lost) |
location_id |
Please ignore (this is an internal key mapping to unit profile data) |
curr_ulping.csv – Upstream Latency Under Load
unit_id |
Unique identifier for an individual unit |
dtime |
Time test finished in UTC |
target |
Target hostname or IP address |
rtt_avg |
Average RTT in microseconds |
rtt_min |
Minimum RTT in microseconds |
rtt_max |
Maximum RTT in microseconds |
rtt_std |
Standard Deviation in Measured RTT in microseconds |
successes |
Number of successes |
failiures |
Number of failures |
location_id |
Please ignore (this is an internal key mapping to unit profile data) |