Hi everyone,
Does anyone have a good way of capturing repeat caller numbers.
Eg over a date range there could be 1m calls.
Of those how many are unique callers, how many are repeat callers, for repeat callers how many times did they repeat.
For a single caller, I can use the Conversation Detail API and just do ANI equals customer number, and if hits =2 or more that is a repeat caller. But that doesn't help with very large data sets.
Exporting to Excel from Interaction Performance is also unwieldy when it is large datasets, as excel just can't handle the large data set at least not on the devices we have.
And sure I can try to reduce the data set by restricting queues and dates, but then to get a view over the month I have to do this multiple times and then still stitch it back together. And this is something we will need to report on regularly, so no one wants to get stuck slowly running through this.
Any ideas would be appreciated.