KPIs Calculator
Upload the CRM lead timeline sheet to calculate pipeline duration KPIs per salesperson, including LRT, TTP, TTIC, TTCC, and TTR.
● Service Available
Lead Response Time
Time to Proposal
Contract Speed
Salesperson Ranking
Service Owner
Sales Operations Team
Last Updated
June 28, 2026
Avg Run Time
7 seconds
Last Success
June 28, 2026 18:00
New KPI run
Upload the CRM lead timeline export. CSV and Excel files are supported.
Latest KPI Summary
High-level result from the latest successful CRM pipeline analysis.
Top Achiever
Esraa al zytoun
Total Leads
2229
Grouped by lead_id
Salespeople
28
Current pipeline owners
Proposals
153
Proposal / quotation stages
Client Contracts
75
Contract Signed by Client
Avg LRT
1176.21
Hours
Avg TTP
89.46
Days
Fastest Responder
Ahmed Allam
Lowest average LRT
Top Revenue Owner
Rehab Mohamed
Expected revenue total
HTML dashboard / printable report
2026/06/28/kpis_power_dashboard.html · 1.3 MB
Full KPI report workbook
2026/06/28/kpis_calculator_report.xlsx · 335.6 KB
Salesperson summary CSV
2026/06/28/kpis_salesperson_summary.csv · 3.2 KB
Lead KPI details CSV
2026/06/28/kpis_lead_details.csv · 459.8 KB
Metric Mapping
How the uploaded timeline is converted to KPIs.
LRTLead arrival → first Salesperson Assignment or meaningful Stage Change.
TTPLead arrival → Proposal Sent / Quotation Presented / Amendment Quotation.
TTICLead arrival → Contract Signed by NOK.
TTCCLead arrival → Contract Signed by Client.
TTRLatest contract date → Requisition stage. If no exact Requisition stage exists, the report flags inferred operational fallbacks.
Generated Report
The workbook includes these sheets.
- Printable HTML Dashboard with charts and raw-data view
- Executive Summary
- Salesperson Summary
- Lead KPI Details
- Stage Funnel
- Metric Definitions
- Data Quality
System Logs
Latest service events recorded for this module.
RUN-0023
Run completed
RUN-0023
Run started