Keep Track of Customers Service Visits

Closed
christossol Posts 15 Registration date Friday February 17, 2017 Status Member Last seen March 23, 2022 - Mar 23, 2022 at 03:06 PM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Apr 11, 2022 at 12:15 PM
Hi All,
I need help in keeping track in excel of the customers service visits.
I have customers that are visited weekly, some twice a month, most of them monthly, bi-monthly, quarterly, twice a year or once a year.
Except of very few customers that their visit day is fixed, the rest, their day or date might change.
Any ideas?

Christossol

1 response

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 552
Apr 11, 2022 at 12:15 PM
Hi Christossol,

What do you want to get out of the Excel file? I mean, do you want to know how many visits a year there were? What about graphs? Visit duration? Monthly visitors? Once you know which results you want, you can think of the best way to input your data (layout).

I guess the most basic way would be to use Columns A and B for first and last name. The following columns will be used for 1st visit, 2nd visit etc..

Best regards,
Trowa
0