I want to create an Excel Sheet so I can monitor the performance of my team. My team are handling customer enquiries and generating sales and I want to see how successfully the convert these enquiries. There maybe a few ways to do this but I was thinking an excel sheet (If you have a different way please let me know in your proposal)
Sheet 1. Name of enquiry staff memeber name Enquiry date Enquiry source Service they want Appt attended - yes/no Booked with dentist yes/no Treatment started yes/no Comments
Sheet2. Monthly conversion stats Number of enquiries Number of enquiries attended Number of patients seen that see the dentist Number that see dentist and start treatment. Treatment value
On sheet 2 it should also have lifetime conversion. The conversion should be of whole team and also be able to segment by staff member. So i can tell which staff member is performing better.
It might also be useful to be able to segment the data by service also. This is less important, but it might show that we are better at converting.One type of treatment over another
Animated Educational Video for Beginners Category: 2D Animation, 3D Animation, Adobe Premiere Pro, After Effects, Animated Video Development, Animation, Motion Graphics, Video Editing, Video Production, Video Services Budget: £10 - £20 GBP
28-Mar-2026 23:03 GMT
WhatsApp Chat-to-Excel Conversion Category: Data Analysis, Data Cleansing, Data Entry, Data Extraction, Data Management, Data Processing, Excel, Visual Basic Budget: $30 - $250 USD
Vidéos comiques bilingues Arabe-Français Category: Adobe Premiere Pro, After Effects, Audio Editing, Content Creation, Graphic Design, Social Media Marketing, Translation, Video Editing, Video Production, Video Services Budget: $15 - $25 USD
28-Mar-2026 22:54 GMT
Steel Reinforcement CAD for Padlock Category: 3D CAD, 3D Design, 3D Drafting, 3D Modelling, 3D Printing, 3D Rendering, AutoCAD, CAD / CAM, Mechanical Engineering, Solidworks Budget: $30 - $250 AUD
Future of Leadership in The Digital Age Category: Academic Writing, Change Management, Data Analysis, Interviewing, Project Management, Report Writing, Research, Strategic Planning, Time Management Budget: $250 - $750 AUD
28-Mar-2026 22:43 GMT
AWS Deployment for Chrome Extension Category: Amazon Web Services, API Development, AWS Lambda, Backend Development, Cloud Computing, Linux, Node.js, Ubuntu Budget: $30 - $250 NZD