Skip to main content

​
MCP tool: get_tickets_analytics_by_account

Get aggregated ticket analytics data grouped by account for a specific date range.

​
Example prompt

Get ticket analytics by account for the last 30 days

​
Parameters

ParameterTypeRequiredDescription
dateRangeobjectYesInclusive date range to aggregate over
dateRange.startDatestringYesStart date in YYYY-MM-DD format
dateRange.endDatestringYesEnd date in YYYY-MM-DD format
teamIdsarrayNoOptional array of team IDs to filter by
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 200, only used when includeTicketMetadata is true)

​
Response fields

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

​
Account analytics object fields

Each account in the aggregatedData array contains:
FieldTypeDescription
accountIdstringAccount unique identifier
accountNamestringAccount name
accountPrimaryDomainstringAccount primary domain
accountSourcestringAccount source
ticketCountnumberNumber of tickets for this account
teamBreakdownobjectBreakdown by team with detailed metrics

​
Team breakdown fields

Each team in the teamBreakdown object contains:
FieldTypeDescription
teamIdstringTeam unique identifier
teamNamestringTeam name
ticketCountnumberNumber of tickets for this team
percentagenumberPercentage of total tickets
statusBreakdownobjectBreakdown by ticket status with counts and percentages
priorityBreakdownobjectBreakdown by ticket priority with counts and percentages
assigneeBreakdownobjectBreakdown by assignee with counts and percentages

​
Sample response

{
  "aggregationType": "account",
  "totalTickets": 2,
  "totalFound": 2,
  "dateRange": {
    "startDate": "2025-01-01",
    "endDate": "2025-09-16"
  },
  "includeArchivedTickets": false,
  "includeTicketMetadata": false,
  "aggregatedData": [
    {
      "accountId": "CDN7BH2K1020181NADAYN2NJG6GSF",
      "accountName": "Acme Corp",
      "accountPrimaryDomain": "acme.com",
      "accountSource": "Website",
      "ticketCount": 2,
      "teamBreakdown": {
        "THEVVHPCCER33E": {
          "teamId": "THEVVHPCCER33E",
          "teamName": "Engineering",
          "ticketCount": 2,
          "statusBreakdown": {
            "Open": {
              "ticketCount": 2,
              "statusId": "3SC6BH2K10X5BSCXF2MFWVYZVYNFX",
              "percentage": 100
            }
          },
          "priorityBreakdown": {
            "Urgent": {
              "ticketCount": 1,
              "priorityId": "CSC6BH2K100SATQR0ZS6KHBW1DFPK",
              "percentage": 50
            },
            "Medium": {
              "ticketCount": 1,
              "priorityId": "CSC6BH2K10XR2ZVVY84VV8506YN80",
              "percentage": 50
            }
          },
          "assigneeBreakdown": {
            "John Doe": {
              "ticketCount": 2,
              "assigneeId": "UTHOOQNUUXZQQ3",
              "assigneeName": "John Doe",
              "percentage": 100
            }
          },
          "percentage": 100
        }
      }
    }
  ]
}