Lead Loader: Reset Duplicate Lead to NEW

Discussions about new features or changes in existing features

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

Lead Loader: Reset Duplicate Lead to NEW

Postby Acidshock » Mon Oct 22, 2018 9:26 am

Would be a nice feature to have the lead loader reset a duplicate lead to NEW and reset it's called count. This would be very useful for collection campaigns where you don't necessarily want to load a lead twice. Sometimes people have an account pay. Then go delinquent again.
VERSION: 2.14-698a | BUILD: 190207-2301 | Asterisk:13.24.1-vici | Vicibox 8.1.2
Acidshock
 
Posts: 413
Joined: Wed Mar 03, 2010 3:19 pm

Re: Lead Loader: Reset Duplicate Lead to NEW

Postby Acidshock » Mon Oct 22, 2018 9:27 am

Whoops. Think I should of posted this in dev and accidentally posted into features.
VERSION: 2.14-698a | BUILD: 190207-2301 | Asterisk:13.24.1-vici | Vicibox 8.1.2
Acidshock
 
Posts: 413
Joined: Wed Mar 03, 2010 3:19 pm

Re: Lead Loader: Reset Duplicate Lead to NEW

Postby williamconley » Mon Oct 22, 2018 5:52 pm

Update Lead is an option if you use the API to load leads. So collect your rejections and push them to the API to update the status to NEW.

On the other hand, having update options in web lead loader would probably be useful, too. ;)
Vicidial Installation and Repair, plus Hosting and Colocation
Newest Product: Vicidial Agent Only Beep - Beta
http://www.PoundTeam.com # 352-269-0000 # +44(203) 769-2294
williamconley
 
Posts: 19737
Joined: Wed Oct 31, 2007 4:17 pm
Location: Davenport, FL (By Disney!)

Re: Lead Loader: Reset Duplicate Lead to NEW

Postby roger.milligan » Thu Nov 15, 2018 6:57 am

I've done this with MySQL database triggers on insert into vicidial_list that look for the same vendor_lead_code & phone_number combo and update an existing lead rather than creating a duplicate. Site had 44 million leads in their Vici and doing this brought it down to 2 million! This also means that all the call history is linked to the same lead record which is so much easier for seeing past activity.

I can share my detailed logic if anyone wants to do the dev.
------------------------------------------------------------------------------------------------------
Roger Milligan
Thrive, Cape Town, South Africa.
Mobile: +27 791412325 rogerm(at)thrivedatasolutions(dot)com
roger.milligan
 
Posts: 45
Joined: Sun Jul 19, 2015 12:18 pm
Location: Cape Town, South Africa


Return to Features

Who is online

Users browsing this forum: No registered users and 3 guests