Report Definitions

Below are definitions for each of the available report objects in the Coach Reporting API service, along with descriptions of each available field. All fields are available to be toggled visible/invisible in the UI and exported as a CSV. When querying via API directly, you'll need to include the list of fields you would like returned if you don't want the defaults.

Admin/Manager

API Object name
Admin

Field	JSON field	Data Type	Description	Visible by default
User ID	userId	String	ID of the user	No
First Name	firstName	String	First name of the user	Yes
Last Name	lastName	String	Last name of the user	Yes
Full Name	name	String	Full name of the user	No
Email	email	String	Email address of the user	No
Division ID	divisionId	String	ID of the Division the Course belongs to	No
Division Name	divisionName	String	Name of the Division the Course belongs to	No
Groups Managed	groupsManaged	Integer	Number of groups the user manages	Yes
Review Average	pitchAverage	Percent	Average score given to learners by the user during pitch reviews Requires PitchIQ activation	Yes
Reviews Assigned	reviewsAssigned	Integer	Number of pitch review tasks assigned to the user Requires PitchIQ activation	Yes
Reviews Completed	reviewsCompleted	Integer	Number of pitch review tasks completed by the user Requires PitchIQ activation	Yes
Reviews With Feedback	reviewsWithFeedback	Integer	Number of pitch reviews the user has provided written feedback on Requires PitchIQ activation	Yes
Role	permission	String	Role of the user. Possible values: Admin Manager	Yes
Users Managed	usersManaged	Integer	Number of learners managed by this user	Yes
Courses Administered	coursesAdministered	Integer	Number of Courses where the user is listed as the owner	Yes
Feedback Length Average	feedbackAverage	Float	Average number of characters given in pitch feedback Note: Requires PitchIQ activation	Yes

Course

API Object name
Course

Field	JSON field	Data Type	Description	Visible by default
Course ID	courseId	String	ID of the Course	No
Course Title	courseTitle	String	Title of the Course	Yes
Division ID	divisionId	String	ID of the Division the Course belongs to	No
Division Name	divisionName	String	Name of the Division the Course belongs to	No
Curriculum ID	curriculumId	String	ID of the curriculum the Course belongs to	No
Curriculum Title	curriculumTitle	String	Title of the curriculum the Course belongs to	No
Description	description	String	Description of the Course	No
Course Owner	admin	String	Owner of the Course	No
Course Status	courseStatus	String	Status of the Course. Possible values: Published Hidden (deprecated, only shown for historical data) Archived (only availble if a request has been made to show archived courses)	No
Course Created	courseCreated	Date	Date the Course was created	No
User Count	userCount	Integer	Count of users assigned to the Course	Yes
Start Count	startCount	Integer	Count of users who have started the Course	Yes
Start Percentage	startPercentage	Percent	Percentage of assigned users who have started the Course	Yes
Completion Count	completedCount	Integer	Count of users who have completed the Course	Yes
Completion Percentage	completedPercentage	Percent	Percentage of assigned users who have completed the Course	Yes
Was Overdue when completed (Count)	overdueCount	Integer	Count of users who were overdue on the Course when completed	Yes
Is Overdue now (Count)	overdueNowCount	Integer	Count of users who are ovedue on the Course now	Yes
Was Overdue when completed (%)	overduePercentage	Percent	Percentage of assigned users who were overdue on the Course when completed	Yes
Is Overdue now (%)	overdueNowPercentage	Percent	Percentage of assigned users who are overdue on the Course now	Yes
Test Average	testAverage	Percent	Average score received by all users who have submitted the test on the Course (- if no test exists) Note: Requires Exam activation	Yes
Pitch Average	pitchAverage	Percent	Average score received by all users who have submitted a PitchIQ on the Course (- if no PitchIQ exists) Note: Requires PitchIQ activation	Yes
Is SCORM	isScorm	String	Whether or not the Course is SCORM-enabled. Possible values: Yes No	No
Has Test	hasTest	String	Whether or not a test is attached to the Course. Possible values: Yes No Note: Requires Exam activation	No
Has PitchIQ	hasPitchIQ	String	Whether or not there is a PitchIQ attached to the Course. Possible values: Yes No Note: Requires PitchIQ activation	No

Course & Group

API Object name
CourseGroup

Field	JSON field	Data Type	Description	Visible by default
Course ID	courseId	String	ID of the Course	No
Course Title	courseTitle	String	Title of the Course	Yes
Division ID	divisionId	String	ID of the Division the Course belongs to	No
Division Name	divisionName	String	Name of the Division the Course belongs to	No
Curriculum ID	curriculumId	String	ID of the curriculum the Course belongs to	No
Curriculum Title	curriculumTitle	String	Title of the curriculum the Course belongs to	No
Description	description	String	Description of the Course	No
Course Owner	admin	String	Owner of the Course	No
Course Status	courseStatus	String	Status of the Course: Published Hidden (deprecated, only shown for historical data) Archived (only availble if a request has been made to show archived Courses)	No
Course Created	courseCreated	Date	Date the Course was created. Format: YYYY/MM/DD	No
Group ID	groupId	String	ID of the group	No
Group Name	groupTitle	String	Name of the group	Yes
Group Created Date	groupCreated	Date	Date the group was created. Format: YYYY/MM/DD	No
Rolling Due Date	dueDays	Integer	Number of days after the group is assigned (or a new user is assigned to the group) that the Course will be due	No
Due Date	dueDate	Date	Date the Course is due for users in the group. Format: YYYY/MM/DD	No
Is Required (Not Elective)	required	String	Whether or not the Course is required for the users in the group. Possible values: Yes No	No
Is Visible (Not Hidden)	visible	String	Whether or not the Course is visible in the Coach interface for users in the group. Possible values: Yes No	No
Assigned Date	assignedDate	Date	Date the group was assigned to the Course. Format: YYYY/MM/DD	No
User Count	userCount	Integer	Count of users in the group assigned to the Course	Yes
Start Count	startCount	Integer	Count of users in the group who have started the Course	Yes
Start Percentage	startPercentage	Percent	Percentage of assigned users who have started the Course	Yes
Completion Count	completedCount	Integer	Count of users in the group who have completed the Course	Yes
Completion Percentage	completedPercentage	Percent	Percentage of assigned users who have completed the Course	Yes
Was Overdue when completed (Count)	overdueCount	Integer	Count of users in the group who were overdue on the Course when completed	Yes
Was Overdue when completed (%)	overduePercentage	Percent	Percentage of assigned users who were overdue on the Course when completed	Yes
Is Overdue now (Count)	overdueNowCount	Integer	Count of users in the group who are overdue now	Yes
Is Overdue now (%)	overdueNowPercentage	Percent	Percentage of assigned users who are overdue on the Course now	Yes
Test Average	testAverage	Integer	Average score received by all users in this group who have submitted the test on this course (- if no test exists) Note: Requires Exam activation	Yes
Pitch Average	pitchAverage	Integer	Average score received by all users in the group who have submitted a PitchIQ on the Course (- if no Pitch IQ exists) Note: Requires PitchIQ activation	Yes
Is SCORM	isScorm	String	Whether or not the Course is SCORM-enabled. Possible values: Yes No	No
Has Test	hasTest	String	Whether or not a test is attached to the Course. Possible values: Yes No Note: Requires Exam activation	No
Has Pitch IQ	hasPitchIQ	String	Whether or not there is a Pitch IQ attached to the Course. Possible values: Yes No Note: Requires PitchIQ activation	No

Course & User

API Object name
CourseUser

Field	JSON field	Data Type	Description	Visible by default
User ID	userId	String	ID of the user	No
First Name	firstName	String	First name of the user	Yes
Last Name	lastName	String	Last name of the user	Yes
Email	email	String	Email address of the user	No
User Status	userStatus	String	Status of the user. Possible values: Registered Invited	No
User Created Date	userCreated	Date	Date the user was created. Format: YYYY/MM/DD	No
Assigned Group IDs	assignedGroupIds	String	Comma-separated list of IDs of groups the user is assigned to	No
Assigned Group Names	assignedGroupTitles	String	Comma-separated list of names of groups the user is assigned to	No
Course ID	courseId	String	ID of the Course	No
Course Title	courseTitle	String	Title of the Course	Yes
Division ID	divisionId	String	ID of the Division the Course belongs to	No
Division Name	divisionName	String	Name of the Division the Course belongs to	No
Curriculum ID	curriculumId	String	ID of the curriculum the Course belongs to	No
Curriculum Title	curriculumTitle	String	Title of the curriculum the Course belongs to	No
Description	description	String	Description of the Course	No
Course Owner	admin	String	Owner of the Course	No
Course Status	courseStatus	String	Status of the Course: Published Hidden (deprecated, only shown for historical data) Archived (only availble if a request has been made to show archived Courses)	No
Course Pass Fail Status	coursePassFailStatus	String	User's Course status: Passed Pending Score Failed	No
Course Created	courseCreated	Date	Date the Course was created. Format: YYYY/MM/DD	No
Assigned Date	assignedDate	Date	Date the user was assigned to the Course. Format: YYYY/MM/DD	No
Due Date	dueDate	Date	Date the Course is due for the user. Format: YYYY/MM/DD	Yes
Completion Date	completed	Date	Date the user completed the Course. Format: YYYY/MM/DD	Yes
Was Overdue when completed	overdue	String	Whether or not the user was overdue for the Course when completed. Possible values: Yes No	Yes
Is Overdue now	overdueNow	String	Whether or not the user was overdue for this Course now. Possible values: Yes No	Yes
Is Required (Not Elective)	required	String	Whether or not the user is required to complete this course. Possible values: Yes No	No
Learn Minutes	learnMinutes	Integer	Number of minutes the user has spent on the Course	Yes
Learn Progress	learnProgress	Integer	Percentage of items in the Course completed. Possible values: Yes No	Yes
Test Attempts	testAttempts	Integer	Number of attempts the user has made on the test for the Course Note: Requires Exam activation	Yes
Test Score	testScore	Integer	Score the user received on the test for this course Note: Requires Exam activation	Yes
Pitch Attempts	pitchAttempts	Integer	Number of attempts the user has made on the Pitch IQ for the Course Note: Requires PitchIQ activation	Yes
Is Pitch IQ Submitted	pitchSubmitted	String	Whether or not the user has submitted a pitch for the Course. Possible values: Yes No Note: Requires PitchIQ activation	Yes
Pitch Score	pitchScore	Integer	Score the user received on the Pitch IQ for the Course Note: Requires PitchIQ activation	Yes
Pitch Passed	pitchPassed	String	Whether or not the user received a passing score on this PitchIQ. Possible values: Yes No Note: Requires PitchIQ activation	No
Is SCORM	isScorm	String	Whether or not the Course is SCORM-enabled. Possible values: Yes No	No
Has Test	hasTest	String	Whether or not there is a test attached to this Course. Possible values: Yes No Note: Requires Exam activation	No
Has Pitch IQ	hasPitchIQ	String	Whether or not there is a Pitch IQ attached to the Course. Possible values: Yes No Note: Requires PitchIQ activation	No
Pitch Review Due Date	pitchReviewDueDate	Date	Date reviews for this pitch are due, if one exists. Format: YYYY/MM/DD Note: Requires PitchIQ activation	No
Pass/Fail Course	isPassFail	String	Whether or not the Course can be failed. Possible values: Yes No	No
Pitch Pass/Fail Status	pitchPassFailStatus	String	Whether or not the Pitch IQ attached to the Course can be failed. Possible values: Yes No Note: Requires PitchIQ activation	No
Test Pass/Fail Status	testPassFailStatus	String	Whether or not the test attached to the Course can be failed. Possible values: Yes No Note: Requires Exam activation	No

Curriculum

API Object name
Curriculum

Field	JSON field	Data Type	Description	Visible by default
Curriculum ID	curriculumId	String	ID of the curriculum	No
Curriculum Title	curriculumTitle	String	Title of the curriculum	Yes
Curriculum Created Date	curriculumCreated	Date	Date the curriculum was created. Format: YYYY/MM/DD	No
Division ID	divisionId	String	ID of the Division the curriculum belongs to	No
Division Name	divisionName	String	Name of the Division this curriculum belongs to	No
Course Count	courseCount	Integer	Count of Courses in the curriculum	Yes
User Count	userCount	Integer	Count of users assigned to Courses in the curriculum	Yes
Start Count	startCount	Integer	Count of users who have started Courses in the curriculum	Yes
Start Percentage	startPercentage	Percent	Percentage of assigned users who have started Courses in the curriculum	Yes
Test Average	testAverage	Percent	Average score received by all users who have submitted the test on Courses in the curriculum (- if no test exists) Note: Requires Exam activation	Yes
Pitch Average	pitchAverage	Percent	Average score received by all users who have submitted a Pitch IQ on Courses in the curriculum (- if no Pitch IQ exists) Note: Requires PitchIQ activation	Yes

Curriculum & Group

API Object name
CurriculumGroup

Field	JSON field	Data Type	Description	Visible by default
Curriculum ID	curriculumId	String	ID of the curriculum	No
Curriculum Title	curriculumTitle	String	Title of the curriculum	Yes
Curriculum Created Date	curriculumCreated	Date	Date the curriculum was created. Format: YYYY/MM/DD	No
Division ID	divisionId	String	ID of the Division the curriculum belongs to	No
Division Name	divisionName	String	Name of the Division the curriculum belongs to	No
Group ID	groupId	String	ID of the group	No
Group Name	groupTitle	String	Name of the group	Yes
Group Created Date	groupCreated	Date	Date the group was created. Format: YYYY/MM/DD	No
Course Count	courseCount	Integer	Count of Courses in the curriculum assigned to the group	Yes
User Count	userCount	Integer	Count of users in the group assigned to Courses in the curriculum	Yes
Start Count	startCount	Integer	Count of users in this group who have started Courses in the curriculum	Yes
Start Percentage	startPercentage	Percent	Percentage of assigned users who have started courses in this curriculum	Yes
Test Average	testAverage	Percent	Average score received by all users in this group who have submitted the test on Courses in the curriculum (- if no test exists) Note: Requires Exam activation	Yes
Pitch Average	pitchAverage	Percent	Average score received by all users in this group who have submitted a Pitch IQ on Courses in the curriculum (- if no PitchIQ exists) Note: Requires PitchIQ activation	Yes

Curriculum & User

API Object name
CurriculumUser

Field	JSON field	Data Type	Description	Visible by default
Curriculum ID	curriculumId	String	ID of the curriculum	No
Curriculum Title	curriculumTitle	String	Title of the curriculum	Yes
Curriculum Created Date	curriculumCreated	Date	Date the curriculum was created. Format: YYYY/MM/DD	No
Division ID	divisionId	String	ID of the Division the curriculum belongs to	No
Division Name	divisionName	String	Name of the Division the curriculum belongs to	No
User ID	userId	String	ID of the user	No
First Name	firstName	String	First name of the user	Yes
Last Name	lastName	String	Last name of the user	Yes
Full Name	name	String	Full name of the user	No
Email	email	String	Email address of the user	No
User Status	userStatus	String	Status of the user: Registered Invited	No
User Created Date	userCreated	Date	Date the user was created. Format: YYYY/MM/DD	No
Assigned Group IDs	assignedGroupIds	String	Comma-separated list of IDs of groups the user is assigned to	No
Assigned Group Names	assignedGroupTitles	String	Comma-separated list of names of groups the user is assigned to	No
Courses Assigned	coursesAssigned	Integer	Count of Courses in the curriculum that the user is assigned to	Yes
Courses Started	coursesStarted	Integer	Count of Courses in the curriculum that the user has started	Yes
Courses Completed	coursesCompleted	Integer	Count of Courses in the curriculum that the user has completed	Yes
Courses Overdue when completed (Count)	coursesOverdue	Integer	Count of Courses in the curriculum that the user was overdue on when completed	No
Courses Overdue now (Count)	coursesOverdue	Integer	Count of Courses in the curriculum that the user is overdue on now	No
Published Courses Overdue when completed (Count)	publishedCoursesOverdue	Integer	Count of published Courses in the curriculum that the user was overdue on when completed	No
Published Courses Overdue now (Count)	publishedCoursesOverdue	Integer	Count of published Courses in the curriculum that the user is overdue on now	No
Test Average	testAverage	Percent	Average score received on all tests submitted in the curriculum Note: Requires Exam activation	Yes
Tests Taken	testsTaken	Integer	Count of tests in the curriculum that the user has submitted Note: Requires Exam activation	No
Tests Assigned	testsAssigned	Integer	Count of tests in the curriculum that the user is assigned to Note: Requires Exam activation	No
Pitch Average	pitchAverage	Percent	Average score received on all PitchIQs submitted in this curriculum Note: Requires PitchIQ activation	Yes

Group

API Object name
Group

Field	JSON field	Data Type	Description	Visible by default
Division ID	divisionId	String	ID of the Division the group belongs to	No
Division Name	divisionName	String	Name of the Division the group belongs to	No
Group ID	groupId	String	ID of the group	No
Group Name	groupTitle	String	Name of the group	Yes
Group Created Date	groupCreated	String	Date the group was created. Format: YYYY/MM/DD	No
Course Count	courseCount	Integer	Count of Courses the group is assigned to	No
Assignment Count	assignmentCount	Integer	Count of all user assignments in the group (Courses + Paths)	No
User Count	userCount	Integer	Count of users in the group	Yes
Start Count	startCount	Integer	Count of Courses started by all users in the group	Yes
Start Percentage	startPercentage	Percent	Percentage of all assignments that have been started by users in the group	Yes
Completion Count	completedCount	Integer	Count of completed Courses for all users in the group	Yes
Completion Percentage	completedPercentage	Percent	Overall percentage of assignments completed by users in the group	Yes
Was Overdue when compled (Count)	overdueCount	Integer	Count of assignments which were overdue for users in the group when completed	No
Was Overdue when completed (%))	overduePercentage	Percent	Overall percentage of assignments which were overdue for users in the group when completed	No
Is Overdue now (Count)	overdueNowCount	Integer	Count of assignments which are overdue for users in the group now	No
Is Overdue now (%	overduePercentage	Percent	Overall percentage of assignments which are overdue for users in the group now	No
Test Average	testAverage	Integer	Average score received by all users in this group who have submitted tests (- if no test exists) Note: Requires Exam activation	Yes
Pitch Average	pitchAverage	Integer	Average score received by all users in this group who have submitted Pitch IQs (- if no Pitch IQ exists) Note: Requires PitchIQ activation	Yes

Path

API Object name
Checklist

Some JSON fields in the following tables are prefixed with checklist for legacy purposes; Checklists are now known as Paths and are labeled properly in the user interface .

Field	JSON field	Data Type	Description	Visible by default
Path ID	checklistId	String	ID of the Path	No
Path Title	checklistTitle	String	Title of the Path	Yes
Division ID	divisionId	String	ID of the Division the Path belongs to	No
Division Name	divisionName	String	Name of the Division the path belongs to	No
Description	description	String	Description of the Path	No
Path Owner	admin	String	Owner of the Path	Yes
Path Status	checklistStatus	String	Status of the Path: Published Hidden (deprecated, only shown for historical data) Archived (only availble if a request has been made to show archived paths)	No
Date Published	datePublished	Date	Date the Path was published. Format: YYYY/MM/DD	No
Path Created Date	checklistCreated	Date	Date the Path as created. Format: YYYY/MM/DD	No
Path Item Count	checklistItemCount	Integer	Count of items in the Path	Yes
User Count	userCount	Integer	Count of users assigned to the Path	Yes
Start Count	startCount	Integer	Count of users who have started the Path	Yes
Start Percentage	startPercentage	Percent	Percentage of assigned users who have started the path	Yes
Completion Count	completedCount	Integer	Count of users who have completed the path	Yes
Completion Percentage	completedPercentage	Percent	Percentage of assigned users who have completed the path	Yes

Path & Group

API Object name
ChecklistGroup

Field	JSON field	Data Type	Description	Visible by default
Path ID	checklistId	String	ID of the Path	No
Path Title	checklistTitle	String	Title of the Path	Yes
Division ID	divisionId	String	ID of the Division the Path belongs to	No
Division Name	divisionName	String	Name of the Division the Path belongs to	No
Description	description	String	Description of the Path	No
Path Owner	admin	String	Owner of the Path	Yes
Path Status	checklistStatus	String	Status of the Path: Published Hidden (deprecated, only shown for historical data) Archived (only availble if a request has been made to show archived paths)	No
Date Published	datePublished	Date	Date the Path was published. Format: YYYY/MM/DD	No
Path Created Date	checklistCreated	Date	Date the path was created. Format: YYYY/MM/DD	No
Group ID	groupId	String	ID of the group	No
Group Name	groupTitle	String	Name of the group	Yes
Group Created Date	groupCreated	Date	Date the group was created. Format: YYYY/MM/DD	No
Path Item Count	checklistItemCount	Integer	Count of items in the path	Yes
User Count	userCount	Integer	Count of users in the group assigned to the path	Yes
Start Count	startCount	Integer	Count of users in the group who have started the path	Yes
Start Percentage	startPercentage	Integer	Percentage of assigned users who have started the path	Yes
Completion Count	completedCount	Integer	Count of users in the group who have completed the path	Yes
Completion Percentage	completedPercentage	Integer	Percentage of assigned users who have completed the path	Yes
Require Y/N	required	String	Whether or not the users in the group are required to complete the path	No
Path Due Days	dueDays	String	Number of days after the group is assigned (or a new user is assigned to the group) that the path will be due	No
Path Due Date	dueDate	Date	Date the path is due for users in the group. Format: YYYY/MM/DD	No

Path & User

API Object name
ChecklistUser

Field	JSON field	Data Type	Description	Visible by default
User ID	userId	String	ID of the user	No
First Name	firstName	String	First name of the user	Yes
Last Name	lastName	String	Last name of the user	Yes
Email	email	String	Email address of the user	No
User Status	userStatus	String	Status of the user: Registered Invited	No
User Created Date	userCreated	Date	Date the user was created. Format: YYYY/MM/DD	No
Assigned Group IDs	assignedGroupIds	String	Comma-separated list of IDs of groups the user is assigned to	No
Assigned Group Names	assignedGroupTitles	String	Comma-separated list of names of groups the user is assigned to	No
Path ID	checklistId	String	ID of the Path	No
Path Title	checklistTitle	String	Title of the Path	Yes
Division ID	divisionId	String	ID of the Division the Path belongs to	No
Division Name	divisionName	String	Name of the Division the Path belongs to	No
Description	description	String	Description of the path	No
Path Owner	admin	String	Owner of the Path	Yes
Path Status	checklistStatus	String	Status of the Path: Published Hidden (deprecated, only shown for historical data) Archived (only availble if a request has been made to show archived paths)	No
Date Published	datePublished	Date	Date the Path was published. Format: YYYY/MM/DD	No
Path Created Date	checklistCreated	Date	Date the Path was created. Format: YYYY/MM/DD	No
Path Items Assigned	checklistItemsAssigned	Integer	Count of items in the Path assigned to the user	Yes
Path Items Started	checklistItemsStarted	Integer	Count of items in the Path that the user has started	Yes
Path Items Completed	checklistItemsCompleted	Integer	Count of items in the Path that the user has completed	Yes
Path Items Overdue when completed (Count)	checklistItemsOverdue	Integer	Count of items in the Path that the user was overdue on when completed	Yes
Path Items Overdue now (Count)	checklistItemsOverdueNow	Integer	Count of items in the Path that the user is overdue on now	Yes
Required Y/N	required	String	Whether or not the user is required to complete the Path. Possible values: Y N	No
Path Due Date	dueDate	String	Date the path is due for this user	No
Path Percent Complete	completedPercentage	Percent	Percentage of the path completed by the user	No
Completion Date	completed	Date	Date the user completed the Path. Format: YYYY/MM/DD	No

Path Item

API Object name
Task

Field	JSON field	Data Type	Description	Visible by default
Path Item ID	checklistItemId	String	ID of the Path item	No
Path Item Title	checklistItemTitle	String	Title of the Path item	Yes
Description	description	String	Description of the Path item	No
Path Item Type	checklistItemType	String	Type of the Path item. Possible values: Task Course Live Training	Yes
Path Item Status	checklistItemStatus	String	Path Item Status: Published Hidden (deprecated, only shown for historical data) Archived (only availble if a request has been made to show archived paths)	No
Path Item Created Date	checklistItemCreated	Date	Date the Path item was created. Format: YYYY/MM/DD	No
Path ID	checklistId	String	ID of the Path	No
Path Title	checklistTitle	String	Title of the Path	Yes
Path Status	checklistStatus	String	Status of the Path: Published Hidden (deprecated, only shown for historical data) Archived (only availble if a request has been made to show archived Paths)	No
Division ID	divisionId	String	ID of the Division the Path belongs to	No
Division Name	divisionName	String	Name of the Division the Path belongs to	No
User Count	userCount	Integer	Count of users assigned to the Course	Yes
Start Count	startCount	Integer	Count of users who have started the Course	Yes
Start Percentage	startPercentage	Percent	Percentage of assigned users who have started the Course	Yes
Completion Count	completedCount	Integer	Count of users have completed the Course	Yes
Completion Percentage	completedPercentage	Percent	Percentage of assigned users who have completed the Course	Yes
Was Overdue when completed (Count)	overdueCount	Integer	Count of users who were overdue on the Course when completed	Yes
Was Overdue when completed (%)	overduePercentage	Integer	Percentage of assigned users who were overdue on the Course when completed	Yes
Is Overdue now (Count)	overdueCount	Integer	Count of users who are overdue on the Course now	Yes
Is Overdue (%)	overduePercentage	Percent	Percentage of assigned users who are overdue on the Course now	Yes

Path Item & Group

API Object name
TaskGroup

Field	JSON field	Data Type	Description	Visible by default
Path Item ID	checklistItemId	String	ID of the Path item	No
Path Item Title	checklistItemTitle	String	Title of the Path item	Yes
Description	description	String	Description of the Path item	No
Path Item Type	checklistItemType	String	Type of the Path item. Possible values: Task Course Live Training	Yes
Path Item Status	checklistItemStatus	String	Path Item Status: Published Hidden (deprecated, only shown for historical data) Archived (only availble if a request has been made to show archived Paths)	No
Path Item Created Date	checklistItemCreated	Date	Date the Path item was created. Format: YYYY/MM/DD	No
Path ID	checklistId	String	ID of the Path	No
Path Title	checklistTitle	String	Title of the Path	Yes
Path Status	checklistStatus	String	Status of the Path: Published Hidden (deprecated, only shown for historical data) Archived (only availble if a request has been made to show archived Paths)	No
Division ID	divisionId	String	ID of the Division the Path belongs to	No
Division Name	divisionName	String	Name of the Division the Path belongs to	No
Group ID	groupId	String	ID of the group	No
Group Name	groupTitle	String	Name of the group	Yes
Group Created Date	groupCreated	Date	Date the group was created. Format: YYYY/MM/DD	No
Rolling Due Date	dueDays	String	Number of days after the group is assigned (or a new user is assigned to the group) that the Path item will be due	No
Due Date	dueDate	Date	Date the Path item is due for users in the group. Format: YYYY/MM/DD	No
Assigned Date	assignedDate	Date	Date the Path item was assigned to the group. Format: YYYY/MM/DD	Yes
User Count	userCount	Integer	Count of users assigned to the Course	Yes
Start Count	startCount	Integer	Count of users who have started the Course	Yes
Start Percentage	startPercentage	Percent	Percentage of assigned users who have started the Course	Yes
Completion Count	completedCount	Integer	Count of users have completed the Course	Yes
Completion Percentage	completedPercentage	Percent	Percentage of assigned users who have completed the Course	Yes
Was Overdue when completed (Count)	overdueCount	Integer	Count of users who are overdue on the Course when completed	Yes
Was Overdue when completed (%)	overduePercentage	Percent	Percentage of assigned users who were overdue on the Course when completed	Yes
Is Overdue now (Count)	overdueCount	Integer	Count of users who are overdue on the Course	Yes
Is Overdue now (%)	overduePercentage	Percent	Percentage of assigned users who are overdue on the Course now	Yes
Required Y/N	required	String	Whether or not the users in the group is required to complete the path. Possible values: Y N	No

Path Item & User

API Object name
TaskUser

Field	JSON field	Data Type	Description	Visible by default
User ID	userId	String	ID of the user	No
First Name	firstName	String	First name of the user	Yes
Last Name	lastName	String	Last name of the user	Yes
Email	email	String	Email address of the user	No
User Status	userStatus	String	Status of the user. Possible values: Registered Invited	No
User Created Date	userCreated	Date	Date the user was created. Format: YYYY/MM/DD	No
Assigned Group IDs	assignedGroupIds	String	Comma-separated list of IDs of groups the user is assigned to	No
Assigned Group Names	assignedGroupTitles	String	Comma-separated list of names of groups the user is assigned to	No
Path Item ID	checklistItemId	String	ID of the Path item	No
Path Item Title	checklistItemTitle	String	Title of the Path item	Yes
Description	description	String	Description of the Path item	No
Path Item Type	checklistItemType	String	Type of the Path item. Possible values: Task Course Live Training	Yes
Path Item Status	checklistItemStatus	String	Path Item Status: Published Hidden (deprecated, only shown for historical data) Archived (only availble if a request has been made to show archived Paths)	Yes
Path Item Created Date	checklistItemCreated	Date	Date the Path item was created. Format: YYYY/MM/DD	No
Path ID	checklistId	String	ID of the Path	No
Path Title	checklistTitle	String	Title of the Path	Yes
Path Status	checklistStatus	String	Status of the Path: Published Hidden (deprecated, only shown for historical data) Archived (only availble if a request has been made to show archived Paths)	No
Division ID	divisionId	String	ID of the Division the Path belongs to	No
Division Name	divisionName	String	Name of the Division the Path belongs to	No
Due Date	dueDate	Date	Date the Path item is due for the user. Format:YYYY/MM/DD	Yes
Assigned Date	assignedDate	Date	Date the Path item was assigned to the user. Formats:YYYY/MM/DD	Yes
Completion Date	completed	String	Date the user completed the Path item. Format: YYYY/MM/DD	Yes
Was Overdue when completed	overdue	String	Whether or not the user was overdue on the Path item when completed.. Possible values: Yes No	Yes
Is Overdue now	overdue	String	Whether or not the user is overdue on the Path item now.. Possible values: Yes No	Yes
Required Y/N	required	String	Whether or not the user is required to complete the Path item. Possible values: Required Elective	No

Pitch IQ Results

Feature activation required

PitchIQ activation is required for this object.

API Object name
PitchReviews

Field	JSON field	Data Type	Description	Visible by default
Course ID	courseId	String	ID of the Course	No
Course Title	courseTitle	String	Title of the Course	Yes
Division ID	divisionId	String	ID of the Division the Course belongs to	No
Division Name	divisionName	String	Name of the Division the Course belongs to	Yes
User ID	userId	String	ID of the user	No
First Name	firstName	String	First name of the user	Yes
Last Name	lastName	String	Last name of the user	Yes
Email	email	String	Email address of the user	Yes
Assigned Group IDs	assignedGroupIds	String	Comma-separated list of IDs of groups the user is assigned to	No
Assigned Group Names	assignedGroupTitles	String	Comma-separated list of names of groups the user is assigned to	Yes
Reviewer Type	reviewerType	String	Type of review submitted by the reviewer. Possible values: Peer Manager Admin	Yes
Reviewer User ID	reviewerId	String	User ID of the reviewer	No
Reviewer First Name	reviewerFirstName	String	First name of the reviewer	Yes
Reviewer Last Name	reviewerLastName	String	Last name of the reviewer	Yes
Pitch Score	pitchScore	Integer	Score given to the pitch by the reviewer	Yes
Positives	positives	String	Positive feedback given by the reviewer	Yes
Constructive	negatives	String	Constructive feedback given by the reviewer	Yes

Pitch Reviewer Activities

Feature activation required

PitchIQ activation is required for this object.

API Object name
PitchReviewerActivity

Field	JSON field	Data Type	Description	Visible by default
Course ID	courseId	String	ID of the Course	No
Course Title	courseTitle	String	Title of the Course	Yes
Division ID	divisionId	String	ID of the Division the Course belongs to	No
Division Name	divisionName	String	Name of the Division the Course belongs to	No
User ID	userId	String	ID of the user	No
First Name	firstName	String	First name of the user	Yes
Last Name	lastName	String	Last name of the user	Yes
Email	email	String	Email address of the user	No
Reviewer Type	reviewerType	String	Type of review submitted by the reviewer. Possible values: Scorer Reviewer	Yes
Pitch Score	pitchScore	Percent	Average score given to pitches on the Course by the reviewer	Yes
Reviews Given	reviewsCompleted	Integer	Count of pitches reviewed on the course for the reviewer	Yes
Reviews To Give	reviewsToGive	Integer	Count of pitches pending review on the Course for the reviewer	Yes

SCORM Courses

API Object name
ScormCourseData

Field	JSON field	Data Type	Description	Visible by default
Asset ID	assetId	string	Asset ID of the lesson item	No
Course ID	courseId	string	ID of the Course	No
Course Title	courseTitle	string	Title of the Course	Yes
Division ID	divisionId	String	ID of the Division the Course belongs to	No
Division Name	divisionName	String	Name of the Division the Course belongs to	No
Description	courseDescription	string	Description of the Course	No
Course Status	courseStatus	string	Status of the Course. Possible values: Published Hidden - deprecated, shown only for historical data Archived - available only if the display of archived Courses has been requested	No
User ID	userId	string	ID of the user	No
First Name	firstName	string	First name of the user	Yes
Last Name	lastName	string	Last name of the user	Yes
Email	email	string	Email address of the user	No
Section ID	sectionId	string	ID of the section	No
Section Title	sectionTitle	string	Title of the section	Yes
Lesson ID	lessonId	string	ID of the lesson	No
Lesson Title	lessonTitle	string	Title of the lesson	Yes
Lesson Item ID	lessonItemId	string	ID of the lesson item	No
Lesson Item Title	lessonItemTitle	string	Title of the lesson item	Yes
Completion Date	completed	Date	Date the user completed the Course. Format: YYYY/MM/DD	Yes
SCORM Data Key	scormDataKey	string	SCORM Data Key	Yes
SCORM Data Value	scormDataValue	string	SCORM Data Value	Yes

Test Results

Feature activation required

Exam activation is required for this object.

API Object name
TestQuestions

Field	JSON field	Data Type	Description	Visible by default
Test ID	testId	String	ID of the test	No
Course ID	courseId	String	ID of the Course	No
Course Title	courseTitle	String	Title of the Course	Yes
Division ID	divisionId	String	ID of the Division the Course belongs to	No
Division Name	divisionName	String	Name of the Division the Course belongs to	No
Type	testType	String	Type of the test. Possible values: Test Survey	Yes
User ID	userId	String	ID of the user	No
First Name	firstName	String	First name of the user	Yes
Last Name	lastName	String	Last name of the user	Yes
Email	email	String	Email address of the user	Yes
Assigned Group IDs	assignedGroupIds	String	Comma-separated list of IDs of groups the user is assigned to	No
Assigned Group Names	assignedGroupTitles	String	Comma-separated list of names of groups the user is assigned to	Yes
Latest Test Version	latestTestVersion	Integer	Indicates the current test	No
Is Latest Test Version	isLatestTestVersion	String	Indicates whether or not the questionTestVersion is the latest version. Possible values: Yes No	No
Question Test Version	questionTestVersion	Integer	The version of the test at the time the exam attempt was completed	No
Test Score	testScore	Percent	Score received on the test by the user	Yes
Question	question	String	Question content	Yes
Response	response	String	Response submitted by the user for the question	Yes
Correct	correct	String	Whether or not the user answered correctly. Possible values: Yes No	Yes

User

API Object name
User

Field	JSON field	Data Type	Description	Visible by default
User ID	userId	String	ID of the user	No
First Name	firstName	String	First name of the user	Yes
Last Name	lastName	String	Last name of the user	Yes
Full Name	name	String	Full name of the user	No
Email	email	String	Email address of the user	No
User Status	userStatus	String	Status of the user. Possible values: Registered Invited	No
User Created Date	userCreated	Date	Date the user was created. Format: YYYY/MM/DD	No
Assigned Group IDs	assignedGroupIds	String	Comma-separated list of IDs of groups the user is assigned to	No
Assigned Group Names	assignedGroupTitles	String	Comma-separated list of names of groups the user is assigned to	No
Division ID	divisionId	String	ID of the Division these statistics are calculated over	No
Division Name	divisionName	String	Name of the Division these statistics are calculated over	No
Courses Assigned	coursesAssigned	Integer	Count of Courses the user is assigned to	Yes
Courses Completed	coursesCompleted	Integer	Count of Courses the user has completed	Yes
Courses Complete Percentage	coursesCompletedPercentage	Integer	Percentage of assigned Courses the user has completed	Yes
Courses Overdue	coursesOverdue	Integer	Count of Courses the user was overdue for when completed	Yes
Courses Overdue now (Count)	coursesOverdueNow	Integer	Count of Courses the user is overdue for now	Yes
Published Courses Overdue	publishedCoursesOverdue	Integer	Count of published Courses the user was overdue for when completed	No
Published Courses Overdue now (Count)	publishedCoursesOverdue	Integer	Count of published Courses the user is overdue for now	No
Lessons Completed	lessonsCompleted	Integer	Count of all lessons completed in Courses assigned to the user	No
Test Average	testAverage	Percent	Average score received by the user on all tests Note: Requires Exam activation	Yes
Tests Taken	testsTaken	Integer	Count of tests submitted by the user Note: Requires Exam activation	Yes
Tests Assigned	testsAssigned	Integer	Count of Courses with tests assigned to the user Note: Requires Exam activation	Yes
Pitches Assigned	pitchesAssigned	Integer	Count of Courses with PitchIQs assigned to the user Note: Requires PitchIQ activation	No
Pitches Submitted	pitchesSubmitted	Integer	Count of PitchIQs submitted by the user Note: Requires PitchIQ activation	No
Pitch Average	pitchAverage	Percent	Average score received by the user on all PitchIQs Note: Requires PitchIQ activation	Yes