1. Home
  2. CUCM CDR Reporting & Analytics
  3. Variphy CUCM CDR Call Analytics Reporting Guide
Searching...

Variphy CUCM CDR Call Analytics Reporting Guide

Introduction

Variphy’s Call Analytics Reporting isn’t based on anything “Canned” that arrives out of the box. Because every Cisco Collaboration environment can be a bit different, Variphy’s CUCM CDR Call Analytics Reporting is completely customizable, allowing reports to be configured for particular dial plans and deployments, along with the desired output content.

Because different user audiences require different data, reports generated by Variphy’s Call Analytics Reporting can be tailored to produce just simple/high level information (such as Summary metrics only), as well as very granular details (e.g. info for each CDR along with full Cradle to Grave Sequencing).

Basic Report Concepts

Each Variphy Call Analytics Report configuration is based upon what CDR/CUCM data the report is based upon (the “Input”) and what resulting content is computed and displayed (the “Output”).

A Report configuration is not tied to a particular Search Time Window or Document Output Format (PDF, XLSX, HTML, CSV).  This means that the same Variphy Call Analytics Report can be used to create reports for different Document Output Formats and/or different periods of time.

When generating a reports in Variphy, the Search Time Window (such as “Yesterday” or “May 1 – May 4, 2020”) and Document Output Format is also chosen, which together are all used to produce the desired output.

Search Sets & Criteria (“Input”)

Each report is based on an “original” set of Call Detail Records (CDRs) that identify the desired call activity, such as:

  1. Where 911 was called
  2. To or from all end users in the Human Resources department
  3. To the Hunt Group with directory number 4400
  4. Originating from end users jsmith or tjackson

Each report must contain at least 1 Search Set, which in turn, must contain at least 1 Search Criteria.  A single Search Set (with 1 or multiple Criteria) is often all that is needed, but in some cases, multiple Search Sets may be required to pinpoint a very specific set of call activity.  

The Search Sets tab contains the report’s configuration for Search Set Criteria. For each of the examples above , the Search Sets might look like:

Where 911 was called

To or from all end users in the Finance department

To the Hunt Group/Pilot 4000

Originating from end users jsmith or tjackson

Summary, Statistics, and Detail Content (“Output”)

All of the possible content that a report contains is based upon the Search Set & Criteria Input and can be enabled (and configured) or disabled according to the type of report you’re looking to generate.

Variphy’s Call Analytics History Report content output is comprised of the following possible sections. If all are enabled/applicable, they will appear in this order in the report output:

Variphy comes bundled with a default system logo, which is the Variphy Logo.

It can be replaced/updated by Administrator users in Variphy via the Logos option in the System section of Setup & Administration.

The Application System logo will be shown in the upper right of every page in the report for image supported document types (PDF).

With the aspect ratio preserved, the width of the System Logo in the report will be decreased to 120 pixels automatically.

If configured, the corresponding Logo for the corresponding Cluster will be included in the upper left of the report for image supported document types (PDF). Cluster Logos can be specified/updated by Administrator users in Variphy via the Logos option in the System section of Setup & Administration.

With the aspect ratio preserved, the width of the Cluster Logo in the report will be decreased to 120 pixels automatically.

Report Title

The report’s name (as configured in Variphy) will be used for the title in the output. The name can be configured in Variphy when adding or editing any report and can contain up to 255 characters.

The report name/title can be updated in the Name field in the Basics tab.

To exclude the title from a report, simply uncheck the Show Title option in a report’s configuration.

Header & Summary

If enabled, the Summary in a report’s output can contain any/all of the following. The entire Summary can be enabled or disabled by toggling the Show Header Summary option.

  • Description – The description as configured for the report, which can contain up to 500 characters. To enable or disable this from the Summary, toggle the Show Description option.
  • Date/Time Range – The Date/Time Window for which the report was generated for. If the Show Header Summary field is enabled, this will be shown automatically.
  • Enterprise – The name of the Enterprise, as configured in Variphy, to which the Cluster (which the report was generated for) is assigned to. To enable or disable this from the Summary, toggle the Show Enterprise option.
  • Cluster – The name of the Cluster in Variphy which the report was generated for. To enable or disable this from the Summary, toggle the Show Cluster option.
  • Generated By – The username of the User which generated the report in Variphy. To enable or disable this from the Summary, toggle the Show Generating User option.
  • User Restrictions – This will display if the report was generated by a user with data visibility restrictions (where the user is not configured with the ability to see all CDR data for the Cluster), by showing “(Limited)” next to the Cluster name. To enable or disable this from the Summary, toggle the Show User Restrictions option.

Table of Contents

The Table of Contents section contains content hyperlinks to navigate to a particular section in the report.  

To enable or disable the Table of Contents from appearing in the report, toggle the Show Table of Contents option in the Header & Summary section on the Basics tab.

Search Criteria Summary

The Search Criteria Summary section will display 1 or more selected statistics per Search Set/Criteria as well as total cumulative values (if the report contains multiple Search Sets).

To enable or disable the Search Criteria Summary, toggle the Show Search Set Summary Table option within the Search Set Statistics tab.

If the Search Criteria Summary is shown, enable or disable the Search Set’s Name or Criteria from appearing by toggling the Show Search Set Name and Show Search Set Criteria options respectively.

For each Search Set/Criteria, Variphy’s Call Analytics Reporting offers an extensive set of Call Statistic options to choose from, such as:

Grouping Statistics Summary & Analytics

Groupings are a very powerful and important concept and feature in Variphy’s Call Analytics Reporting. When analyzing and reporting/displaying on a set of call activity, it’s often very helpful to organize or “group” data into groupings such as per End User, Department, Device Pool, Phone or Device, Directory Number, Cause Code, or one of many other options.

Grouping Type

To enable Groupings, toggle the Data Grouping Enabled field to on (green).

Then, in the Primary Grouping Type field, select the desired Grouping Type. There are many grouping options, many of which are directional, such as “Originating, Dialed, or Terminating CUCM End User ID”, which will identify which CUCM End Users were involved in each call (per the search set/criteria results), based upon the originating user, user who was dialed, and terminating user (he/she who ultimately received/answered the call).

Depending on the Grouping Type, the option for Include Grouping for Unassociated may appear. If enabled, this option will also include an additional grouping for CDRs for which there is no associated Grouping value, such as CDRs for which there is no Originating or Terminating CUCM End User.

If an End User Grouping Type is selected the Display End User As field will provide options for how each End User should be displayed, such as “Last Name, First Name (Username)” or “First Name Last Name”.

The Sort Groupings By field controls how Groupings should be sorted, such as by Name/Label or Total Call Count (Highest to Lowest).

Grouping Filtering

In the Grouping Filtering section there are additional options (all of which are optional) to filter out Groupings based upon the Total Call Count.

If specified between 1 and 50, the Maximum Primary Grouping Count (Top/Bottom N) field will ensure that only the 1st N Groupings will appear, according to the Sort Groupings By field.

If specified, the Minimum Primary Total Call Count and Maximum Total Call Count fields can also provide filtering to only include Groupings where a certain Total Call Count (or range) is met, such as where the Grouping was involved in 1000 calls or more or 0.

Grouping Source Configuration

In the Grouping Source Configuration settings there are additional options to filter the grouped data.

Call History Data – All of the output in the grouping section of the report will be provided based on the data in the CDR returned from the reports search set. For example: If my report search set is built searching Originating or Terminating Department = SALES and I am grouping on Originating or Terminating End User. In the grouping section of the report you will see all end users that called the sales department (Originating End users), regardless of what department they reside in, and I will see all end users that received a call from the sales department (Terminating End users), regardless of what department they reside in.

Search Set Criteria – All of the output in the grouping section of the report will be provided based what your search set criteria is. For example: If my report search set is built searching Originating or Terminating Department = SALES and I am grouping on Originating or Terminating End User. In the grouping section of the report you will only see user in the sales department that placed a call (Originating End users) and only users in the sales department that received a call (Terminating End users). This would restrict the grouped users to only sales department users.

Grouping Search Sets – Grouping search sets allows you to restrict the grouping results to a new search set that will search within the CDR’s output but the man report search set. For example: If my report search set is built searching Originating or Terminating Department = SALES and I have a Grouping Search Set configured for Originating or Terminating End User = Bruce Wayne. My grouping results will only include calls to or from Bruce Wayne.

Grouping Summary

For example, the output below shows a Grouping Summary for call history that is grouped by Calling, Original Called, or Final Called Party Number, and statistics for each. Variphy offers a multitude of Grouping options.

The Grouping Summary section will display 1 or more selected statistics per Grouping as well as total cumulative values (if the report contains multiple Groupings).

To enable to disable, toggle the Show Grouping Summary option within the Grouping Statistics tab. If enabled, select the desired statistics to show per Grouping, such as:

If the Grouping Summary is enabled, the Show Grouping Summary Header field controls whether a simple section header with text showing the Grouping Type appears above the Grouping Summary table.

The example output above can be produced with the following configuration in the Grouping Statistics tab:

Grouping Statistics & Scenarios

In addition to the Grouping Statistics Summary above, Variphy can also include time period based analytics for each grouping in reports, such as:

  • Total call count per Quarter Hour (9:00am – 9:15am, 9:15am – 9:30am, etc)
  • Total call count per Half Hour (9:00am – 9:30am, 9:30am – 10am, etc)
  • Total call count per Hour (9am, 10am, etc.)
  • Total call count per Day of Week (Monday, Tuesday, etc)
  • Total call count per Date Of Year (e.g. Feb 10 vs Feb 11, etc)

The Grouping Statistics & Scenarios section in the Grouping Statistics tab contains statistic options for time-based tables and charts that can be computed per Grouping (e.g. per Device, End User, Department, Directory Number, etc.).

Show Primary Grouping Call Statistic Data Tables

Read more about call statistics in the Variphy CUCM CDR Call Analytics Call Statistics Guide & Dictionary.

For a Grouping Type of Calling Party, Original, or Final Called Party Number, the above configuration would show the following output for Primary Grouping Call Statistic Data Tables, showing the Total Call Count and Abandoned Call % for each party number grouping per Hour of Day.

In this example, the report was run for 9:00am to 5:59pm only.

Show Primary Grouping Call Scenario Volume Tables

This represents an analytical “summary” of the call volume for each Grouping, computed for each the selected Call Scenario Types and desired Time Unit Type (e.g.  Hour Day vs Day of Week), producing tables showing metrics such as the low, high, and average call count/volume per Call Scenario.

Variphy offers many Call Scenarios to choose from.  Read more about call scenarios in the Variphy CUCM CDR Call Analytics Call Scenario Guide & Dictionary. Keep in mind that many Call Scenarios can often apply to a single call/CDR .

For the above configuration, the following example report output shows 4 Call Scenarios (Total Calls, Abandoned Calls, Answered Calls, and Long Duration Calls) per Hour of Day for each Directory Number (Calling Party, Original, or Final Called Party Number Grouping).

For Directory Number 2110, this example Call Scenario Volume Table shows:

  • A total of 151 calls were made, dialed, and received by this DN
  • Between the hours of 9am to 5pm (which the report was run for), the average per hour was 16.78 calls
  • Per Hour of the Day, the average abandoned call rate for 15.63%
  • Overall (across all 151 total calls), 92.72% were Answered

Show Primary Grouping Call Scenario Volume Charts (PDF Only)

Read more about call scenarios in the Variphy CUCM CDR Call Analytics Call Scenario Guide & Dictionary.

Total Call Scenario Volume Tables

This represents an analytical “summary” of the call volume for each of the selected Call Scenario Types, computed for each desired Time Unit Type (e.g.  Hour Day vs Day of Week, producing tables showing metrics such as the low, high, and average call count/volume per Call Scenario, computed for each Time Unit Type.

The following example report output shows 3 Call Scenarios (Total Calls, Answered Calls, and Voice Mail Calls) for the Time Unit Type of Hour of Day as well as Day Of Week, which was based on a specific set of 141,872 calls – resulting from its Search Set Criteria.

  • 95.06% (134,861 of the 141,872 Total Calls) were Answered
  • 0.04% (60 of the 141,872 Total Calls) went to and were connected to Voice Mail
  • Per Hour of the Day, the average # of calls was 5,911.33 with 57.96% Answered and 0.02% going to Voice Mail
  • The Low # of Total Calls per Hour was 0 and High was 19,543

The example output above can be produced with the following configuration in the “Total Call Scenario Volume Tables” section of the “Call Analytics” tab:

Total Call Statistic Data Tables

This represents an analytical breakdown of key statistics, computed for each desired Time Unit Type (e.g.  Hour Day vs Day of Week).

The following example report output shows 3 Call Statistics (Total Call Count, Answered Call %, and Voice Mail Call %) for the Time Unit Type of Hour of Day as well as Day Of Week, which was based on a specific set of 141,872 calls – resulting from its Search Set Criteria.


  • 95.16% of 15,199 Total Calls were Answered between 12:00:00 PM and 12:59:59 PM PDT
  • 0 Calls took place between 7:00:00 PM and 7:59:59 PM PDT as well as 9:00:00 PM and 11:59:59 PM PDT
  • An Hourly high of 0.07% of 15,199 Total Calls were Voice Mail Calls between 12:00:00 PM and 12:59:59 PM PDT
  • A Day of Week high of 32,613 Total Calls took place on Friday as compared to other days of the week

The example output above can be produced with the following configuration in the “Total Call Statistic Data Tables” section of the “Call Analytics” tab:

Total Call Scenario Volume Charts

Similar to the Total Call Scenario Volume Tables, this represents an analytical “summary” of the call volume for each of the selected Call Scenario Types, computed for each desired Time Unit Type (e.g.  Hour Day vs Day of Week), but in vertical bar chart format.

The following example report output shows 3 Call Scenarios (Total Calls, Answered Calls, and Voice Mail Calls) for the Time Unit Type of Hour of Day as well as Day Of Week, which was based on a specific set of 141,872 calls – resulting from its Search Set Criteria.

The example charts above can be produced with the following configuration in the “Total Call Scenario Volume Charts” section of the “Call Analytics” tab, which will only appear when the report is generated in PDF format:

Analytics Call Scenario Settings

Call Scenario settings can be configured for the specific report to identify what constitutes and “Long” vs “Short” Duration call. Default values are 3600 seconds (1 hour) for “Long” and 10 seconds for “Short” Duration calls, respectively.

Using the values as shown below, any Connected call which lasts for at least 3600 seconds will be considered a Long Duration call while any those which only lasted for 10 seconds or less are considered a Short Duration call.  

Concurrent Call Activity

Variphy can compute the Concurrent Call Activity, meaning the number of concurrent calls taking place, for each second in time (within the Search Time Window used when generating a report) for the calls identified by the report’s Search Set Criteria. This flexible approach ensures reports can measure and show Concurrent Call Activity for any set of calls whether company/cluster wide or a very granular data set, such as calls over a WAN connection or to a helpdesk or hunt group.

Concurrent Call Activity Summary

The summary provides a brief summary of the Concurrent Call Activity, showing:

  1. the peak number of concurrent calls (15)
  2. the number of seconds in which the peak number of concurrent calls took place (5 seconds)
  3. the average number of concurrent calls over the entire Search Time Window (Previous Week in this example)

Concurrent Call Activity Chart

This content option illustrates the Concurrent Call Activity per date (June 10, 2018 vs June 11, 2018, etc) per time of day.  As the following example output shows, the peak # of concurrent calls was 15, just after 2:00 PM PDT on June 12, 2018.

Each date will be charted with a different color (green in this example for June 12, 2018).  

Because showing too many colors/lines on the same chart can make it difficult to read, Concurrent Call Activity Charts will show a maximum of 7 days per chart.  When the Search Time Window includes more than 7 days, multiple charts will be used.

Concurrent Call Activity Table

The Concurrent Call Activity Table reveals the total time duration and percentage of time (for the Search Time Window – “Previous Week” in this example) for which the specific number of concurrent calls were taking place. The example output below shows that there were 15 concurrent calls for a total of 5 seconds (00:00:05). The Time Window Percentage column on the right shows the 5 secs is ~ 0.0% of the total Search Time Window (Previous Week).

The example output above can be produced with the following configuration in the “Concurrent Call Activity” section towards the bottom of the “Call Analytics” tab:

Search Result Details

If enabled, the Search Result Details section will contain Call Detail data for the original Search Results, in a tabular format.  

To enable or disable, toggle the Show Call History Record Details option with the Call History Details tab.

If enabled, select at least 1 or multiple options from a variety of History Detail Columns, including:

  • Date/Time Origination
  • Ring Time
  • Calling Party Number
  • Originating CUCM End User ID
  • Final Called Party Number
  • Terminating Device Name
  • Terminating CUCM Device Description
  • Call Duration

Toggle the Show Call History Record Details Header option to enable or disable the “Call Details” section header in the report.

The example output above can be produced with the following configuration in the Call History Details tab:

Cradle to Grave Sequence Details

A single call is often just 1 of many in a sequence of “related” calls, such as when a call is answered and then forwarded to another recipient. The chronological order of calls is commonly referred to as the “Cradle to Grave” sequence, which shows the complete order from 1st to last.

If enabled, the Cradle to Grave Sequence Details section shows the full sequence of call legs that each original Search Result is involved in, where there are multiple call legs present (more than 1 call leg in the sequence).  Variphy finds related calls using Global Call, Originating Call Leg, and/or Terminating Call Leg IDs for every CDR record.

The example output above can be produced with the following configuration in the Cradle to Grave tab:

Additional Settings

Variphy offers full customization for how Dates and Times appear in reports, configurable via the “General Settings” tab.  

Date Format

Choose the preferred Date Format, ranging from popular U.S. and international options.

Time Format

Choose the preferred Time Format, ranging from popular U.S. and international options.

Updated on April 17, 2023
Tagged:

Was this article helpful?

Yes No

About The Author

Variphy

Our mission, since 2004, has been to help simplify the use and management of Unified Communications and Collaboration products through quality software and service delivery.

Related Articles