How to set priorities for leads within an outbound campaign?

All installation and configuration problems and questions

Moderators: gerski, enjay, williamconley, Op3r, Staydog, gardo, mflorell, MJCoate, mcargile, Kumba, Michael_N

Is setting of priorities within one outbound campaign of any use for you?

yes
7
78%
no
0
No votes
maybe
2
22%
 
Total votes : 9

How to set priorities for leads within an outbound campaign?

Postby marmu » Fri Jul 02, 2010 5:34 am

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
marmu
 
Posts: 190
Joined: Fri Mar 12, 2010 6:57 am

Postby mflorell » Fri Jul 02, 2010 7:06 am

Yes, this is what RANK is for, it is new in 2.2.1
mflorell
Site Admin
 
Posts: 18335
Joined: Wed Jun 07, 2006 2:45 pm
Location: Florida

Postby marmu » Fri Jul 02, 2010 8:50 am

great, thanks for implementing ;) Again I safe some time, that I can invest in implementing a kind of "campaign-switch"
marmu
 
Posts: 190
Joined: Fri Mar 12, 2010 6:57 am

Postby marmu » Mon Aug 09, 2010 10:50 am

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
Vicibox redux 3.1.10 64 bit (ViciBox_Redux.x86_64-3.1.10.iso)
Admin-GUI: VERSION: 2.4-310a - BUILD: 110506-1537 - with some adaptions :)
Asterisk 1.4.39.2-vici | Single Server | wanpipe_voicetime
2x Intel(R) Xeon(R) X5650 | 12 GB | SAS 15k RAID1
marmu
 
Posts: 190
Joined: Fri Mar 12, 2010 6:57 am

Postby mflorell » Mon Aug 09, 2010 4:52 pm

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.
mflorell
Site Admin
 
Posts: 18335
Joined: Wed Jun 07, 2006 2:45 pm
Location: Florida

Postby marmu » Tue Aug 10, 2010 7:09 am

thanks again matt!
Vicibox redux 3.1.10 64 bit (ViciBox_Redux.x86_64-3.1.10.iso)
Admin-GUI: VERSION: 2.4-310a - BUILD: 110506-1537 - with some adaptions :)
Asterisk 1.4.39.2-vici | Single Server | wanpipe_voicetime
2x Intel(R) Xeon(R) X5650 | 12 GB | SAS 15k RAID1
marmu
 
Posts: 190
Joined: Fri Mar 12, 2010 6:57 am

Postby schernit » Sat Oct 23, 2010 10:10 am

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 ?
schernit
 
Posts: 58
Joined: Sun Sep 16, 2007 6:02 pm

Postby mflorell » Sat Oct 23, 2010 10:17 am

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.
mflorell
Site Admin
 
Posts: 18335
Joined: Wed Jun 07, 2006 2:45 pm
Location: Florida

Postby schernit » Sat Oct 23, 2010 10:31 am

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 ?)
schernit
 
Posts: 58
Joined: Sun Sep 16, 2007 6:02 pm

Postby mflorell » Sat Oct 23, 2010 10:51 am

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)
mflorell
Site Admin
 
Posts: 18335
Joined: Wed Jun 07, 2006 2:45 pm
Location: Florida

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

Postby vijo » Mon Jun 18, 2018 10:58 pm

HAi,

Is there any option in vicidial hopper ..the lead which are came last has to dial out(LIFO) first bases on the priority.
vijo
 
Posts: 40
Joined: Tue Feb 14, 2017 12:33 am


Return to Support

Who is online

Users browsing this forum: No registered users and 90 guests