1. 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.

We are working on an API instructor-led class with labs which will cover some of the analytics, so I'd like to hear which ones are the most important to you (so I can pass the info along to shape the class Objectives).

Hopefully some of the other folks who have done a lot with the API will pitch in. You might also think about posting in the forum on developer.mypurecloud.com, since they have their own community, as it were, for API developers.

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.

3. RE: Extract performance metrics

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.

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.

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.

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.

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.

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.

New Best Answer

About Genesys

Genesys® powers 25 billion of the world’s best customer experiences each year. Our success comes from connecting employee and customer conversations on any channel, every day. Over 10,000 companies in 100+ countries trust our #1 customer experience platform to drive great business outcomes and create lasting relationships. Combining the best of technology and human ingenuity, we build solutions that mirror natural communication and work the way you think. Our industry-leading solutions foster true omnichannel engagement, performing equally well across all channels, on-premise and in the cloud. Experience communication as it should be: fluid, instinctive and profoundly empowering.