Read time: 3 min 34 s. Unsure of how pivot tables can be useful? Check out one of Versature's use cases!
Versature's Google Sheets™ add-on is a tool that allows you to download your call data into a spreadsheet quickly. Learn more about the different sheets you can create in the Versature Google Sheets™ Add-On - The Basics article.
Having all this data at your fingertips within minutes is excellent, approaching a giant data dump can be overwhelming and time-consuming to stifle through.
There are so many figures you can derive from the "Company CDR's" call data spreadsheet. Every business has different goals and uses for the information you can extrapolate from this report. To give you an idea of how to refine your Company's CDRs data-dump this article will show you how we, at Versature, use our add-on.
Pivot tables are one of the best tools to use when analysing spreadsheet data.
There are two main pivot tables we use daily to track productivity and client care.
1. Outbound calls + count + talk time
2. Inbound calls + count + talk time
When creating pivot tables, it's helpful to think of your pivot table through rows OR columns, but not both.
In this example, we are reading the tables through rows; even though it is the columns that are titled—the table's data is dependant on the users' extensions. Although the title categories are displayed as a row, i.e., "To User," you must read the data horizontally, through the column.
While the numbers don't necessarily tell the whole story, they can be monitored for trends and create concrete stepping stones for meaningful questions.
You must create separate inbound and outbound pivot tables when looking at users extensions.
Our pivot table will include outbound calls + count of start time + duration of the call.
Follow these instructions after you have generated a Company CDR sheet with a predetermined time period.
Rows = From User + Type Values = Start Time + Duration
After the data is defined you will see a nonformatted table that looks like the image below.
In the "To User" and "Type" columns, there are still data included from all users in the company. To refine your pivot table, you must use filters found in the pivot table editor.
Scroll down to the bottom of the pivot table editor and add a "From User" filter. Once added you can select the users you want to include in the table.
For this table we only want to see outbound calls, so we also add a "Type" filter.
Once that is done our table our reformatted table will look like:
Now our outbound call table is done, we'll repeat the same steps to create the inbound pivot table.
Use the same process for the Inbound Pivot Table as you did for the Outbound Pivot Table, only with "To User" for the row and filter so the table shows incoming calls to specified extensions.
Now both our pivot tables have been created; we can take it to the next level. Learn how to create an Impact Table with some basic formulas.
Our award-winning customer support team is here for you.Contact Support