net2phone Canada’s Google Sheets™ add-on was created so you can get the most of your call data and better understand the numbers behind your success. After a simple download, you’re ready to start importing your personal call data or your company's call data. To learn how to download the integration and access your call data, check out our installation article.
After you have installed net2phone Canada's Google Sheets™ add-on you can open it anytime from a new sheet by clicking Add-ons in the top toolbar, then net2phone Canada for Sheets and Open.
Choose a pre-built report type, a date range, and then generate a new Google Sheet™.
There are two categories of sheets, with seven different types of sheets available in total.
CDRs are the backbone of all the report types you can generate with the Google Sheets™ Add-On. Call queue reports are provided for a faster way to drill down in a specific queue—rather than filter through your entire company records.
My CDRs - includes all the data from your personal call history. Any user scope can access their personal CDRs.
Company CDRs - includes all the data from the entire company's call history. These can only be accessed by users classified as an Office Manager.
With the exception of live queue stats, you must choose a time period for the data you want to view. Within the interval column, the report will automatically display the date but not the time. To change this to date and time:
Generate a sheet displaying inbound calls with the volume of calls dialled to a specific number within a predetermined period of time.
Generate a sheet displaying a call queue's volume within a predetermined period of time. This report can be generated for all queues or 1 specific queue at a time.
Generate a sheet with all the call queue statistics from a predetermined period of time.
Stats included | |
---|---|
abandoned rate |
average handle time |
dial transfers |
adjusted calls offered |
average answer speed |
calls handled |
service level |
call volume |
abandoned calls |
average talk time |
calls to voicemail |
adjusted abandoned rate |
calls offered |
adjusted abandoned calls |
average hold time |
calls forwarded |
Generate a sheet with live queue stats for all the queues in a company.
Stats included | |
---|---|
calls waiting |
unavailable agents |
average wait time |
max wait time |
available agents |
number of agents |
When generating personal or company Call Detail Records (CDRs):
Our award-winning customer support team is here for you.
Contact Support