In addition to our newer Metrics pages, many areas of Secure Code Warrior offer CSV downloads with different datasets that you might find useful in administering your secure code learning program.
Over time, as we continue to improve our newer reports, we plan to rationalize these reports, so there aren't too many different ways to get the same or similar data.
Note: The data in these CSV extracts is updated daily at midnight UTC.
Courses
- Course Progress Summary
- Player Data: Player Course Summary
- Team Data: Course Summary for teams
- Export All Data: Task attempts for all players
To download Courses CSVs, please follow the steps below:
- Navigate to Metrics from the top menu
- From the Leaderboards section, select Course Leaderboards
- Click the "Export CSVs" button
Course Progress Summary
Note: Time spent is the amount of time a player has spent actively playing a challenge/mission. The time is tracked once a challenge has started/resumed and stopped once they submit an answer.
|
Label |
Description |
|
Course Name |
The name of the Course |
|
Description |
Description of the Course (descriptions are added on creation) |
|
Deadline |
The expiration date of the Course (if set). An expiry date is optional |
|
Status |
Course status. This can be Published, Unpublished, or Archived |
|
Created By |
The name of the Company Admin or Team Manager that created the Course |
|
Players Invited |
Number of players invited to the Course |
|
Players Enrolled |
Number of players that enrolled in the Course but haven't completed it yet |
|
Players Completed |
Number of players that completed the Course |
|
Percentage Completed |
The percentage of players that completed the Course |
|
Languages available |
The languages that were available in the Course |
|
Average time spent on Course |
The average amount of time players spent on challenges/missions |
Player Data: Player Course Summary
|
Label |
Description |
|
Player Name |
The name of the player |
|
|
The email address of the player |
|
Team Name |
The name of the team the player belongs to |
|
Tags |
Any tags associated with the players' account |
|
Course |
Course Name |
|
Course Status |
Course status. This can be Published, Unpublished, or Archived |
|
Languages Available |
The languages that were available in the Course. For the player Course summary, there will be a row per language available within the Course per player. |
|
Status (player) |
Course status per player |
|
Status for a language (player) |
Course status per language |
|
First Started Date |
The date the Course was first started |
|
First Completed |
The date the Course was first completed in one of the languages available |
|
Progress |
A percentage of how much of the Course the player has completed |
|
Points |
How many points the player has acquired in the Course |
|
Accuracy |
Individual player Accuracy. Accuracy = (# Correct Challenges /# of attempts) * 100 |
|
Confidence |
Individual player Confidence. |
|
Completed tasks |
Number of tasks completed within the Course |
|
Total Tasks |
Total number of tasks available in the Course |
|
Hints Used |
Number of hints used throughout the Course |
|
Total Hints |
Total number of hints available in the Course |
|
Correct Attempts |
The number of correct challenge attempts |
|
Total Attempts |
The total number of challenge attempts |
|
Total Time Spent |
The total amount of active time spent playing challenges/missions on the Course is measured in hours (h), Minutes (m), and seconds (s) |
|
Videos Watched |
Number of resource videos that were watched throughout the Course |
Team Data: Course Summary for Teams
|
Label |
Description |
|
Team |
Name of the team |
|
Course |
Name of the Course |
|
Players Invited |
Number of players within the team that were invited to the Course |
|
Players Enrolled |
Number of players that enrolled in the Course but haven't completed it yet |
|
Players Completed |
Number of players in the team that have completed the Course |
|
Average progress |
A percentage showing the average Course progress per player in the team |
|
Total Points Earned |
The total amount of points earned by the team |
|
Accuracy |
Accuracy of the team Accuracy is calculated by dividing the number of correct attempts by the total of both incorrect and correct attempts and multiplying that by 100.Accuracy = (# Correct Challenges /# of attempts) * 100 |
|
Confidence |
Confidence of the team |
|
Average Time Spent on Course |
The average amount of active time spent playing challenges/missions on the Course as a team is measured in hours (h), Minutes (m), and seconds (s) |
|
Total Time Spent |
The total amount of active time spent playing challenges/missions on the Course as a team is measured in hours (h), Minutes (m), and seconds (s) |
Export All Data: Task attempts for all players
Note: The stage columns will be repeated for the number of stages in the course
|
Label |
Description |
|
Name |
Name of the player |
|
|
Player’s email address |
|
Status |
User status in Secure Code Warrior (enabled/disabled) |
|
Team |
The team the player belongs to |
|
Company |
The company the player belongs to |
|
Roles |
The player's role within Secure Code Warrior (User, Developer, Team Manager, Company Admin) |
|
Tags |
Any tags related to the player |
|
Language |
The Language the task has been played in |
|
Challenge Started |
The date the challenge had been started |
|
Course Name |
Name of the course the challenge had been in |
|
Activity Type |
Type of activity within the course (Challenge, Video, Custom) |
|
Category |
Vulnerability Category of the activity |
|
Subcategory |
Vulnerability subcategory of the activity |
|
Difficulty |
The difficulty of the challenge if applicable |
|
Activity Status |
The current progress of the activity |
|
Course Language Status |
Current player status of the course in the selected language (Done, In Progress) |
|
Course Status |
Status of the course (Published, unpublished) |
|
Base Points Earned |
Amount of points earned from the Base points available for the challenge |
|
Bonus Points |
Any bonus points earned for the challenge |
|
Stage 1 Question |
Type of question (only for challenges) Fix the vulnerability, Locate the vulnerability |
|
Stage 1 Status |
Status of Stage 1 (Done, skipped, in progress) |
|
Stage 1 total attempts |
Number of attempts on this stage |
|
Stage 1 Total Hints |
Number of Hints available |
|
Stage 1 Hints Used |
Number of hints used for this Stage |
Comments
0 comments
Please sign in to leave a comment.