Question
How can I report on user and organization data in Explore? Can I report on users or organizations that do not have tickets associated with them?
Answer
Most of the user and organization data in Explore is contained in the Support: Tickets dataset. The dataset contains many useful metrics such as:
- Users
- Suspended users
- Deleted users
- Organizations
For a comprehensive list of available metrics, see the article: Metrics and attributes for Zendesk Explore.
Not every metric requires that a ticket be associated with it but some are fundamentally tied to ticket data. For example, in order to find out when a user was created, you have to use the Ticket attribute, Time - requester created.
For more information and useful recipes, check out the following articles:
- Reporting on user and organization data
- Explore recipe: Displaying organizations with no users
- Explore recipe: Displaying users with no ticket requests
- Explore recipe: Displaying organizations with no tickets
An alternative to reporting on user and organization information in Explore would be to export that information directly from Support and report on it in an external program. Learn how to export Support data in this article: Where is the data export option?
5 comments
Allan Kimutai
Hello,
While reporting on deleted users metric, is there a way you can include the day the same accounts were deleted as an attribute.
Your support on this will be highly appreciated
0
Mau
Natively, Zendesk doesn't have a metric that reports on the timestamp when a user is deleted. You may want to check the article Metrics and attributes for Zendesk Support for a comprehensive list of metrics and attributes.
Thanks for understanding.
Mau
0
Allan Kimutai
Hi Mau,
Many thanks for your response. I was able to hack it by using;
as the last requester user-profile update was 'Delete'.
Allan
0
Sydney Neubauer
I am looking for a way to see the name of the User and selections they have on their profile. I only see Name options for "Assignee, requester, and submitter" which does not apply to user profile. Is there an option similar to "User name"?
0
Viktor Osetrov
We can recommend using API GET requests for checking the information about the "user name".
GET /api/v2/users/{user_id}
where{user_id}
is the id of the user.- https://developer.zendesk.com/api-reference/ticketing/users/users/#show-user
For example, using this API requests you can extract "alias" information and so on.
Have attached an example of how you can check it via the browser console:
Hopefully, it helps
0