Internal and External Activity Report

The Internal and External Activity report provides a complete summary of each learner's activity including Skillsoft content, custom content, and external learning. You can filter data by date range, audience, or individual user. This is a standard report that shows all learner activity for your organization up through the last 24 months. If you run the report and it contains more than 10,000 records, adjust your filters and rerun it. You cannot schedule this report, but you can download it and share it.

Get Started

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.

To access the report and customize it for your needs:

  1. From the Analytics menu in the left navigation bar, select the All Reports tab and then from the Activity section, select Internal and External Activity.

  2. To see just the data you need, the platform allows you to specify global filters for this report. If you run the report and it contains more than 10,000 records, adjust your filters and rerun it.

    The global filters you set apply to all data presented on the page. If your filters are too broad, allowing for an excessive amount of data, the report may stall. If this happens, adjust your filters and rerun. This may occur, for example, if your date range is too large or you choose to include all videos. 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.

  3. The following options are available to organize the columns in the report:

    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.
  4. You can select to Download report at this point so you can share with others in your organization.

Filters

  • Date filters: The Date filters apply to the DURATION, FIRST ACCESS, LAST ACCESS, and TOTAL ACCESSES columns. With this report, you can only view the last 24 months of data. For more historical data, use the Detailed activity report.
    • 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.

      • A user accesses a course on September 1 and September 15. They accesses it again on October 1, when they complete the course. They access it once more on October 15 to review it.

      The activity for this user, with Start set as September 1 and End set as October 15, would look like this:

      FIRST ACCESS: September 1
      LAST ACCESS: October 15
      TOTAL ACCESSES: 4
      COMPLETED DATE: October 1
      STATUS: Completed

  • 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. You can display data for up to 10 users at the same time by typing in more than one user name.
  • Asset Type: Choose which types of assets to include in your report. A default list of asset types displays when you launch the report. To include additional content types, such as videos, modules, and journeys, select the Asset Type filter field for a full list of available options. To remove an asset type from the filter, click the remove icon, blue circle with white X to the right of the item. When you choose to include videos or modules, you will see both videos and modules launched from within a course and those launched in the video-only/module-only player in the report. To see how the asset was launched, turn on the Consumed in Course column.

Columns

Note: Each user number-related column is specific to the filtered date range (for example, the FIRST ACCESS date is the first time the user accessed the content within the specified date range, and not necessarily the first time content was accessed.)

Default columns

The following columns are available in the Internal and External Activity report:

  • 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.
  • CONTENT TITLE: The title of the asset.

  • CONTENT TYPE: The type of content. Content types can be subsets of asset types. Content types are equivalent to the asset type for courses, videos, books, audiobooks, audio summaries, book summaries, and journeys. When an asset type is set for assessment, you can see a content type of Skill Benchmark. When an asset type is set for linked content, you can see content types for AI simulator, cheatsheets, interactive courses, test preps, labs, bootcamps, partner content, and any custom content items you added. When an asset type is set for scheduled content, you see content types of live courses and live events.

  • LEARNING HOURS (HOURS): The total number of hours a learner spent in content learning. If the item is a Skillsoft course, the total includes time spent watching videos while in the course (not the time spent on the same videos if launched in video-only mode) and working on knowledge checks within the course. If you see learners with a completed status and with 0 duration, the learner only took the test and did not watch any of the content. Time is listed as fraction of hours. Something that takes 90 minutes to complete is listed as 1.50 and something that takes 15 minutes is listed as 0.25.
  • ESTIMATED DURATION (HOURS): Total estimated amount of time it takes a learner to complete the specified content. For online courses this only includes the video playback time. Time is listed as fraction of hours. Something that takes 90 minutes to complete is listed as 1.50 and something that takes 15 minutes is listed as 0.25.
  • STATUS: The status of the content. The status is not impacted by the Date filters. For all content items you could see Started or Completed.
  • COMPLETED DATE: The date in UTC the user completed the content. This date is not impacted by the Date Range Presets filter. You may see completion dates outside your Date filters if there was any type of asset activity within the selected date range. The time stamp of t00:00:00Z is expected. For scheduled content this could be the date of the class or the date the admin entered the completion and scores.
  • BADGE EARNED: The date the user earned the content's Digital Badge. This date does not change and is not affected by the date range filters. You may encounter situations where the First Access date shows a date later than the Badge Earned date. This happens when a learner accesses content again after they earn a badge AND you run the report for a date range that does not include the original date the content was accessed. Percipio populates the First Accessed date using the first date the content was accessed within the date range you specified.
  • FIRST ACCESS DATE: The first date within the filtered date range that the learner accessed the content. If the learner accessed the content on multiple occasions, this date may change based on the date range filters you specify. When you download the report as a CSV file, this field shows the date and time. Time is formatted in UTC, which may not match the learner's date because they see the date in their machine's local time.
  • LAST SCORE: The last score recorded for the content.
  • ENTRY METHOD: Indicates how the external learning item was added to Percipio either either self reported indicating that the learner entered the item from their Activity page, or imported indicating you added the item via bulk import.
  • LAST ACCESS DATE: The last date within the filtered date range that the user accessed the content. When you download the report as a CSV file, this field shows the date and time. Time is formatted in UTC, which may not match the learner's date because they see the date in their machine's local time.
  • TOTAL ACCESSES: The total number of times within the filtered date range that the item was accessed. For example, if a learner launches the same course 3 times within the specified date range, the total accesses is 3.

Additional columns

The following columns are also available in the Internal and External Activity report:

  • USER ID: The value entered in the User ID field. It is used to identify a user inside Percipio.
  • EMAIL ADDRESS: The value entered in the Email address user attribute; the user's email address.
  • CONTENT UUID: This is an internal Percipio code used with third-party learner management systems.
  • CONTENT ID: Unique identifier for the Skillsoft content item.
  • ISSUING BODY: For items entered as external learning, the organization that issued the completion.

  • ASSET TYPE: The type of asset.

    • Types may include assessment, audiobooks, audio summaries, books, book summaries, course, journey, linked content, scheduled content, dynamic content, video, and module.
    • When you select module or video, only items launched stand-alone display in the report. If you select Course: child content ( videos and modules) viewed as part of a course display in the report. You can choose to display both and then select to display the column, Consumed in Course, to determine how the item was launched.
    • When you see the asset type for linked content, it could be associated with any of following Skillsoft content types: AI simulator, cheatsheets, interactive courses, test preps, labs, bootcamps, partner content and any custom content items you added.
    • When you see the asset type, scheduled content, it could be associated with any of following Skillsoft items: live courses or live events.
    • When you see the asset type, assessment, it is associated with the content type of Skill Benchmarks.
    • The module asset type refers to individual components of Skillsoft courses that are in HTML format.
  • CONSUMED IN COURSE: Indicates whether a piece of child content such as a video or a module was launched from within a course (Yes) or launched independently in the video-only or module-only player (No).
  • SOURCE: The source of the content item.
  • LEARNING HOURS (SECONDS): The total number of hours a learner spent in content learning. If the item is a Skillsoft course, the total includes time spent watching videos while in the course (not the time spent on the same videos if launched in video-only mode) and working on knowledge checks within the course. If you see learners with a completed status and with 0 duration, the learner only took the test and did not watch any of the content. Time is listed in total seconds.
  • ESTIMATED DURATION (SECONDS): Total estimated amount of time it takes a learner to complete the specified content. Time is listed in total seconds.
  • LANGUAGE CODE: The language of the asset. Available languages and their codes are listed here.
  • COMPLETION TYPE: The type of completion. Options include, learner (when learner completes the item themselves), admin override (admin grants a completion), or waiver (admin grants a completion waiver).
  • ALL TIME FIRST ACCESS DATE: The date of all time that the learner first accessed the content. This date is not impacted by Date range filters.
  • ALL TIME LAST ACCESS DATE: The date of all time that the learner last accessed the content. The date shown in this field is not impacted by the Date range filters.
  • COURSE ASSESSMENT ATTEMPTS: The number of times the user attempted the assessment.
  • # OF RECURRENCES: The number of times a learner returned and re-completed the content.
  • EXPIRATION DATE: The date a certification expires.
  • CREATED DATE: The date the external learning item was added to Percipio.
  • 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.