question

jacob-swanson avatar image
jacob-swanson asked alfm15395 answered

is it possible to export call log into excel allowing the log to be automatically updated?

I am wondering if you can use the queries and connections in excel to keep call logs updated in excel?

what i have found out so far:
- when you use the web link in the queries and connections; you get directed to the log in screen 
- if you export/download the data; it only give you call logs that exist and will not update. 

my intentions with call logs:
- export data on a weekly/monthly/yearly basis to predict hold times of contacts.
- use trends to know what times its most efficient to call contacts

is there a way to get through the login screen? what can i do to get automatically updating spread sheets? is this possible?


topic-default
1 |1000
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 8 attachments (including images) can be used with a maximum of 1.0 MiB each and 10.0 MiB total.

1 Answer

·
alfm15395 avatar image
alfm15395 answered
You can already setup an automated export of basic and detailed call logs. For example I have the systems set to email me each Monday with the last week's detailed call logs (includes duration and individual call steps around our company's call routing system).

To do this follow the below article:
https://success.ringcentral.co.uk/articles/RC_Knowledge_Article/Activity-Log-Overview

Depending on your email client you could script it to automatically save the attachment and use an Excel macro to combine the old log file with the new calls.
1 |1000
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 8 attachments (including images) can be used with a maximum of 1.0 MiB each and 10.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MiB each and 10.0 MiB total.