Analytics Report Details

Analytics report types

The Analytics extract API takes a type parameter which selects the output CSV report content, where type is one of:

inputs, for the Inputs Report
issues, for the Issues Report
completion, for the Completion Report
job_steps, for the Job Steps Report
deviations, for the Deviations

The detailed columns of these CSV reports are described below.

Content of specific report types

Inputs report

Selected by type=inputs

The Inputs report contains field inputs and step completions from jobs. For this report, the time period corresponds to all field inputs and step completions (excluding setting the step or step group as n/a) that occurred during the time period. Note that the time period is applied to the date of the input and is not related to start or completion of a job. Thus, it is possible to generate input values for a given step or field that is not the final value for a completed job. It is a CSV document with the following columns.

Note that the Template Report available via the UI is just an Inputs report with a specific template ID.

Index #	Column name	Description	Example
1	Date	Date of input in this row	2017-03-01
2	Time	Time of input in this row	19:25:53
3	Time Zone	Time zone for row as a UTC offset; this will change across a daylight adjustment	UTC-07
4	Job ID	UUID uniquely identifying the job	12345678-9ABC-DEF0-1234-56789ABCDEF0
5	Job Name	Name of the job (not unique)
6	Job Template Number	Unique index of the template within the job (order added to job)	2
7	Template ID	UUID uniquely identifying the template	12345678-9ABC-DEF0-1234-56789ABCDEF0
8	Template Version	Version of template used	1
9	Template Name	Name of the template
10	Step ID	UUID uniquely identifying the global step (may be shared across templates within a job)	12345678-9ABC-DEF0-1234-56789ABCDEF0
11	Job Step ID	UUID uniquely identifying the step within a job	12345678-9ABC-DEF0-1234-56789ABCDEF0
12	Template Step Number	Position of the step within the template	1.2.3
13	Step Name	Name of the step
14	Field ID	UUID uniquely identifying the field (may be shared across steps, should be used along with Job Step ID)	12345678-9ABC-DEF0-1234-56789ABCDEF0
15	Field Name	Name of the field, Step Completion, or Job Completion
16	Field Type	Type of the field, or Completion	Text, Number, List, Photo, Video, Signature, Completion
17	Field Value	Value of the field, or Captured for completions or media types
18	Is Na	To indicate if field was marked as N/A or not, 1=N/A
19	Executor ID	UUID identifying the user reporting the input	12345678-9ABC-DEF0-1234-56789ABCDEF0
20	Executor Name	Name of the user
21-a	job params	One column for each job parameter, in the same order displayed elsewhere
(a+1)-b	template params	One column for each template parameter, in the same order displayed elsewhere

Issues report

Selected by type=issues

The Issues report contains field inputs from issues on the team. For this report, the time period corresponds to all field inputs and issue open or resolution that occurred during the time period. This may include only parts of some issue executions. It is a CSV document with the following columns.

Index #	Column name	Description	Example
1	Date	Date of input in this row	2017-03-01
2	Time	Time of input in this row	19:25:53
3	Time Zone	Time zone for row as a UTC offset; this will change across a daylight adjustment	UTC-07
4	Issue ID	Lookup ID uniquely identifying the issue on the team	team-i-123
5	Issue Title	Title of the issue (not unique)
6	Issue Priority	Priority of the issue	1
7	Status	Status of the issue	Open or Resolved
8	Job ID	If the issue was created on a job, UUID uniquely identifying the job	12345678-9ABC-DEF0-1234-56789ABCDEF0
9	Job Name	If the issue was created on a job, name of the job
10	Job Step Group ID	If the issue was created on a step group, UUID uniquely identifying the step group	12345678-9ABC-DEF0-1234-56789ABCDEF0
11	Job Step ID	If the issue was created on a step, UUID uniquely identifying the step	12345678-9ABC-DEF0-1234-56789ABCDEF0
12	Job Step Name	If the issue was created on a step, name of the step
13	Issue Template Number	Unique index of the template within the issue (order added to issue)	1
14	Template ID	UUID uniquely identifying the template	12345678-9ABC-DEF0-1234-56789ABCDEF0
15	Template Version	Version of template used	1
16	Template Name	Name of the template
17	Field ID	UUID uniquely identifying the field (may be shared across steps, should be used along with Job Step ID)	12345678-9ABC-DEF0-1234-56789ABCDEF0
18	Field Name	Name of the field, Issue Open, or Issue Resolution
19	Field Type	Type of the field, Open, or Resolution	Text, Number, List, Photo, Video, Signature, Completion
20	Field Value	Value of the field, or Captured for issue status change or media types
21	Is Na	To indicate if field was marked as N/A or not, 1=N/A
22	Units	Unit of Measurement of the Field Value
23	Executor ID	UUID identifying the user reporting the input	12345678-9ABC-DEF0-1234-56789ABCDEF0
24	Executor Name	Name of the user
25-a	job (issue) params	One column for each job (issue) parameter, in the same order displayed elsewhere
(a+1)-b	template params	One column for each template parameter, in the same order displayed elsewhere

Completion report

Selected by type=completion

The Completion report contains all steps in jobs completed during the time period, with their status (e.g. Complete, Marked N/A) along with estimated start times for the job and all steps. It is a CSV document with the following columns.

Index #	Column name	Description	Example
1	Job Completion Date	Completion date of this job	2017-03-02
2	Job Completion Time	Completion time of this job	07:52:35
3	Time Zone	Time zone for row as a UTC offset; this will change across a daylight adjustment	UTC-07
4	Job Start Date	Start date of this job	2017-03-01
5	Job Start Time	Start time of this job	19:25:53
6	Job Duration	Duration of this job	12:26:42
7	Job ID	UUID uniquely identifying the job	12345678-9ABC-DEF0-1234-56789ABCDEF0
8	Job Name	Name of the job (not unique)
9	Job Template Number	Unique index of the template within the job (order added to job)	3
10	Template ID	UUID uniquely identifying the template	12345678-9ABC-DEF0-1234-56789ABCDEF0
11	Template Version	Version of template used	1
12	Template Name	Name of the template
13	Step Completion Date	Completion date of this step	2017-03-01
14	Step Completion Time	Completion time of this step	22:33:55
15	Step Start Date	Start date of this step, approximated based on first view	2017-03-01
16	Step Start Time	Start time of this step, approximated based on first view	21:53:25
17	Step Duration	Duration of this step	00:40:30
18	Step ID	UUID uniquely identifying the global step (may be shared across templates within a job)	12345678-9ABC-DEF0-1234-56789ABCDEF0
19	Job Step ID	UUID uniquely identifying the step within a job	12345678-9ABC-DEF0-1234-56789ABCDEF0
20	Template Step Number	Position of the step within the template	1.2.3
21	Step Name	Name of the step
22	Step Status	Final status of the step in the completed job	Incomplete, Complete, Reopened, or Marked N/A
23	Executor ID	UUID identifying the user setting the status	12345678-9ABC-DEF0-1234-56789ABCDEF0
24	Starter ID	UUID identifying the user starting the step	12345678-9ABC-DEF0-1234-56789ABCDEF0
25	Executor Name	Name of the user setting the status
26-a	job params	One column for each job parameter, in the same order displayed elsewhere
(a+1)-b	template params	One column for each template parameter, in the same order displayed elsewhere

Job Steps report

Selected by type=job_steps

All steps for a completed job with the final values for input fields. One record for each step within a job. All timestamps are reported as UTC. This report may take a few minutes to generate. It is a CSV document with the following columns.

Index #	Column name	Description	Example
1	Job Uuid	UUID for the job	12345678-9ABC-DEF0-1234-56789ABCDEF0
2	Job Lookup Id	Readable identifier for a job, generated by Parsable	Job-1234
3	Job Created At	When the job was created	2017-01-01 23:59:59
4	Job Started At	When the job was started	2017-01-01 23:59:59
5	Job Completed At	Latest timestamp of the job was completed	2017-01-01 23:59:59
6	Job Title	Name of job entered by author	Temperature Inspection
7	Step Hierarchy Order	Ordinal position of steps within a job (may show irregularities with offline activity)	1
8	Step Hierarchy Position	Hierarchy of steps and ordinal position using dot notation	1.2.3
9	Step Uuid	UUID for a step. A repeated step will have a the same value	12345678-9ABC-DEF0-1234-56789ABCDEF0
10	Job Step Uuid	UUID for a step within a job. A repeated step will have a different value	12345678-9ABC-DEF0-1234-56789ABCDEF0
11	Job Step Title	Name of step entered by author	Check Back Panel Gauges
12	Template Uuid	UUID of the template used. Null if the step is not assigned to a template	12345678-9ABC-DEF0-1234-56789ABCDEF0
13	Template Name	Name of template entered by author	Machine X Temperature Check
14	Template Version	Version of template associated with step	1
15	Step State	Final status of step when job was completed, `not_applicable` if the step has no execution data	complete
16	Step Completed At	When the step was last marked complete	2017-01-01 23:59:59
17	Field Values	JSON of all field values when step was completed, `"{}"` if no field values recorded	{"Gauge A":18}
18	Executor Id	UUID of user the executed the step	12345678-9ABC-DEF0-1234-56789ABCDEF0
19	Executor Name	Name of user the executed the step	Morty Smith

Deviations report

Selected by type=deviations

All deviations with field values when the deviation was created. All timestamps are reported as UTC. It is a CSV document with the following columns.

Index #	Column name	Description	Example
1	Deviation Uuid	UUID for the deviation	12345678-9ABC-DEF0-1234-56789ABCDEF0
2	Created At	When the deviation was created	2017-01-01 23:59:59
3	Deviation Kind Name	String encoding of the deviation kind	DEVIATION_INPUT_NA
4	Deviation Kind Display Name	Human readable representation of hte deviation kind	Step Input Marked N/A
5	Job Uuid	UUID for the job	12345678-9ABC-DEF0-1234-56789ABCDEF0
6	Job Lookup Id	Readable identifier for a job, generated by Parsable	Job-1234
7	Job Title	Name of job entered by author	Temperature Inspection
8	Job Step Guid	UUID for a step within a job. A repeated step will have a different value	12345678-9ABC-DEF0-1234-56789ABCDEF0
9	Job Step Title	Name of step entered by author	Check Back Panel Gauges
10	Job Step Group UUID	UUID of the step group if the step is a member of this group	12345678-9ABC-DEF0-1234-56789ABCDEF0
11	Job Step Group Title	Name of step group entered by author	Check Gauges
12	Step Hierarchy Order	Ordinal position of steps within a job (may show irregularities with offline activity)	1
13	Step Hierarchy Position	Hierarchy of steps and ordinal position using dot notation	1.2.3
14	Field Uuid	UUID for the field	12345678-9ABC-DEF0-1234-56789ABCDEF0
15	Field Title	User generated title for the field	Gauge 10
16	Field Type	Data type for the input field	Text
17	Field String Value	Field value if field uses a string type	This is an input
18	Field Number Value	Field value if field uses a number type	1234
19	Field Timestamp Value	Field value if field uses a timestamp type	2017-01-01 23:59:59
20	Field Range Low	Minimum expected value for numeric types	1
21	Field Range High	Maximum expected value for numeric types	100
22	Field Order	Ordinal position of field within the step	1
23	Executor Id	UUID of user the executed the step	12345678-9ABC-DEF0-1234-56789ABCDEF0
24	Executor Name	Name of user the executed the step	Morty Smith