Data Explorer Quick Start Guide: Build a Report on Call Recording Events

In this guide, we help you build a report that shows you the number of call events (hold, pause, silence, and talk over) for the past week, broken down by team and agent. We’ll also include links to each contact that had one of these events so that you can play it to see what actually happened on the call. Here’s what the final report will look like. (Imagine that this preview has rows with additional teams and agents.)

Here’s a quick review of the different kinds of call events:

Call Event Definition
Hold The agent placed the call on hold.
Pause The recording of the call was paused, either manually by the agent or automatically by Workforce Optimization. For example, the agent clicked on a credit card field to enter a customer’s card number, and Workforce Optimization paused the recording to protect the customer’s information.
Silence Neither the agent nor the customer was speaking. Your organization sets the number of seconds of silence that must pass to qualify as a silence event.
Talk Over Both the agent and the customer were speaking at the same time. Your organization sets the number of seconds of talk over that must happen to qualify as a talk over event.

If you haven’t worked with Data Explorer very much, don’t worry. We explain every step. But if you’re completely new to Data Explorer, you might want to start with the Beginner’s Guide to Data Explorer Dashboards.

The information in this guide also applies to Data Management.

Step 1: Build the basic report

NOTE   If your organization has a high number of contacts or you’ve been using Provider QM for a long time, Workforce Optimization might run a little slowly during Step 1. If that bothers you, skip to Step 2: Filter the data and come back to Step 1 when you’re done.

Add a custom measure for event duration

The first step in building any report is selecting the data you want to see.

  1. Click Data Explorer in the top menu.
  2. Click New Report (upper left corner of the page). The blank report page appears.
  3. Click [measure]. The Select Measure window opens.
  4. Click Custom (upper right corner of the window).
  5. Select Measures from the menu on the left side of the window.

  6. Double-click Recording Event Duration in the list of measures.

    A formula appears in the Formula window.

  7. Enter /1000 at the end of the formula.

  8. Select #,### from the Format: drop-down list.
  9. Enter Duration in Seconds in the Name field.
  10. Click Add. The Measure: Duration in Seconds window closes, and the basic report appears. At this point, it looks like this:

    This is the number of seconds for all hold, silence, talkover, and pause events for all calls across your organization—for all time (or at least from when you started using Workforce Optimization). This isn’t a very helpful number, but things will start to make more sense in the next step.

Group the duration data

In this step, we sort this giant number of seconds into meaningful buckets.

  1. Click [grouping]. The Select Grouping window opens.
  2. Select Contact.
  3. Click Add. The Grouping: Contact window closes, and the report now looks like this.

    We’ve shown only the first few rows here. You probably have many more. This grouping separates the total event duration in seconds by contact. Let’s keep going to separate these times by event type.

    NOTE   Each contact number is a link. If you click it, the call recording opens in the media player.

  4. Click [grouping].
  5. Select Recording Event Type.
  6. Click Add. The report now looks like this. We’ve shown only the first few rows, but you get the idea.

    This grouping shows the duration of each type of call event for each call. Now let’s add the agent who handled each call.

  7. Click [grouping].
  8. Select Person.
  9. Click Add. Here’s what we get:

    Now we can see which agent handled each call, but we don’t need to see the same person’s name repeated. Let’s fix that.

  10. Drag the Person grouping and drop it above Contact.

    Here’s how the report looks now. The agents’ names are in alphabetical order.

    Now, let’s add the date and time for each call.

  11. Click [grouping].
  12. Click Time (upper right corner of the window).
  13. Select Contact Start Time.
  14. In the Period panel on the right side of the window, select Contact Start Time.
  15. Click Add. The report now looks like this:

    Let’s keep going and add each agent’s team.

  16. Click [grouping].
  17. Select Team.
  18. Click Add. Here’s what we have now:

    Similar to when we grouped by person earlier, we see the same team name listed over and over. Let’s fix that.

  19. Drag the Team grouping and drop it above Person.

    That’s better:

Step 2: Filter the data

We’ve built the report, but it’s just too much data. Let’s filter the data to see only events from contacts that specific teams handled recently.

Filter by date

In this step, we limit the data to only call events that happened today and the previous seven days. This date will be relative, so no matter when you go back to this report, you always see information from today and the previous seven days.

  1. Click [limit]. The Select Filter window opens.
  2. Click Time (upper right corner of the window).
  3. Select Contact Start Time.
  4. In the Period panel, select Contact Start Time.
  5. Click Add Filter (the + icon). The Select Period window opens.

  6. Select Day of Month.
  7. Click OK. The Select Period window closes.
  8. Enter 7 in the Last column.
  9. Select This. With Steps 8 and 9, we’re telling Data Explorer to include only data from today and the previous seven days.

  10. Click Add. The Filter: Contact Start Time window closes. Here’s our report, now showing only recording events for the past week:

Filter by team

In this step, we limit the call events to only those from specific teams.

  1. Click [limit].
  2. Select Team.
  3. In the Field panel, select Team Name.
  4. Clear the All values check box.
  5. Select the teams whose events you want to view.
  6. Click Add.

NOTE   If you would like to see data from all teams but see only one team at a time on your dashboard, see Data Explorer Quick Start Guide: Filter Reports on Your Dashboard.

Step 3: Create separate columns for each event type

Right now, the Recording Event Type column lists all the event types together. To make things a little easier to read, let’s move the events into separate columns.

  • For the Recording Event Type grouping, select columns by from the rows by drop-down list.

That’s it! The report is finished. Congratulations!

Step 4: Save the report

  1. Click Save (upper left corner of the page). The Save Report window opens.
  2. Enter a name for the report.
  3. Click Save. The Save Report window closes, and the report name appears in the upper left corner of the page.

Step 5: Share the report

This step is optional, but sharing reports helps you easily communicate the report’s information to other people, like direct reports or upper management. Anyone you share a report with sees only the data they have permission to see, so you don’t need to worry about exposing information to the wrong people.

  1. Click Data Explorer in the top menu.
  2. (Optional) Select Owned by Me from the drop-down list at the top left of the page.
  3. Right-click the report and select Share from the drop-down list. The Sharing window opens.
  4. Select the level of control to give the people you are sharing with.

    Permission What it means
    None No one else can see the report.
    View Other people can see the report but can’t copy it or make any changes to it.
    Explore Other people can adjust the groups and filters in the report but can’t save changes.
    Save As Other people can save their own copy of the report and edit their copy. This is the most commonly used option.
    Edit Other people can edit your original report.
  5. Click OK. The Sharing window closes.

Congratulations, you’ve built and shared a Data Explorer report!

Keep learning about Data Explorer

Our Data Explorer library has a great collection of guides for people who are new to Data Explorer or are looking to grow their skills. Check them out!

For beginners

For QM

For Analytics

For intermediate users