Read time: 3 min 11 s
Versature’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 Versature's Google Sheets™ add-on you can open it anytime from a new sheet by clicking Add-ons in the top toolbar, then Versature 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.
average handle time
adjusted calls offered
average answer speed
average talk time
calls to voicemail
adjusted abandoned rate
adjusted abandoned calls
average hold time
Generate a sheet with live queue stats for all the queues in a company.
average wait time
max wait time
number of agents
When generating personal or company Call Detail Records (CDRs):
Our award-winning customer support team is here for you.Contact Support