The API is definitely an option - we have a lot of customers using that as well as partners that have build solutions using the API. If you'd like to learn more about the APIs, I'd recommend you start in the developer center:
Analytics overview. There's also some tutorials available as well.
For the CSV export, I have created a simple macro that you install once in your toolbar in Excel and then each time you open one of the CSV exports you can just highlight each of the columns with durations and it immediately converts them to HH:MM:SS format - Happy to share if you are interested.
You mentioned messing with the dates, etc between the views - have you tried to do a saved view where you can set what you want the default timeframe, filters, etc to be when you open that saved view? For instance if you always want to export yesterday's data you could create a saved view with that as the default timeframe and then click the download for the export. You can have as many different saved views as you want depending on what filters, timeframes you'd like.
In 2019, we also plan to work on scheduling so that these exports can be scheduled and available within your inbox as well as providing a PDF version of the export for the views.
Hope that helps!
------------------------------
Darlene Oordt
Sr Director, Product Management
Genesys - Employees
------------------------------
Original Message:
Sent: 10-10-2018 20:00
From: Darryn Chang
Subject: Extract performance metrics
Hi, while i am aware that there are external parties that focus there business on collecting the metrics out of purecloud.
Has anyone completed this task by using the API and extracting it to a excel source or likewise tool?
If so do you have any advice into completing such tasks, i find it non user friendly to go back and forth between the Agent/Queue Performance views and exporting the data plus a waste of resources to be collecting this information.
Shame it cant extract like for like, fiddling around with formulas and formats to convert the times is annoying as well.
Any tips or ideas would be incredibly helpful
Cheers
------------------------------
Darryn Chang
Stuff Limited
New Zealand
2 Years Purecloud
------------------------------