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?
Most of the user and organization data in Explore is contained in the Support: Tickets dataset. The dataset contains many useful metrics such as:
- Suspended users
- Deleted users
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?