1
00:00:00,350 --> 00:00:03,108
Let's organise a customer request with Cuotaro's

2
00:00:03,122 --> 00:00:06,183
free template. We'll use a fictional

3
00:00:06,197 --> 00:00:09,743
example: Panadería Norte calls about a leaking tap.

4
00:00:10,680 --> 00:00:13,167
By the end, we'll have recorded what the customer

5
00:00:13,180 --> 00:00:16,699
needs and prepared the next step. You can follow

6
00:00:16,713 --> 00:00:19,227
along with your usual spreadsheet application.

7
00:00:21,483 --> 00:00:24,133
On the Resources page of the Cuotaro website,

8
00:00:24,377 --> 00:00:27,955
download the service request template. You don't

9
00:00:27,969 --> 00:00:31,542
need to register. Open the file in your spreadsheet

10
00:00:31,556 --> 00:00:35,251
application and save a working copy. Replace the

11
00:00:35,265 --> 00:00:38,961
example row with your own information. If everything

12
00:00:38,974 --> 00:00:41,841
appears in one column, import the file with a comma

13
00:00:41,855 --> 00:00:44,490
as the separator and U T F eight encoding.

14
00:00:46,750 --> 00:00:49,889
Start with the customer's name: Panadería Norte.

15
00:00:50,830 --> 00:00:53,765
The request comes by phone on the first of September.

16
00:00:54,703 --> 00:00:57,624
Under request source, enter Returning customer.

17
00:00:58,561 --> 00:01:01,496
These details will help us recognise the enquiry

18
00:01:01,510 --> 00:01:04,866
when we come back to the sheet. You can fill in the

19
00:01:04,879 --> 00:01:07,230
row as the information becomes available.

20
00:01:09,483 --> 00:01:12,635
For the service needed, enter Inspect a leaking tap.

21
00:01:13,577 --> 00:01:17,028
Add the fictional address, fourteen Calle Mercado.

22
00:01:17,966 --> 00:01:21,240
In this example, choose High priority and New as the

23
00:01:21,254 --> 00:01:24,814
status. We now have a first description of the

24
00:01:24,827 --> 00:01:28,496
request. Use the notes for any details that will

25
00:01:28,509 --> 00:01:29,732
help prepare the visit.

26
00:01:31,983 --> 00:01:35,493
Alex will take care of the follow-up. The next

27
00:01:35,507 --> 00:01:38,265
action is Confirm the visit window, with a target

28
00:01:38,278 --> 00:01:41,702
date of the second of September. Keep these three

29
00:01:41,716 --> 00:01:44,936
details together: who's responsible, what they'll do

30
00:01:44,950 --> 00:01:48,523
and when. When Alex picks up the request again,

31
00:01:48,768 --> 00:01:51,539
the details for the next step will be close at hand.

32
00:01:53,817 --> 00:01:56,439
After speaking to the customer, we agree a visit for

33
00:01:56,453 --> 00:02:00,017
the second at half past nine. Return to the

34
00:02:00,030 --> 00:02:03,699
same row. Change the status to Visit confirmed and

35
00:02:03,712 --> 00:02:07,286
the next action to Carry out the visit. Add the time

36
00:02:07,299 --> 00:02:10,479
and the date of the conversation to the notes. The

37
00:02:10,492 --> 00:02:12,557
row now reflects what we've agreed.

38
00:02:14,817 --> 00:02:17,847
When you have several requests, review them by target

39
00:02:17,860 --> 00:02:20,496
date and owner using your spreadsheet's filters.

40
00:02:21,438 --> 00:02:25,106
Here we have Alex's visit for the second. Save

41
00:02:25,120 --> 00:02:28,272
your changes. If you've added filters or

42
00:02:28,286 --> 00:02:30,731
formatting, save the working copy in your

43
00:02:30,745 --> 00:02:33,544
application's workbook format so those changes are

44
00:02:33,557 --> 00:02:34,087
kept.

45
00:02:36,350 --> 00:02:39,027
If you'd like to keep notes, files and follow-up

46
00:02:39,040 --> 00:02:42,686
together, you can also use Cuotaro. We've

47
00:02:42,699 --> 00:02:45,050
prepared Panadería Norte's request and a linked

48
00:02:45,064 --> 00:02:47,958
reminder for Alex, with the visit date and time.

49
00:02:48,895 --> 00:02:51,504
The spreadsheet and the app are filled in separately.

50
00:02:52,441 --> 00:02:54,792
In the app, the information stays linked to the

51
00:02:54,805 --> 00:02:56,830
customer so you can continue from there.

52
00:02:59,083 --> 00:03:01,828
The request is recorded, the visit is noted and the

53
00:03:01,841 --> 00:03:05,120
next step is ready. You can start with one

54
00:03:05,134 --> 00:03:07,430
enquiry from your own business and complete the

55
00:03:07,444 --> 00:03:11,139
sheet at your own pace. You'll find the template

56
00:03:11,153 --> 00:03:13,721
and the user manual on the Cuotaro website.

57
00:03:14,658 --> 00:03:15,990
Thanks for joining us.
