With thanks to Andrew Sapienza and Zach Arnold
Stella Connect is software that connects customer feedback, QA, and coaching, giving CX leaders visibility into performance and driving improvement of frontline teams. You can integrate Stella Connect with Zendesk Support so feedback requests are triggered automatically once tickets are solved.
The Stella Connect star rating metric is stored in a custom field in Zendesk Support and therefore can be accessed from your Explore reports. Using that, you can create a standard calculated attribute that indicates whether the rating is positive or negative.
In this Explore recipe, you'll learn how to create a report that shows the percentage of positive and negative Stella Connect star ratings for each of your assignees.
This article contains the following sections:
What you'll need
Skill level: Beginner
Time required: 10 mins
- Zendesk Explore Professional or Enterprise
- Editor or Admin permissions (see Giving agents access to Explore)
- Ticket data in Zendesk Support
- The Stella Connect Zendesk app from the Zendesk Marketplace
- You must have Stella Connect data return enabled. To do this, reach out to your Stella CSM.
Creating the report
In this section, you'll build a table that shows the Stella Connect star rating as a percentage for each of your assignees.
To create the report
- In Explore, click the reports (
) icon.
- In the Reports library, click New report.
- On the Select a dataset page, click Support > Support - Tickets, then click Start report. The report builder opens.
- In the Metrics panel, click Add.
- From the list of metrics, search for and click Stella Connect: Star rating, then click Apply. Ensure the aggregator for this metric is set to COUNT.
- Next, create a standard calculated attribute that indicates whether the star rating is positive or negative. In the calculations menu.(
), click Standard calculated attribute.
-
On the Standard calculated attribute page, enter Stella Rating (Neg or Pos) as your attribute name, then enter or paste the following formula:
IF (VALUE(Stella Connect: Star Rating)<4) THEN "Negative" ELSE "Positive" ENDIF
Tip: If you're working in a language other than English, read this article to help you enter Explore formulas in your language. - When you are finished, click Save.
- In the Columns panel, click Add.
- From the list of attributes, choose Calculated attributes > Stella Rating (Neg or Pos) (the standard calculated attribute you just created), then click Apply.
- In the Rows panel, click Add.
- From the list of attributes, click Assignee > Assignee name, then click Apply.
- From the visualization type menu (
), choose Table. Your report will look something like the following screenshot:
Tip: If you have a high number of ticket assignees in your Zendesk Support instance, it could make this report unmanageable. If that's the case, consider adding a filter to reduce the number of assignees returned. In the example above, a filter based on the Ticket group attribute has been added. - You might notice in your table that some of the Stella Connect results are blank. This is because no results have been reported yet. You can remove these lines by using a metric filter. In the result manipulation menu (
), click Metric filter.
- On the Metric filter page, enable Remove blank values, then click Apply. Any lines that are blank for both Stella Connect values are removed.
Tip: You could also set the metric filter to only show lines with a minimum and maximum rating you choose. - Finally, you need to convert the positive and negative Stella Connect star ratings into percentages. In the result manipulation menu (
), click Result path calculation.
-
On the Result path calculation page, configure the following values:
- Pattern: % of total
- Path: On columns
When you are finished, click Apply.
Explore displays the finished table showing positive and negative Stella connect star ratings.
Read on for other ideas about how to present this report.
Next Steps
Now you've created your report, you can use other Explore features to improve the presentation. Here are some ideas:
- Hide columns you don't want. For example, if you only want to show positive results, you can hide the negative column. For help, see Working with tables.
-
Change the visualization. In this example, the Ticket group attribute is added to the Rows panel and the Pie visualization is selected. You'll now see the percentage of positive and negative Stella Connect star ratings for each group you choose.
- Do you want to show only the top ten results? Ot the bottom ten results? Create a top/bottom filter.
9 comments
Nick Estrada
Hi Rob,
How do I add the calculated Metrics Stella Connect: Star rating to the Calculated Metrics list?
I assume I have to create the formula but I don't know what that should be. Can you help?
1
Rob Stack
Hi Nicholas Estrada, thanks for pointing this out. The Stella Connect: Star rating is in fact a custom field, not a calculated metric. The best way to find it is to do a search in the add metric menu. I've updated the article to reflect this. Thanks again!
0
Nick Estrada
Thanks Rob,
Also, I believe the Stella Rating (Neg or Pos) formula needs to be updated. I added the formula
But I was receiving an error that "Stella Connect Star Rating" was an unfound metric. When I added a colon, ( : ) between Stella Connect and Star Rating the formula worked. Here is my formula:
1
Rob Stack
Hi Nicholas Estrada, thanks a bunch for spotting that. You're correct, and I've fixed that formula. We really appreciate your help. Thanks!
0
Danielle Zulueta
Hi Rob,
Is there a way to add the count of negatives and positives on top of the percentages? When I add the count of Stella Rating (Neg or Pos) it changes the percentages to count. Is there to view both?
0
Rob Stack
Hi Danielle Anne Zulueta, someone will correct me if I'm not correct, but I don't think you can do that in a single query. What you could do is create a second query using a count. You can then add both queries to a single dashboard to display them together. I'm not sure this would completely suit your needs, but I hope it helps. Thanks!
0
Rylee Calabro
Can you receive Stella ratings within the ticket in Zendesk?
0
Brett
The metric Stella Connect: Star rating is not coming up for me. I have tried contacting Stella support to make sure data return is enabled, and I've tried reinstalling Stella in Zendesk. My surveys are sending, and I can pull up tickets to QA on the Stella site. Do you have any tips for troubleshooting this?
1
Brett
Following up on my own question: I had reached out to Stella support before to make sure data return was enabled. I reached out again to clarify that I still did not have fields in Zendesk created by Stella, which is why I wasn't seeing the Metrics. Once I did this, they were able to create the fields for me, which solved my problem.
0