Video tutorial · 4K
Organise customer requests with a free template
Organise customer requests with a free CSV template for Excel or Google Sheets. Record the enquiry, assign the next action and update the agreed visit using a fictional service call.
Chapters
Transcript
00:00 Let's organise a customer request with Cuotaro's free template. We'll use a fictional example: Panadería Norte calls about a leaking tap. By the end, we'll have recorded what the customer needs and prepared the next step. You can follow along with your usual spreadsheet application.
00:21 On the Resources page of the Cuotaro website, download the service request template. You don't need to register. Open the file in your spreadsheet application and save a working copy. Replace the example row with your own information. If everything appears in one column, import the file with a comma as the separator and U T F eight encoding.
00:46 Start with the customer's name: Panadería Norte. The request comes by phone on the first of September. Under request source, enter Returning customer. These details will help us recognise the enquiry when we come back to the sheet. You can fill in the row as the information becomes available.
01:09 For the service needed, enter Inspect a leaking tap. Add the fictional address, fourteen Calle Mercado. In this example, choose High priority and New as the status. We now have a first description of the request. Use the notes for any details that will help prepare the visit.
01:31 Alex will take care of the follow-up. The next action is Confirm the visit window, with a target date of the second of September. Keep these three details together: who's responsible, what they'll do and when. When Alex picks up the request again, the details for the next step will be close at hand.
01:53 After speaking to the customer, we agree a visit for the second at half past nine. Return to the same row. Change the status to Visit confirmed and the next action to Carry out the visit. Add the time and the date of the conversation to the notes. The row now reflects what we've agreed.
02:14 When you have several requests, review them by target date and owner using your spreadsheet's filters. Here we have Alex's visit for the second. Save your changes. If you've added filters or formatting, save the working copy in your application's workbook format so those changes are kept.
02:36 If you'd like to keep notes, files and follow-up together, you can also use Cuotaro. We've prepared Panadería Norte's request and a linked reminder for Alex, with the visit date and time. The spreadsheet and the app are filled in separately. In the app, the information stays linked to the customer so you can continue from there.
02:58 The request is recorded, the visit is noted and the next step is ready. You can start with one enquiry from your own business and complete the sheet at your own pace. You'll find the template and the user manual on the Cuotaro website. Thanks for joining us.