A weekly ticket quality review desk for Freshdesk support leads

By General Input

Give every support lead a fair, sampled queue of resolved tickets to score against your own rubric, with an assistant that pre-scores each one.

Integrations

  • Freshdesk
  • Google Sheets
  • Slack

Type

App

Categories

  • Customer Support
  • Operations

I want an internal app my support leads open once a week to review ticket quality in Freshdesk. It is a review desk, not a report: a reviewer signs in, gets their own sampled queue of tickets resolved in the past week, reads each full customer conversation inside the app, and scores it against a rubric I configure. Build four surfaces: my review queue, the ticket review screen, agent and team rollups, and a rubric settings page.

When someone opens the app, match them to a Freshdesk agent using List Agents by comparing the signed in user's email against the agent emails, and let them pick their agent manually if the match fails. Everything is per reviewer: their queue, their in progress scores, their history.

Building the weekly queue is the part that has to be right. Use List Agents and List Groups to get the active agents and which group each belongs to. For each agent, run a narrow Filter Tickets query scoped to that one agent and the past week (agent id plus resolved or closed status plus an updated date range) and count what they resolved. Do not try to pull the whole week in one query: Filter Tickets returns at most 30 results per page and 300 in total, so per agent queries are the only way to see real volume. Allocate the reviewer's weekly sample across agents in proportion to each agent's resolved volume, so someone who closed 120 tickets contributes far more of the queue than someone who closed 12. Make the sample size per reviewer a setting with a default of 15 tickets. Drop one touch autoreplies before sampling: check the conversation count on each candidate and skip anything that closed with a single outbound message and no customer back and forth. Never hand a reviewer a ticket they handled themselves, checked against the responding agent and against anyone who replied on the thread. Seed the sample per reviewer per week so the queue is stable if they close the app and come back, and never give the same ticket to two reviewers in the same week.

The queue view lists each sampled ticket with subject, requester, the agent who handled it, the group, priority, how many replies it took, whether it was reopened, time to resolve, and a scored or not scored state, plus a progress counter such as 6 of 15 scored.

Opening a ticket goes to the review screen. Load the ticket with View Ticket and the whole thread with List Ticket Conversations, and render the conversation inline in reading order with sender, timestamp, and whether each entry was a public reply or a private note, so the reviewer never has to open Freshdesk. Alongside it, show the rubric as a scoring panel: by default tone, accuracy, resolution and follow up, each on a 1 to 5 scale with its own comment box, plus an overall comment. Saving persists the scores and comments in the app against that reviewer and ticket, and appends a row to a running scorecard log in Google Sheets with Append Values carrying review date, reviewer, agent, group, ticket id and subject, each rubric score, the total, the comments, and whether the score came from the assistant or was overridden by the human. Add previous and next controls so a reviewer can work straight through the queue without going back to the list.

Every ticket needs a pre-score button that kicks off a background agent. That agent reads the ticket with View Ticket and the full thread with List Ticket Conversations, then proposes a score for every rubric line with a short justification and a direct quote from the thread as evidence, for example the exact sentence where the agent apologised, or the point where a promised follow up never arrived. Its output lands back in the app as a draft score, rendered in the scoring panel with the quoted evidence beside each line and clearly marked as suggested. The human can change any number or comment before saving, and the saved record keeps track of which lines were accepted and which were overridden so I can see over time how close the assistant is running.

The rollup view answers who needs coaching. Build a per agent table from List Agents showing tickets reviewed, average score overall and per rubric line, the spread of scores, and the trend against previous weeks. Build a per team table from List Groups that aggregates the same numbers by group. Let me filter by date range and by group, and click through from any row into the underlying reviewed tickets.

Put a write the coaching brief button on each agent's rollup row. It starts a second background agent that gathers that agent's reviewed tickets for the chosen month from the saved scores, re reads the notable ones with List Ticket Conversations, and writes a short coaching brief: what they do well with a quoted example, the two or three patterns to work on with quoted examples, and concrete suggestions. Show the brief in the app for review, then a send button posts it to that agent's manager in Slack with Send a Message, either into a chosen channel or as a direct message after resolving the manager's conversation with Open a Conversation. Let me set the manager per agent in settings.

The settings page is where I define the rubric. Let me rename categories, change the scale, add or remove lines, mark lines required, and write the guidance shown to reviewers for each line, and version the rubric so older scores keep the version they were graded against. The same page holds the weekly sample size, the volume weighting, the skip rules for autoreplies, the Google Sheet and tab used for the log, and the Slack destinations.

Two rules to build in. There is no customer satisfaction or survey rating data available for this helpdesk, so do not design any view around CSAT: quality is the human rubric score plus the signals on the ticket itself, meaning reply count, reopens, time to resolve and priority. And rubric feedback must never reach the customer, so if I switch on writing a summary back into Freshdesk it has to use Add Note to Ticket in private agent only mode, never Reply to Ticket.

Related prompts

Explore more prompts
Call overdue Xero customers with an AI collections agentLocal listing health board for every location you manageWin back LiveChat visitors whose chats went unansweredLet support send one-off Loops emails without an engineerStop cold emails to anyone with a live deal in PipedriveiMessage campaign console with pre-flight checks and delivery boardChat quality review board for LiveChat support leadsLinkedIn Ads budget pacing dashboard for every client accountFront desk appointment confirmation board for the next 3 daysGive your team Looker numbers without buying more seats