Read feedback summary by operator
Reads a summary of feedback ratings grouped by operator for the previous year. This aggregation is useful for performance reviews and identifying top-performing agents.
This query aggregates data from the Conversations table, grouping by OwnerEmail and RatingString to provide a count of each rating type per operator.
SELECT
OwnerEmail,
OwnerId,
RatingString,
COUNT(Id) Total
FROM Conversations
GROUP BY OwnerEmail, OwnerId, RatingString
ORDER BY OwnerEmail, RatingString
WITH(
--OperatorIds='81565000003048017,81565000002408043' --You can supply Operator Ids to filter result for those Operators only
StartTime='yearstart-1y'
, EndTime='yearstart-1d'
)