> For the complete documentation index, see [llms.txt](https://resources.unizin.org/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://resources.unizin.org/products/content/unizin-order-tool/order-tool-dashboard.md).

# 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&#x20;

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.&#x20;

<figure><img src="/files/mcoiXM8Grv9t7NFb4ub4" alt="View 1 showing the total number of orders placed by each persona"><figcaption></figcaption></figure>

## View 2&#x20;

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

<figure><img src="/files/3gtXUCkqWS2UNShFTJzp" alt="View 2 showing different charts showing number of orders placed by each persona over time"><figcaption></figcaption></figure>

## View 3

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

<figure><img src="/files/BStGFva3dvhG0d5nQE1h" alt="View 3 showing the number of courses and section on order for a given term"><figcaption></figcaption></figure>

## View 4&#x20;

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

<figure><img src="/files/QWLLUnM5MJgv0Nhq3qxt" alt="View 4 showing the active profiles with program administrator and course coordinator permissions"><figcaption></figcaption></figure>

## 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.

<figure><img src="/files/OGanSHYsugSIKFvvwZmb" alt="View 5 showing a table with any order that has both an eText and DLT from the same publisher on it"><figcaption></figcaption></figure>

### 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.

<figure><img src="/files/MUu5QmTOFQNydYW8AFEc" alt="View 6 showing users who have placed orders in previous terms, but not current term(s)"><figcaption></figcaption></figure>

{% hint style="info" %}
Data on this dashboard is updated twice per day: at 5am EST and 3pm EST.
{% endhint %}

## 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.                                                                                                                                                                                                                     |

{% hint style="info" %}
Please contact [Unizin Services](mailto:services@unizin.org) if you would like to set up this dashboard for your institution.
{% endhint %}

<br>


---

# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter, and the optional `goal` query parameter:

```
GET https://resources.unizin.org/products/content/unizin-order-tool/order-tool-dashboard.md?ask=<question>&goal=<endgoal>
```

`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is optional and describes the broader end goal you are ultimately trying to accomplish on behalf of the user. GitBook uses it to tailor the answer towards what is most useful for that goal.

The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.
