matthew | 2016-10-20 22:36:42 UTC | #1
Hi, I'm doing a simple aggregate query using the /api/v2/analytics/conversations/aggregates/query
and grouping by Outboundcontactid
I'm getting several metrics coming back Tacw, Noutboundconnected etc. but the Noutboundattempted metric never seems to be returned. I would expect the Noutboundattempted to be at least equal to the Noutboundconnected ?
Is there a reason for this?
Matthew
tim.smith | 2016-10-26 14:56:46 UTC | #2
Generally, if a metric isn't returned, it's because there isn't a value for it for the interval. That doesn't seem right if you're getting a value for nOutboundConnected though. Could you post the body of your query?
matthew | 2016-10-26 18:58:04 UTC | #3
Here's my query ;
{
"interval": "2016-07-31T00:00:00/2016-08-30T00:00:00",
"groupBy": [
"outboundContactId"
],
"flattenMultivaluedDimensions": false
}
the results are similar to
{
"results": [
{
"group": {
"mediaType": "voice",
"outboundContactId": "326a244e19aee520257744b96fc44181"
},
"data": [
{
"interval": "2016-07-31T00:00:00.000Z/2016-08-30T00:00:00.000Z",
"metrics": [
{
"metric": "tHandle",
"stats": {
"max": 2013,
"count": 3,
"sum": 5454
}
},
{
"metric": "tAcw",
"stats": {
"max": 0,
"count": 4,
"sum": 0
}
},
{
"metric": "nOutboundConnected",
"stats": {
"count": 3
}
},
{
"metric": "tTalkComplete",
"stats": {
"max": 2013,
"count": 3,
"sum": 5454
}
},
{
"metric": "tTalk",
"stats": {
"max": 2013,
"count": 3,
"sum": 5454
}
}
]
}
]
},
{
"group": {
"mediaType": "voice",
"outboundContactId": "668b646d5c093d3eed8e153fedd99a94"
}
}
]
}
This repeats for all the contacts, but the nOutboundAttempted is never listed.
matthew | 2016-11-08 22:33:08 UTC | #4
hi tim - did you get chance to test that example query? can you see the outbound attempted metrics?
tim.smith | 2016-11-08 22:58:27 UTC | #5
Sorry, this one slipped through the cracks. I discussed with the analytics team and they don't think it's correct that you're missing the nOutboundAttempted stat either. There is a situation where that stat may not be returned, which is when no calls were initiated in the specified interval but some were handled/ended in that interval. Given that your interval is a month long, this isn't the case for your query.
Would you mind opening a ticket with PureCloud Support for this missing metric? They can assist in digging deeper to see why analytics isn't returning a value.
system | 2017-08-28 19:28:06 UTC | #6
This post was migrated from the old Developer Forum.
ref: 528