Lab 8: Reporting & Data
Webex Contact Center Reporting - Analyzer
Table of Contents
- 1. Login into Analyzer and review user interface
- 2. Execute Stock Report and use it to create custom reports
- 3. Create an Agent Historical Call Visualization
- 4. Create a Call Realtime Report
- 5. Create Dashboard
Quick Links
Introduction
Lab Objective
This lab is designed to give you basic understanding of Analyzer, user interface features , how execute stock reports and use them to create custom reports per your need.
We will also be creating two new reports (one for Call and one for agent) to capture relevent information and then will use these reports in a dashboard, while doing this we will learns about capabilities and features you can use to capture the required insights.
Pre-requisite
- All previous labs completed
- Admin or supervisor credential with Analytics access in user profile
- Make sure to make few test calls and answered by the agent the day you attempting this lab (to ensure we have some data to analyze)
1. Login into Analyzer and review user interface
Section Information
- Login Into Analyzer
- Four Repositories
- Review Stock reports and Dashboard
- Search Folder & Visualization
- List or Grid View
- Visualization Summary information
- Report Details information
- Click on the
Burger
sign next toHOME
- You can see 3 modules on the left pane :
Visualization , Dashboard and Variables
- In the middle of the page you would notice 4 Repositories :
Total Agent Activity Records, Total Agent Session Records, Total Customer Activity Records and Total Customer Session Records
- Click on More details on Total Customer Session Records: Make a note of
total
customer sessions records andperiod
those records were executed - Click on
Visualization
: you will noticeStock Reports
Folder , Click onStock reports --> Business Metrics
- Click on
GRID
option on left upper side (under the user name), this will show you reports in GRID view Make a note ofType, Temporal Scope, Last Modified , Created By and ID
- Click on Search
Folder & Visualization
and enterAgent realtime
This is execute a global search and list the matching report
2. Execute Stock Report and use it to create custom reports
Section Information
- Create a folder
- Save a stock report as custom in your folder
- Execute Your report
- Information in preview
- Run a Stock Dashboard
- Go to
Home --> Visualization
- Click on
Create New
and selectFolder
to create a new folder with your name - Click on ` Stock Reports -> Historical -> Reports -> Agent Reports`
- Take cursor on top of
Agent Details
report, click 3 dots and clickCreate a Copy
- Click
Save As..
, select the Folder you created previously, change the Report name to something custom to your self (For example KT_Agent Details) and clickOK
- Not close this report by clicking x on right upper side.
- Go back to your Folder under
Home -> Visualization
and Double click (or click on 3 dots and clickRun
) on your newly added report to run it. - Now you are in Preview mode and to check the
data summary
for this report click on burger sign next tosetting
on the header. Make a note ofData Summary
andDetails
- Click on
Export
option and download this report inExcel
orCSV
format. - Make a note of informational
Timezone
information on right hand upper side and make sure this match with your browser time. - Click on
Dashboard -> Stock Reports -> Historical Reports -> Contact Center Overview
- Double click
Contact Center Overview - Historical
. This will should your Contact Center Historical Summary
3. Create an Agent Historical Call Visualization
Section Information
- Create a Historical Agent report
- Repository and Interval Selection
- Using Measures and Profile Variables
- How to use Enhanced Field
- How to creat new Formulas
- Go to
Home --> Visualization
and Click on yourFolder
created in previous excercise. - Click on
Create New
–>Visualization
- On the top pane Click next to
Type
and selectAgent Session Record
- On left pane click next to
Start Time
and selectLast 7 Days
- Click on
Compute
and select underInterval
Daily - Click on
+ Row Segment
, search for FieldAgent
. SelectAgent Name
and drag it toRow segment
area (Green color pane) - Click on
Interval
onColumn Segment
and drag it toRow Segment
underAgent Name
- Click on
+ Profile Variable
, search forconnected
and click onMeasure
drop-down. SelectConnected Count
and drag it toProfile Variable
pane (Green). Here click onFormula
and selectSum of Connected Count
, change the name toInbound Calls
and ClickSave
- Repeat
step 7
and dragOutdial Connected Count
and SaveSum of Outdial Connected Count
asOutdial Calls
- Click
Save
option on the top pane - Name the report as
Agent Call Volume Last7Days
and clickOK
- Click on
Preview
, You can seeCalls handled (Inbound and Outbound)
by all the agents forlast 7 days.
- Lets see how can we leverage
Enhanced Field
to create Grouping ofSegment fields
. - Go to
Edit view
of the report, right click on theAgent Name
and click onCreate Enhanced Field
- Change the
Name
toLOB_{YourNameInitial}
, TypeDefault
inDefault Group
- In
Group
configureGroup Name
asSales
and select youragent
inProvide Value
andSave
it - Now move the newly created
Enhanced field
aboveAgent Name
by click and drag in the segment section. - Now this
Enhanced field
can be saved to use globally in other reports byright click
on the field and clickSAVE
andSAVE
. Save
the report andPreview
: You will seeEnhanced Field
in first column :Default
andSales
with your agent assigned underSales
and rest of the agents underDefault
.- Lets see how we can create
Custom formula
: In this case we would like to get a field which give ustotal number of calls handled by the agent including inbound and outbound
. - Go to the
report edit view
and right Click onInbound Call
–>click New Formula
- Name the formula as
Total Agent Call_{YourNameInitial}
- In Arithmetic Expression Use
Inbound Call + Outdial Calls
(Click the down arrow to see the field) andSave
- This Formula can be saved for global use in other reports, to do so
right click
on the newly created formula variable and clicksave
and thenOK
Save
the report andPreview
, this will add new column providing youTotal number of calls
4. Create a Call Realtime Report
Section Information
- Creating a Realtime Report
- How to use Filter
- Use Drill-down functionality
- Go to
Home --> Visualization
and Click on yourFolder
created in previous excercise. - Click on
Create New
–>Visualization
- On the top pane Click next to
Type
and make sureCustomer Session Record
is selected - On Left pane click next to
Start Time
and selectRealtime
- Click on
Compute
and selectStart of Day
- Click on
Refresh Rate
and change it to15
(Minutes) from default5
- click on
+ Profile Variables
, search forSession
and selectContact Session ID
, drag it toProfile Variable
pane. - Click on
Formula
select Value ofContact session ID
- Repeat
step 7
to add these variables:EntryPoint, Final Queue Name, Team Name, Agent Name
- Click
Save
option on the top pane - Name the report as
Call Session Today
and clickOK
- Click on
Preview
, You can see Calls received Today (for all the entry points and calls answered by all the agents) - Now to see the calls today answered by you only lets
add a filter
in this report - Go To the
Report edit view
and on left pane click onAdd Filter
- Here search for
Agent
and selectAgent Name
and drag it toFilter area
- Now
Click under the Field,
as you do that analyzer will list possible values. Select yourAgent
and ClickSave
- Now
Save
the report on top andClick Preview
. Now you will only see calls handled by your agent. - Lets check on
Drill-down
Functionality now. - In your Preview report click on any one of
Contact Session ID Value
(alpha numeric string), as you click you will see aZoom icon
. Click it. - This will open a new Window with
Drill-Down view
, essentially showing you all the Activities during this session (start with Activity state - new) - In this Drill-Down window on left pane click on
Agent name
, Moment you click it this data will be added to the Drill-down and show you value for each Activity in this session, more fields can be added like this. - Click on
Launch
icon to open this Drill-down window in a separate window withfull view
.
5. Create Dashboard
Section Information
- How to create Dashboard
- Go to
Home --> Dashboard
- Click on your
Folder
- Click on
Create New --> Dashboard
- On left pane you would see your
Folder
, click it. Here you will see two reports you created in previous excercise - Drag these one by one into the
Dashboard pane
. Now by clicking on right bottom corner of these reports you can maximize them as per your preference - Click
Save
and set the nameDashboard_{Name Initials}
- Click
Preview
to see your Dashboard (With one Historical and one Realtime Report)
Changelog:
Version | Comments | Author(s) | Date |
---|---|---|---|
1.0 | Initial Release | Krishna Tyagi (ktyagi) | 25 Jan 2021 |
1.1 | Final Release | Mike Turnbow (miturnbo) | 27 Jan 2021 |
1.2 | Final Release Video Fix | Mike Turnbow (miturnbo) | 27 Jan 2021 |