Hi dcollins,
I have managed complaint tracking for about 15 years. I would strongly urge you to research the use of complaint tracking software. In the meantime, you may want to set up an excel spreadsheet which tracks using case numbers (you can use any random set of numbers to start, i.e. 0001). I'm sure it goes without saying that your numbers should be sequential. You should also determine what you want to track and establish standards around those metrics. Do you want to track the type of complaint you receive; the number of days it takes to respond and/or resolve an issue; the final resolution, etc? Once you have determined what information is important, you can set up a simple spreadsheet. If you have access to database software, you may want to work with your IT group to set up a tracking system. But, I would encourage you to keep control of the project. Otherwise, you may end up tracking unecessary/useless information or, it may not suit your purpose.
I hope this helps.
JazzTab1 |