Subject: Homebox UAE Dashboard 27-Feb-2023
From: Gaurav Yadav <[email-masked]>
To: Ahmed Zoher <[email-masked]>, Murtaza Kutiyanawala <[email-masked]>
Cc: saurabh <[email-masked]>, Syed Ataullah <[email-masked]>, Sameer Sadiq <[email-masked]>, Anunay Sharma <[email-masked]>, raja ramachandran <[email-masked]>, Muralidharan Gunjur <[email-masked]>
Date: Tue, 28 Feb 2023 01:57:08 -0700 (MST)

Hi all, 

Given below is the Homebox UAE dashboard for yesterday. I have also attached raw data for Ageing tickets. 

	
Homebox UAE 

									
Channel 	Volume 	SLA 1st Resp Time (%age) 	SLA Resolution Time (% age) 	Avg 1st response time 	Avg response Time 	Resolution Time 			
Whatsapp 	233 			0:01:52 	0:02:53 	0:14:27 			
Emails 	24 	100% 	100% 	0:46:03 	0:43:54 				
Facebook 	14 	63% 	100% 	2:51:00 	2:28:00 				
Instagram 									

Ageing Tickets (All Channels) 
									
Status 	0-2 Days 	3-4 Days 	5-6 Days 	7-10 Days 	11-15 Days 	15+ Days 	Grand total 		
Open 	17 	1 	2 	0 	0 	2 	22 		
Waiting on customer 	16 	1 	0 	0 	2 	0 	19 		
Waiting on 3rd party 	19 	2 	7 	8 	5 	20 	61 		
Pending 	3 	2 	4 	5 	0 	1 	15 		
Grand total 	52 	4 	9 	8 	7 	22 	117 		
									
WhatsApp chats category 
									
Date 	Inquiry 	Complaints 							
27-Feb-23 	84% 	16% 							
									
Inquiry Sub category 									
Date 	Post Order 	Pre Order 	Disconnected CALL 						
27-Feb-23 	71% 	25% 	4% 						
									
Post order Sub category 
									
Date 	Delivery Follow up 	Return Request/Creating RMA/Return to Store/Exchange 	Cancellation 	Click & Collect Follow Up 	Refund Follow up 				
27-Feb-23 	77% 	12% 	6% 	3% 	2% 				
									
Complaints Sub category 
									
Date 	WWD Damaged/Manufacturing Fault 	Late Delivery 	Mattress Complain 	Late C&C 	Order Not Shipped/Tracking Not generated 	Late Collection (Returns) 			
27-Feb-23 	35% 	29% 	12% 	12% 	6% 	6% 			

From: "Gaurav Yadav" <[email-masked]> 
To: "Ahmed Zoher" <[email-masked]>, "Murtaza Kutiyanawala" <[email-masked]> 
Cc: "saurabh" <[email-masked]>, "Syed Ataullah" <[email-masked]>, "Sameer Sadiq" <[email-masked]>, "Anunay Sharma" <[email-masked]>, "raja ramachandran" <[email-masked]>, "Muralidharan Gunjur" <[email-masked]> 
Sent: Monday, February 27, 2023 1:07:05 PM 
Subject: Homebox UAE Dashboard 26-Feb-2023 

Hi all, 

Given below is the Homebox UAE dashboard for yesterday. I have also attached raw data for Ageing tickets. 

	
Homebox UAE 

									
Channel 	Volume 	SLA 1st Resp Time (%age) 	SLA Resolution Time (% age) 	Avg 1st response time 	Avg response Time 	Resolution Time 			
Whatsapp 	158