A CRM that keeps an eye on client contact for the whole sales team

The problem: clients drop off the radar

In theory the rule is simple. We divide clients into the very important, the moderately important and the least important. We need to meet the first group often and call them regularly. The second group less often, but contact has to be constant - we always need to know what is going on in that company. For the third group an occasional call is enough.

In practice this rule collapses under everyday work. Sales reps lose control of their base - some clients get visited too rarely, some are simply forgotten. Nobody does it on purpose. With a few hundred companies per person, human memory cannot keep up with the calendar. And the result is always the same: a client nobody talks to quietly moves their orders to a competitor. I recently wrote about systems that spot a departing client in the data earlier than the sales rep does. This idea takes the same thinking one step further: instead of merely detecting the risk, the system prevents neglected contact in the first place.

The idea: the system remembers for the sales rep

The mechanism is built on contact groups. Every client in the database goes into a group, and every group has time intervals assigned: how often a meeting should take place and how often a phone call. A strategic client may get a meeting once a month, another one once a quarter, yet another once every six months.

From that moment the system plans the tasks for the sales reps itself. The rep does not have to remember that they have not visited company X for three months - the task simply appears in their plan.

The same applies to quotes. If the company sells products that clients buy repeatedly - a regular buyer orders material every month or every quarter - then that client must always have an up-to-date quote, so they know at what price to order. And every quote has its expiry date: exchange rates and other pricing factors change, so after that date it has to be prepared anew. The system watches the expiry dates and assigns quote-update tasks to the sales reps by itself.

An important assumption: such a system does not have to tear down processes that already work in the company. If the sales reps record meeting outcomes in another system the company has used for years, that system stays. Integration is enough - when a rep saves a meeting outcome on their side, the planning system learns about it automatically, synchronises the data and marks the planned task as done. Zero double work.

Effectiveness measured directly from tasks

The most interesting part begins where tasks are left undone. If a rep fails to complete a meeting, a call or a quote update within the given time, the system automatically closes the task as not done and generates the next one. Thanks to this, the rep's effectiveness calculates itself - from the ratio of tasks done to tasks closed. Closed tasks are those done and those the system closed as not done. Tasks still in the plan are left out. Example: one task done, one not done and one still planned. Two closed tasks count, one of them done - 50%. No explanations and no manual reporting.

On top of that come new-business targets. Every rep has a goal: a specific number of new clients added to the database in a given period, for example a month or a quarter. This is counted automatically as well.

A simple, readable traffic-light system runs on this data. The thresholds are configurable, but as an example: below 60% of completed tasks the rep gets a red light, between 60 and 90% an orange one, above 90% a green one. The lights of individual reps roll up into a rating of the whole division, and therefore of its manager. And the division ratings roll up into a picture of the company's entire sales structure - and that is the view for the CEO, who can see at a glance whether sales is working effectively and where exactly the problem is.

Technology

Such a system can be built in Claris FileMaker: the client database, contact groups, the task-planning engine, effectiveness tracking and the integration with the system where reps record meeting outcomes. This is exactly the kind of application I build - tailored to the processes of a specific company and integrated with what already works there, instead of replacing everything at once.

A step further: AI reads the notes, plans routes and verifies visits

The foundation is task planning and completion tracking. The idea can be taken further, though.

First direction: AI analyses the notes from meetings and contacts. After a quarter or half a year of a rep's work, artificial intelligence reads all their notes and generates a descriptive quality profile of their work: do they know who makes the decisions at the client, what the client needs and what challenges the client is facing. This translates directly into money, because this knowledge determines what value propositions we can communicate in our offer. When the offer answers the client's challenges, price stops being the only argument in the conversation. If we do not know the client, we are one of many vendors offering their products - and then all that remains in the end is a price war. Such a report goes to the team leads, the sales director and the board.

Second direction: route planning. The system knows the clients' addresses and the dates of planned meetings, so it can arrange business-trip routes so that the rep visits as many companies as possible during one trip - split into days, with time for travel and overnight stays along the way.

Third direction: a mobile app as an interface to the database. Standing in front of the client's premises, the rep takes a photo with one tap, and it lands in the system together with GPS coordinates. This confirms that the visit really took place on that day and at that address. And the photos from consecutive visits say more than you would expect: a new production hall, a new office building, new cars in the car park. Comparing photos over time shows whether the client is growing.

What this means for a business owner

The mechanism works the same in a company with a few sales reps as with a few dozen - only the scale differs. It is worth counting on your own numbers: how many clients are your sales reps neglecting today? How many companies in your database have had no contact for half a year, and how many of them still order? Losing one regular buyer often means a hole in revenue for many months, and winning a new client costs several times more than keeping an existing one.

A system that plans contacts by client rank, watches quote validity and measures sales effectiveness by itself costs a fraction of what a company loses on neglected clients. And it relieves the sales manager of the role of an overseer with a spreadsheet - task-completion data collects itself and reaches the managers where necessary.

Where to start

With cleaning up the client database and dividing it into groups by importance. This is a purely business decision - the system can only enforce rules the company defines first. Then a simple task engine with intervals and completion tracking is enough. Extensions like AI note analysis, route planning or photo-verified visits can come later, on a working foundation.

If you want to talk about such a system in your company, write to me or book 30 minutes in the calendar below.

More articles about what can be built in your company are in the Knowledge section.