Using the Data Tool

Everything you need to know about data, Scorecards, and KPIs in Ninety.

Written by Tommy Mains

Updated at November 6th, 2024

+ More

Table of Contents

The Data Tool Primary Functions of the Data Tool Video Overview of the Data Tool Operating Scorecards According to Your User Role Customizing Scorecards Company-Wide Settings Scorecard Filters Organizing Scorecards Creating KPI Groups Reorganizing KPIs Frequently Asked Questions (FAQs)

The Data Tool

The Data tool simplifies setting up and managing your team’s Scorecard to keep track of goals on five levels:

  1. Organization-wide
  2. Leadership Team
  3. Departmental
  4. Teams
  5. Individuals

Reviewing the Data tool every week is a critical function of team meetings. 

Learn more about making data a superpower for your organization with our free On Data Guide.

 

 

Primary Functions of the Data Tool

The primary functions of the Data tool include:

📖 Are you new to the Data Tool? Check out our introduction article here.

 

Video Overview of the Data Tool

 

Operating Scorecards According to Your User Role

The functionality of the Data tool changes based on each user's role in Ninety. Click here for a basic understanding of user permissions for this tool. In short, all licensed users can view and operate their assigned KPIs, while users with Manager or higher level permissions can add KPIs and groups to Scorecards and adjust settings.

 

 

Customizing Scorecards

To customize your team's Scorecard settings:

  1. Click the ellipsis on the far right of the Filters bar.
  2. Click Settings.
  3. Toggle off Use company default settings.

From there, you can adjust the settings described in the tabs below.

Show Current Period

To hide the current week’s column from your team’s Scorecard, toggle off Show current period.

 
 

Total Column

Enabling the Total column adds a column to all the team’s Scorecards to show the sum total of each KPI.

To change the number of reporting periods for the KPIs on a Scorecard, click the Periods dropdown on the Filters bar.

 
 

Average Column

Enabling the Average column adds a column to all the team’s Scorecards to show the average score of each KPI.

To change the number of reporting periods for the KPIs on a Scorecard, click the Periods dropdown on the Filters bar.

 
 

Goal Column

Enabling the Goal column adds a column to all the team’s Scorecards to show the goal (target) score of each KPI.

 
 

KPI Status Color

When the KPI status colors toggle is toggled on, a vertical, colored line appears on the far left of each KPI on the team’s Scorecard. The status color is based on each KPI's  goal — often called its target.

🟩 Green indicates the KPI has been on track for the previous three reporting intervals.
🟨 Yellow indicates the KPI was off track at least once over the previous three reporting intervals.
🟥 Red indicates the KPI was off track for the previous three reporting intervals.

 
 

Weekly Start Day

Choose the start day for Weekly KPIs that best fits your organization.

There are two ways to change your Scorecard’s start day, changing it in the Data tool or changing it organization-wide through company settings.

To change it in the Data tool:

  1. Click Data from the left navigation.
  2. Click the ellipsis on the far right of the Filters bar.
  3. Click the KPI Weekly Start Day dropdown.
  4. Select a weekday.
 
 

 

Company-Wide Settings

Admins, Owners, and Coaches can set company-wide Scorecard settings from the Configuration page in the Data section of Feature Controls.

Any teams using company default settings match the options here for:

  • Average Column
  • Total Column
  • Status Color Indicator
  • Weekly Start Day

 

Scorecard Filters

The Data tool page has four tabs for Weekly, Monthly, Quarterly, and Annual Reporting.

  • Team — Many users are on several teams in Ninety; ensure you have the correct team selected here.
  • Date range — Each Scorecard has its own default setting, but you can select any option from the dropdown to analyze your data as needed.
  • Periods (Weekly Scorecard only) — Change the reporting period from 1-week columns to 4- or 13-week groupings to see trailing reporting periods.
  • Ascending or Descending Toggle — Click the left arrow to view dates from the start of the reporting period to the end or the right arrow to view dates from the end of the reporting period (often the current period) to the start.

 

Organizing Scorecards

There are several ways to keep your team's Scorecards organized, including creating KPI groups and reorganizing KPIs.

Previously, you may have divided groups of KPIs with line breaks. Our updated tool automatically moved your KPIs into groups based on how you placed line breaks. With the Combine all groups button, you'll have a one-time option to combine all your KPIs into a single group.

 

 

Creating KPI Groups

Keep your Scorecards organized by creating groups. Each group can house similar KPIs to make reviewing your Scorecard as easy as possible. You can include up to 20 groups on each of your Scorecards. You may want to create a group for each team member, Seat, or goal. For example, a sales team may have a KPI group which includes a KPI from each sales Seat holder.

To create a new group:

  1. Click New Group on the far right of the Filters bar.
  2. Name the group.
  3. (Optional) Write a description for the group.
  4. Click Save.

To edit a group's details, click the ellipsis on the top right of the group's card. Then, click Edit group details. To delete it instead, click Delete group.

 

Reorganizing KPIs

You can drag and drop a KPI within its group by clicking and holding the dots on the far left of the KPI's row and then releasing your click in its new location.

To send a KPI from one group to another:

  1. Right-click the KPI.
  2. Click Move to group… from the dropdown.
  3. Select a group from the dropdown.
  4. Click Move.

 

Frequently Asked Questions (FAQs)

What happened to trailing Scorecards?

We've made trailing Scorecards easier than ever; you can still view your KPIs in trailing 4- or 13-week intervals to see trends over time.

The trailing scorecard was a temporary solution in the previous iteration of the Data tool. You can achieve a similar effect by clicking the Period dropdown and selecting 4-week (read-only) or 13-week (read-only).

 
 

How do I change a KPI's owner?

There are two ways to change a KPI's owner:

  1. Click the KPI's title to open its details card.
  2. Click the profile photo on the top right of the card.
  3. Hover over a Seat from the dropdown.
  4. Click one of the users who occupy that Seat.

Or:

  1. Click the KPI's title to open its details card.
  2. Click the KPI Owner dropdown toward the bottom of the details card.
  3. Choose a Team Member.
  4. (Optional) Select the relevant Seat from the Seat dropdown if this user sits in multiple Seats.
 
 

What does it mean to own a KPI?

To “own” a KPI means to be accountable for its success. Each KPI's owner has their profile picture featured on the Scorecard. KPI owners should create an Issue about their KPI whenever it’s off track, needs updating, or has consistently surpassed its target.

 
 

How do I move a KPI from one group to another?

To move a KPI from one group to another:

  1. Right-click the KPI.
  2. Click Move to group… from the dropdown.
  3. Select a group from the dropdown.
  4. Click Move.
 
 

How do I enter my KPI's scores?

All licensed users can be assigned KPIs and input data for any of their team's KPIs. Input scores for your KPIs from the My 90 page or the Data tool page. The My 90 workspace shows all the KPIs you own across every team. 

To add scores in My 90:

  1. Click My 90 from the left navigation.
  2. Scroll to the Scorecard section.
  3. Type in your scores to the corresponding KPI and reporting period cell.
    1. Click the Period Interval dropdown to access your Trailing, Monthly, Quarterly, and Annual Scorecards.

To enter scores using the Data tool:

  1. Click Data from the left navigation.
  2. Choose a team from the Team dropdown.
    1. Click another Scorecard tab to switch away from the Weekly Scorecard.
  3. Locate the KPI.
  4. Type the score in the reporting period cell.
    1. Press your tab key to move one cell to the right or press shift + tab to move one cell to the left.
 
 
data scorecard color status metric customize data data settings customize scorecard scorecard settings organizing scorecards editing scorecards trailing four week data data user roles data tool permissions group kpi group scorecard group data group

Related Articles