Mesina Capistrano | Freelancer Portfolio Item #172643

Productivity Report (bottom bubble) Date Shift Dials Completed Calls Inbound Calls Total set % set Shows Ellaine Al Xena Sophia Leo John Kristine Ralph Allen Charlie Erika - - - - - - - - - 12.12% 62.50% 40.00% 26.67% #VALUE! 55.56% 0.00% 50.00% 30.00% 14.29% #VALUE! - 8-7 8-7 OFF OFF BDC & Sales Management Report Elite/ Date MTD Leads MTD Set appts MTD Shows MTD set/show% MTD Show/Lead% CarWise/Date MTD Leads MTD Set appts MTD Shows Ellaine Al Xena Maria Sophia Leo John Kristine Ralph Allen Charlie Erika - - - 55.56% #DIV/0! 25.00% #DIV/0! 83.33% #DIV/0! 66.67% 50.00% #DIV/0! #DIV/0! 75.00% 37.50% 26.32% #DIV/0! 20.00% #DIV/0! 41.67% #DIV/0! 150.00% 8.33% #DIV/0! #DIV/0! #DIV/0! #DIV/0! Ellaine Al Xena Maria Sophia Leo John Kristine Ralph Allen Charlie Erika - - - MTD set/show % MTD Show/Lead% #DIV/0! 20.00% #DIV/0! #DIV/0! #DIV/0! 40.00% #DIV/0! #DIV/0! 66.67% 75.00% #DIV/0! #DIV/0! #DIV/0! 20.00% #DIV/0! #DIV/0! 0.00% #DIV/0! #DIV/0! #DIV/0! 100.00% 150.00% #DIV/0! #DIV/0! Productivity Report Date Ellaine Al Xena Maria Sophia Leo John Kristine Ralph Allen Charlie Erika (bottom bubble) Shift Dials Completed Calls Inbound Calls Total set % set 10-7 10-7 OFF OFF OFF 3-7 OFF 10 - 100 121 15 7 5 1 4 0 61 1 0 0 - 2 4 7 7 0 0 2 2 2 1 3 20.00% 0.00% #DIV/0! #DIV/0! #DIV/0! #DIV/0! 0.00% #DIV/0! 100.00% 50.00% 14.29% 33.33% Shows BDC & Sales Management Report Elite/ Date MTD Leads MTD Set appts MTD Shows MTD set/show% MTD Show/Lead% CarWise/Date Ellaine Al Xena Maria Sophia Leo John Kristine Ralph Allen Charlie Erika 34 9 5 55.56% #DIV/0! 25.00% #DIV/0! 83.33% #DIV/0! 66.67% #DIV/0! #DIV/0! #DIV/0! 66.67% 37.50% 14.71% #DIV/0! 20.00% #DIV/0! 41.67% #DIV/0! 100.00% #DIV/0! #DIV/0! #DIV/0! 25.00% 25.00% Ellaine Al Xena Maria Sophia Leo John Kristine Ralph Allen Charlie Erika 5 4 1 12 6 5 6 9 6 8 12 3 8 2 3 MTD Leads MTD Set appts MTD Shows 11 5 1 1 0 5 2 7 6 4 3 2 3 MTD set/show % MTD Show/Lead% #DIV/0! 20.00% #DIV/0! #DIV/0! #DIV/0! 40.00% #DIV/0! #DIV/0! 50.00% 100.00% #DIV/0! #DIV/0! #DIV/0! 9.09% #DIV/0! #DIV/0! 0.00% #DIV/0! #DIV/0! #DIV/0! 28.57% 50.00% #DIV/0! #DIV/0! Productivity Report (bottom bubble) Date Shift Dials Completed Calls Inbound Calls Total set % set Shows Ellaine Al Xena Sophia Leo John Kristine Ralph Allen Charlie Erika - OFF 8-6 10-8 - - - - 30.61% 62.50% 0.00% #VALUE! 33.33% 50.00% 46.67% 133.33% #VALUE! 29.41% 23.81% - 8-7 OFF 8-9 8-7 BDC & Sales Management Report Elite/ Date MTD Leads MTD Set appts MTD Shows MTD set/show% MTD Show/Lead% CarWise/Date MTD Leads MTD Set appts MTD Shows Ellaine Al Xena Maria Sophia Leo John Kristine Ralph Allen Charlie Erika - - - 66.67% #DIV/0! 33.33% #VALUE! 66.67% #DIV/0! 83.33% 50.00% #DIV/0! #DIV/0! 71.43% 42.86% 22.22% #DIV/0! 15.38% #VALUE! 54.55% #DIV/0! 111.11% 6.90% #DIV/0! #DIV/0! 20.83% 20.69% Ellaine Al Xena Maria Sophia Leo John Kristine Ralph Allen Charlie Erika - - - MTD set/show % MTD Show/Lead% #DIV/0! 37.50% #DIV/0! #DIV/0! #DIV/0! 62.50% #DIV/0! 0.00% 60.00% 66.67% #DIV/0! #DIV/0! #DIV/0! 15.79% #DIV/0! #DIV/0! 0.00% 83.33% #DIV/0! 0.00% 33.33% 50.00% #DIV/0! #DIV/0! Productivity Report (bottom bubble) Date Shift Dials Completed Calls Inbound Calls Total set % set Shows Ellaine Al Xena Maria Sophia Leo John Kristine Ralph Allen Charlie Erika - OFF 8-7 OFF 8-4 10-9 - - 10 3 1 7 31.25% 55.56% 37.50% #VALUE! 42.86% 25.00% 100.00% #VALUE! 71.43% #VALUE! 12.50% 12.50% 1 2 2 - 1 2 - 0 2 1 1 1 2 BDC & Sales Management Report Elite/ Date MTD Leads MTD Set appts MTD Shows MTD set/show% MTD Show/Lead% CarWise/Date MTD Leads MTD Set appts MTD Shows Ellaine Al Xena Maria Sophia Leo John Kristine Ralph Allen Charlie Erika - - - 59.09% #DIV/0! 28.57% #DIV/0! 66.67% #DIV/0! 84.62% 40.00% #DIV/0! #DIV/0! 60.00% 47.37% 18.84% #DIV/0! 11.11% #DIV/0! 33.33% #DIV/0! 68.75% 5.26% #DIV/0! #DIV/0! 22.22% 25.00% Ellaine Al Xena Maria Sophia Leo John Kristine Ralph Allen Charlie Erika - - - MTD set/show % MTD Show/Lead% #DIV/0! 41.67% #DIV/0! #DIV/0! #DIV/0! 66.67% #DIV/0! 0.00% 28.57% 75.00% #DIV/0! #DIV/0! #DIV/0! 15.63% #DIV/0! #DIV/0! #DIV/0! 42.86% #DIV/0! 0.00% 16.67% 66.67% #DIV/0! #DIV/0! Productivity Report (bottom bubble) Date Shift Dials Completed Calls Inbound Calls Total set % set Ellaine Al Xena Sophia Leo John Kristine Ralph Allen Charlie Erika off- - - - - #VALUE! 38.46% 16.67% 66.67% 28.57% 50.00% #REF! #VALUE! 46.15% 50.00% 17.65% OFF- Shows - BDC & Sales Management Report Elite/ Date MTD Leads MTD Set appts MTD Shows MTD set/show% MTD Show/Lead% CarWise/Date Ellaine Al Xena Maria Sophia Leo John Kristine Ralph Allen Charlie Erika 68 1 26 15 2 2 34 - 22 52 15 9 12 4 35 44 14 19 10 12 60.00% 100.00% 25.00% 0.00% 57.89% #DIV/0! 80.00% 44.44% #DIV/0! #DIV/0! 71.43% 63.16% 22.06% 200.00% 7.69% #DIV/0! 32.35% #DIV/0! 54.55% 7.69% #DIV/0! #DIV/0! 28.57% 27.27% Ellaine Al Xena Maria Sophia Leo John Kristine Ralph Allen Charlie Erika 11 MTD Leads MTD Set appts MTD Shows 29 13 6 19 10 7 2 12 17 1 8 7 0 3 6 MTD set/show % MTD Show/Lead% #DIV/0! 46.15% #DIV/0! #DIV/0! #DIV/0! 70.00% #DIV/0! 0.00% 37.50% 85.71% #DIV/0! #DIV/0! #DIV/0! 20.69% #DIV/0! #DIV/0! #DIV/0! 36.84% #DIV/0! 0.00% 25.00% 35.29% #DIV/0! #DIV/0! Productivity Report (bottom bubble) Date Shift Dials Completed Calls Inbound Calls Total set % set Shows Ellaine Al Xena Maria Sophia Leo John Kristine Ralph Allen Charlie Erika - - *- - - - #DIV/0! 22.22% 0.00% #VALUE! 50.00% 37.50% 57.14% 40.00% 100.00% 55.56% 0.00% 28.57% 2 2 1 8-7 10-9 - BDC & Sales Management Report Elite/ Date MTD Leads MTD Set appts MTD Shows MTD set/show% MTD Show/Lead% CarWise/Date MTD Leads MTD Set appts MTD Shows Ellaine Al Xena Maria Sophia Leo John Kristine Ralph Allen Charlie Erika - - - 56.25% 100.00% 33.33% #DIV/0! 70.59% #DIV/0! 76.47% 60.00% #DIV/0! #DIV/0! 61.11% 60.00% 24.32% 200.00% 11.11% #DIV/0! 27.91% 0.00% 41.94% 8.33% #DIV/0! #DIV/0! 27.50% 27.91% Ellaine Al Xena Maria Sophia Leo John Kristine Ralph Allen Charlie Erika - - - MTD set/show % MTD Show/Lead% #DIV/0! 47.06% #DIV/0! #DIV/0! #DIV/0! 61.54% #DIV/0! 0.00% 54.55% 70.00% #DIV/0! #DIV/0! #DIV/0! 26.67% #DIV/0! #DIV/0! #DIV/0! 27.59% #DIV/0! 0.00% 50.00% 30.43% #DIV/0! #DIV/0! Productivity Report (bottom bubble) Date shift Dials Completed Calls Inbound Calls Total set % set Shows Ellaine Al Xena Maria Sophia Leo John Kristine Ralph Allen Charlie Erika - - - - 21 4 3 9 5 - 12 1 3 9 - 3 1 3 5 3 - 10 - - 2 5 12 11 0 0 0 5 3 4 3 7 9.09% 20.00% 50.00% #VALUE! 27.78% 60.00% #VALUE! #DIV/0! 150.00% 80.00% 25.00% 43.75% - BDC & Sales Management Report Elite/ Date MTD Leads MTD Set appts MTD Shows MTD set/show% MTD Show/Lead% CarWise/Date MTD Leads MTD Set appts MTD Shows Ellaine Al Xena Maria Sophia Leo John Kristine Ralph Allen Charlie Erika - - - 55.81% 100.00% 27.27% #DIV/0! 60.00% 0.00% 77.78% 50.00% #DIV/0! #DIV/0! 63.16% 60.87% 27.27% 200.00% 8.57% #DIV/0! 27.27% 0.00% 48.28% 6.25% #DIV/0! #DIV/0! 25.00% 29.79% Ellaine Al Xena Maria Sophia Leo John Kristine Ralph Allen Charlie Erika - - - MTD set/show % MTD Show/Lead% #DIV/0! 47.37% #DIV/0! #DIV/0! #DIV/0! 57.89% #DIV/0! 0.00% 50.00% 57.14% #DIV/0! #DIV/0! #DIV/0! 28.13% #DIV/0! #DIV/0! #DIV/0! 31.43% #DIV/0! 0.00% 42.86% 36.36% #DIV/0! #DIV/0! Productivity Report (bottom bubble) Date Shift Dials Completed Calls Inbound Calls Total set % set Shows Ellaine Al Xena Maria Sophia Leo John Kristine Ralph Allen Charlie Erika 8-7 OFF 8-7 8-7 OFF OFF - - - - - - 10 3 3 - 29.41% #VALUE! 30.00% #VALUE! 23.08% #REF! #VALUE! 60.00% 100.00% 50.00% 100.00% #VALUE! - 8-7 8-7 8-7 OFF BDC & Sales Management Report 6 5 6 4 -- Elite/ Date MTD Leads MTD Set appts MTD Shows MTD set/show% MTD Show/Lead% CarWise/Date MTD Leads MTD Set appts MTD Shows Ellaine Al Xena Maria Sophia Leo John Kristine Ralph Allen Charlie Erika - - - 55.77% 100.00% 26.67% #DIV/0! 66.67% #DIV/0! 80.00% 62.50% #DIV/0! #DIV/0! 76.00% 62.96% 26.61% 200.00% 9.30% #DIV/0! 30.99% 0.00% 55.17% 11.36% #DIV/0! #DIV/0! 37.25% 36.17% Ellaine Al Xena Maria Sophia Leo John Kristine Ralph Allen Charlie Erika - - - MTD set/show % MTD Show/Lead% 100.00% 44.44% #DIV/0! #DIV/0! #DIV/0! 61.90% #DIV/0! 100.00% 56.25% 55.00% #DIV/0! #DIV/0! 100.00% 25.81% #DIV/0! #DIV/0! #DIV/0! 36.11% #DIV/0! 100.00% 42.86% 40.74% #DIV/0! #DIV/0! Productivity Report Date Ellaine Al Xena Maria Sophia Leo John Kristine Ralph Allen Charlie Erika (bottom bubble) Shift Dials Completed Calls Inbound Calls Total set % set Shows 10-7 OFF OFF OFF OFF OFF OFF 10 - 7 10 - 7 OFF 10 - 7 - 17 3 7 9 4 0 0 3 4 1 3 2 19.05% #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! 33.33% 42.86% #VALUE! 16.67% - MTD Leads MTD Set appts MTD Shows MTD set/show% MTD Show/Lead% CarWise/Date MTD Leads MTD Set appts MTD Shows - - - 57.69% 100.00% 26.67% #DIV/0! 66.67% 0.00% 80.00% 62.50% #DIV/0! #DIV/0! 76.00% 62.96% #DIV/0! 200.00% 9.09% #DIV/0! 30.99% 0.00% 55.17% 10.53% #DIV/0! #DIV/0! 38.00% #DIV/0! Ellaine Al Xena Maria Sophia Leo John Kristine Ralph Allen Charlie Erika - - - BDC & Sales Management Report Elite/ Date Ellaine Al Xena Maria Sophia Leo John Kristine Ralph Allen Charlie Erika MTD set/show % MTD Show/Lead% 100.00% 44.44% #DIV/0! #DIV/0! #DIV/0! 61.90% #DIV/0! 0.00% 52.94% 55.00% #DIV/0! #DIV/0! #DIV/0! 26.67% #DIV/0! #DIV/0! #DIV/0! 36.11% #DIV/0! 0.00% 32.14% 33.33% #DIV/0! #DIV/0! Productivity Report (bottom bubble) Date Shift Dials Completed Calls Inbound Calls Total set % set Shows Ellaine Al Xena Sophia Leo John Kristine Ralph Allen Charlie Erika - RTO 18 8-7 OFF 8-9 8-7 - - 11 4 4 7 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #VALUE! #DIV/0! #DIV/0! #VALUE! #DIV/0! #DIV/0! 1 1 1 2 4 1 2 5 - MTD Leads 2 1 2 2 2 BDC & Sales Management Report Elite/ Date MTD Leads MTD Set appts MTD Shows MTD set/show% MTD Show/Lead% CarWise/Date Ellaine Al Xena Maria Sophia Leo John Kristine Ralph Allen Charlie Erika 148 1 53 56 2 18 30 2 5 - 37 24 23 16 18 10 53.57% 100.00% 27.78% #DIV/0! 64.86% #DIV/0! 78.26% 62.50% #DIV/0! #DIV/0! 71.43% 61.29% 20.27% 200.00% 9.43% #DIV/0! 29.63% 0.00% 62.07% 8.62% #DIV/0! #DIV/0! 33.33% 27.94% Ellaine Al Xena Maria Sophia Leo John Kristine Ralph Allen Charlie Erika 60 68 28 31 20 19 MTD Set appts 49 22 49 21 30 34 18 26 MTD Shows - MTD set/show % MTD Show/Lead% #DIV/0! 40.91% #DIV/0! #DIV/0! #DIV/0! 61.90% #DIV/0! #DIV/0! 55.56% 50.00% #DIV/0! #DIV/0! #DIV/0! 18.37% #DIV/0! #DIV/0! 0.00% 26.53% #DIV/0! #DIV/0! 33.33% 38.24% #DIV/0! #DIV/0!