Grouping by externalTag not working in /api/v2/analytics/conversations/aggregates/query

[kristofferph]

Hi,

I’m encountering an issue when trying to group metrics by externalTag using the /api/v2/analytics/conversations/aggregates/query endpoint.

Request Details:

Here’s the request body I’m using:

{
  "interval": "2024-12-17T00:00:00.000Z/2024-12-17T23:59:59.999Z",
  "groupBy": [
    "queueId",
    "mediaType",
    "externalTag"
  ],
  "metrics": [
    "nOffered",
    "tAbandon",
    "tAnswered",
    "tConnected",
    "nConnected",
    "nTransferred",
    "tHandle",
    "tFlowOut",
    "tAcd",
    "tWait",
    "tHeldComplete",
    "tTalkComplete",
    "tAcw",
    "tIVR",
    "tTalk"
  ],
  "granularity": "PT1H"
}

What I’ve Done:

1. I used the PUT /api/v2/conversations/{conversationId}/tags endpoint to set the externalTag value on specific conversations:

2. 1. Some conversations have externalTag = "TEST GROUP 1"
3. 2. Others have externalTag = "TEST GROUP 2"

4. I verified via GET /api/v2/conversations/{conversationId} that the externalTag is correctly set on these conversations.

5. I ran the aggregate query for the correct interval covering the conversations.

The Problem:

When I execute the aggregate query, I don’t see any groups based on the externalTag. The response groups by mediaType and queueId, but the externalTag group is missing.

Any insights or tips would be greatly apprecited.