Subject: HB KSA Dashboard - 1st Dec
From: Gaurav Yadav <[email-masked]>
To: yahia taha <[email-masked]>, hasan razakhan <[email-masked]>
Cc: saurabh <[email-masked]>, Syed Ataullah <[email-masked]>
Date: Fri, 2 Dec 2022 10:06:52 -0700 (MST)

Hi all, 

Given below is the HB KSA Dashboard for 1st Dec. 

				Homebox KSA 						
											
Tickets 											
Source 	Tickets 	First response time (average) 									
Emails 	24 	06:59:47 									
Whatsapp open 	73 	11:42:18 									
Whatsapp resolved 	5 										
Facebook 	18 	09:06:23 									
											
HB Auto Tag 											
Date 	Count 										
01-Dec-22 	477 										
											
Ageing Tickets 											
Tickets 	0-2 Days 	3-4 Days 	5-6 Days 	7-10 Days 	11-15 Days 	15+ Days 	Grand total 				
Emails 	25 	9 	6 	6 	2 	6 	54 				
Facebook 	3 	1 	0 	1 	0 	0 	5 				
WhatsApp 	66 	33 	15 	14 	3 	7 	138 				
Grand total 	94 	43 	21 	21 	5 	13 	197 				
											
Chats category (Top 10) 											
Date 	WWD Related 	Order Scheduling Related 	Delivery Related Within TAT 	Maintenance Related 	Presales 	Click and Collect 	Cancelation 	Damaged Delivery 	Change Address or Phone Number 	Return and Refund 	Others 
01-Dec-22 	21.5% 	9.0% 	7.7% 	4.8% 	4.6% 	3.6% 	3.3% 	3.3% 	2.9% 	2.9% 	36.2% 
											
WWD Related sub category 											
Date 	WWD - DO Created - Details Available 	WWD delay - Slot missed 	WWD - Reschedule - Slot not available - booked alternate date 	WWD delay - driver call not answered 	WWD - Rescheduled as per request 	WWD - Reschedule Request - Slot not available ask for other date options 	WWD - Reschedule - No Slot Available - create CRM 	Store or Amz Noon WWD Order not pulling on CRM GDMS 			
01-Dec-22 	28.2% 	27.2% 	19.4% 	7.8% 	7.8% 	4.9% 	2.9% 	1.9% 			
											
Order Scheduling Related Sub category 											
Date 	Order scheduled HB WWD 										
01-Dec-22 	100% 										
											
Delivery Related Within TAT Sub category 											
Date 	Order Shipped HH 	HH Order Out for Delivery 	WWD Order Already Delivered 	HH Order Already Delivered 	Order Not Shipped - HH 						
01-Dec-22 	73.0% 	10.8% 	8.1% 	5.4% 	2.7% 						
											
Maintenance Related Sub category 											
Date 	Timeframe for Inspection 	Follow-up ticket already created 	SRCC WHCC CC not covered in warranty 								
01-Dec-22 	60.9% 	34.8% 	4.3%