by 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