Skip to main content

​
MCP tool: get_tickets_analytics_by_standard_fields

Get aggregated ticket analytics data grouped by multiple standard fields for a specific date range and team.

​
Example prompt

Get ticket analytics by assignee and status 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
teamIdsstringNoTeam ID to filter by (optional)
selectedFieldsstringYesComma-separated list of standard fields to aggregate by (e.g., assignee,status,priority,sentiment)
includeArchivedTicketsbooleanNoInclude archived tickets (default: false)
includeTicketMetadatabooleanNoInclude minimal ticket metadata for drill-down (default: false)
metadataPagenumberNoPage number for metadata pagination (1-based, only used when includeTicketMetadata is true)
metadataLimitnumberNoLimit for metadata results per page (max 500, only used when includeTicketMetadata is true)

​
Available standard fields

The following standard fields can be used in the selectedFields parameter:
  • assignee - Ticket assignee
  • status - Ticket status
  • priority - Ticket priority
  • sentiment - Ticket sentiment
  • type - Ticket type
  • team - Team information
  • account - Account information

​
Response fields

The response will contain aggregated analytics data with the following structure:
FieldTypeDescription
aggregationTypestringType of aggregation performed (“multi_field”)
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 field aggregations

​
Team analytics object fields

Each team in the aggregatedData array contains:
FieldTypeDescription
teamIdstringTeam unique identifier
teamNamestringTeam name
totalTicketsnumberTotal number of tickets for this team
percentagenumberPercentage of total tickets
fieldAggregationsobjectIndividual field aggregations with counts and percentages
crossTabulationobjectCross-tabulation analysis between selected fields

​
Field aggregation fields

Each field in the fieldAggregations object contains an array of field values:
FieldTypeDescription
fieldNamestringName of the field value (e.g., “Open”, “John Doe”)
fieldUidstringUnique identifier for the field value
ticketCountnumberNumber of tickets with this field value
percentagenumberPercentage of total tickets

​
Cross-tabulation fields

The crossTabulation object contains combinations of fields (e.g., “status_assignee”):
FieldTypeDescription
primaryFieldNamestringName of the primary field value
primaryFieldUidstringUnique identifier for the primary field value
secondaryFieldBreakdownobjectBreakdown by secondary field with counts and percentages

​
Sample response

{
  "aggregationType": "multi_field",
  "totalTickets": 2,
  "totalFound": 2,
  "dateRange": {
    "startDate": "2025-01-01",
    "endDate": "2025-09-16"
  },
  "includeArchivedTickets": false,
  "includeTicketMetadata": false,
  "aggregatedData": [
    {
      "teamId": "THEVVHPCCER33E",
      "teamName": "Engineering",
      "totalTickets": 2,
      "percentage": 100,
      "fieldAggregations": {
        "status": [
          {
            "statusName": "Open",
            "statusUid": "3SC6BH2K10X5BSCXF2MFWVYZVYNFX",
            "ticketCount": 2,
            "percentage": 100
          }
        ],
        "assignee": [
          {
            "assigneeName": "John Doe",
            "assigneeUid": "UTHOOQNUUXZQQ3",
            "ticketCount": 2,
            "percentage": 100
          }
        ]
      },
      "crossTabulation": {
        "status_assignee": [
          {
            "statusName": "Open",
            "statusUid": "3SC6BH2K10X5BSCXF2MFWVYZVYNFX",
            "assigneeBreakdown": {
              "John Doe": {
                "ticketCount": 2,
                "percentage": 100,
                "assigneeId": "UTHOOQNUUXZQQ3"
              }
            }
          }
        ]
      }
    }
  ]
}