Call volume forecasting add-on?

Discussions about development of VICIDIAL and astGUIclient

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

Call volume forecasting add-on?

Postby vermorel » Fri Sep 21, 2007 5:22 am

Lokad is company that specializes in forecasting with a special interest for call centers. We would be very interested in developing a call volume forecasting add-on for VICIDIAL.

I would highly appreciate some community feedback on this matter to be sure that we are moving in the right direction.
- What would be the format that best suit your need to display the forecasts?
- What would you suggest to integrate such a feature in VICIDIAL?
- Any general remark on the subject?

Then, I am also very new to VICIDIAL, and I am very uncertain how to retrieve the inbound call logs. Could someone here give me some indications concerning the SQL tables we should look at?

Thanks in advance,
Joannès
Lokad call volume forecasting
vermorel
 
Posts: 8
Joined: Fri Sep 21, 2007 5:10 am
Location: Paris, France

Postby mflorell » Fri Sep 21, 2007 12:00 pm

Could you explain in a little more detail exactly what your inbound call forcasting does?

In VICIDIAL, all inbound calls are logged to the vicidial_closer_log table.
mflorell
Site Admin
 
Posts: 18335
Joined: Wed Jun 07, 2006 2:45 pm
Location: Florida

Postby vermorel » Fri Sep 21, 2007 12:24 pm

mflorell wrote:Could you explain in a little more detail exactly what your inbound call forcasting does?


Sorry for being quite unclear on that matter. Basically, raw call logs constitute a time-series that can be forecasted through statistical methods.

Here, the goal would be to provide hourly / half-hourly / quarter-hourly inbound call volume forecasts based on historical inbound call data. Those forecasts could then be used to optimize workforce capacity.
vermorel
 
Posts: 8
Joined: Fri Sep 21, 2007 5:10 am
Location: Paris, France

Postby mflorell » Fri Sep 21, 2007 1:45 pm

Sounds good. Thanks!
mflorell
Site Admin
 
Posts: 18335
Joined: Wed Jun 07, 2006 2:45 pm
Location: Florida

Postby Op3r » Fri Sep 21, 2007 7:40 pm

Kindly contact matt for that :D

And it really does sounds good....
Get paid for US outbound Toll Free calls. PM me.
Op3r
 
Posts: 1424
Joined: Wed Jun 07, 2006 7:53 pm
Location: Manila

Postby vermorel » Sat Sep 22, 2007 7:55 am

mflorell wrote:In VICIDIAL, all inbound calls are logged to the vicidial_closer_log table.


Thanks for the indication. Actually, I would like to retrieve something that would look like

Code: Select all
SELECT
   call_date,
   queue_name
FROM
   vicidial_closer_log


Yet, there is no such things as queue name in the vicidial_closer_log table. I must probably to a join with vicidial_campaigns.campaign_name

Could someone confirm my guess?

Thanks in advance,
Joannès

Note: I need a "queue" in order to provide meaningful call volume forecasts (i.e. aggregated at the right level).
vermorel
 
Posts: 8
Joined: Fri Sep 21, 2007 5:10 am
Location: Paris, France

Postby mflorell » Wed Sep 26, 2007 8:29 am

campaign_id is the field you are looking for, and it would link to the vicidial_inbound_groups.group_id field.

Inbound calls go into inbound groups.
mflorell
Site Admin
 
Posts: 18335
Joined: Wed Jun 07, 2006 2:45 pm
Location: Florida

Postby vermorel » Tue Oct 02, 2007 7:27 am

Thank to the indication posted here above, we have released "Lokad Desktop Workload Forecasting" with a native support for Vicidial, see
http://www.lokad.com/desktop-call-cente ... sting.ashx
(the application is released as open source but relies on the Lokad hosted forecasting technology)

We would be very interested in getting some community feedback for this application.

Best regards,
Joannès
vermorel
 
Posts: 8
Joined: Fri Sep 21, 2007 5:10 am
Location: Paris, France

Re: Call volume forecasting add-on?

Postby mflorell » Fri Apr 28, 2017 8:36 pm

It's been several years since Lokad stopped offering their vicidial forecasting reporting tools, so we decided a few months ago to start working on our own forecasting reports based upon the Erlang formulas.

We just added a couple of forecastingreports to svn/trunk. Here's a screenshot:

Image
mflorell
Site Admin
 
Posts: 18335
Joined: Wed Jun 07, 2006 2:45 pm
Location: Florida

Re: Call volume forecasting add-on?

Postby buns » Thu Nov 30, 2017 12:44 am

Very Nice ! Thx a Lot.
Vicidial Consultant in France and Indian Ocean. http://vicidial.fr
buns
 
Posts: 14
Joined: Thu Nov 23, 2017 1:59 am


Return to Development

Who is online

Users browsing this forum: No registered users and 46 guests