Subject: Audi/VW Dashboard - 14th March
From: Rohan Panwar <[email-masked]>
To: saurabh <[email-masked]>
Cc: deeksha <[email-masked]>, Gaurav Yadav <[email-masked]>
Date: Wed, 15 Mar 2023 05:36:04 -0700 (MST)

Hi sir, 
Given below is the report of AVME for Yesterday. 

				Audi/VW DashBoard 					
										
				Total Tickets 		CSAT Score 		Missed chats 		
	14-Mar 			274 		69% 		10 		

										
	Agent wise Chats and missed chats 			Agent wise CSAT 				
	14-Mar 	Total chats 	Missed chats 			Agent 	Rated chats 	Rated good 	CSAT % 	
	Mohammed Obiedo 	101 	6 			Mohammed Obiedo 	9 	8 	89% 	
	Hiba Wassowf 	21 	0 			Hiba Wassowf 	5 	3 	60% 	
	Nansy Saeed 	96 	2 			Nansy Saeed 	12 	5 	42% 	
	Kinan 	29 	2 			Kinan 	6 	5 	83% 	
	Mays 	27 	0 			Mays 	4 	4 	100% 	
										
	Agent wise DSAT 									
	Agent 	Rated chats 	Rated Bad 	DSAT 						
	Mohammed Obiedo 	9 	1 	11% 						
	Hiba Wassowf 	5 	2 	40% 						
	Nansy Saeed 	12 	7 	58% 						
	Kinan 	6 	1 	17% 						
	Mays 	4 	0 	0% 						

										

										

From: "Rohan Panwar" <[email-masked]> 
To: "saurabh" <[email-masked]> 
Cc: "deeksha" <[email-masked]>, "Gaurav Yadav" <[email-masked]> 
Sent: Tuesday, March 14, 2023 4:58:24 PM 
Subject: Audi Dashboard - 7th March to 13th March 

Hi sir, 
Given below is the report of Audi from 7th march to 13 march 

				Audi/VW DashBoard 					
										
Summary 7th March to 13th March 		Total Tickets 		CSAT Score 		Missed chats 		
				1780 		76% 		122 		

										
	Total ticket count day wise and missed chats 			Day-wise CSAT/DSAT rated ticked 			
	Date 	Total chats 	Missed chats 			Date 	Rated good 	Rated bad 		
	07-03-2023 	266 	20 			07-03-2023 	18 	7 		
	08-03-2023 	254 	25 			08-03-2023 	31 	5 		
	09-03-2023 	232 	16 			09-03-2023 	12 	7 		
	10-03-2023 	190 	16 			10-03-2023 	12 	5 		
	11-03-2023 	275 	16 			11-03-2023 	25 	9 		
	12-03-2023 	271 	13 			12-03-2023 	12 	1 		
	13-03-2023 	292 	16 			13-03-2023 	24 	7 		
										
	Agent wise CSAT 					Agent wise DSAT 				
	Agent 	Rated chats 	Rated good 	CSAT % 		Agent 	Rated chats 	Rated Bad 	DSAT 	
	Mohammed Obiedo 	41 	33 	80% 		Mohammed Obiedo 	41 	8 	20% 	
	Hiba Wassowf 	58 	41 	71% 		Hiba Wassowf 	58 	17 	29% 	
	Nansy Saeed 	35 	24 	69% 		Nansy Saeed 	35 	11 	31% 	
	Kinan 	23 	20 	87% 		Kinan 	23 	3 	13% 	
	Mays 	19 	16 	84% 		Mays 	19 	3 	16% 	

Thanks, 
Rohan 

From: "Rohan Panwar" <[email-masked]> 
To: "saurabh" <[email-masked]> 
Cc: "deeksha" <[email-masked]>, "Gaurav Yadav" <[email-masked]> 
Sent: Friday, March 10, 2023 2:27:04 PM 
Subject: Audi Dashboard - 4th March to 9th March 

Hi Sir, 

For Audi we can't access Agent wise performance, We have data only for total chat counts/missed chats and CSAT score only, from the data available i have tried to make the dashboard given below. 

					
	Audi/VW DashBoard 			
										
Summary 4th March to 9th March 		Total Tickets 		CSAT Score 		Missed chats 		
				1524 		79% 		101 		

										
	Total chats count day wise and missed chats 			Day-wise CSAT/DSAT rated chats 			
	Date 	Total chats 	Missed chats 			Date 	rated good 	rated bad 		
	04-03-2023 	242 	7 			04-03-2023 	18 	4 		
	05-03-2023 	229 	9 			05-03-2023 	24 	4 		
	06-03-2023 	301 	24 			06-03-2023 	34 	8 		
	07-03-2023 	266 	20 			07-03-2023 	18 	7 		
	08-03-2023 	254 	25 			08-03-2023 	31 	5 		
	09-03-2023 	232 	16 			09-03-2023 	12 	7 		
										
	Agent wise CSAT 					Agent wise DSAT 				
	Agent 	Rated chats 	Rated good 	CSAT % 		Agent 	Rated chats 	Rated Bad 	DSAT 	
	Mohammed Obiedo 	35 	30 	86% 		Mohammed Obiedo 	35 	5 	14% 	
	Hiba Wassowf 	40 	33 	83% 		Hiba Wassowf 	40 	7 	18% 	
	Nansy Saeed 	68 	52 	76% 		Nansy Saeed 	68 	16 	24% 	
	Kinan 	21 	16 	76% 		Kinan 	21 	5 	24% 	
	Mays 	16 	12 	75% 		Mays 	16 	4 	25% 	

										

	

	

Thanks, 
Rohan