Reading Your Exported Analytics

If you haven't yet download any report exports, go here for a brief summary of all of them.

Assuming you've now downloaded a report, let's take a closer look at all the data. Just remember that any calls that happened less than 24 hours from when you export won't show up on your reports.

Call Logs Export

date_started	The date and time that a call is received by the Dialpad system.
call_id	A unique ID automatically assigned to each call. We generate new call IDs most of the time a call is transferred. Entry point call and user call have different call IDs as well.
category	Indicates whether a call was... Incoming: an inbound call that was connected Outgoing: an outbound call that was connected Missed: an inbound call where users were rung but didn't accept Abandoned: an inbound call that did not ring any users Short Abandoned: an inbound call that did not ring anyone and the caller hung up within a specific timeframe Canceled: an outgoing call initiated by a Dialpad user and hung up before someone answers Visit this Help Center article to review all definitions.
direction	Call direction indicating whether a call was made (outbound) or received (inbound).
external_number	The phone # external to your Organization.
internal_number	The phone # internal to your Organization; users without an assigned # will be given a fake number starting with 803 for routing.
date_first_rang	Timestamp of the first time a Dialpad user was rung. See also date_rang. This is a new timestamp as of mid-June 2020.
date_queued	Timestamp of when an inbound Call Center call is placed in the Hold Queue.
date_rang	Timestamp when the call started to ring before it was answered (effectively the ringing start time of when it was successfully answered). May appear blank if... The caller hung up before we could detect ringing The user has IVR settings that put callers directly to VM It is an outbound call Example: If the call rings 3 people and the third person answers it, this is the timestamp. If selected, Agents or Operators should be rung immediately. If not, menu or greeting and then date_rang or date_queued.
date_connected	Timestamp when the call connects to an Agent, Operator, or user. May appear blank if... Dialpad did not detect a date_rang value Agent did not answer (Call Center)
date_ended	Timestamp when the call was hung up.
target_id	Unique ID automatically assigned to the Office, Department, user, or group.
target_kind	Indicates whether the target was an Office (Main Line), Department, Call Center, room, or user.
target_type	User, Dept., Call Center, Office (Mainline), Room Phone, etc.
name	Name of the target.
email	Email of the user who handled the call; may appear blank if unanswered.
was_recorded	Indicates that a call was recorded manually or automatically, but not Admin call recordings.
entry_point_target_id	Where calls originated from.
entry_point_call_id	A group call will always result in at least two call IDs. This data point ties the child call leg ('fan outs') back to the parent call leg. Actions leading to new call ID include... Group call Transfer (manual and automatic)
proxy_target_id	Caller ID used for outbound calls. If a value appears, the call was placed with an outbound ID other than the User's direct line
voicemail	Whether or not a voicemail was left.
transferred_to	Phone number that the call was transferred to.
transferred_to_contact_id	Unique ID associated with the contact that the call was transferred to.
transferred_from_target_id	Unique ID associated with the Main Line, Department, or user that transferred the call.
office_id	Unique ID associated with the Office where this call record exists.
company_id	Unique ID associated with the company where this call record exists.
device	Android, Desk_Phone, Desktop_App, Web_app Forwarding_Number, iPad, iPhone
salesforce_activity_id	Unique ID of the Salesforce record that was created when this call was logged.
timezone	Timezone of target (e.g. US/Pacific).
availability	Indicates whether the call was received during 'open' or 'closed' hours.
wait_time	date_connected - date_first_rang
callback_type	In-queue callback feature; callback_request, callback_fulfilled, and callback_cancelled
callback_id	Unique ID associated with the callback request.

Statistics by User Export

date	Indicates each date where there was call activity for that user.
user_id	A unique ID that is automatically assigned to all users.
name	Name of user.
email	Email associated with that user.
type	User or Room.
all_calls	Total # of all calls (inbound, outbound, missed, abandoned, and canceled).
inbound_calls	Number of answered calls.
outbound_calls	Number of placed calls that were connected.
voicemails	Number of voicemails. Data deleted in Analytics will be permanently gone and unable to retrieve. Filter for voicemails and missed calls only if you want total missed calls. On the Analytics page, this is how missed calls are counted, with voicemails not being counted as an independent event (in grey).
missed	Number of missed calls.
abandoned	Number of abandoned calls.
forwarded	Number of calls forwarded automatically.
canceled	Number of canceled calls; outbound calls that only rang, never connected by human or voicemail.
minutes	Total number of minutes on all calls.
acd	Average call duration in minutes; calculation: minutes / (inbound_calls + outbound_calls).
inbound_minutes	Number of inbound minutes.
outbound_minutes	Number of outbound minutes.
internal_calls	Number of calls that were connected between users within your organization.
forwarding_number	Number of times calls were answered via a forwarding phone # and will show when the user answers the call on any PSTN device, including carrier calling on mobile; forwarding numbers are only for inbound calls.
desktop_app	Number of times calls were answered via a desktop app.
mobile_voip	'HD calls' on our mobile apps (iOS or Android).
desk_phone	Number of times calls were answered via a desk phone.

Statistics Export

date	Date that the call activity occurred.
all_calls	Total # of all calls (inbound, outbound, missed, abandoned, and canceled).
inbound_calls	Number of answered calls.
outbound_calls	Number of placed calls that were connected.
voicemails	Number of voicemails; filter for voicemails and missed calls if you want total missed calls. On the Analytics page, this is how missed calls are counted, with voicemails not being counted as an independent (in grey).
missed	Number of missed calls.
abandoned	Number of abandoned calls.
forwarded	Number of calls forwarded automatically, for example in an IVR menu.
canceled	Number of canceled calls; outbound call that just rang out and did not connect either to a human or voicemail.
minutes	Total number of minutes on all calls.
acd	Average call duration in minutes; calculation: minutes / (inbound_calls + outbound_calls).
inbound_minutes	Number of inbound minutes.
outbound_minutes	Number of outbound minutes.
average_wait
service_level	The count of calls that hit service level, not the percentage.
asa	Average speed to answer; calculation: date_connected - earlier of date_first_rang or date_queued
callback_request	Inbound call that the caller requested a callback for.
callback_fulfilled	Dialpad placing an outbound call to the caller who requested a callback.
callback_cancelled	Caller declined the callback.
open_inbound_calls	# of inbound calls received during open hours.
open_missed_calls	# of missed calls during open hours.
open_abandoned_calls	# of abandoned calls during open hours.

Text Statistics Export

date	Date
user_id	ID automatically assigned to all users
name	Name of user.
email	Email of team member handling the call.
type	User (in this case).
texts	Total number of texts.
internal_texts	Number of texts to and received from users in your company.
external_texts	Number of texts to and received from users outside your company.
outgoing	Number of texts sent.

Statistics by Group Export

name	Name of group.
type	Group or Room.
all_calls	Total # of all calls (inbound, outbound, missed, abandoned, and canceled).
inbound_calls	Number of answered calls.
outbound_calls	Number of placed calls that were connected.
voicemails	Number of voicemails. Data deleted in Analytics will be permanently gone and unable to retrieve. Filter for voicemails and missed calls only if you want total missed calls. On the Analytics page, this is how missed calls are counted, with voicemails not being counted as an independent event (in grey).
missed	Number of missed calls.
acd	Average call duration in minutes; calculation: minutes / (inbound calls + outbound_calls).
inbound_minutes	Number of inbound minutes.
outbound_minutes	Number of outbound minutes.
average_wait
callbacks_requested	Inbound call that the caller requested a callback for.
callbacks_cancelled	Caller declined the callback.

Have more questions about analytics? Check out our FAQ.

Call Logs Export

Statistics by User Export

Statistics Export

Text Statistics Export

Note:

Statistics by Group Export