Genesys CTI User Forum

Genesys CTI User Forum => Genesys CTI Technical Discussion => Topic started by: cavagnaro on January 19, 2009, 11:37:07 PM

Title: Finding no contacted numbers in OCS calling list
Post by: cavagnaro on January 19, 2009, 11:37:07 PM

Hi guys,
One question, have any of you created a query to find which numbers (not how many) or better said, contacts, have been not contacted after the campaign have ended at the end of the day?
Thanks

Title: Re: Finding no contacted numbers in OCS calling list
Post by: blakshmikanth on January 20, 2009, 04:27:46 PM

select count(*) from <table_name> where attempt = 0 and chain_n in (select distinct(chain_n) from <table_name>)

Cheers,
Lucky

Title: Re: Finding no contacted numbers in OCS calling list
Post by: PhoneBill on January 20, 2009, 04:58:38 PM

Don't forget to account for any dialing filter that might be applied to the campaign calling list as well as other factors such as if you are checking after the last dial_till time. Checking after you unload the campaign will ensure there aren't any in progress as well.

Title: Re: Finding no contacted numbers in OCS calling list
Post by: cavagnaro on January 20, 2009, 05:35:44 PM

Yes attempt=0 will do a part, but for example, a chain_id with 3 chain_n and all 3 chains gave me No Answer will have attempt > 0 and even is not a contacted customer because we dialed and tried but no answer from remote side. Same for busy, faxes, SIT, etc.
I have a query with these values but I believe I might be missing some ideas.

Title: Re: Finding no contacted numbers in OCS calling list
Post by: cavagnaro on January 26, 2009, 09:16:05 PM

Taking blakshmikanth query as a base I believe this can be the one:

select * from <table> where call_result!=33
and chain_id not in(select distinct chain_id from <table> where call_result=33)

What do you think?

Title: Re: Finding no contacted numbers in OCS calling list
Post by: blakshmikanth on January 27, 2009, 11:01:59 AM

Cavangro,

As you are aware, chain_id may contain 'n' records for a single contact and will return more number of records than expected.

To find the no. of contacts, I modified the query as below

select count(*) from
(
select distinct chain_id from <table> where chain_id not in
(select chain_id from <table> where call_result=33)
)

Is it helpful?

Regards,
Lucky

Title: Re: Finding no contacted numbers in OCS calling list
Post by: cavagnaro on January 27, 2009, 05:58:52 PM

Yes, in order to determine the ammount of customers  :D
Thanks!