PRODUCT
Mobile Number Deviation is a key performance indicator (KPI) utilized within the service industry to measure the inconsistency or discrepancy between the mobile phone numbers provided by customers or clients during service interactions and those stored in the organization's database. This metric quantifies the extent to which mobile phone numbers provided by customers differ from the records maintained by the organization, highlighting potential inaccuracies or gaps in customer data management processes.
This metric helps keep track of accuracy of the service staff in collecting the right phone number details of a customer
COUNT(SRN) where : Mobile_Num_Deviation ='Y' and Status in ('Closed', 'Completed') / COUNT(SRN) as tot_count where : Status in ('Closed', 'Completed')