MCP tool: get_tickets_analytics_by_assignee

Fetch comprehensive assignee performance metrics and ticket analytics for a specified date range.

Example prompt

Get assignee performance analytics for the last month

Parameters

ParameterTypeRequiredDescription
dateRangeobjectYesInclusive date range to aggregate over
dateRange.startDatestringYesStart date in YYYY-MM-DD format
dateRange.endDatestringYesEnd date in YYYY-MM-DD format
includeArchivedTicketsbooleanNoInclude archived tickets (default: false)
includeTicketMetadatabooleanNoInclude minimal ticket metadata for drill-down (default: true)
teamIdsarrayNoOptional array of team IDs to filter by
metadataPagenumberNoPage number for metadata pagination (default: 1)
metadataLimitnumberNoLimit for metadata results per page (default: 25)

Response fields

The response will contain aggregated analytics data with the following structure:
FieldTypeDescription
aggregationTypestringType of aggregation performed (“assignee”)
totalTicketsnumberTotal number of tickets in the date range
totalFoundnumberTotal number of tickets found matching criteria
dateRangeobjectThe date range used for the analysis
includeArchivedTicketsbooleanWhether archived tickets were included
includeTicketMetadatabooleanWhether ticket metadata was included
aggregatedDataarrayArray of team-based analytics objects with assignee breakdowns

Team analytics object fields

Each team in the aggregatedData array contains:
FieldTypeDescription
teamIdstringTeam unique identifier
teamNamestringTeam name
totalnumberTotal number of tickets for this team
ticketCountnumberNumber of tickets for this team
assigneesobjectDetailed assignee breakdown with nested analytics
percentagenumberPercentage of total tickets

Assignee breakdown fields

Each assignee in the assignees object contains:
FieldTypeDescription
assigneeIdstringAssignee unique identifier
assigneeNamestringAssignee name
assigneeEmailstringAssignee email address
ticketCountnumberNumber of tickets assigned to this assignee
percentagenumberPercentage of team tickets
statusBreakdownobjectStatus breakdown for this assignee’s tickets
priorityBreakdownobjectPriority breakdown for this assignee’s tickets
sentimentBreakdownobjectSentiment breakdown for this assignee’s tickets

Status/Priority/Sentiment breakdown fields

Each status, priority, or sentiment in the breakdowns contains:
FieldTypeDescription
ticketCountnumberNumber of tickets with this status/priority/sentiment
percentagenumberPercentage of assignee’s tickets
statusId/priorityId/sentimentIdstringUnique identifier for the status/priority/sentiment

Sample response

{
  "aggregationType": "assignee",
  "totalTickets": 2,
  "totalFound": 2,
  "dateRange": {
    "startDate": "2025-01-01",
    "endDate": "2025-09-16"
  },
  "includeArchivedTickets": false,
  "includeTicketMetadata": false,
  "aggregatedData": [
    {
      "teamId": "THEVVHPCCER33E",
      "teamName": "Engineering",
      "total": 2,
      "ticketCount": 2,
      "assignees": {
        "John Doe": {
          "assigneeId": "UTHOOQNUUXZQQ3",
          "assigneeName": "John Doe",
          "assigneeEmail": "john.doe@thena.ai",
          "ticketCount": 2,
          "percentage": 100,
          "statusBreakdown": {
            "Open": {
              "ticketCount": 2,
              "percentage": 100,
              "statusId": "3SC6BH2K10X5BSCXF2MFWVYZVYNFX"
            }
          },
          "priorityBreakdown": {
            "Urgent": {
              "ticketCount": 1,
              "percentage": 50,
              "priorityId": "CSC6BH2K100SATQR0ZS6KHBW1DFPK"
            },
            "Medium": {
              "ticketCount": 1,
              "percentage": 50,
              "priorityId": "CSC6BH2K10XR2ZVVY84VV8506YN80"
            }
          },
          "sentimentBreakdown": {
            "Neutral": {
              "ticketCount": 1,
              "percentage": 50,
              "sentimentId": "MSC6BH2K1052GKT05M6QTFZVTPQ3S"
            },
            "Negative": {
              "ticketCount": 1,
              "percentage": 50,
              "sentimentId": "MSC6BH2K10CBVVTXD3Y6J5AC3X8R2"
            }
          }
        }
      },
      "percentage": 100
    }
  ]
}