Wrong number of sales team performance report
Posted: Fri Jul 31, 2020 4:06 amWhen 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
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