When to use Looker
Generally speaking most reporting needs of a supervisor should be covered in the CXP Reporting Center to allow supervisors to remain focused on live-listening and coaching their agents.
The information provided in this section should equip supervisors with the ability to pull additional info not provided in the CXP Reporting Center.
It may be a tendency for some to over-analyze data (aka analysis paralysis). Please maintain focus on the calls and DO NOT get lost in the data!
Sections
Each report has three sections (Filters, Visualization, Data) which may be expanded by clicking the small arrow to the left as shown in the screenshot below.
Visualization and Data are almost the same so we will ignore Data
Filters
Only 3 items in the Filters section may need adjusting:
Date Granularity - It is recommended to always make this “quarter.” If you wish to pull for a week’s worth of data and the granularity setting is “Daily” then it will pull each agent 5 times, once for each of the 5 days.
If you want to pull yesterday only, toggle to “Is on the day” and select yesterday’s date.
If you want to toggle for a date range, select, “Is in range” and select the range.
Warning: Notice the second date of the range says “until (before).” You must select the date AFTER the last day you wish to pull for. For example, in the screenshot below, the report will pull June 20-24. It will NOT include the 25th.
Enter your name if you want to pull for your team.
Warning: You will not be able to pull info for agents who were recently assigned to you in Looker for dates before they were assigned to you. You’d have to include whichever TL was assigned previously, or leave the section blank to pull all agents across all teams.
After selecting the filters, click “Run”
Visualization
Displays the data after the report Runs. To download into excel, click the cog-wheel next to Run followed by “Download”
Toggle to CSV and click Download
Reports
Below are the reports in Looker worth familiarizing yourself with along with a description of what they may be used for.
User Historical Row Level Activity Lookup
This may be your most effective tool for weeding out shenanigans.
It shows, in chronological order, each time an agent moved from one status to another, including the duration stayed in that status.
The report shows the number of seconds in each status. A bit of excel knowhow is needed to make the report more user-friendly by creating a minute and an hour column (divide seconds by 60 for min and divide min by 60 for hours).
This report generates a large number of rows and Looker settings limits how many rows can be returned. Therefore - you are limited on the number of days you can pull for your team. Depending on how many agents worked and how often they alter to different statuses, you can probably pull 2-5 days at most.
Important: This is one report that requires viewing the “Data” dropdown because, be default, looker pulls back 500 rows. Select the date range (1) and change the “row limit” (2) to 5000 (Looker’s limit) as shown in the screenshot below:
Pulling one day should be sufficient to see ‘a day-in-the-life’ of an agent’s activity.
Download into Excel.
Create a Minutes column (divide seconds by 60).
Create an Hours column (divide minutes by 60).
Sort “Start Time” from A-Z (earliest to latest time chronologically).
Filter for the agent your are meeting with.
Walk through their “Day-in-the-life”
This exercise will shine the spotlight on shady Productivity practices.
The screenshot below demonstrates one example of what to watch for. The casual observer may overlook the fact that the “Disposition Status” was abused this day. The agent seemingly takes advantage of the Disposition status with a few minutes here and a few there. But the total sum of hours in Disposition adds to 1.48 Hrs.
Taking the total Disposition Minutes (1.48 hrs *60 = 89 min) divided by the number of Disposition line items listed above (32) suggests the agent spent an average of 2.8 min in Disposition status. This alone is enough to call the agent out because there should not be more than 1 min in this status on average. But, looking at additional reporting for this day shows the true number of inbound and outbound calls is 27:
…which makes the average worse. Maybe some agents have found a way to embellish reporting details? If so we should verify so we can watch for this.The example above was found in one attempt of pulling data for an agent who has a history long disposition time. These situations are not difficult to find for the careful observer.
Here is another example of how to utilize this report. The daily CR-Productivity report shows some agents who ‘struck out’ for the day and were advised to stop taking calls (ie lines 14-17). It is somewhat apparent why their Productivity may have been low. What about the agent on line 5 with 75% Productivity? 1 Submit, 7 IB Calls, 3 outbound calls, and 75% Productivity…there were no trainings scheduled this day. Maybe there were extensive coaching sessions…if so, you would know as their coach.
Here is a detailed view of the agent from row 5 above:
Each yellow highlight is a red flag.
Lines 8-9: Why does it take 2.3 minutes to disposition a call which lasted .6 min?
Lines 12-14: Why does it take 3.2 min to disposition a 1.5 min call followed by 10.7 min of offline time?
Line 18: Why 3.4 min to disposition the last 8.4 min call?
Lines 25, 27, 29, 59: Sum is 235 min. Max training time for Bridge trainings this week should not have exceeded 120 min which is generous. Why did this agent take 2x longer than needed for training this week on one day alone?
Line 28: 34 min offline. The agent granted herself a bonus lunch break?
Line 30: Another 34 min offline. Another bonus lunch??
Line 32: Agent used one, 33 min break instead of two, 15 min breaks per attendance policy.
Line 45: 4.2 min Disposition needed + 4.2 min offline?
Line 58: 1 min lunch?
The agent in the first example has worked on this campaign for about 4 months. There should be no reason the agent is not adhering to status expectations by now. The agent in the second example has been here since 2020. This is inexcusable and a reflection of poor management. These behaviors must be quickly identified and corrected for new agents this year.
Some agents will be running games on your watch, on your team, at your expense. Can you efficiently identify these behaviors to correct and weed them out or will these slip your attention and cause goals to be missed?