Average Sale Time and Average Contact Time

All installation and configuration problems and questions

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

Average Sale Time and Average Contact Time

Postby saulortega » Wed Jun 18, 2014 12:26 pm

Hello.

On Team Performance Detail, how is calculated Average Sale Time and Average Contact Time?

Image

http://www.subeimagenes.com/img/sdasd-995882.png

I was unable to find a formula for it.
Last edited by saulortega on Fri Jun 20, 2014 11:18 am, edited 1 time in total.
saulortega
 
Posts: 118
Joined: Mon Jul 29, 2013 11:46 am

Re: Average Sale Time and Average Contact Time

Postby omarrodriguezt » Fri Jun 20, 2014 9:22 am

Hello,
You will be able to see the formula on each php file
$average_sale_time=sec_convert(round($sales_talk_time_array[$user]/$sale_array[$user]), 'H');
$average_contact_time=sec_convert(round($contact_talk_time/$contacts), 'H');

Avg Sale time total talk time for all sales divided by total sales.
Avg Sale time total talk time for all contacts divided by total contacs.
http://www.ITContinental.com
Dedicated USA Servers - Vicibox - Vicidial - Limesurvey - Vtiger CRM - More than 15 years experience - Hablamos Español
omarrodriguezt
 
Posts: 667
Joined: Fri Jun 05, 2009 12:22 pm
Location: Dominican Republic

Re: Average Sale Time and Average Contact Time

Postby saulortega » Fri Jun 20, 2014 11:17 am

So, 511(8:31)/1=30? (look the image) :P


Maybe it's a bug also?
saulortega
 
Posts: 118
Joined: Mon Jul 29, 2013 11:46 am

Re: Average Sale Time and Average Contact Time

Postby omarrodriguezt » Fri Jun 20, 2014 12:08 pm

is not a bug.
Notice,is NOT talk time divided by sales. It is total talk time handling sales, divided by sales. $average_sale_time=sec_convert(round($sales_talk_time_array[$user]/$sale_array[$user]), 'H');
http://www.ITContinental.com
Dedicated USA Servers - Vicibox - Vicidial - Limesurvey - Vtiger CRM - More than 15 years experience - Hablamos Español
omarrodriguezt
 
Posts: 667
Joined: Fri Jun 05, 2009 12:22 pm
Location: Dominican Republic

Re: Average Sale Time and Average Contact Time

Postby saulortega » Fri Jun 20, 2014 12:29 pm

Which is the "total talk time handling sales"?

It appears on this report?

Where appears?
saulortega
 
Posts: 118
Joined: Mon Jul 29, 2013 11:46 am

Re: Average Sale Time and Average Contact Time

Postby omarrodriguezt » Fri Jun 20, 2014 12:41 pm

It does not appear in the report.
Lets say you did 3 sales for today, and you spend 10 minutes for one sale, 15 for the second and 5 minutes for the third. You will have total SALES talk time, 30 minutes, divided by 3 sales, 10 minutes per sale average.
In other words, how many minutes average you spend for each sale
http://www.ITContinental.com
Dedicated USA Servers - Vicibox - Vicidial - Limesurvey - Vtiger CRM - More than 15 years experience - Hablamos Español
omarrodriguezt
 
Posts: 667
Joined: Fri Jun 05, 2009 12:22 pm
Location: Dominican Republic

Re: Average Sale Time and Average Contact Time

Postby saulortega » Fri Jun 20, 2014 1:04 pm

Okay, I get it, thanks.

It appears in Campaign Status List Report
saulortega
 
Posts: 118
Joined: Mon Jul 29, 2013 11:46 am


Return to Support

Who is online

Users browsing this forum: No registered users and 121 guests