How to Get CSAT Survey Ratings for Tickets Solved by differnt Agents

When a ticket in Zendesk is reopened and then solved by a different agent, you might want to track the Customer Satisfaction (CSAT) survey rating specifically for each solving event. This guide will walk you through creating a report in Zendesk Explore that captures the CSAT rating every time a ticket is marked as solved by a different agent, including after ticket reopenings. What You Will Learn
How to identify the agent assigned to the ticket at the time of the CSAT response
How to see each satisfaction score for reopened tickets solved by different agents
Steps to Create the CSAT Rating Report in Explore
In Explore, Click the Reports icon on the sidebar.
In the Reports library, click New report.
On the Select a dataset page, click Support > Support - Updates history, then click Start report.
In the Metrics panel on the left, click Add and Search for and select the metric Updates. Select the aggregation method to D_COUNT

In the filter, Add a filter "Ticket Solved"
Add the following attributes:
Ticket ID

Update ID (each ticket update has a unique ID)

Ticket Update Timestamp (to see when each update occurred)


Add the default attribute Changes - Field Name. In this attribute select satisfactions_score to focus on CSAT rating changes.
Add below attributes in row to show the CSAT scores before and after the update:
Changes - Previous Value
Changes - New Value


Add attribute Update Ticket Assignee to display the name of the agent assigned when the CSAT rating was recorded.
Final Result {
"@context": "https://schema.org",
"@type": "TechArticle",
"@id": "https://support.zendesk.com/hc/en-us/articles/9698227935898",
"url": "https://support.zendesk.com/hc/en-us/articles/9698227935898-How-to-Get-CSAT-Survey-Ratings-for-Tickets-Solved-by-differnt-Agents",
"headline": "How to Get CSAT Survey Ratings for Tickets Solved by differnt Agents",
"description": "You can create a report to track Customer Satisfaction survey ratings for tickets solved by different agents, including after ticket reopenings, by using specific metrics and attributes in the reporting tool.",
"articleSection": "Other reporting recipes",
"datePublished": "2025-09-10T08:43:12+00:00",
"dateModified": "2025-09-10T10:25:01+00:00",
"inLanguage": "en-US",
"mainEntityOfPage": {
"@type": "WebPage",
"@id": "https://support.zendesk.com/hc/en-us/articles/9698227935898"
},
"author": {
"@type": "Organization",
"name": "Zendesk",
"@id": "https://www.zendesk.com"
},
"publisher": {
"@type": "Organization",
"name": "Zendesk",
"@id": "https://www.zendesk.com"
},
"isPartOf": {
"@type": "WebSite",
"name": "Zendesk Help",
"@id": "https://support.zendesk.com/hc/"
},
"about": {
"@type": "SoftwareApplication",
"name": "Zendesk",
"@id": "https://www.zendesk.com",
"softwareAddOn": {
"@type": "SoftwareApplication",
"name": "Explore",
"@id": "https://support.zendesk.com/hc/en-us/sections/4405298856346"
}
}
}