{"product_id":"customer-feedback-complaints-and-quality-register","title":"Customer Feedback, Complaints and Quality Register","description":"\u003cp\u003eThis workbook is a record-keeping tool and general information only. It is not legal, tax or financial advice.\u003c\/p\u003e\u003cp\u003eThis workbook holds personal information about customers. Look after it: share it only with those who need it and keep it somewhere protected. It has no columns for payment, bank, identity or health details, so please do not type them into the Summary or Corrective action columns either.\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003eThe problem.\u003c\/strong\u003e Feedback and complaints end up in inboxes, notebooks and memory. It is hard to see which items are still open, which corrective actions are overdue and how long items take to close.\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003eWhat this does.\u003c\/strong\u003e You keep one list of feedback items, one of the corrective actions you take and one of your customers. The workbook works out whether each item is open or closed, its days open and days to close, and the status of each action, and the dashboard counts items by status, type, channel and category, open and overdue actions and the average rating. You type the records; it does the sums.\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003eWhat you can do with it\u003c\/strong\u003e\u003c\/p\u003e\u003cul\u003e\n\u003cli\u003eSee open items, overdue actions and the average rating on one dashboard.\u003c\/li\u003e\n\u003cli\u003eSee items by status, type, channel and category, as tables with charts for status and type.\u003c\/li\u003e\n\u003cli\u003eWork out days open and days to close, and flag open items older than the number of days you choose.\u003c\/li\u003e\n\u003cli\u003eLink each corrective action to its item, and see the overdue ones with their owner and days overdue.\u003c\/li\u003e\n\u003cli\u003eChoose your industry (retail, professional services or hospitality) to load suggested categories and channels, then type the lists you want to use.\u003c\/li\u003e\n\u003cli\u003eKeep your records in a clear structure: a Data Dictionary explains every column, and three export sheets repeat your feedback items, actions and customers under plain field names.\u003c\/li\u003e\n\u003c\/ul\u003e\u003cp\u003e\u003cstrong\u003eHow it works\u003c\/strong\u003e\u003c\/p\u003e\u003col\u003e\n\u003cli\u003eEnter your business name, choose your industry and type your own statuses, types, channels and categories.\u003c\/li\u003e\n\u003cli\u003eAdd your customers, then your feedback items and corrective actions.\u003c\/li\u003e\n\u003cli\u003eCheck the dashboard regularly.\u003c\/li\u003e\n\u003c\/ol\u003e\u003cp\u003e\u003cstrong\u003eWho it is for.\u003c\/strong\u003e Sole traders, freelancers and small businesses who want one place to record customer feedback, complaints and the actions taken.\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003eWho it is not for.\u003c\/strong\u003e Anyone who needs replies or reminders sent for them, attachments stored or links to other software. This is a spreadsheet: it does not send anything or connect to other software, and nothing in it is a rule.\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003eWhat you need.\u003c\/strong\u003e Microsoft Excel 2016 or later. It was tested in Excel for Windows. No macros, no add-ins and no subscription.\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003eGood to know\u003c\/strong\u003e\u003c\/p\u003e\u003cul\u003e\n\u003cli\u003e1,000 feedback items, 500 actions and 300 customers are ready, and you can add more by dragging the last row down.\u003c\/li\u003e\n\u003cli\u003eNothing is set for you. Statuses, types, channels, categories, the rating range and the days after which an open item is flagged are your own.\u003c\/li\u003e\n\u003cli\u003eA rating is just a number. You decide what it means.\u003c\/li\u003e\n\u003cli\u003eAn example copy with a made-up shop shows every sheet working before you start.\u003c\/li\u003e\n\u003cli\u003eNothing is locked or password protected.\u003c\/li\u003e\n\u003cli\u003eUse this template to capture and improve your business data now. In future you can automate with AI.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"TeleWorld Online","offers":[{"title":"Default Title","offer_id":48859262714061,"sku":null,"price":1700.0,"currency_code":"INR","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0652\/1031\/9053\/files\/01-cover_c68b0730-533c-4e12-a83c-a1f0960cab5e.png?v=1795096330","url":"https:\/\/www.teleworld.online\/gu-in\/products\/customer-feedback-complaints-and-quality-register","provider":"TeleWorld Online","version":"1.0","type":"link"}