Recent searches


No recent searches

Explore recipe: List of incoming phone numbers by date



image avatar

Ricardo Pinto

Zendesk Digital Resources Team

Edited Jun 21, 2024


0

15

15 comments

What if a phone number is associated with a name?  Is there a way to get a report that just shows a list of the calls? 

0


image avatar

Cheeny Aban

Zendesk Customer Care

Hi Allison,

Unfortunately, the only available option to show the caller phone number on the report is by adding the filter or attribute caller name. If the caller is a verified user or the ticket title is changed, the number will no longer appear on the report.

 

0


So you are saying there is no way to access the list of calls that underlies the summary statistics shown on the dashboard?

For example, if I have 10 abandoned calls this month and I want to see who they came from, is there any way to access that?

Thanks for your help, Allison

0


image avatar

Cheeny Aban

Zendesk Customer Care

Hi Allison,

You can view in-depth details of your calls and Talk performance on your Talk Dashboard. More information can be found on Analyzing call activity with the Talk dashboard.

You can also create a query for abandoned calls in Explore, they will be filtered via ticket id and you need to open the ticket to see the phone number. 

0


Thanks for getting back to me so fast.

1. That article does not include information on how to see a list of calls, or a list of the calls summarized by a given statistic. All data in that view is summary. I could not, for example, see what calls were abandoned. I could only see that there were 3 abandoned calls today.

2. The Talk dashboard only includes live same-day data, it does not provide historical information. I could not, for example, get a list of all numbers that abandoned a call or all numbers that left a voicemail this month. 

How can I get this data?  Thank you!

0


image avatar

Cheeny Aban

Zendesk Customer Care

Hi Allison,

If you would like to access more details about your Talk Reports, you can also view it under the prebuilt Talk dashboard in Explore. Moreover, you can also create your own queries and dashboard base on the data that you would like to use. In creating your report, the following article will be a good guide companion.

Metrics and attributes for Zendesk Talk
Reporting on calls with Explore
Explore recipes reference for Zendesk Talk

 

0


Great post and thanks for the information! Can you please confirm what it means when the "End-user name" field is empty for a call? For example, after creating this query, I'm seeing a few callers with a completion status of "abandoned in IVR" but a blank "End-user name" column.

0


image avatar

Aubree

Zendesk Customer Care

Hi William Flaugher,

The end-user name pulled up by Explore Talk reports is the user associated with the phone call at the time the call was received. This means that for the calls listed in the query that don't have End-user name values, the system didn't find a user profile in Zendesk associated with the caller's number at the time the call was made.

Also, you may see, there are some calls in your report with End-user names; this means that at the time the calls were received, there were already existing tickets/profiles associated with the callers' phone numbers. 

 

0


Thanks for the response, Aubree! Would this essentially mean that the user has never had a completed call in the psat? At what point are user profiles created?

If this is the case, is there any way to know the numbers associated with missed/abandoned calls if a ZD user wasn't created at the time of the call?

0


image avatar

Aubree

Zendesk Customer Care

Hi William Flaugher

Appreciate your response. If you see a blank end user name, that means the number is not associated with any user profile of your customers in Support at the time of the call. If a caller was able to complete a call/create a ticket from a phone call, then a user profile would have been automatically created for them, with their number saved as contact information – and the End-user name wouldn't be null or blank when you check the data in Explore.

At the moment, Explore is only able to pull the end user names from saved profiles in Support based on the number associated with the Call-ID. So, I'm afraid it really is not possible in Explore to identify the user or number, at the time the call was made, if the number is not linked to any user profile.
 
If you need to track it, you may have to get the Call-ID in the Explore report, then manually search for that Call ID through the Talk History dashboard.

0


This is hilarious. So in reports, we can get email addresses of verified end-users calling, but not their phone number?

Is there really no want in query builder where we can see the phone numbers of abandoned calls by verified end-users?

What are your suggestions on tracking this?

 

1


David - while it's not through the explore function, I was able to find a workaround through the Talk History dashboard that Aubree just mentioned. If you go to Settings, click "Talk", click "History", and then click "Export CSV" you will see a full list with phone numbers included, per period.

We had a person claiming to have reached out before with no assistance, so we were able to use this export to determine whether or not this was true. Not an ideal solution, but it got the job done for this specific use case.

0


image avatar

Jacob the Moderator

Zendesk LuminaryCommunity Moderator

Came by this article looking for something else, just want to mention that requester phone numbers are now available in Explore.

0


Hi Jacob the Moderator

Yes! Thanks! But in "Support Dataset" not on "Calls Dataset". And there are some blank "Requester phone number" even though the "phone" field on "Customer Context" is filled.

Unfortunately it is not very reliable and if I want all the other data that the call report gives me I should make two reports and cross them.

0


Hi @.....

I created a webhook:

Then I add a custom text ticket field on ticket form. With a trigger, I fill in this field every time a call ticket is created:

In this way I have the phone number on Explore report.

 

2


Please sign in to leave a comment.