hiadviser:
Your setup seams nice, don't understand your worries about not being effective, tell us more about your thoughts!
I'm using lead recycle too and combined with resetting lists.
My setup:
I migrated the old hand-made customer database ( MS-SQL
) to mysql, because I moved everything to vicidial (from some propiraty s**t)
so there it lives besides vicidial, I wrote a few scripts to manage that database.
the scripts takes customers (under certain criterias) from that database, table customers_X, and puts them into a campaign in vicidial,
when a SALE is made, those are imported to the database in an other table orders_X,
a third scripts creates invoices in the table invoices_X and creates pdf-files to be printed
and there is some scripts to update the invoices based on time and update them if they get paid etc, you get the picture
X is the campaign in question, but i realize that I should have just made the tables customers,orders,invoice
and have a field telling what campaign there is instead of spreading out the campaign in different tables...
I try to prevent cluttering down the vicidial database by updating the leads in vicidial_list instead of just import them again if its the same customers that is gonna be imported.
I recommend you other admins out there to not tinker too much with the vicidial database, you got to know how to debug if you do, because you will get into some problems.
but it seams to work pretty well with my method, all the calls are stored in vicidial_log anyway so I change stuff in vicidial_list and still keeps the history of the lead.
regarding lead recycle, I use the built in recycle function in vicidial, but its not enough for what i want, thats why I made a lead loader that takes leads from my "CRM" and imports them into vicidial_list
and updates the ones that got a NI,SALE,WN,DNC,A,NA etc that are not called in long enough time
Vicidial Partner. Region: Sweden/Norway.
Does Vicidial installation, configuration, customization, add-ons, CRM implementation, support, upgrading, network-related, pentesting etc. Remote and onsite assistance.
Email: domedan (at) gmail.com