Advanced Realtime Report

[SlavaE]

Since I've been working on this useful add-on last 12 months (and using it with 2 other people 45 hr/week), it gave me a lot of time to add a ton of extra functions to help all of our call-centers productivity and also made my job A LOT easier, also giving the ability to change lists and dialing strategy extremely fast (literally with 1-click, also using keyboard shortcuts).

Here, I will just give you a few screen shots:
http://slavae.com/wp-content/uploads/20 ... or-Mod.jpg
http://slavae.com/wp-content/uploads/20 ... -2-Mod.jpg
http://slavae.com/wp-content/uploads/20 ... -3-Mod.jpg

Since I was not making the script to sell or release, I will need to change a few things to make it available to anyone.

Also, it will be illegal to sell this, so please message me if you have any interest, or send an email to slava.eremenko@gmail(.)com
I may record a quick presentation and put it up on youtube with enough interest, or charge a setup fee to install the script

Cheers, Slava

[mflorell]

The screenshots look very interesting, but some of the stuff I see looks like it would be very database intensive to generate. Are you using caching data tables in MySQL or are you doing new queries to generate all of the graphing elements?

Did you use a programming framework or utility to create this?

Thanks for sharing

[SlavaE]

Thanks for the reply! Also thank you for vicidial for it being so easy to extend lol

Heres my cron-script for caching
*/5 * * * * curl http://192.168.1.253/vicidial/arr.lists ... ists_cache >> /srv/www/htdocs/maintenance/list_reseter_log.txt
*/5 * * * * sleep 150 && curl http://192.168.1.253/vicidial/arr.lists ... ists_cache >> /srv/www/htdocs/maintenance/list_reseter_log.txt
0 2 * * * curl http://192.168.1.253/vicidial/arr.lists ... rcent=true >> /srv/www/htdocs/maintenance/list_reseter_log.txt

There is a separate table "vicidial_lists_cache" for those stats. It gets updated for all lists nightly for stats like called_count, area codes etc.
Other important but processor-consuming stats are generated every 2.5 minutes (dialed percent, dialable leads count) ---- Only for active lists (which are those that has been called in last 2.5 min)
Other stats are generated in real time, and it only takes 0.5s to generate for the whole day,

I use that report about every 10 minutes to tweak lists depending on how they perform, or if manager thinks people on the list are broke, (you know how that goes),
stats in top right corner are: hopper reset toggle, sales, server seconds, memory used, processor load.

[SlavaE]

I used http://getbootstrap.com for tables and dropdowns.

[SlavaE]

Another feature would be checking for dups in campaign lists.
http://slavae.com/wp-content/uploads/20 ... itor-4.jpg

It is obviously takes the most processing time, but it is up to 10 times faster than built-in dup-checking feature, and you can also go retrospectively and check old lists against newer ones. I think this is quite useful, since sometimes you don't want to remove dups from expensive the lists that YOU JUST BOUGHT, but want to keep your system clean also.

Cheers,
Slava

[mav2287]

This looks awesome and kudos on sharing the code. I would be interested in it

[brett05]

great tools but can you share it please

[GaD]

This looks awesome! Congrats on the interface. Would definately like to try it out!

[mazhar996]

Dear SlavaE,
i need this advanced report. i contact you on your email a few days ago but i have not received any answer yet. if anyone else here can do that report customization, please contact me at mazhar996(at)gmail(dot)com

[williamconley]

Dear SlavaE,
i need this advanced report. i contact you on your email a few days ago but i have not received any answer yet. if anyone else here can do that report customization, please contact me at mazhar996(at)gmail(dot)com

We customize Vicidial and integrate it quite regularly for clients. If you want customization, choose the image/sample and send it to us for an estimate (along with your vicidial version).