MestraMestra
All posts

Client Tracking: How to Keep a Base, What to Record and Which Software to Use in 2026

Guides5 min read

How to keep track of clients: which fields to record, methods from a notebook and Excel to a CRM, when a spreadsheet stops being enough and how to switch.

M
Mestra Team
Client tracking: a client card with history and a next step in Mestra

Client tracking is a single base that stores, for each customer, their contacts, enquiry source, conversation history, purchases, payments and next step. You can keep it in a notebook, Excel or a CRM system.

The main rule is one base for the whole company, not a separate one for each manager. When enquiries come from several messengers and a team handles them, a CRM is more convenient: the base updates itself rather than once a week by hand.

Why a business needs client tracking

  • Requests disappear. Someone wrote on Telegram, nobody replied, and a week later nobody remembers they got in touch.
  • The base leaves with the employee. If contacts are on a manager's personal phone, the company is left with nothing when they leave.
  • Repeat sales don't happen. Nobody goes back to past customers, even though it's easier and cheaper to sell to them.
  • It's unclear where people come from. Without tracking sources, advertising is paid for blindly.

What to record about each client

Field Why
Name and phone To get in touch
Messengers Where the person prefers to talk: MAX, Telegram, WhatsApp*
Source Avito, website, referral, advertising
Type Buyer, tenant, seller, partner
Interest What they want to buy or which problem to solve
Conversation history What was agreed and promised
Next step What to do next and when
Purchases and payments What they bought and for how much
Date of first enquiry How long the deal takes
Owner Who handles the client

The most important field is the next step. A card without it is a contact, not work with a customer.

3 ways to keep track of clients

Method Pros Cons Who it suits
A notebook or notes Simple No search, reminders or shared access A handful of clients
Excel or Google Sheets Free, familiar, shared access No reminders, messages by hand, goes out of date fast A start, one or two people
A CRM system The base updates itself, tasks, analytics Needs choosing and setting up A team and several channels

How to keep a base in a spreadsheet — in our article CRM in a spreadsheet; what a CRM is — in our article what a CRM is in simple terms.

When a spreadsheet is no longer enough

It's time to move to software if at least two of these apply:

  • enquiries come from several channels;
  • there are more than a few dozen clients a month;
  • more than one person works with them;
  • you can't say within a minute how many deals are in progress;
  • promises to "call back on Thursday" are regularly forgotten.

How to move from a spreadsheet to software without losses

  1. Clean the spreadsheet. Remove duplicates and bring phone numbers into one format.
  2. Decide on the fields. Keep only what you actually use.
  3. Upload the base to the CRM. Most systems accept an Excel file.
  4. Connect the channels — the messengers and classified sites enquiries come from.
  5. Set up roles and permissions so an employee can't export the whole base.
  6. Agree the rules. Every enquiry is a card, every agreement is a task.

How it works in Mestra

Mestra is our product. Client tracking in Mestra is designed so the base fills itself as you work:

  • One base for the whole company with filters and export to Excel.
  • A client card with the key data: type, source (UTM), messengers, date of first enquiry, manager notes.
  • All history in one place: conversations, tasks, invoices and payments, files.
  • Enquiries from messengers and classified sites — MAX, Telegram, WhatsApp*, VKontakte, Instagram*, Avito, CIAN — go straight into cards.
  • Roles and detailed permissions, unlimited users — from one manager to hundreds.
  • Import from Excel or an old CRM at launch.

Client tracking in Mestra: a card with history and a next step

FAQ

Which software should you use to track clients?

If you have few clients and work alone, Google Sheets is enough. If enquiries come from messengers and a team handles them, a CRM where the base updates itself is more convenient.

Can you track clients for free?

Yes: in a spreadsheet or on some CRMs' free plans. Most systems have a trial; Mestra offers 15 days with no bank card.

How do you avoid losing the base when a manager leaves?

Keep contacts and conversations in a shared system rather than on personal phones, and set up permissions.

Yes, provided you comply with Federal Law No. 152-FZ: you need consent to process personal data, and the data of Russian citizens must be stored in line with the law's requirements.

Bottom line

Client tracking starts not with software but with a rule: one base for everyone and a next step in every card.

A spreadsheet suits a start, but when there are many enquiries and several channels, the base needs to update itself. Try Mestra free for 15 days: move your base from Excel and connect your messengers in 10 minutes.

*WhatsApp and Instagram are owned by Meta, which is recognised as extremist and banned in Russia.

Keep reading

Sign up for a demo and see it in action

Niche analysis with ready scenarios and fields

Sign up for a demonstration

Leave your contacts and we will schedule a short demo.

We use cookies

Cookies keep Mestra running, remember your preferences and help us understand how the site is used. See our Privacy Policy, Terms of Service and Consent Form.