Wrong number of sales team performance report

All installation and configuration problems and questions

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

Wrong number of sales team performance report

Postby dspaan » Fri Jul 31, 2020 4:06 am

When looking at the Team Performance Detail report we see 5 sales for an agent. The next day when the same report is used to look back at the previous day suddenly there are 6 sales visible. I supposed a cronjob is at play here.

I have looked in the database in the vicidial_agent_log and could only find 5 records with a status that qualifies as sale=Y.

I have also looked at the source code for AST_team_performance_detail.php but could not find a reason for the extra sale but i'm afraid my knowledge of coding is lacking here.

In inspected the 5 leads and noticed one of them was called twice that day but the first dispo result was not a sale status, could it be that the report counts the extra calls to the same lead ID as sale too if there was a sale on the same day?

edit:

I suppose this cronjob has something to do with it:

### fix the vicidial_agent_log once every hour and the full day run at night
33 * * * * /usr/share/astguiclient/AST_cleanup_agent_log.pl
50 0 * * * /usr/share/astguiclient/AST_cleanup_agent_log.pl --last-24hours
Regards, Dennis

Vicibox 9.0.1
Version: 2.14b0.5
SVN Version: 3199
DB Schema Version: 1588
Build: 200310-1801
dspaan
 
Posts: 1377
Joined: Fri Aug 21, 2009 1:40 pm
Location: The Netherlands

Return to Support

Who is online

Users browsing this forum: Google [Bot] and 104 guests