Articles in this section

Export Guide: Calculating Talk Time

Knowing your user's talk time helps efficiently allocate resources and aids in effective scheduling. Export your call logs to drill into the details of how much time an individual user spends on the phone. 

Let's dive into the details. 

Who can use this

Dialpad admins and users with Analytics permission can export office-wide call data.

Individual users can export their own call analytics data.

Refer to our Pricing Page to see if you have access to this feature. If you have any questions about your plan, reach out to your Customer Success Manager or Dialpad Customer Care.

Export call logs

To export your call logs, head to your Admin Portal from Dialpad.com 

  1. Navigate to Analytics 

  2. Select the desired User or groups filter

  3. Select a desired date range

  4. Select Export (.csv)

  5. Select Call Logs

  6. Select Send Report

    Image showing where to export call logs.

     

That’s it! You'll receive a download link with a CSV file containing the call logs.

Calculate talk time 

Keeping track of talk time (account minutes) helps your business and customer service teams figure out how efficiently they're handling customer interactions.

To see your talk time (calculated in minutes), use the exported call logs file, and apply the following filters:

  1. Navigate to the Direction column

  2. Select the Inbound filter 

    Image showing inbound filter to select.

  3. Navigate to the Category column

  4. Select Incoming filter Image showing incoming filter.

  5. Navigate to Target_type column

  6. Select User filter

To get the call time value, apply the formula of subtracting the date_ended from the date_connected column.

Image showing talk duration column.

To see the total account minutes, calculate the sum of the talk_duration column. 

Tip

Set the format of the date_connected and the date_ended columns to Time, and the talk duration column to Duration. This ensures the result is displayed correctly.

 

Was this article helpful?
0 out of 0 found this helpful

Comments

0 comments

Article is closed for comments.