Leaderboards Report

The Leaderboards report provides an overall summary of each user's learning activity relative to others learning activity ranking them from highest activity to lowest activity. This report is available to admins even if the leaderboard feature is turned off. Percipio may take up to 24 hours to include relevant activity in this report. You can see at the top of the report when the data was last updated.

Report insights

The Leaderboards report shows you:

  • A list of active and inactive users in Percipio with activity.
  • For each user listed in the report, a summary of their learning activity including how many completions they made and how many badges they earned ranked from most activity to least activity.
  • You can use this report to determine the winner of a learning contest. Maybe you ran a promotion and the person completing the most courses in the month of July would win a prize – this report gives you that information.

Access this report

To access the Leaderboards report and customize it for your needs:

  1. From the Analytics menu in the left navigation bar, select All reports.
  2. From the Users section, locate and select Leaderboards. The report displays with default filters selected.
  3. Make the report your own:
    • Specify global filters, then select Update. Manipulate columns for just the right view.
    • To generate a CSV file for further analysis, select Download report. If you chose to download the report, a message displays with a link to the Reports download tab. Select it to view the CSV download progress and/or open the CSV file.

Global Filters

The global filters you set apply to all data presented on the page. To use global filters:

  1. Change the default filters by selecting an option from each filter you require.
  2. Select Run report. The report loads to match your filters.
  3. If needed, reset both global filters and any filters made to columns by selecting Clear all filters. To reset the full report back to its original state, select Reset to default.

Global report filters include:

  • Audience: Predefined group of users. Enter the name of an audience and then select it from the list. You can display the data for multiple audiences at the same time by entering more than one audience name.
  • User: Individual with a Percipio user account. Enter a user's name to filter the report to include that user.
  • Include: Select the types of users to show in the report. You can show users with activity, users without activity, and both users with and without activity.
  • Learning activity date range:The Date filters apply to the DURATION, FIRST ACCESS, LAST ACCESS, and TOTAL ACCESSES columns.
    • Date Range Presets: A drop-down list of date ranges that filters the data to the selected range. Select Custom to enter specific dates.
    • Start: Instead of using a Date Range preset, use this to specify a start date. When you enter a Start date, the Date Range Presets filter changes to Custom.
    • End: Instead of using a Date Range preset, use this to specify an end date. When you enter an End date, the Date Range Presets filter changes to Custom.
  • Include inactive users: Select this box if you want to show inactive users in your report, otherwise the report only shows active users.

After applying global filters, the table loads with a default set of columns presented in a default order. To use your data in a way that makes the most sense to you, you can organize the columns in the table by sorting, filtering, changing the order, and choosing which ones to display. You can also pin columns and group by them.

Column Action How to Use
Sort From within the column heading, select the arrow button to toggle between ascending and descending.
Filter

To filter a column for select data, from within the column heading:

  1. Select the more options button , then select the filter button .
  2. Choose how you want to filter. Options will vary depending on the data contained in that column. You may see: equal, greater than, less than, not equal, contains, does not contain, starts with, ends with, or in range.
  3. Enter a value in the space provided. This field is case sensitive. For example if you select contains and enter akara,Percipio does not find a match with and item containing Akara.
  4. If available, you can add more filters using the inclusion of AND or OR. If you select AND, data must meet both conditions to display. If you select OR, data must meet at least one condition to display.
  5. The filter is applied immediately. Select anywhere outside the filter to close the filter box.

If a column is filtered, the filter icon shows in the column header.

Pin (Anchor)

To pin or anchor a column so that it does not scroll left or right off the page:

  1. From within the column heading, select the more options button .
  2. Make sure the more options tab is highlighted and select Pin.
  3. Choose Pin left or Pin right. If you select Pin left, the column is moved to the far left. If you select Pin right, the column is moved to the far right.
  4. To remove the pin and reposition the column back to its original location, select No pin.
Autosize

If you want to ensure you can read the longest value within a column, you can autosize it. You can do one column at a time or all of them at once.

  1. From within the column heading, select the more options button .
  2. Make sure the more options tab is highlighted and select Autosize this column or Autosize all columns.
Group

Sometimes it is helpful to see your data grouped in a particular way, for example, by user role or by status. You can create groups within groups for further segmentation.

There are two ways to group your data:

  1. From within the column heading:
    1. Select the more options button .
    2. Make sure the more options tab is highlighted and select Group by [this column]
    3. To remove the grouping: select Ungroup by this column.
  2. From the right column expansion list:
    1. Locate the column in the list you want to group by.
    2. Select and hold the group icon group icon, array of gray dots.
    3. Drag the column to Row Groups at the bottom.
    4. Select the X next to the Row Group to remove it.
Hide/Show

To only show the data relevant to your needs, you can select which columns display.

From the right Column expansion listClosed Column expansion list:

  1. Locate the column in the list you want to show or hide.
  2. To show a column, make sure you check the box. To hide a column, uncheck the box.
Reorder To change the display order of the columns, you can click and drag a column heading left or right to reposition it within the table.

Column Descriptions

Default columns

The following columns are displayed by default in the User Summary report:

  • LOGIN NAME: The value entered in the Login name attribute for the user.
  • USER ID: The value entered in the User ID field. It is used to identify a user inside Percipio.
  • FIRST NAME: The value entered in the First name user attribute. Usually the user's first name.
  • LAST NAME: The value entered in the Last name user attribute. Usually the user's last name.
  • EMAIL ADDRESS: The value entered in the Email address user attribute; the user's email address.
  • USER STATUS: The status of the user in Percipio. Valid values are active or inactive.
  • ROLE: The user's Percipio role. Valid values are: domain admin, site admin, learning admin, manager, content coordinator, content curator, and learner.
  • CREATED DATE: The date the user account was created.
  • TOTAL COMPLETIONS WITH COURSE VIDEO: The total number of completions for that user. This number includes individual Skillsoft course videos when launched separately in the video-only player. This number does not include individual Skillsoft course videos that are watched when the learner launches a course.
  • TOTAL BADGES EARNED:  The total number of Digital Badges for courses, tracks, and journeys your users earned during the specified time period.
  • User Attributes (varies): These fields are defined by (and are unique to) your organization. For more information, see User Attributes. If you are using an attribute type of Percipio User, the value in the field can be either first and last name, email address, login ID, or external user ID. The value that appears depends on what has been specified for the individual user.

Other available columns

Other columns not shown by default, but available for selection include:

  • LAST LOGIN DATE: The date when the user last signed into Percipio.
  • LAST LOGIN TIME: The time when the user last signed into Percipio.
  • LAST ACCESS DATE: The date when the user last accessed content.
  • LAST ACCESS TIME: The time when the user last accessed content.
  • UPDATED DATE: The date the user account last had updates made to it.
  • UPDATED TIME: The time the user account last had updates made to it.
  • WELCOME EMAIL SENT DATE: The last date a welcome email was sent to the user.
  • WELCOME EMAIL SENT TIME: The last time a welcome email was sent to the user.
  • TOTAL LEARNING HOURS (SECONDS): The duration (in seconds) of time the user spent within learning assets.
  • TOTAL LEARNING HOURS (HHMMSS): The duration shown in hours minutes and seconds of time the user spent within learning assets.
  • AUDIENCE: Predefined group of users. The name of the audiences for which this user is a member.
  • USE POLICY AGREEMENT DATE: The date when the user last accepted the Corporate Use Policy.
  • USE POLICY AGREEMENT TIME: The time when the user last accepted the Corporate Use Policy.
  • CURRENT GOAL STREAK: The number of weeks in a row, starting from the previous week and counting backward, that the learner completed their goal. This value is not bound by the date range specified — it is for all time.
  • BEST GOAL STREAK: The maximum number of weeks in a row that the learner completed their goal. This value is not bound by the date range specified — it is for all time.

When a course is restartedClosed A course is considered restarted if a learner previously completed it and then selected the Restart button. When a course is restarted, the learner sees a new row in their My Activity page and admins see a new row in reports. If a learner just relaunches a previously completed course, no new row shows in My Activity or reports. When a course is restarted and completed, the learner earns a new certificate of completion with the new completion date. Learners do not earn a new badge for a restarted course. within the specified time frame, that is only counted once.