{"product_id":"customer-support-log","title":"Customer Support Log","description":"\u003cp\u003e\u003cstrong\u003eThe problem.\u003c\/strong\u003e Customers ask questions and raise problems by email, phone, chat and in person. Details end up in inboxes, notebooks and memory, and nobody has one clear view of which enquiries are still open, which have waited too long or how long they take to resolve.\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003eWhat this does.\u003c\/strong\u003e You keep one list of enquiries. Each row records who asked, how they got in touch, what it was about, how urgent it is and when it was resolved. The workbook works out the days to resolve, counts open and late enquiries, and shows enquiries by category and by channel.\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003eWhat you can do with it\u003c\/strong\u003e\u003c\/p\u003e\u003cul\u003e\n\u003cli\u003eSee how many enquiries are open, and how many of them are waiting on the customer.\u003c\/li\u003e\n\u003cli\u003eSee how many have been open longer than the limit you set.\u003c\/li\u003e\n\u003cli\u003eSee the average days to resolve, and how many were resolved this month.\u003c\/li\u003e\n\u003cli\u003eSee high priority enquiries that are still open.\u003c\/li\u003e\n\u003cli\u003eSee enquiries by category and by channel (email, phone, chat or in person), with each share and a bar chart.\u003c\/li\u003e\n\u003cli\u003eChoose your industry (home services, professional services or retail) to load a suitable Category list, then edit it to suit you.\u003c\/li\u003e\n\u003cli\u003eKeep your records in a clear structure: a Data Dictionary explains every column, and an export sheet repeats your enquiries 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 set how many days an open enquiry may wait.\u003c\/li\u003e\n\u003cli\u003eAdd one row per enquiry, and set the Status and Resolved date when you finish it.\u003c\/li\u003e\n\u003cli\u003eCheck the dashboard each week.\u003c\/li\u003e\n\u003c\/ol\u003e\u003cp\u003e\u003cstrong\u003eWho it is for.\u003c\/strong\u003e Sole traders, freelancers, trades and small businesses that answer customer questions, complaints and requests by hand and want to see them in one list.\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003eWho it is not for.\u003c\/strong\u003e Teams that already work in help desk software, or that need emails, calls or chats logged automatically. This is a spreadsheet: it does not connect to your email, phone or chat, and it does not reply to anyone for you.\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\u003e2,000 enquiry rows are ready, and you can add more by dragging the last row down.\u003c\/li\u003e\n\u003cli\u003eAn example copy with 40 made-up enquiries 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\u003cli\u003eGeneral information only. It is not accounting, tax, legal or financial advice.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"TeleWorld Online","offers":[{"title":"Default Title","offer_id":48859261894861,"sku":null,"price":17.0,"currency_code":"CHF","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0652\/1031\/9053\/files\/01-cover_fd1e1caf-8365-4a54-a26b-a40364298f51.png?v=1795099633","url":"https:\/\/www.teleworld.online\/de-ch\/products\/customer-support-log","provider":"TeleWorld Online","version":"1.0","type":"link"}