Question
A customer complaint tracker in Excel can be created using the following template:
1. Complaint ID: A unique identifier for each complaint.
2. Customer Name: The name of the customer who lodged the complaint.
3. Date Received: The date when the complaint was received.
4. Complaint Details: A brief description of the complaint.
5. Assigned To: The name of the person who is handling the complaint.
6. Status: The current status of the complaint (e.g., Open, In Progress, Closed).
7. Resolution Date: The date when the complaint was resolved.
8. Comments: Any additional notes or comments related to the complaint.
Remember to keep the tracker updated regularly for effective complaint management.
This question was asked on:
So how can you make your own issue tracker in Excel? For an issue tracker that works like Jira, you need to plan out, assign, manage, report, and track the progress of a series of competing issues, whether they be new features, bugs, recurring weekly tasks or user experience overhauls. Issue trackers are vital for any industry, as a recent Gartner survey found eighty-eight percent of boards regard cybersecurity as a business risk rather than solely a technical IT problem. (Source)
Receive new free presentations every Monday to your inbox.
Full content, complete versions — No credit card required.
