SHARE



ABOUT THE AUTHOR


Kevin Kieller
Kevin Kieller is a partner with enableUC, a company that helps measure, monitor and improve UC and collaboration usage and...
Read Full Bio >>
SHARE



Kevin Kieller | March 30, 2018 |

 
   

Sophisticated Skype: Rate My Call

Sophisticated Skype: Rate My Call Helping organizations get the most from their Skype for Business deployments

Helping organizations get the most from their Skype for Business deployments

In a recent article I mentioned various methods to better understand user behavior and satisfaction. In this article, I teamed up with my business partner, and four-time Skype MVP, Dino Caputo to explore in detail the "Rate My Call" user feedback mechanism.

Rate My Call is a feature in the Skype for Business 2015 and 2016 clients on Windows that provides enterprises a way to gather direct feedback from their end users. The Rate My Call pop-up offers a "star" rating system from 1-5, which users can select to give feedback on call or video quality (really bad, poor, fair, good, excellent). In addition, administrators can enable a custom field to provide free form text feedback.

portable

Collected Rate My Call data is not currently included on any of the built-in Skype for Business monitoring reports; however, data is collected in SQL tables that can be accessed by running SQL queries if running Skype for Business Server on premises.

What Do I Need to Get Started?
Before users can access the Rate My Call functionality, the following set of components must be deployed and configured within your Skype for Business Server environment:

  • You must have Skype for Business Server installed (version 9160 or higher).
  • If possible, update the Skype for Business client to the latest version (however, version 15.0.4711.1002 or later is supported)
  • The user needs to be homed on a Skype for Business Server 2015 pool or homed in Skype for Business Online
  • You must have a Skype for Business Server monitoring database deployed and associated to your Skype for Business Server pools.
  • While not required, it is recommended you deploy Call Quality Dashboard (CQD) as there are built in reports you can access with respect to Rate My Call.
  • The user has to be granted a Client Policy, where the parameter RateMyCallDisplayPercentage is larger than 0

On your Skype for Business Server, open a Skype for Business Administrative Management Shell and run the following cmdlet:

Get-CsClientPolicy Global

This will return all the parameters for your Global Client Policy. Specifically look for the following two parameters:

RateMyCallDisplayPercentage : 10

RateMyCallAllowCustomUserFeedback : True

The above settings indicate that users will be prompted to rate their call 10% of the time and will also be allowed to enter custom feedback using free form text if they desire.

To change the percentage or the option for text you would use the following cmdlet:

Set-CSClientPolicy -Identity Global -RateMyCallDisplayPercentage 80 -
RateMyCallAllowCustomUserFeedback $true

(The above commands would cause users to be prompted for feedback 80% of the time and would also enable the free-form text box on the Rate My Call pop-up.)

Note you don't need to use the Global Policy if you only want a subset of users to utilize the Rate my Call feature. If you had another Client Policy, called Sales for example, you could change the parameters for that policy. Using these different policies allows you to canvas certain groups of users more aggressively, if for example you were rolling out a new office and wanted more feedback from these specific users.

How is the Data Sent?
A SIP Service request is generated after every Skype for Business client call. Within this Service request, there is a content-type application/ms-cqf+xml where the data is encoded in an XML blob.

How is the Data Stored?
The Rate My Call data is stored in the QoE Metrics database. Assuming you have the appropriate prerequisite update installed on your server, the QoE Metrics database will include three new tables that stores the feedback. These are:

  • dbo.CallQualityFeedback
  • dbo.CallQualityFeedbackToken
  • dbo.CallQualityFeedbackTokenDef

The CallQualityFeedback table has the rating and the feedback text. CallQualityFeedbackToken has the values for each issue. CallQualityFeedbackTokenDef has the definition of the issues.

dbo.CallQualityFeedbackTokenDef
The latest Token definitions are coded as follows:

portable

[QoeMetrics].[dbo].[CallQualityFeedback]
The [QoeMetrics].[dbo].[CallQualityFeedback] table contains the polling results from "Star" voting and customer feedback if enabled.

Responses from the data from tables can be by retrieved using a select * from [Table.Name] query or by using Microsoft SQL Server Management Studio.

Microsoft TechNet provides a complex and often repeated example of accessing users' feedback for audio calls using an SQL query as per below:

portable

And a second, overly-complex, example for retrieving video call feedback:

portable

The potential trouble with these queries is that they list all conference calls, via the SQL join to the Sessions table, and return multiple rows for each response and then fail to explain how to interpret the results.

Below is an example of the data when running the SQL Query above for audio calls:

portable

When trying to decode the output from this complex query, it is important to realize that rows with the same ConferenceDateTime and Caller sip address represent the same call. Further, zeroes in the TokenValue column represent checkboxes that were NOT selected. A one in the column represents checkboxes that were selected.

Simpler Is Often Better
Given the complexity often associated with technology, sometimes simple is better and more understandable. The following single line query retrieves the call ratings and any text comments that may have been entered:

SELECT * from CallQualityFeedback

A typical result set from the above query looks like this:

portable

A few observations:

  • If a user dismisses the Rate My Call pop-up window, by clicking the close button or the X in the upper right, a rating of zero is written to the database. It is important to exclude these zero values when you are calculating an average rating score.
  • The FeedbackText column will only contain values if you set the RateMyCallAllowCustomUserFeedback parameter to $true as described above.
  • If you want to determine who provided a particular response, the value in the FromURI column corresponds to the UserKey column in the User table.

Building on our simple query, we can count the number of each particular rating over a specified period of time as follows:

portable

Comparing the total number of non-zero values to the the number of zero values tells us the response rate; that is to say, how often users provide a response when presented with the Rate My Call pop-up.

The CallQualityFeedbackToken table has one row for each checkbox presented on the Rate My Call popup, with a value of 1 in the TokenValue column if a checkbox was selected. As such, we can tally the reasons for each rating as follows:

portable

Lastly, we can get a list of people who on average have provided low ratings using this query:

portable

Using Call Quality Dashboard (CQD) with Rate My Call
If you deployed the Microsoft Call Quality Dashboard (CQD) then you may access reports with respect to Rate My Call as follows:

portable

Once again, it is important to understand that users can dismiss the Rate My Call pop-up or simply click "Submit" without entering any details. Both have the adverse effect of scoring the call with a zero rating. In our experience, many users who hit submit do not understanding that this causes the score to be skewed. For example, below is the same, more accurate, report with any ratings of "0" removed:

portable

What You Do with the Results Is What Matters!
Rate My Call data provides insights into end user satisfaction and augments the quality and reliability of information provided through the standard Monitoring Server reports.

Understanding user perceptions can provide useful information to help guide communications and training programs and/or to identify specific technical issues.

For example, in a recent organization we worked with, background noise accounted for 20% of the reasons calls were rated "really bad" or "poor." This serves as an indication that a) users or presenters should be reminded how to mute themselves or other participants who are in noisy environments (e.g. airport, coffee shop, etc.), or b) specific audio devices may not be effectively applying noise cancellation (e.g. built-in laptop microphones, using earbuds plugged into the audio jack).

In our case, further data correlation indicated that both causes were contributing and a targeted communication initiative was undertaken. And of course, we will use future Rate My Call queries to investigate whether this initiative was effective in modifying user behavior and thus user satisfaction with Skype for Business.

My team and I help vendors and organizations predict and plan for the future then deliver exceptional results in the present. If you have specific questions please comment below, send me a tweet @kkieller or message me on LinkedIn.

Related content:





COMMENTS




October 24, 2018

With disparate workplaces and ever-expanding volumes of information to manage, the challenges for collaborating effectively are only intensifying. Many critical applications are not integrated, and

October 10, 2018

Businesses are growing across international borders quicker than ever, but scaling operations to follow suit can be a harder, longer process.

This webinar focuses on scaling your next-generat

September 26, 2018

Join Kevin Kieller, Microsoft UC&C expert, along with Ribbon Communications and Polycom, for an update on Microsoft Ignite, and a focus on critical things you need to know about your voice deployme

March 12, 2018
An effective E-911 implementation doesn't just happen; it takes a solid strategy. Tune in for tips from IT expert Irwin Lazar, of Nemertes Research.
March 9, 2018
IT consultant Steve Leaden lays out the whys and how-tos of getting the green light for your convergence strategy.
March 7, 2018
In advance of his speech tech tutorial at EC18, communications analyst Jon Arnold explores what voice means in a post-PBX world.
February 28, 2018
Voice engagement isn't about a simple phone call any longer, but rather a conversational experience that crosses from one channel to the next, as Daniel Hong, a VP and research director with Forrester....
February 16, 2018
What trends and technologies should you be up on for your contact center? Sheila McGee-Smith, Contact Center & Customer Experience track chair for Enterprise Connect 2018, gives us the lowdown.
February 9, 2018
Melanie Turek, VP of connected work research at Frost & Sullivan, walks us through key components -- and sticking points -- of customer-oriented digital transformation projects.
February 2, 2018
UC consultant Marty Parker has crunched lots of numbers evaluating UC options; tune in for what he's learned and tips for your own analysis.
January 26, 2018
Don't miss out on the fun! Organizer Alan Quayle shares details of his pre-Enterprise Connect hackathon, TADHack-mini '18, showcasing programmable communications.
December 20, 2017
Kevin Kieller, partner with enableUC, provides advice on how to move forward with your Skype for Business and Teams deployments.
December 20, 2017
Zeus Kerravala, principal analyst with ZK Research, shares his perspective on artificial intelligence and the future of team collaboration.
December 20, 2017
Delanda Coleman, Microsoft senior marketing manager, explains the Teams vision and shares use case examples.
November 30, 2017
With a ruling on the FCC's proposed order to dismantle the Open Internet Order expected this month, communications technology attorney Martha Buyer walks us through what's at stake.
October 23, 2017
Wondering which Office 365 collaboration tool to use when? Get quick pointers from CBT Nuggets instructor Simona Millham.
September 22, 2017
In this podcast, we explore the future of work with Robert Brown, AVP of the Cognizant Center for the Future of Work, who helps us answer the question, "What do we do when machines do everything?"
September 8, 2017
Greg Collins, a technology analyst and strategist with Exact Ventures, delivers a status report on 5G implementation plans and tells enterprises why they shouldn't wait to move ahead on potential use ....
August 25, 2017
Find out what business considerations are driving the SIP trunking market today, and learn a bit about how satisfied enterprises are with their providers. We talk with John Malone, president of The Ea....
August 16, 2017
World Vision U.S. is finding lots of goodness in RingCentral's cloud communications service, but as Randy Boyd, infrastructure architect at the global humanitarian nonprofit, tells us, he and his team....
August 11, 2017
Alicia Gee, director of unified communications at Sutter Physician Services, oversees the technical team supporting a 1,000-agent contact center running on Genesys PureConnect. She catches us up on th....
August 4, 2017
Andrew Prokop, communications evangelist with Arrow Systems Integration, has lately been working on integrating enterprise communications into Internet of Things ecosystems. He shares examples and off....
July 27, 2017
Industry watcher Elka Popova, a Frost & Sullivan program director, shares her perspective on this acquisition, discussing Mitel's market positioning, why the move makes sense, and more.
July 14, 2017
Lantre Barr, founder and CEO of Blacc Spot Media, urges any enterprise that's been on the fence about integrating real-time communications into business workflows to jump off and get started. Tune and....
June 28, 2017
Communications expert Tsahi Levent-Levi, author of the popular BlogGeek.me blog, keeps a running tally and comprehensive overview of communications platform-as-a-service offerings in his "Choosing a W....
June 9, 2017
If you think telecom expense management applies to nothing more than business phone lines, think again. Hyoun Park, founder and principal investigator with technology advisory Amalgam Insights, tells ....
June 2, 2017
Enterprises strategizing on mobility today, including for internal collaboration, don't have the luxury of learning as they go. Tony Rizzo, enterprise mobility specialist with Blue Hill Research, expl....
May 24, 2017
Mark Winther, head of IDC's global telecom consulting practice, gives us his take on how CPaaS providers evolve beyond the basic building blocks and address maturing enterprise needs.
May 18, 2017
Diane Myers, senior research director at IHS Markit, walks us through her 2017 UC-as-a-service report... and shares what might be to come in 2018.
April 28, 2017
Change isn't easy, but it is necessary. Tune in for advice and perspective from Zeus Kerravala, co-author of a "Digital Transformation for Dummies" special edition.
April 20, 2017
Robin Gareiss, president of Nemertes Research, shares insight gleaned from the firm's 12th annual UCC Total Cost of Operations study.
March 23, 2017
Tim Banting, of Current Analysis, gives us a peek into what the next three years will bring in advance of his Enterprise Connect session exploring the question: Will there be a new model for enterpris....
March 15, 2017
Andrew Prokop, communications evangelist with Arrow Systems Integration, discusses the evolving role of the all-important session border controller.
March 9, 2017
Organizer Alan Quayle gives us the lowdown on programmable communications and all you need to know about participating in this pre-Enterprise Connect hackathon.
March 3, 2017
From protecting against new vulnerabilities to keeping security assessments up to date, security consultant Mark Collier shares tips on how best to protect your UC systems.
February 24, 2017
UC analyst Blair Pleasant sorts through the myriad cloud architectural models underlying UCaaS and CCaaS offerings, and explains why knowing the differences matter.
February 17, 2017
From the most basics of basics to the hidden gotchas, UC consultant Melissa Swartz helps demystify the complex world of SIP trunking.
February 7, 2017
UC&C consultant Kevin Kieller, a partner at enableUC, shares pointers for making the right architectural choices for your Skype for Business deployment.
February 1, 2017
Elka Popova, a Frost & Sullivan program director, shares a status report on the UCaaS market today and offers her perspective on what large enterprises need before committing to UC in the cloud.
January 26, 2017
Andrew Davis, co-founder of Wainhouse Research and chair of the Video track at Enterprise Connect 2017, sorts through the myriad cloud video service options and shares how to tell if your choice is en....
January 23, 2017
Sheila McGee-Smith, Contact Center/Customer Experience track chair for Enterprise Connect 2017, tells us what we need to know about the role cloud software is playing in contact centers today.