While Explore is great for reporting on your tickets, help center page views, calls, and chats, you can also use it to report about users and organizations associated with your account. The Support: Tickets dataset contains a lot of metrics and attributes you can use to report on users, organizations, and much more. See Metrics and attributes for Zendesk Support to learn more about what you can report on.
In this article, you can get started by creating the following two simple, but useful reports:
Displaying the number of users in each organization associated with your Zendesk account
To display organizations associated with your account
- 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.
- Next, add your metrics, the things you want to measure; in this case, the number of organizations associated with your account. In the Metrics panel, click Add.
- From the list of metrics, choose Users and organizations > Users, then click Apply. Explore displays the number of users in your account.
- Now, you'll slice this data to show the name of each organization. In the Rows panel, click Add.
- From the list of attributes, choose Ticket organization > Requester
organization name, then click Apply. Explore displays a list of
all of your organizations and the number of users in each. If there is a blank
line at the top of your table, this indicates users who are not assigned to an
organization. If you want to remove this line, click the Requester
organization name attribute and exclude any NULL values.
For more information about ticket organizations, see Organizing tickets and users.
More ideas
While you've started with a simple example, try adding more attributes to make the report more useful. For example:
- Add the attribute Requester organization domains to see the domains associated with each organization.
- Add the attribute Requester organization status to see which organizations are currently active.
Displaying users associated with your Zendesk account
This is a great report that shows all users and agents associated with your Zendesk account and how many ticket requests they've made.
To display users associated with your Zendesk account and their ticket requests
- 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.
- Next, add your metrics, the things you want to measure; in this case, the number of organizations associated with your account. In the Metrics panel, click Add.
- From the list of metrics, choose Users and organizations > Users, then click Apply. Explore displays the total number of users associated with your account.
- Next, you'll add the users names and their Zendesk role to the report. In the Rows panel, click Add.
- From the list of attributes, choose Requester/user > Requester
name and Requester role, then click Apply. Explore
displays a list of all users in your account together with their role.
There are many hundreds of metrics and attributes you can report on with Explore so feel free to experiment with these examples using Metrics and attributes for Zendesk Support for ideas.
Next steps
If you haven't already found them, our extensive collection of Explore recipes gives you some great, self-contained examples of using Explore to report on real-world scenarios. Here are links to a few examples that will help you report on user and organization information:
29 comments
John
Is there a way to add the Agent role to the report?
Not Agent/Admin/end-user, but rather the internally-defined agent roles?
0
Candyce Thompson (Left 17/02/2023)
How do we add the Agent Role. I have pulled the Requester Role onto the report but it only shows Agent or Admin - I would expect to see the Roles as they have been defined in our environment.
0
Gab Guinto
Hi John, Hi Candyce,
I'm afraid the default Role attributes are only able to identify if the user is an agent, admin or an end-user. Explore currently does not have the ability to pull the specific extended or custom role of agents. A workaround is to create a custom user field and fill it out with values that match the specific assigned role of users. The data from this field should then be imported to Explore under the Requester/user custom fields folder, and you'll be able to use this attribute in your reports.
0
Martin Cubitt
It would be really great to be able to report on the number of Organisations based on a time period.
For example, I would like to compare new ticket growth with the growth in the number of customers we have in my last 12-month report by month.
It would also be great to be able to report each month on how many new tickets we get per customer we had during that month, ie new tickets / total orgs.
One problem is that although Zendesk has Organisation status, you can only add, edit or delete Orgs and not deactivate them. We wouldn't want to hard-delete an Org, we move it to a special Group - but this makes reporting hard to identify inactive orgs. If necessary we can add customer fields to Orgs for Date Started and Ended Support, but would rather ensure we can use this is in reporting before updating all Orgs.
1
Thibaut
Thanks for contacting Zendesk Support! My name is Thibaut and I'd be happy to assist you with this!
First of all, I would like to sincerely apologise for the delay in getting back to you. We have been experiencing a high ticket volume the past few weeks, but we are doing our best to reach back out to our customers as soon as we can. Please, accept my apologies and thank you in advance for understanding!
Closed tickets are locked, they cannot be reopened or updated in any way, unfortunately we won't be able to update your old tickets to cleanup your reports.
I understand this is not the answer you were hoping for, but this is something we will not be able to change in your account.
Thank you for your understanding,
Kind regards,
0
Justin Near
Is it possible to also see users who have an organization as their second or third organization and not just their primary organization? We have many users with more than one organization.
0
bill cicchetti
Is there any reason we cannot report off the Group the group the users belong to? Currently when you report on a user's group its the group it looks at ticket history and the group the the user belonged to at the time of the ticket. We have gone to a tiered support system so when I report on the user and group it will show multiple groups (since its looking at the ticket group not the current user group). One for each group they belonged to in the past and current. I just simply want to see what their current assigned group is as noted on the user profile.
0
Gabriel
Unfortunately, as you can see presented in the article, that is expected behavior and there is no workaround at the moment. If the ticket belongs to multiple organizations, when reporting on the custom organization fields, Explore will only refer to the Default organization. I understand this may be an issue for your report, but this should only affect the custom organization fields.
Thanks!
0
Gabriel
In Explore we can not report on users themselves. For example, we have the Tickets dataset. So in this dataset, we can only report on tickets. We don't have a "user dataset", so we can not achieve what you have suggested. With the ticket dataset, as you have mentioned, you will see the data attached to the ticket metrics.
Thanks!
0
bill cicchetti
Hi Gabriel,
Thanks for the reply. If the above statement is true why can we report off whether a user is an agent or end user? We also can report on suspended and deleted users
0
Dane
As what Gabriel has mentioned, we don't have the dataset for users. The reason why you can extract the information about the ticket if it was submitted/updated by an agent or end user is because these data is also part of the Ticket Dataset. If you want to have a complete list of your current users, you can try the USER XML export option.
0
Chris Aylott
Hello,
Is there a way to add the value of two rows only together?
In my example I am looking to add two organisational values together, leaving the rest intact.
SUM(where Requester Organisational Name == NULL AND Requester Organisational Name == Legal)
0
Elaine
Hi Chris,
I would like to further understand your concern regarding the report where you're trying to add the values of two rows together.
I'm going to create a ticket on your behalf and let's continue from there. Kindly look out for an email notification. For now, stay safe! :)
0
Mark Molloy
I cannot find the attributes for the Requestor Organization fields: Group, Users, Details, and Notes. They would be very helpful in my verification reports. I have no trouble finding the fields: Tags and Domains.
0
Gabriel Manlapig
Explore's reporting for Support is primarily focused on tickets. While there are some Organization fields available to report on in Explore, the mapped Group, Users, Details, and Notes field are not one of them. The way I've had this explained to me is that this is more of an account setting than something that would be considered data relevant to your tickets.
I'll include a link to our guide for our Support datasets below, this goes over all of the Support metrics and attributes that are at your disposal.
Metrics and attributes for Zendesk Support
A potential workaround for this would be to create a custom organization field that you can then report on in Explore. You could create a custom organization dropdown field and add your groups and users access as the values for this field. And for the details and notes, you can add a text and multi-line field. I hope this helps!
0
Mark Molloy
Gabriel, Thanks for the info and workaround.
0
Michael Warr
Hi,
I'd like to be able to see what articles an organisation is viewing in guide. A lot of our content is behind a 'pay-wall'.
When we talk to our end users we like to be able to show that they are using our services and therefore getting value.
We're trying to move everything from a proprietary system to guide but can't see how to replicate this function.
0
Dane
As it turns out, organization is not an attribute for the Knowledge Base dataset. Hence, your use case it not currently possible.
0
michael warr
Hi Dane,
Can this please be added to the wishlist/roadmap?
We can track individual user activity through interactions in zendesk support but not in explore, so hopefully the technology is possible to port across.
With this ability, we can have meaningful conversations with customers about thier activity and what they thought of articles plus whether or not our self service option is right for them.
1
John Harte
Hi,
How is it not possible to see what users are searching and clicking in Help Center and then report on the user and organisation?. We can see them in Interactions........
There must be a way to report on it - what am I missing?
1
Stephen
Are there any plans to add a native Organisation / User dataset to Zendesk Explore?
I am curious, because it would be useful to build custom metrics / attributes based on update times for Ticket fields. This data is quite difficult to surface otherwise - I believe it is available in Audits, but this is not exactly useful for reporting.
0
Shawna James
0
Rena Towles
I want to run a report on every single user that is associated with our ZD instance. Not End User, every user including agents, light agents, end users, and admins. The systems shows we have 1000s of seats used and 1000s of light agents, but when I followed the above to run a report I only received a report of 72 users. There's a discrepancy. Please advise how I can run a User Report?
0
bill cicchetti
In the filter options is there a date restriction? If so check that since ZD auto-inserts a date range filter (of I think 30 days) in many reports
0
Rena Towles
bill cicchetti Good point! I did put a date filter in and I still only get 74 agents. I tried to seeing if they have multiple seats. Even if every agent has the max number of seats possible it would still equate to 300-something. Can anyone explain why I'm showing 1000's of seats being used but only 74 users in the system?
0
bill cicchetti
Rena Towles Could you provide screenshots of the report metrics and attributes? It would be helpful to see how you are creating the report
0
Rena Towles
bill cicchetti Sure.
0
bill cicchetti
Rena Towles : One thing to keep in mind with reporting on users and/or orgs. If the user never submitted or requested a ticket they will NOT show on the report. Its been a sore spot for me since we started using ZD in 2015. Upper mgmt wants a report with all the orgs paid modules (set via check boxes on the org form) but if they org has not opened a ticket it wont show. Very frustrating and hard to explain to mgmt.
I would maybe start with just:
and then try to add aggregates/filters as you go to see how granular you can make the report.
1
Rena Towles
bill cicchetti You are amazing! I didn't know that about the reporting and it does makes sense after you explained it. I finally have a higher number. It's no where near the 1300, but it's far higher than the 74 so I'm grateful. Thank you!
0