Report Abandoned calls in Routing Strategy

Last month, I attended workshop from Genesys and BT and found an interesting trend. One of the customer shared that they were able to customer satisfaction and revenue by tracking and linking customer journey through multiple channels. For example, if customer selected products online for purchase and initiates call, they were able to link this and able to provide service. Simple and effective strategy.

Linking transactions across multiple channels is very big & interesting topic and will restrict to only voice channels in this post.

From my experience, I observed that many companies focus on active and answered calls by agent only. For example, C-SAT (Customer Satisfaction) survey are sent to customers which were answered by agent. What happens to customer disconnecting the call while waiting in queue? Most likely, these people are either looking for new service and simply switch to other provider. Others are left with no other option than wait 🙁 Imagine the potential loss of new customers and revenue..

In this post, I will explain how to record abandoned calls for reporting from the strategy (Francesc – Thanks for sharing this idea).

Database – Create Stored Procedure and Table

Configure DAP in CME

Create routing strategy for Abandoned Calls

Modify existing strategy to record abandoned calls

Database – Create Stored Procedure and Table

In my environment, I made decision to record ANI, DNIS, Conn ID and Timestamp and in most cases, it is sufficient for analysis or to schedule call backs.

Script to create table ‘CallDetails’

calldetails

Transact-SQL

1

2

3

4

5

6

7

8

createtable[dbo].[calldetails](

[callerani][nvarchar](50)null,

[callerdnis][nvarchar](50)null,

[timestamp][datetime]null,

[connectionid][nvarchar](50)null

)on[primary]

go

Script to create stored procedure ‘SP_UpdateCallDetails’

sp_updatecalldetails

Transact-SQL

1

2

3

4

5

6

7

8

9

10

createprocedure[dbo].[sp_updatecalldetails]

@varaninvarchar(30),

@vardnisnvarchar(30),

@varconnidnvarchar(30)

as

begin

insertintocalldetailsvalues(@varani,@vardnis,getdate(),@varconnid)

end

go

Configure DAP in CME

Using Genesys Administrator or Configuration Manager, create new DAP ‘CustomDAP’ to point to reporting database

Create routing strategy for Abandoned Calls

Open IRD and create new routing strategy ‘RecordAbandonedCalls’ as below