Go to the Statistic > Lead Aging Report
In this report, we have two reports:
1. Leads Aging Report by Project/Phases/RAs – summary of the lead aging report.
2. Attended Aging Report by Project/Phases/RAs – detailed breakdown for Total Attended Leads
Leads Aging Report by Project/Phases/RAs
Description of each of the columns:
- Total Leads – Total Leads owned by the sales rep within the date range do not include the deleted deal.
 - Total Attended Leads – Total leads that are in Progressing status, Follow Up status, closed as Won deal and closed as a Lost deal.
 - Total Unattended Leads – Total leads that are Not Contactable, status of the lead is New Lead.
 - For Pending Aging column, it is the breakdown of the Total Unattended Leads:
- 5 Days – total unattended leads are within 5 days from the selected end date. 
Eg: Total unattended leads (all open leads with Not Contacted status from 15/12/2022 to 20/12/2022. - 10 Days – total unattended leads are within 10 days from the selected end date not including the total leads within 5 days.
Eg: Total unattended leads (all open leads with Not Contacted status from 10/12/2022 to 20/12/2022 (-) total unattended leads from 5 Days. 
- 15 Days – total unattended leads are within 15 days from the selected end date not including the total leads within 5 and 10 days.
Eg: Total unattended leads (all open leads with Not Contacted status from 05/12/2022 to 20/12/2022 (-) total unattended leads from 5 Days (-) total unattended leads from 10 Days. 
- 30 Days – total unattended leads are within 30 days from the selected end date not including the total leads within 5, 10 and 15  days.
Eg: Total unattended leads (all open leads with Not Contacted status from 20/11/2022 to 20/12/2022 (-) total unattended leads from 5 Days (-) total unattended leads from 10 Days (-) total unattended leads from 30 Days. - >30 Days – total unattended leads of more than 30 days not including the total leads within 5, 10, 15 and 30 days.
Eg: Total unattended leads (all open leads with Not Contacted status) before 19/11/2022. 
 - 5 Days – total unattended leads are within 5 days from the selected end date. 
 
Attended Aging Report by Project/Phases/RAs
- Total Attended Leads – Same as total attended column in Lead Aging Report.
 - First Response Time (median Hours) – Refers to the response time taken by the sales rep to make the first response such as call, add notes and schedule activities to the deal.
 - Average Call Duration (Seconds) – Total call duration of the leads (secs) (/) total call activities made.
 - Average No. of Follow-Up per Lead – Total core activities and calls made (/) total of the attended deal.
 - The aging Column, is referred to Total Attended Leads:
- 5 Days – total attended leads are within 5 days from the selected end date.
 - 10 Days – total attended leads are within 10 days from the selected end date. not including the total leads within 5 days.
 - 15 Days – total attended leads are within 15 days before the ending date not including the total leads within 5 and 10 days.
 - 30 Days – total attended leads are within 30 days before the ending date not including the total leads within 5, 10 and 15 days.
 - >30 Days – total attended leads of more than 30 days not including the total leads within 5, 10, 15 and 30 days.
 
 
