Using Tags for Reporting

Using Tags for Reporting

Overview

Below is a list of explanations on how tags would be used in custom reports on Pluto LMS and how it is setup.
  1. A tag can be created and the name of that tag can be defined by the Client
  2. A tag will be assigned to an activity within a Pluto LMS course
  3. This activity will then be associated with the tag
  4. Learners will complete the activity and the completion records will be associated to the activity.
  5. The tag is not directly associated to the learner, but rather the activity (which the learner completed)
  6. By tagging the activity, the dataset will know which activity to pull learner records for.
The following diagram offers a visual aid on how tags work within Pluto LMS:



Please note that Pluto LMS do not create custom reports for the clients, this is just a sample to show you what the outcome will be for this setup and how tags can be used in reporting

Dataset:
  1. List of tags
  2. List of activities associated to those tags
  3. List of user segments associated to the learner
  4. List of learner details
  5. Completions associated to the activities
The dataset structure is as follows:



Advantages of this dataset structure:
  1. As new tags are added, the list will grow vertically without changing the table structure.
  2. As the learner completion number increases, the list will grow vertically without changing the table structure.
  3. This allows for scalable and dynamic changes/additions to dataset
  4. The column structure shown above allows for easier query logic as the column references will not change as new rows are added to the dataset.
Notes:
  1. If an activity is tagged more than once, it will show duplicate rows of user and completion data within the dataset. Please ensure this is considered when doing completion checks.
  2. The Client will still need to setup the LMS to restrict users to certain activities as required to avoid learners completing the wrong activity and showing in the dataset. This can be done via, but not limited to Activity Restriction Settings, Course Enrollments and User Segments.
  3. The Client will need to define the activity completion settings to ensure the correct data is pulled into this dataset. For example, if completing a quiz requires a pass mark, ensure that this is setup. The system will pull a completion into this dataset based on how the Client has defined the completion.
  4. Only user completions of a given activity will reflect in the dataset.
Guides:

Activity Restriction Settings:

Course Enrollments:

User Segments:

Understanding the Context of Tags in the Pluto LMS Database:

The below graphic will help you visualize how tags relate to other tables within your LMS database:



Table Structures:

The tables shown below include the tags you create within your LMS:

prefix_tag

This table will list the tags on your LMS. 

id
userid
name
timemodified
6
287
activity_tag
1568518024
7
123
course_tag
1668519034

id = unique identifier for your tag
userid = user id who created the tag
name = tag's name
timemodified = the time the tag was created/modified

prefix_tag_instance

This table will help you link the tag id in the prefix_tag table to the specific item within your LMS. 

idtagiditemtype
itemid
timemodified
226course_module
306
1568518024
237course
42
1668519034

id = unique identifier of instance
tagid = the id of the tag
itemtype = the type of the item in which your tag is used (will help you find other LMS database table)
itemid = the item id which your tag is linked to (example course id)
timemodified = the time the tag was created/modified

Creating Custom Reports:

If you're using a tool like PowerBI or Tableau, you can use tags to help segment or filter your reports.
  1. https://support.plutolms.com/portal/en/kb/articles/creating-a-custom-report
  2. https://support.plutolms.com/portal/en/kb/articles/sql-query-basics
  3. https://support.plutolms.com/portal/en/kb/articles/adding-filters
Note: The implementation of custom reports is out of Pluto LMS's support scope, however we will gladly assist you with understanding the database structure. Should you require support on writing custom reports, please make use of a 3rd party development service offering.



    • Related Articles

    • Tags

      OVERVIEW In the context of a Learning Management System, tags refer to a system of organizing and categorizing content, such as courses, modules, resources, or assessments, based on specific keywords or labels. Tags serve as metadata that can be ...

    • SCORM Reporting

      ADD SCORM TO YOUR COURSE Before you can start pulling SCORM reports, you will need to upload one/more SCORM packages to your Pluto LMS. Use Case Example: By utilizing the SCORM functionality in Pluto LMS and exploring the comprehensive SCORM reports, ...

    • Reports API

      block_configurable_reports_get_report_data Arguments reportid (Required) The report id General structure int //The report id REST (POST parameters) reportid= int How to connect to 3rd party data analysis tools: You can also connect to tools like: ...

    • Using the Data Table

      Overview Data Tables can be used to create structured tables that contain data in column and row format. Data Tables allow you to define column headings in preparation for a data import. A Data Table has the following structure: Fields = Columns ...

    • Finding Course Reports

      OVERVIEW In the relevant course, you can find a variety of course reports in (1) course admin, (2) the right-hand drawer and (3) on the "Grades" page. COURSE ADMIN On the "Course admin" page, in the "Reports" tab, you can find the following reports: ...