Downloading Player Report - at Project Level

Downloading Player Reports at the Project level allows you to analyze Players' activities based on completions, votes, comments, and points across all Topics, Flashcards, and Challenges in the Project. This article will cover the following: 

• How to download the report
• How to interpret the report

How to download Player Report

1. Go to Project Analytics and select “Report Download”. 
2. Scroll to the section “Player Statistics” and you will see 5 reports available for download (learn how to interpret each of them below)
   1. All Players: consolidated report of all the Players in the Project
   2. Active Players Only: consolidated report of all the active players in the Project (active being having at least one completion, vote, or comment)
   3. Include Points Summary: a breakdown of the actions that contribute to the Players’ current total points 
   4. Players for each Topic: each worksheet contains player activity in the selected Topic
   5. Weekly Completions and Points: activity accumulated by Players, by calendar week.
3.  After selecting a report, you will see the options to 1) download the report directly, or 2) send the report via email.
4. To download the report directly:
   1. Go to the section “Download Report” and pick a time period - “All Time” or a date range (according to GMT +0). 
   2. Click to begin downloading. 
5. To send the report via email:
   1. Go to the section “Send Report via Email” and pick a time period - “All Time” or a date range (according to GMT +0). 
   2. Insert an email address to which you would like to send the report. 
   3. Click  to generate and send the report. 

How to interpret the report

There are 5 reports available:

1. Player activity in this project - All Player
2. Player activity in this project - Active Players only
3. Player activity in this project - Include Points Summary
4. Player activity in this project - Players for each Topic
5. Player activity in this project - Weekly Completions and Points 

Player activity in this project - All Players

A consolidated report of all activities by all Players in the selected Project. You will see the following:

1. [Column A to B] Team information: unique ID and name
2. [Column C to G] Player information: unique ID, name, email, region, account suspension status 
3. [Column H to T] Player statistics: project completion status, progress in %, topics completed,  total time spent, total time spent (in seconds), total completions, challenges completed, votes cast, votes received, comments posted, total points, points balance (after deduction from reward redemption) and redemptions
4. [Column U to AD] Player activity data (any timestamp is according to GMT +0)
   1. Join Time: timestamp at which the player joined the project 
   2. First Accessed At: timestamp at which the player first accessed the Project
   3. First Completion At: timestamp at which the player first submitted a challenge completion
   4. Last Completion At: timestamp at which the player last submitted a challenge completion
   5. Last Vote At: timestamp at which the player last voted on a content or completion
   6. Last Comment At: timestamp at which the player last commented on content or completion
   7. Last Activity At: timestamp at which the player is last active in the Project - can refer to either viewing content, completing challenges, etc.
   8. Days Since Last Activity: the number of days since the player is active in the Project
   9. Last Accessed at: timestamp at which the player last accessed the Project
   10. Days Since Last Access: the number of days since the player last accessed the Project
   11. Account Creation: timestamp at which the player account was created

Player activity in this project - Active Players only

A consolidated report of activities by active players in the Project only. An active player has at least one completion, vote, or comment in the select Project. The data available is the same as the report for “Player activity in this project”.

Player activity in this project - Include Points Summary

There are 2 reports available - “Players” and “Points Summary”.

“Players” is a consolidated report of all activities by all Players in the selected Project. The data available is the same as the report for “Player activity in this project”.

“Points Summary” is a breakdown of the actions that contribute to the Players’ current total points in the Project. You will see the following:

1. [Column A to C] Player information: unique ID, name, and email
2. [Column D] Action: any activity in the Project that resulted in the change in points (can include completing a challenge, redeeming a reward, awarded bonus points by Admin, etc)
3. [Column E to F] Challenge details (if relevant): ID and title
4. [Column G to J] Details and impact of the action:
   1. Count: the number of times this particular action has occurred for the selected player (i.e. how many times did it happen)
   2. Total points: total change in points due the action (a result of an addition of ‘points’ & ‘from bonus points’)
   3. Points: change in points due to action (not accounting bonus points)
   4. From Bonus Points: change in bonus points due to action
      NOTE: any negative sign before the value represents a deduction of points, typically due to reward redemption. 
5. [Column K] Last Update: timestamp in which the action happened (according to GMT +0)

Player activity in this project - Players for each Topic

Each worksheet, marked by the Topic ID and title, contains player activity in the selected Topic. You will see the following: 

1. [Column A to E] Player information: unique ID, name, email, region, account suspension status
2. [Column F to J] Player statistics: number of completions, votes cast, votes received, comments posted, points in the selected Topic
3. [Column K to N] Player activity data in the selected Topic (any timestamp is according to GMT +0)
   1. Join Time: timestamp at which the player joined the topic 
   2. Topic Completion At: timestamp which the player completed the Topic, i.e. completed all challenges in the topic
   3. First Completion At: timestamp at which the player first submitted a challenge completion in the selected topic
   4. Last Completion At: timestamp at which the player last submitted a challenge completion in the selected topic

Player activity in this project - Weekly Completions and Points 

A summary of the activities accumulated by Player, with a breakdown by calendar week. There are 2 reports available - “Completions” and “Points”. 

“Completions” only shows the number of challenge completions accumulated by the selected Player. You will see the following:

1. [Column A] Week: displayed as the year, followed by the calendar week
2. [Column B to D] Player information: ID, name, and email
3. [Column E] Completions: the number of completions accumulated by the selected player

“Points” only shows the number of points accumulated by the selected Player. You will see the following:

1. [Column A] Week: displayed as the year, followed by the calendar week
2. [Column B to D] Player information: ID, name, and email
3. [Column E] Points: the number of points accumulated by the selected player from all activity in the Project