Subject: HB KSA Dashboard
From: Gaurav Yadav <[email-masked]>
To: saurabh <[email-masked]>
Date: Tue, 29 Nov 2022 00:17:14 -0700 (MST)

Hi sir, 

Given below is updated 

			HB KSA Dashboard 							
											
Email Tickets 											
Week 	Email Tickets 	Average 1st response time 									
1st Nov to 6th Nov 	93 	05:42:00 									
7th Nov - 13th Nov 	75 	05:53:20 									
14th Nov - 20th Nov 	126 	06:26:08 									
21st Nov - 27th Nov 	176 	05:01:15 									

Chat category 											
Week 	Customer Services 	Mattress Related 	No Answer 	PreSales 							
1st Nov to 6th Nov 	75% 	1% 	12% 	12% 							
7th Nov - 13th Nov 	96% 		1% 	3% 							
14th Nov - 20th Nov 	96% 			4% 							
21st Nov - 27th Nov 	96% 	0.4% 		3.6% 							
											
Customer Services category 											
Week 	App and Website Issues 	Delivery Related 	Product Complaint 	Refunds and Cancelations 							
1st Nov to 6th Nov 	0.5% 	81% 	12% 	7% 							
7th Nov - 13th Nov 		28% 	64% 	7% 							
14th Nov - 20th Nov 	1% 	51% 	41% 	8% 							
21st Nov - 27th Nov 	1% 	58% 	34% 	6% 							
											
Delivery Related Sub category 											
Week 	Delivery Status 	Delayed Delivery (HH) 	Day of Delivery - Status 	Damage during delivery 	Delayed Delivery (Furniture) 	Fresh fixing pending 	Missing items\parts 	Partial Delivery 	Reschedule Delivery 	Wrong commitments 	
1st Nov to 6th Nov 	44% 	5% 	38% 	2% 	1% 	1% 	2% 	2% 	5% 	2% 	
7th Nov - 13th Nov 	63% 	32% 						5% 			
14th Nov - 20th Nov 	69% 	13% 	4% 		6% 		2% 	6% 		2% 	
21st Nov - 27th Nov 	29% 	17% 	33% 	3% 	6% 	1% 	5% 	5% 	2% 	1% 	
											
Product Complaint Sub category 											
Week 	Complaint within Warranty 	Complaint outside Warranty 									
1st Nov to 6th Nov 	92% 	8% 									
7th Nov - 13th Nov 	98% 	3% 									
14th Nov - 20th Nov 	98% 	2% 									
21st Nov - 27th Nov 	97% 	3% 									
											
Refunds and Cancelations Sub category 											
Week 	Cancelation 	Refunds after Return 	Delay collection 	Refund for Other reason 	Return item not received 	Return Request Initiation 					
1st Nov to 6th Nov 	29% 	21% 	7% 		7% 	36% 					
7th Nov - 13th Nov 	20% 	40% 	20% 	20% 							
14th Nov - 20th Nov 	50% 	30% 	10% 			10% 					
21st Nov - 27th Nov 	8% 	31% 	15% 		8% 	38% 					

From: "Gaurav Yadav" <[email-masked]> 
To: "saurabh" <[email-masked]> 
Sent: Monday, November 28, 2022 2:50:47 PM 
Subject: HB KSA Dashboard 

Hi sir, 

Given below is the dashboard for this month for HB KSA. 

			HB KSA Dashboard 							
											
Email Tickets 											
Week 	Email Tickets 	Average 1st response time 									
1st Nov to 6th Nov 	93 	02:19:00 									
7th Nov - 13th Nov 	75 	02:10:38 									
14th Nov - 20th Nov 	126 	02:09:00 									
21st Nov - 27th Nov 	176 	02:05:45 									

Chat category 											
Week 	Customer Services 	Mattress Related 	No Answer 	PreSales 							
1st Nov to 6th Nov 	75% 	1% 	12% 	12% 							
7th Nov - 13th Nov 	96% 		1% 	3% 							
14th Nov - 20th Nov 	96% 			4% 							
21st Nov - 27th Nov 	96% 	0.4% 		3.6% 							
											
Customer Services category 											
Week 	App and Website Issues 	Delivery Related 	Product Complaint 	Refunds and Cancelations 							
1st Nov to 6th Nov 	0.5% 	81% 	12% 	7% 							
7th Nov - 13th Nov 		28% 	64% 	7% 							
14th Nov - 20th Nov 	1% 	51% 	41% 	8% 							
21st Nov - 27th Nov 	1% 	58% 	34% 	6% 							
											
Delivery Related Sub category 											
Week 	Delivery Status 	Delayed Delivery (HH) 	Day of Delivery - Status 	Damage during delivery 	Delayed Delivery (Furniture) 	Fresh fixing pending 	Missing items\parts 	Partial Delivery 	Reschedule Delivery 	Wrong commitments 	
1st Nov to 6th Nov 	44% 	5% 	38% 	2% 	1% 	1% 	2% 	2% 	5% 	2% 	
7th Nov - 13th Nov 	63% 	32% 						5% 			
14th Nov - 20th Nov 	69% 	13% 	4% 		6% 		2% 	6% 		2% 	
21st Nov - 27th Nov 	29% 	17% 	33% 	3% 	6% 	1% 	5% 	5% 	2% 	1% 	
											
Product Complaint Sub category 											
Week 	Complaint within Warranty 	Complaint outside Warranty 									
1st Nov to 6th Nov 	92% 	8% 									
7th Nov - 13th Nov 	98% 	3% 									
14th Nov - 20th Nov 	98% 	2% 									
21st Nov - 27th Nov 	97% 	3% 									
											
Refunds and Cancelations Sub category 											
Week 	Cancelation 	Refunds after Return 	Delay collection 	Refund for Other reason 	Return item not received 	Return Request Initiation 					
1st Nov to 6th Nov 	29% 	21% 	7% 		7% 	36% 					
7th Nov - 13th Nov 	20% 	40% 	20% 	20% 							
14th Nov - 20th Nov 	50% 	30% 	10% 			10% 					
21st Nov - 27th Nov 	8% 	31% 	15% 		8% 	38%