Order Tool Dashboard

Institution specific ordering data from the Order Tool can be visualized in a Google's Looker Dashboard for Program Administrators.

The Order Tool Dashboard has four views:

View 1

This view demonstrates the amount of orders that each profile has submitted, as well as the percentages of Course Coordinators and Instructors with at least one order.

View 2

This view demonstrates the growth of orders by SIS term and shows the percentages of Course Coordinators and Instructors with at least one order.

View 3

This view demonstrates the amount of sections and courses that have at least one order, grouped by SIS Term ID.

View 4

This view demonstrates a list of all active profiles with Program Administrator permissions and Course Coordinator permissions, respectively.

View 5

This view demonstrates a list of any order that contains both an eText and DLT from the same publisher. This can be used to determine orders where the orderer may have accidentally ordered the eText and DLT of versions of the same title.

View 6

This view demonstrates a list of instructors who have placed an order in a chose term, but have not yet placed any orders in a different chose term. This view is intended to be used to send reminders to instructors who are likely to place an order, but have not yet done so.

Data on this dashboard is updated twice per day: at 5am EST and 3pm EST.

The following data are pulled from the Order Tool to populate the dashboard:

Column name	Data type	Definition
is_active	Boolean	If “true,” the profile is active.
is_admin	Boolean	If “true,” the profile has program administrator ordering permissions.
is_coordinator	Boolean	If “true,” the profile has at least one course coordinator ordering permission.
is_instructor	Boolean	If “true,” the profile has instructor ordering permissions.
network_id	Text	The "network_id" for a user is the identifier released by your Institutions' Identity Provider in a Single Sign-on integration. In a Shibboleth implementation, this value must be identical to the EPPN attribute released by your Institution's Identity Provider.
last_name	Text	The SIS provided last name for a user.
first_name	Text	The SIS provided first name for a user.
sis_term_id	Text	The unique and immutable SIS ID for the Term; e.g., "201890."
term_name	Text	The name of the SIS term.
sis_user_id	Text	The unique and immutable SIS ID for the individual user.
profile_id	Text	The unique and immutable Profile ID for the individual user in Order Tool.
has_teaching_assignments	Boolean	If “true,” the profile has at least one teaching assignment.
order_id	Text	The unique and immutable Order ID for an individual order.
sis_section_id	Text	The unique and immutable SIS ID for the Term; e.g. "201890-22-BIO-101-0001" or "4205-30855". This key is used to uniquely identify sections upon import into Order Tool.
sis_course_id	Text	The unique and immutable SIS ID for the Course; e.g., "201890-22-BIO-101."
publisher_name	Text	The name of the content item’s publisher.
title	Text	The title of a content item that is on the order.

Please contact Unizin Services if you would like to set up this dashboard for your institution.