To help you get the most from Explore, we've put together a selection of recipes that help you set up queries and dashboards for many common business scenarios. Feel free to modify these to suit your own business needs. For some of our favorite recipes, see Explore recipe showcase.
Tip: To get notified when we release new recipes, click the Follow button at the top of this article. When we release a new recipe, we'll post a note in the comments section below, and you'll get an email.
The recipes are sorted into the following categories:
 Zendesk Support
|
Getting started
Time tracking and efficiency
Time and date calculations
Customer satisfaction
Users, groups, and organizations
Apps and integrations
Zendesk Chat
|
Zendesk Messaging
|
Zendesk Guide
|
Zendesk Talk
|
Custom metrics and attributes
|
Explore Enterprise
|
Miscellaneous
|
 From the community
|
The recipes in this section have been created by you, our incredible Zendesk community. We love to see what you're doing with Explore and we'll feature the best recipes, tricks, and tips here. Post your best ideas in our community.
111 Comments
Hi all, we've got a great new recipe for you today. This one will help you generate a detailed analysis that shows information about what customers are asking Answer Bot and which articles are being recommended.
Analyzing the last 100 Answer Bot tickets
Hi!
New to explore and really need a way to show total number of tickets by week for last 90 days that have not been updated by assignee for >30 days. Really struggling how to make this happen in explore. Thanks!
Backlog Tickets By Month : the link is broken https://explore.zendesk.com/hc/en-us/articles/360034489753-Explore-recipe-Backlog-tickets-by-month
We've just added a new recipe in which you'll learn how to create an Explore query that will report on the number of tickets your agents are being assigned each day - Ticket assigns per day
Hi everyone! We've done a redesign of this recipes reference page to make it easier to search for what you need. Additionally, we've also added a community section to the list where we'll feature the best Explore recipes and tips we receive. Feel free to post your own tips at User Tips & Tricks. We love to see what you do with Explore!
Hey everyone, we've just added a great new recipe that lets you calculate the percentage change in ticket volume between two time periods and then break this down by the values in a custom field. As well as being a useful report in itself, it's also very easily customized to report on other metrics.
Time over time percentage change for a custom dropdown ticket field
Thank you for sharing this, Rob! I wasn't far off when I was playing around, so this is great validation!
Fiona
Happy to help! There are a lot of metrics and attributes to absorb when you start using Explore. Sometimes, just (and pardon the pun) exploring is a great way to learn :-)
Hi everyone, another new recipe to end the week!
This give you a query that shows solved ticket trends by assignee name.
Hi everyone, hope you are well!
For those of you using the Support Social Messaging add-on, we've just released a new recipe to help you create Explore reports based on tickets generated by the add-on. We hope you find this useful!
Monitoring your social media channels
Hi everyone, we've just added a new recipe that helps you breakdown calls from each of your Talk numbers and the tickets created by each call.
Reporting on calls received per Talk number
Hi everyone, another new recipe is out today. This one demonstrates a really clever way of using Explore's powerful string manipulations to get your ticket tags looking just how you want them.
Hi, I would like to see a metric that shows the chatzendesk status duration for an agent, which calcuates how many minutes/hours the agent "online" or "away" during a certain period. Does it exist?
Thank you
Hi all, we've just added a great new recipe. This one is a little different as it takes you through the entire process of creating queries, adding them to a dashboard, then creating dashboard filters and bookmarks. It's a great way to get used to this process.
Taking dashboard filters and bookmarks to the next level
Hi, another new recipe that enables you to report on the number of tickets solved by articles linked to the ticket using the Knowledge Capture app.
Count of tickets solved by linked articles by month
Hi all, it's been a good week for Explore recipes and we have another three for you:
Hi, another new recipe - Tickets created by agents or end-users
Use this recipe to create a query that shows the number of tickets being created by agents and end-users.
We used to have a Top Incident description stacked area chart in insights that would looks something like this. I dont see a way to select just the top "Incident Descriptions" by ticket count. Is there any way this can be done with Explore?
Hi everyone, we've released a new recipe to create an Explore query that shows the top problem tickets by number of unsolved incidents that are attached - Explore Recipe: Top problem tickets by unsolved incidents
Remember, if you'd like to keep up to date with new recipes as they are released, click the "Follow" button at the top of this article.
Hi all, happy Friday!
We've just added a great new recipe that uses the Ticket updates dataset to find the first agent a ticket was assigned to.
Explore recipe: Finding the first assignee for a ticket
Hi all, we've just added a new recipe that gives the number of interactions each of your agents had with tickets over a date range you specify.
Count of agent interactions with tickets
Hi everyone, we've got a great new recipe that helps you calculate the satisfaction score for your agents based on the good or bad ratings their tickets received:
Hi all. We've added a new recipe to help you track abandoned Talk calls over time.
Calculate the percentage of inbound abandoned calls within a time frame
Hi, another great recipe for you today. This is in response to a couple of you asking if you could display the current date in a dashboard. That's not built into Explore, but this recipe uses a clever attribute trick to let you do this.
Hi everyone, we've just added a new recipe for Talk:
Declined and missed calls by ticket ID and agent leg
We hope you find this helpful!
Hi @Rob
Thank you! There's a way to know how many time a ticket spent in a status?
i.e. How many time our tickets spent in hold or pending?
And in which tickets a trigger made changes?
Thank you in advance :)
Hi everyone. We've just added a new recipe that uses the bubble pack chart type to give you a great visual representation of where your chats are coming from - Identifying where chats originate
Hi all, we've just added a new recipe to help you use forecasting in Explore. The recipe is for ticket volumes, but can be repurposed to work with many different date-based reports - Forecasting ticket volumes by year
Hi everyone, we've added another new recipe today that counts the number of agent comments made on your tickets over a time period you specify.
Counting agent comment updates
Please sign in to leave a comment.