Mobile data model

When you retrieve test results for a test whose testType is MOBILE, the structure of the test results follows the Mobile data model. The following diagram depicts the basic structure of the Mobile data model.

A Test captures the result of a particular test execution at a given time on a given Mobile node (site). A test is uniquely identified by:

  • Its mid (MBG_mid will always be -1.)
  • The ttime at which it ran
  • The sid of the site on which it ran

A test contains one to many steps. A Step is uniquely identified by:

  • Its pseq (page sequence number) and the following fields of its test:
    • Its mid (MBG_mid will always be -1.)
    • Its ttime
    • Its sid

A step contains one to many objects. An Object is uniquely identified by:

  • Its oseq (object sequence number),
  • The pseq of its step and the following fields of its test:
    • Its mid (MBG_mid will always be -1.)
    • Its ttime
    • Its sid

A step also contains one to many hosts. A Host is uniquely identified by:

  • Its hid (host ID),
  • The pseq of its step and the following fields of its test:
    • Its mid (MBG_mid will always be -1.)
    • Its ttime
    • Its sid

A host contains one to many connections. A Connection is uniquely identified by:

  • Its connid
  • the hid (host ID) of the host that contains it
  • The pseq of the step the step that contains the host and the following fields of its test:
    • Its mid (MBG_mid will always be -1.)
    • Its ttime
    • Its sid

Because a query may return data from multiple test executions, the client will see multiple tests in the output, all with the same mid and MBG_mid but with different ttime and sid values. Some use cases will involve aggregating data from multiple test executions. Others will involve plotting data from multiple test executions within a single chart.

The full content model for Mobile data appears below:

Test

Field Description
mid Test ID
MBG_mid Monitor batch group monitor ID
tname Test name
ttype Test type (always set to Mobile)
ttime Timestamp of test relative to GMT
arrtime Arrival timestamp (populated if used in filter)
popid Population ID
popname Population name
prid Peer ID
prreg Peer region
prisp Peer ISP
prip Peer IP
rtime Response time
tpt Total steps
tps Successful steps
tpf Failed steps
tot Total objects
tos Successful objects
tof Failed objects
nbyte Number of bytes downloaded
prebw Pre-bandwidth
postbw Post-bandwidth
actualbw Actual bandwidth
carrier Carrier (reserved for future use)
location Location (reserved for future use)
connspeed Connection speed (reserved for future use)
conntype Connection type (reserved for future use)
signalstrength Signal strength (reserved for future use)

Step

Field Description
mid Test ID
MBG_mid Monitor batch group monitor ID
ttime Timestamp of test relative to GMT
arrtime Arrival timestamp (populated if used in filter)
popid Population ID
pseq Step sequence number
pname Step name
rtime Response time of Step in milliseconds
nobj Number of objects downloaded in the Step
rc200 Number of objects with a return code of 200-299
rc300 Number of objects with a return code of 300-399
rc400 Number of objects with a return code of 400-499
rc500 Number of objects with a return code of 500-599
rcnet Binary flag to indicate network related errors
rcint Binary flag to indicate site related errors
nbyte Total number of bytes in the Step
nhost Number of hosts in the Step
nconn Number of connections opened for the Step
cmstat Binary flag to indicate a content match failure
tostat Binary flag to indicate a socket time out error
usstat Binary flag to indicate a user script error
blstat Binary flag to indicate a byte limit exceeded error
rtobjseq Root object sequence number of the first object with a 200 return code
dnssum Summary of all DNS times for all the connections in milliseconds
ndns Number of DNS calls
connsum Summary of all connection times in milliseconds
sslsum Summary of all SSL connection times in milliseconds
nssl Number of SSL connections
fbsum Summary of all first byte times in milliseconds
nfb Number of first byte objects
contsum Summary of content download time in milliseconds
ncont Number of content time objects
ptime Processing time

Object

Field Description
mid Test ID
MBG_mid Monitor batch group monitor ID
ttime Timestamp of test relative to GMT
arrtime Arrival timestamp (populated if used in filter)
popid Population ID
pseq Step sequence number (step where the object is referenced)
oseq Unique object sequence number for a test
hid Unique host ID for the object
connid Unique connection ID for the object
rc Return code of the downloaded object
ctype MIME type of the object (only applicable with return code < 300)
rtime Response time of the object in milliseconds
nbyte Total number of bytes downloaded
fbstart Start timestamp in GMT format of the object download
fbtime Time in milliseconds to download the first byte of the object
contstart Time in milliseconds to download the second and subsequent bytes of the object
conttime Time in milliseconds to download the second and subsequent bytes of the object
urlhost URL of the host from where the object is downloaded
upage URL of the object
uparam Request parameters in the URL of an object
redirobjid If a redirect, the object ID of the redirection
spdy Flag for SPDY (set 1 or 0)

Host

Field Description
mid Test ID
MBG_mid Monitor batch group monitor ID
ttime Timestamp of test relative to GMT
arrtime Arrival timestamp (populated if used in filter)
popid Population ID
pseq Step sequence number (step where the hostname is referenced)
hid Host ID of the host
dnsstart Timestamp in GMT format of the start of the DNS connection
dnstime Time in milliseconds to resolve the DNS lookup
nbyte Total number of bytes downloaded from this host
nerr Total number of object errors from this host
nobj Total number of objects downloaded from this host
nconn Total number of connections for this host
ip IP address of the host

Connection

Field Description
mid Test ID
MBG_mid Monitor batch group monitor ID
ttime Timestamp of test relative to GMT
arrtime Arrival timestamp (populated if used in filter)
popid Population ID
pseq Step sequence number (step where the hostname is referenced)
hid Host ID of the host
connid Connection identifier
rtime Time in milliseconds to download all objects
connstart Timestamp in GMT format of the start of the object connection
conntime Time in milliseconds to open the connection
sslstart Timestamp in GMT format of the start of the SSL
ssltime Time in milliseconds to complete the SSL connection
nbyte Total number of bytes downloaded from this connection
nerr Total number of object errors from this connection
nobj Total number of objects downloaded from this connection

W3C metrics

Field Description
mid Test ID
MBG_mid Monitor batch group monitor ID
sid Site ID
ttime Time stamp (epoch) of test relative to GM
arrtime Arrival time stamp (populated if used in filter)
rootstepseq Step Sequence Number
w3cseq W3C record Number
stepseqs Not Used
navstart Timestamp of NavigationStart
uldstart UnloadEventStartOffset
uldend UnloadEventEndOffset
rdstart RedirectStartOffset
rdend RedirectEndOffset
fchstart fetchStartOffset
dlkstart domainLookupStartOffset
dlkend domainLookupEndOffset
constart connectionStartOffset
conend connectionEndOffset
sconstart secureConnectionStartOffset
reqstart requestStartOffset
rspstart responseStartOffset
rspend responseEndOffset
domld domLoadingOffset
domint domInteractiveOffset
dcldstart domContentLoadedEventStartOffset
dcldend domContentLoadedEventEndOffset
domcmpl domCompleteOffset
ldstart loadEventStartOffset
ldend loadEventEndOffset
uldtime unloadTime
rdtime redirectTime
fchtime fetchTime
dnstime dnsTime
contime connectTime
reqtime requestTime
rsptime responseTime
ssltime sslTime
firtpaint Time to First Paint