Interpret the Learner Transcript CSV

Caution:

Learning Manager Learning Programs are renamed to Learning Paths. This change happens immediately after the October 2021 release and the terminology of Learning Path is reflected for all roles.

Overview

The Learner Transcript is one of the most popular reports used in Adobe Learning Manager. The report enables one to get nearly every possible detail in a single report in CSV format.

Apart from being a report that users can fetch to track and analyze learning behaviors, the report can also be viewed as the format in which Learning Manager can be set up to export data about learning behaviors to external applications/systems.

A typical enterprise scenario is to take a periodic export of learner transcript for Learning Manager, analyze it to extract learners completing an important learning program, and placing an order for a gift voucher to recognize and reward timely completions.

Another use case is to add the learning behavior data to an enterprise data warehouse, where one may want to combine learning data with other enterprise data to analyze correlations between learning behavior and other process data.

In the rest of the document, we briefly describe how one can fetch the Learner Transcript from Learning Manager; and then proceed to providing the details on how each row and column of the report needs to be interpreted.

This information may be useful for any developer who intends to integrate Learning Manager with other systems by way of processing the exported learner transcript data.

Fetch Learner Transcript from the User Interface

From the Profile Settings, a learner can download his/her transcript. For more information,  see Download Learner Transcript.

Administrators can generate Learner Transcripts for the whole organization, a specific set of users or a specific set of learning objects, or a specific set of users and learning objects. They can also get all learning records for a time interval duration and indicate if module level information is required (by default, module level information is omitted). For more details, see Download Learner Transcripts.

Administrators can also set up the system to email the Learner Transcript periodically.

Note:

The Learner Transcript generated via the UI will be an Excel file, which also contains the “Skill Transcript”. In this document, we will refer to what is generated in the CSV format, a report containing learning activities pertaining to enrollment, starting, progress or completion of a learning object.

Export Learner Transcript

When the Learner Transcript has to be consumed by an external system, Learning Manager provides a feature called Export Data, where Learner Transcript is one of the types of data that can be exported. As explained in the Preamble, this is required for integration of Learning Manager with an external system that needs to process learning behavior data or for populating an enterprise data warehouse with learning behavior data.

For details of how the connectors that supporting Export of Learner Transcript, see the Export Data section in the FTP, Box and PowerBI Connectors.

The purpose served by these connectors is to export data to a downstream application periodically (once in N days). So, these connectors export only the incremental learning behavior data in every run. Note that these connectors don’t allow for fetching records pertaining to specific subset of users or learning objects – it is always data about all users and all learning objects in that account.

In the case of PowerBI, the customer should provide a workspace where Learning Manager can keep exporting this data incrementally into a dynamically created dataset. This connector merely exports data, and the customers must build their own reports/dashboards based on this dataset as need be.

The next section provides the details on how a downstream system should interpret the records in the learner transcript.

Interpret the Learner Transcript

Each row in a Learner Transcript can be thought of as some learning behavior that was captured in Learning Manager in a specific time period. Typically, the connectors export “incremental data” and so the rows represent learning activities that happened between the last run of the connector and the current run.

Of course, the connectors also allow you to fetch the learner transcript on demand, and in this case the user can specify a start date and the end date is assumed to be now. Usually one would do this once initially and then set up the connector for exporting the incremental learner transcript at a specific time of day, once in N days (the default value of N, being 1).

Let us now define what is meant by Incremental Learner Transcript

In the learner transcript, every row represents a specific activity involving a specific learner and a specific learning object. We are primarily interested in what state a learner is with respect to the learning object – Enrolled, Started, In Progress, and Completed. Therefore, the learner transcript captures four corresponding dates as well.

Now there are three types of learning objects, where Learning Manager tracks learner progress; and the exported data contains progress information at the module level, which is the most granular unit of content that a learner can experience in Learning Manager.

  • Course – a composition of one or more modules
  • Learning Program – a composition of one or more courses
  • Certification – a composition of one or more courses.

Every row in the Learner Transcript could be pertaining to a specific user’s engagement with a Module, Course, Learning Program or Certification. When a user is enrolled to a Learning Program, the transcript will indicate that the user is e

The columns of the Learner Transcript provide various pieces of information pertaining to each learning activity, and the following tables describe the semantics of each column.

Learner Transcript

Column Name

Type of value

Description

Name

Never empty

Name of the learner

email

Never empty

Email address of the learner

Adobe ID Can be empty Adobe ID of the learner
User Unique ID Can be empty User Unique Id of the Learner. This column is based on the backend setting whether enabled/ disabled at account level.

Learning plan Name

Can be empty

Name of the learning plan (if any), through which the user has been automatically assigned to.

LP/Certification/Course

Never empty

Name of the learning pogram, Certification or Course

Type

Never Empty

The type of the learning object, the user was enrolled into.

Course

Can be empty

Name of course in which user is enrolled to. When it is empty, the row represents either a Certification or Learning Program. 
LO Unique ID Can be empty Learnig Object Unique Id of the LO. This column is based on the setting whether enabled/ disabled at account level

Instance 

Never Empty Name of the instance of the LO user is enrolled into. 

Selection Criteria

Never empty

Basis of enrollment (how this learner got enrolled to this LO).

Module

Can be empty

Name of module inside the Courses. When empty, this row represents either a course, learning program or certification.
Version Can be empty Version of the module
Delivery Type Can be empty Delivery Type of the module - eLearning, F2F, VC, Activity.
Language Can be empty Language in which the module is consumed by learner. This column shows value only for eLearning modules.
Comment Can be empty Comments added by Admin, Instructor for the learner while marking the user attendance.
Enrollment Date (Asia/Calcutta TimeZone) Never Empty Date of enrollment by the learner to the LO type.
Started Date (Asia/Calcutta TimeZone)

Can be empty

Date on which learner started the LO. Empty implies the learner has not yet started this.
Completion Date (Asia/Calcutta TimeZone)

Can be empty

Date on which learner completed this. Empty implies the learner has not yet completed this.

Deadline (Asia/Calcutta TimeZone)

Can be empty

Date on which learner is expected to complete this LO. Empty implies that there is no deadline for this.
Overdue Yes/ No Current overdue status of the Learner enrolled to the LO. Yes/No

Status

Not started/Completed/In Progress/Unenrolled Current Progress % of the Learner enrolled to the LO.

Progress %

Can be empty

Indicates the extent to which learner has completed this.

Time Spent(minutes) Can be empty Learning time spent by the learner in the LO, the module level rows displays the individual module wise Learning Time Spent. The Course / Program / Certificate level rows displays the aggregated learning time spent.

Grade

Pass/ Fail Indicates success of learner. 'Pass', if user has met success criteria for this, 'Fail' otherwise.

Quiz Score

Can be empty The latest quiz score obtained by learner. Can be empty, if learner has not attempted the quiz or content doesn't have any quiz in it or Admin/ Instructor haven't assigned any score.
Quiz_score_max Can be empty The latest maximum quiz score possible for the module. Can be empty if learner has not attempted the quiz or content doesn't have any quiz in it.
Highest_Quiz_score Can be empty The highest quiz score obtained by the learner across multiple attempts. Can be empty, if learner has not attempted the quiz or content doesn't have any quiz in it or Admin / Instructor haven't assigned any score.
Highest_Quiz_score_max Can be empty The highest maximum quiz score possible for the module. Can be empty if learner has not attempted the quiz or content doesn't have any quiz in it.
Attempts Taken Can be empty The total number of attempts taken by learner so far for this module.
Maximum Allowed Attempts Can be empty The maximum number of allowed attempts for the learner to consume the module.

userState

Never Empty User state of the learner: Active / Deleted / Suspended.
Groupable Active Field Can be empty For each groupable Active Field in account, there will be a column, where the column name is that of Active Field and the value will be the specific value the learner has for that field.

Manager Name

Can be empty

Manager Name of the learner
Enrollment Count 1 or 0 Enrollment Count of the learner for the LO. The highest level LO row shows a value = '1'. The subtrainings displays a value 0.
Started Count 1 or 0 Started Count of the learner for the LO. The highest level LO row shows a value = '1'. The subtrainings displays a value 0.
Completion Count 1 or 0 Completion Count of the learner for the LO. The highest level LO row shows a value = '1' if learner is pending completion in that training. The subtrainings displays a value 0 even when in Pending state. The highest level LO row shows a value = '0', if learner has completed the training.
Due in N Days 1 or 0 This shows a value of '1' or '0' depending on the instance deadline of the training learner is enrolled to. It depends on the value entered on Learning Sumary I sheet > 'Due Date Coming up in' field.
Due in N Days for User 1 or 0 This shows a value of '1' or '0' depending on the instance deadline of the training learner is enrolled to. It depends on the value entered on Learning Sumary II sheet > 'Due Date Coming up in' field.
Count of (Progress Greater than N %) 1 or 0 This shows a value of '1' or '0' depending on the learner progress in the training. It depends on the value entered on Learning Sumary I sheet > 'Progress Greater than' field.
Count of (Progress Greater than N %) for User 1 or 0 This shows a value of '1' or '0' depending on the learner progress in the training. It depends on the value entered on Learning Sumary II sheet > 'Progress Greater than' field.
Training ID Never Empty Training ID of the training.
Training or Module Duration (mins) Never Empty Total Training or Module Duration (mins) of the default instance of the training.

Learning summary I

Column name
Type of value Description
Type All, Learning Program, Certificate, Course. The LO type for which the Learning Sumary table should show data.
Groupable field(profile) Never Empty The profile for which the learning summary table should show data.
Manager Name Never Empty The manager name, whose subordinates LO engangement data is to be displayed on the Learning summary table.
Row Labels Never Empty The LO name with the list of learners enrolled to the LO.
Number of Learners enrolled Never Empty Number of learners enrolled the LO.
Number of Learners Who Have Started Never Empty Number of learners who have started the LO.
Number of Learners Who Have Completed Never Empty Number of learners who have completed the LO.
Number of Learners who have progressed >= N % Never Empty Number of Learners who have progressed >= N % (values).
Number of Learners with due date in N days Never Empty Number of Learners with due date in N days (values).

Learning summary II

Column name Type of value Description
Type All, Learning Program, Certificate, Course. The LO type for which the Learning Sumary table should show data.
Groupable field(profile) Never Empty The profile for which the learning summary table should show data.
Manager Name Never Empty The manager name, whose subordinates LO engangement data is to be displayed on the Learning summary table.
Row Labels Never Empty The Learner name with the list of LOs learner is enrolled to.
Number of Learning Objects Enrolled Never Empty Number of Learning Objects learner is enrolled to.
Number of Learning Objects Started Never Empty Number of Learning Objects learner has started.
Number of Learning Objects Completed Never Empty Number of Learning Objects learner has completed.
Number of Learning Objects which have progressed >= N % Never Empty Number of Learners Objects learner have progressed >= N %.
Number of Learning Objects with due date in N days Never Empty Number of Learning Objects with due date in N days.

Compliance Summary

Column name  Type of value Description
Type All, Learning Program, Certificate, Course. The LO type for which the Learning Sumary table should show data.
Row Labels (Left side column) Never Empty The Learner name with the list of LOs learner is enrolled to.
Row Labels (Left side column) Never Empty The Learner name with the list of LOs learner is enrolled to.

Skill Transcript

.Column name Type of value   Description
Name Never Empty Name of the learner
email Never Empty Email address of the learner
Adobe ID Can be empty Adobe ID of the learner
User Unique ID Can be empty User unique ID of the learner. This column is based on the backend setting whether enabled/disabled at account level.
Skill Never Empty Assigned skill name to the learner.
Skill Level Never Empty Assigned skill level to the learner.
Credits Required Never Empty Total Credits required by Learner to achieve the Skill.
Credits Earned Never Empty Total Credits earned by Learner for the Skill.
Completion Percentage Never Empty Progress Percentage to achieve the skill.
Date Assigned (UTC TimeZone) Never Empty Date on which the Skill was assigned to the Learner.
Date Achieved (UTC TimeZone) Never Empty Date on which Learner achieved the Skill.
userState Never Empty User state of the learner: Active / Deleted / Suspended.
Groupable Active Field Can be empty For each groupable Active Field in account, there will be a column, where the column name is that of Active Field and the value will be the specific value the learner has for that field.
Manager Name Can be empty Manager Name of the learner.

Skill Summary I

Column name Type of value Description
After Never Empty Number of learners who achieved the skill, before the entered (value) number of days which needs refreshing.
Name All or any Learner name The learner name who has a skill assigned.
Manager Name Never Empty The manager name, whose subordinates skill engangement data is to be displayed on the Skill summary table.
Row Labels Never Empty The Skill name with the list of learners assigned to the Skill.
Number of users who should have this skill Never Empty Number of learners assigned to the Skill.
Number of users who have achieved this skill Never Empty Number of learners who have achieved the Skill.
Number of learners whose skill needs refreshing Never Empty Number of learners whose Skill needs refreshing.
Percentage of Compliance (Based on skill achieved) Never Empty The progress percentage of the assigned Skill.

Skill summary II

Column name Type of value Description
After Never Empty Number of learners, who achieved the skill before the entered (value) number of days which needs refreshing.
Skill All or any Skill name The Skill names that are assigned to Learners.
Manager Name Never Empty The manager name, whose subordinates skill engangement data is to be displayed on the Skill summary table.
Row Labels Never Empty The Learner name with the list of Skills assigned.
Number of Skills Each User Should Have Never Empty Number of Skills asigned to the learner.
Number of Skills Each User Has Never Empty Number of Skills achieved by the learner.
Number of Skills that need Refreshing Never Empty Number of learners whose Skill needs refreshing.
Percentage of Compliance Never Empty The progress percentage of the assigned Skill.
Note:
  • Sometimes administrators may mark completion for a Learning Object manually (especially for Class Room courses) much after the class. In such a scenario, if Export Data is set up to export LT daily, the actual date of completion may have passed already and so the export will never get such completion records that were marked as completed much after the class happened. When this is detected, consider exporting the transcript from a given start date till date (on demand) in the UI; and then take it to the downstream application for “late processing”. While doing  this, you may have to ignore records that have already been processed.
  • Multiple Attempts for a module depends on whether that is enabled for that LO. When enabled, what you now see in a CSV row related to a module is one attempt. Not all attempts in a day may be reported and so you may see the total number of attempts see increment by more than one. Also an attempt may not necessarily improve a score, and at any given point you will only the best score. 

 Adobe

Get help faster and easier

New user?