Easily export assessment data for analysis and reporting. Select from detailed response data, performance score summaries, or manager score summaries based on your reporting requirements.
Exporting results to Excel
-
Click Reviews in the top nav.
-
Click the name of the review.
-
Click Actions on the top right of the page.
-
Select Export data in the dropdown.
-
Select the report type.
-
Click Export.
Available report types
Raw data
The Raw Data report provides the most detailed assessment data available.
Rows
-
One row per question per participant.
-
Example: A 180 In-Depth Assessment with 17 questions will generate 34 rows of data.
Columns
|
Column |
Description |
|---|---|
|
Subject |
First and last name of the subject |
|
Job |
Subject's job title |
|
Job Level |
Subject's job level |
|
Position |
Subject's position |
|
Department |
Subject's department |
|
Library Item |
Competency or skill name |
|
Question |
Question text:
|
|
Rating |
Level selected by the participant |
|
Rating By |
First and last name of the participant |
|
Rating Viewpoint |
Viewpoint type associated with the rating
|
|
Comment |
Response comment |
|
Comment By |
First and last name of the participant |
|
Comment Viewpoint |
Viewpoint type associated with the comment
|
|
Target |
Target score (from the job description) |
|
Relative Score |
Calculated relative score |
Performance score data
The Performance Score Data report provides summarized performance score information for each assessment subject.
Rows
-
One row per subject.
-
Example: A 180 In-Depth Assessment with 17 questions and 3 subjects will generate 3 rows of data.
Columns
|
Column |
Description |
|---|---|
|
Subject |
First and last name of the subject |
|
Job |
Subject's job title |
|
Job Level |
Subject's job level |
|
Position |
Subject's position |
|
Department |
Subject's department |
|
Manager |
First and last name of the subject's manager |
|
Performance Score (Subject) |
Performance score calculated based on the subject’s ratings |
|
Performance Score (Manager) |
Performance score calculated based on the manager’s ratings |
Manager score data
The Manager Score Data report summarizes manager assessment ratings.
Rows
-
One row per manager.
-
Example: A 180 In-Depth Assessment with 17 questions and 3 subjects will generate 3 rows of data.
Columns
|
Column |
Description |
|---|---|
|
Manager |
First and last name of the subject’s manager |
|
Job |
Subject’s job title |
|
Job Level |
Subject’s job level |
|
Position |
Subject’s position |
|
Department |
Subject’s department |
|
Manager Score |
Choosing the right report
|
Report Type |
Best For |
|---|---|
|
Raw Data |
Detailed analysis of individual responses, ratings, and comments |
|
Performance Score Data |
Reviewing performance scores across assessment subjects |
|
Manager Score Data |
Reporting on manager rating tendencies |
Use the Raw Data report when exporting data for external analytics tools or custom reporting, as it contains all available assessment responses and comments.