Customer Count and Type
I was wondering if someone could assist me on this:
We tag both the Organization and Ticket certain types to indicate what kind of customer they are: Enterprise, Standard, OnDemand.
I've been task with getting a report that shows the count of customers we have in each catergory.
Seems simple enough but haven't been able to figure it out. Any helps here? Thanks.
-Jeff
-
Hey Jeff,
While we don't really assist with the creation of Reports, we do have some resources that would be able to help. And once you give that a try and Save it, we have Specialists that can take a look at the report you've created and help you out there.
For your request, this resource here should be of assistance:
For more information on Reporting and our pre-made reporting Recipes check out these two links:
https://support.zendesk.com/hc/en-us/articles/208225158
-
Jeff
You will find it a lot easier to report on organisations and customers using custom fields rather than just tags.
To count users, rather than tickets, create a custom metric.
Be sure to enter field information from element selector rather than just typing the text.
While tickets inherit the tags of both their organisation and their requester, the user record here does not. So, you are only looking at tags against a user here.
-
So What I have is this:
What: # Organizations
How: Organization, Support Plan
That yields me this:
Which is almost perfect. What I need to do is Group it by Support Plan (a option to combine a few Support Plans as one group). Also then Sum the # Organizations by that new Group.
Any thoughts on achieving this? Thanks in advance.
-
Jeff
Drag your support plan column so that it appears on the left hand side. GoodData will automatically group your plans.
To get totals, right click the # Organisations heading and select SUM>By Support Plan.
Alternatively, just drop the organisation column from your report.
Grouping support plans is a little messy. You would need to create custom metrics for each new group of plans with IF statements or CASE statements. It may be better to create another custom field in Zendesk. But that has drawbacks too.
Please sign in to leave a comment.
4 Comments