Reporting on user and organization data with Explore

Return to top

11 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

    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
    Zendesk Customer Care

    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
    Hi,
    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
    Zendesk Customer Care
    Hello Justin! 

    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
    Zendesk Customer Care
    Hello Bill!

    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
    Zendesk Engineering
    Hi Bill,
     
    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

Please sign in to leave a comment.

Powered by Zendesk