Page 1 of 1

Advanced Realtime Report

PostPosted: Thu Sep 26, 2013 5:01 pm
by 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

Re: Advanced Realtime Report

PostPosted: Thu Sep 26, 2013 10:18 pm
by 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 :)

Re: Advanced Realtime Report

PostPosted: Fri Sep 27, 2013 1:54 pm
by 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.

Re: Advanced Realtime Report

PostPosted: Fri Sep 27, 2013 1:56 pm
by SlavaE
I used http://getbootstrap.com for tables and dropdowns.

Re: Advanced Realtime Report

PostPosted: Fri Sep 27, 2013 6:51 pm
by 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

Re: Advanced Realtime Report

PostPosted: Tue Oct 29, 2013 6:35 pm
by mav2287
This looks awesome and kudos on sharing the code. I would be interested in it

Re: Advanced Realtime Report

PostPosted: Wed Oct 30, 2013 4:21 am
by brett05
great tools but can you share it please

Re: Advanced Realtime Report

PostPosted: Thu Nov 21, 2013 6:50 pm
by GaD
This looks awesome! Congrats on the interface. Would definately like to try it out!

Re: Advanced Realtime Report

PostPosted: Fri Dec 13, 2013 10:58 am
by 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

Re: Advanced Realtime Report

PostPosted: Fri Dec 13, 2013 11:37 am
by williamconley
mazhar996 wrote: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).