QMEvaluationAnalysisReport
Query the Quality Management Evaluation Analysis Report via the Explore API. Provides data collected during evaluations. Up to a month of data per request.
Select
The QMEvaluationAnalysisReport is a report view. The driver processes the following pseudo-columns server-side; any other WHERE clause conditions are evaluated client-side.
- TimespanFrom supports the following operator: >=
- TimespanTo supports the following operator: <
- Timezone supports the following operator: =
If TimespanFrom and TimespanTo are omitted, the driver defaults the time range to the last 31 days.
For example, the following query is processed server-side:
SELECT * FROM QMEvaluationAnalysisReport WHERE TimespanFrom >= '2025-01-01' AND TimespanTo < '2025-02-01'
Columns
| Name | Type | References | Description |
| EvaluationId [KEY] | String | The unique identifier of the evaluation. | |
| InteractionId | String |
CallsReport.InteractionId | The unique identifier of the interaction being evaluated. |
| AgentId | String |
Users.Id | The unique identifier of the agent being evaluated. |
| EvaluatorId | String |
Users.Id | The unique identifier of the evaluator. |
| SectionId | String | The unique identifier of the form section. Can be null for the header section. | |
| FormId | String | The unique identifier of the evaluation form. | |
| HeaderId | String | The unique identifier for a header section. | |
| Agent | String | The full agent description including name, email, and ID. | |
| AgentName | String | The name of the agent being evaluated. | |
| AgentEmail | String | The email of the agent being evaluated. | |
| TeamName | String | The team name of the evaluated agent. | |
| EvaluationVersion | Int | The version number of the evaluation. 0 means original and never edited. | |
| EvaluatorName | String | The name of the person who performed the evaluation. | |
| RingGroupNames | String | The ring group or queue names the interaction belongs to. | |
| EvaluationObtainedScore | Double | The achieved score for the evaluation. | |
| EvaluationMaxScore | Double | The maximum possible score for the evaluation. | |
| FormName | String | The name of the evaluation form. | |
| SectionName | String | The name or title given to the section. | |
| SectionObtainedScore | Double | The achieved score for the section. | |
| SectionMaxScore | Double | The maximum possible score for the section. | |
| QuestionId | String | The unique identifier of the question. | |
| QuestionType | String | The type of question. Example values: MultipleChoiceQuestion, TextQuestion, DropdownSingleChoice, CheckBoxQuestion. | |
| QuestionText | String | The text of the question. | |
| QuestionAnswer | String | The text of the answer given to the question. | |
| QuestionObtainedScore | Double | The score obtained for the question. | |
| QuestionMaxScore | Double | The maximum possible score for the question. | |
| EvaluationTime | Datetime | The date and time when the evaluation was performed or last edited. | |
| FirstEvaluatedOn | Datetime | The date and time of the first version of the evaluation. Null if only one version exists. | |
| InteractionReference | String | The reference added to ad-hoc evaluations. Null if not set. | |
| HeaderText | String | The text of the header section. | |
| BranchTo | String | The branching destination when an answer has branching configured. | |
| InteractionChannel | String | The channel of the interaction being evaluated. | |
| InteractionDirection | String | The direction of the interaction. Example values: IN, OUT. | |
| InteractionSource | String | The source of the interaction. | |
| InteractionDate | Datetime | The date and time of the interaction. | |
| FormElementMandatory | String | Whether the form element is mandatory. | |
| InteractionType | String | The type of the interaction. |
Pseudocolumns
Pseudocolumn fields are used in the WHERE clause of SELECT statements and offer more granular control over the data returned from the data source.
| Name | Type | Description | |
| TimespanFrom | Datetime | The start date for the report timespan. | |
| TimespanTo | Datetime | The end date for the report timespan. | |
| Timezone | String | The IANA timezone for the report timespan. |