Page 1 of 1

How to set priorities for leads within an outbound campaign?

PostPosted: Fri Jul 02, 2010 5:34 am
by marmu
If have come by the "queue_priority" in the admin-GUI-help which influences:
1) outbound vs. inbound
2) inbound vs. other inbound

what I am looking for is a priority influencing the dialing of leads within one outbound campaign. I think this is not implemented. Any hints on how this can be done? Perhaps adding leads directly in the hopper instead of the vicidial_list? Or may working with "vicidial_hopper.priority" be useful?

Further, what is the meaning of the columns "vicidial_list.rank" and "vicidial_hopper.priority"?

EDIT: Found out, that if
vicidial_list.rank = '1' and vicidial_campaigns.lead_order = 'DOWN RANK'
-> leads with rank = '1' get a higher priority
Am I right?

Thanks for your help!

Cheers,
Marcus

PostPosted: Fri Jul 02, 2010 7:06 am
by mflorell
Yes, this is what RANK is for, it is new in 2.2.1

PostPosted: Fri Jul 02, 2010 8:50 am
by marmu
great, thanks for implementing ;) Again I safe some time, that I can invest in implementing a kind of "campaign-switch"

PostPosted: Mon Aug 09, 2010 10:50 am
by marmu
Hi Guys,

another quesion concerning priorities and how vicidial handles them.

Within vicidial_list leads got a priority using rank, but this priority cannot be found within vicidial_hopper. there is a column called 'priority' which is always '0'.
How is the table vicidial_hopper processed within vicidial? Is the priority which is set in vicidial'_list always respected (I think so)? And how is it respected?

I thought of some kind of first in first out order, where the priority is respected while loading leads from the vicidial_list (with priority) into the vicidial_hopper.

Thanks for any explanation.

Cheers,
Marcus

PostPosted: Mon Aug 09, 2010 4:52 pm
by mflorell
The hopper is first in and first out, except for scheduled callbacks, lead recycling and auto-alt-dial, all of which take priority over standard leads loading by the hopper.

PostPosted: Tue Aug 10, 2010 7:09 am
by marmu
thanks again matt!

PostPosted: Sat Oct 23, 2010 10:10 am
by schernit
Matt,

We have MANUAL OR INBOUND-MAN outbound campaigns to sale different products. When we insert records on vicidial_list we may know what records has better possibilities to be a SALE so we could categorize them with a rank (0 - bad record / 10 very good record).

So, We want that leads on hopper be sent to better agents (the one that has better sale skill). We think It can improve sales and well use of leads.

What I was thinking is:

- Hopper works exactly on same way as usual (just add rank column on hopper table)
- Process that select what lead to be sent to an agent can select lead_id from hopper looking for agent Rank and lead_id rank. I think It should only affect vdc_db_query.php method: manDiaLnextCaLL

--------------

$stmt = "UPDATE vicidial_hopper set status='QUEUE', user='$user' where campaign_id='$campaign' and status='READY' order by priority desc,hopper_id LIMIT 1";

if ($DB) {echo "$stmt\n";}
$rslt=mysql_query($stmt, $link);
if ($mel > 0) {mysql_error_logging($NOW_TIME,$link,$mel,$stmt,'00024',$user,$server_ip,$session_name,$one_mysql_log);}
$affected_rows = mysql_affected_rows($link);

--------------

With samething like this:

--------------
$stmt = "UPDATE vicidial_hopper set status='QUEUE', user='$user' where campaign_id='$campaign' and status='READY' and rank <= '$userRank' order by rank desc, priority desc,hopper_id LIMIT 1"; ## rank is a new column on hopper table

if ($DB) {echo "$stmt\n";}
$rslt=mysql_query($stmt, $link);
if ($mel > 0) {mysql_error_logging($NOW_TIME,$link,$mel,$stmt,'00024',$user,$server_ip,$session_name,$one_mysql_log);}
$affected_rows = mysql_affected_rows($link);

if ($affected_rows<1){

## no records with that rank. Need to take a higher hopper rank

$stmt = "UPDATE vicidial_hopper set status='QUEUE', user='$user' where campaign_id='$campaign' and status='READY' and rank > '$userRank' order by rank, priority desc,hopper_id LIMIT 1"; ## rank is a new column on hopper table

if ($DB) {echo "$stmt\n";}
$rslt=mysql_query($stmt, $link);
if ($mel > 0) {mysql_error_logging($NOW_TIME,$link,$mel,$stmt,'00024',$user,$server_ip,$session_name,$one_mysql_log);}
$affected_rows = mysql_affected_rows($link);

}
--------------

What do you think of this feature ?

PostPosted: Sat Oct 23, 2010 10:17 am
by mflorell
That looks like a workable patch, but there are other places in the code you will need to alter as well. Also, adding it as a permanent feature will take adding a web-config option for it to campaigns as well.

PostPosted: Sat Oct 23, 2010 10:31 am
by schernit
Matt,

I would love to change it and create a patch for it but I didnĀ“t do it.

do I need to be on the last vicidial version ? I am now on:

$version = '2.4-162';
$build = '100908-1102';

What should I do ?

- make changes
- create a patch file
- upload patches (where ?)

PostPosted: Sat Oct 23, 2010 10:51 am
by mflorell
Yes, you do need to be on the latest SVN/trunk snapshot.

You can upload your patches to the Issue Tracker(link at the top of this page)

Re: How to set priorities for leads within an outbound campa

PostPosted: Mon Jun 18, 2018 10:58 pm
by vijo
HAi,

Is there any option in vicidial hopper ..the lead which are came last has to dial out(LIFO) first bases on the priority.