What a CRM is and how to choose one: 7 steps first

Signs a spreadsheet is not enough, writing down your sales stages, the fields you really need, the form and email link, data entry, moving old records and the first report.

· 12 min readEmail

Short answer

A CRM is the system that keeps every record and conversation with your customers and prospects in one place. Before you look at tools, write down your sales stages, pick the fields you need and decide where the form and email will connect; then test tools against that list.

Picture a morning like this: a salesperson writes a quote reminder to a customer from the shared spreadsheet, and in the same hour a colleague in the office tells the same customer, “we’re here whenever you want to talk”. One of them looked at the current tab, the other at an old copy made a week ago. The customer gets two messages, and nobody knows what each record says. This is where the practical answer to “what is a CRM” begins: a record system in which everyone sees, in one place, who came, when, through which channel, what was discussed and what stage it is at now. This guide walks a small or mid-sized firm through the seven jobs to do, in order, before it looks at a tool list. You can also find the term in the glossary.

What a CRM does in a small firm

A CRM keeps the details of customers and prospects, the conversations with them and the stage each sale has reached, all in one place. It does three jobs. First, no enquiry is left sitting with nobody: every record has an owner and a next step. Second, sales and marketing look at the same record, so you can see which source’s enquiries actually become customers. Third, when someone leaves, the customer history does not leave with them.

A CRM is not an email tool either. Email tools send the message; a CRM keeps the record. When the two are connected, the flows are fed by the stage on that record. We compared which type of tool suits which job in Klaviyo or HubSpot; here we cover the preparation that comes before choosing a tool.

Signs a spreadsheet is no longer enough

If one person works in one file, a spreadsheet is still the right tool. The trouble starts when more people deal with the records. If you recognise several of these, you have outgrown it:

  • The same customer sits on two separate rows in two people’s sheets.
  • The answer to “what happened to that quote?” lives in one person’s memory.
  • Enquiries from the form wait in an inbox and are copied into the sheet by hand.
  • Asking how many enquiries came from each source means a day of manual work.
  • The sheet gains a few more columns every month and nobody remembers what each one is for.

The number of signs is a direction, not a threshold. If you have only one or two, tidying the spreadsheet may be enough.

Step 1: Write down your sales stages

Before you look at any demo screen, take a sheet of paper and write the steps a customer goes through from first contact to sale. Pipedrive’s help centre recommends the same: your pipeline should reflect your real process, with each major step as a stage. Stage names should state an action: “Meeting scheduled” and “Proposal sent” say what is waiting, while “In progress” does not. Keep the number of stages low too, because many stages make the pipeline harder to scan and reduce use.

An example sequence might be:

  1. New enquiry
  2. Meeting held
  3. Proposal sent
  4. Won or lost

Write an entry condition for each stage as well: what has to happen for a record to move on? For example, a record moves to “Proposal sent” only when the proposal has actually gone out. Give lost deals a reason field; one of the most useful reports later comes from it. If you have different sales processes, for example project work and a maintenance contract, give each its own pipeline. HubSpot’s help page likewise recommends separate pipelines only for processes whose stages really differ.

Step 2: Choose the fields you really need

Every CRM comes with basic fields such as name, email and phone; Pipedrive calls these default fields and lets you add custom fields for your own information. Decide which fields to add by looking at the stages you wrote: keep a field if it feeds a decision or a report.

The table below shows the fields most firms need at the start and what each one is for:

Field What it is for Who fills it in
Name, company, email, phone Who to contact The form or the salesperson
Source (form, phone, referral, ad) Which channel the work came from Mostly automatic
Stage Where the deal is The salesperson
Owner Who has the record The manager, or automatic assignment
Next step and its date Making sure follow-up is not forgotten The salesperson
Reason lost What to fix later The salesperson
Email consent Whether marketing messages may be sent The form or the marketing owner

The longer the field list, the slower data entry becomes and the more records are left blank. If you cannot say which report a field feeds, leave it out for now. Adding a field later is easier than deleting an unneeded one from the start.

Step 3: Now choose the tool

You now have a yardstick: your stages, your fields and the connections below. Try two or three candidates by building your own stage list in each. In each trial version, check:

  • Can you set up your stages under their own names?
  • Can you add your fields and the source?
  • Is it easy to connect your website form and your email inbox?
  • Can it take an Excel or CSV file and map it to fields?
  • Will your sales team get used to it within a week?

Do not compare prices and plans at this stage; price means nothing until you have seen which tool fits your process. Each tool’s help centre explains how the jobs on this list are done, and if you would like us to set it up with you, see the scope of our email and CRM service.

Step 4: Connect the website form and email

The first connection after choosing is the contact or quote form on your website. The aim is simple: a person who fills in the form should appear in the CRM as a new record, at the “New enquiry” stage, with the source filled in, without anyone doing anything by hand. There are three ways to connect a form to a CRM: use the tool’s own form feature, set the existing form to send data to the CRM, or build the hand-off with an automation tool. We explained how these hand-offs work in business process automation examples and in how to set up email automation.

On the email side there are two separate jobs. The first is getting correspondence with the customer onto the record; most CRMs let you connect your mailbox for this. The second is the campaign or automation emails that the record receives. Whether a person can be sent marketing messages depends on consent here: collect consent with its own checkbox on the form and write it to the record as a field. We cover the rules in email and SMS consent in Türkiye. To record the source correctly in ad and email links, it helps to add campaign tags to the links; you can do this with the UTM link builder.

A form, an email and a phone note land in the same CRM record; the record moves through sales stages and feeds the first report Web form Email Phone note (typed in) CRM record Contact and company Source Owner Next step Moves through stages New enquiry Meeting held Proposal sent Won or lost First report: stage, source A form, an email and a phone note land in the same CRM record; the record moves through sales stages and feeds the first report Web form Email Phone note (typed in) CRM record Contact and company Source Owner Next step Moves through stages New enquiry Meeting held Proposal sent Won or lost First report: stage, source
Figure: A form, an email and a typed-in phone note land in the same CRM record; the record moves through the sales stages, and the first report reads by stage and source.

Before you go live, send three test records: a form, an email and a phone note typed in by hand. Check that each appears in the CRM under the right person, with the right source and at the right stage.

Step 5: Decide who enters data, and when

The real risk in a CRM is that the team does not enter data. To prevent that, set a written rule: on which event does who update which field? An arrangement like this works for most small teams:

  • Form and email records are created automatically; nobody types them in.
  • After a call or meeting, the same day, the salesperson updates the stage and the next step.
  • Every record has an owner; a record with no owner goes to the manager in the daily check.
  • The weekly meeting runs from the CRM screen; no spreadsheet or separate notebook is opened.

The last point matters most: if the CRM is open in the meeting, the team keeps records current; if the manager keeps looking at the spreadsheet, the CRM empties quickly.

Step 6: Move the old records in

You do not need to move every row from your old spreadsheet. Move the customer records and open deals; calculation sheets and one-off analyses can stay in the spreadsheet. Before moving:

  1. Clean the sheet: merge anyone who appears on two rows and fix spelling differences. We set out the steps in order in our guide to cleaning customer data.
  2. Map columns to CRM fields. HubSpot’s help page asks for a header row in which each column header corresponds to a field, a file with a single sheet, and UTF-8 encoding if the file contains Turkish characters. Also check the file requirements on your own tool’s help page.
  3. Import a small sample first and see that the records land in the right fields.
  4. Set a cut-over date, and on that day make the spreadsheet read-only and archive it. Running both systems side by side means the records drift apart.

Do not put people without marketing consent into email flows when you do not know how consent was collected in the old list; keep them apart, following the rules in the consent article.

Step 7: Build the first report

Once data starts going in, build one screen and look at it once a week. The first report should answer three questions:

  • How many open records are at each stage, and which have not moved for a long time?
  • Which source do enquiries come from, and which source turns into won deals?
  • Which records have a next step that is overdue or was never written?

The third question gives you a clean-up list; the first two build up the numbers that will help you decide months from now. To bring this report into your weekly meeting, you can use the Monday report format.

Common mistakes

  • Choosing the tool first. A tool chosen before the process is written ends up full of unneeded fields or without the ones you need.
  • Too many stages and fields. Each one is a piece of data entry; when entry is tiring, records stay blank.
  • Running the spreadsheet and the CRM together. Neither stays current, and nobody knows which to trust.
  • Records with no owner. A record everyone can see can end up a record nobody follows.
  • Moving dirty data as it is. Duplicates and errors in the sheet stay duplicates and errors in the CRM.

Common questions

Is a CRM the same as an email marketing tool?

No. A CRM keeps contacts, conversations and sales stages; an email tool prepares and sends the message. Some products offer both, and some firms connect separate tools. Which suits you better depends on whether your revenue comes from orders or from sales conversations.

Does a small firm need a CRM?

Not necessarily. If one person handles the records and enquiries are few, a tidy spreadsheet may be enough. Moving to a CRM makes sense once several people deal with the same customer, enquiries from the form start waiting, or you want a report by source.

What data should I not put in a CRM?

Do not collect personal information you do not need; every field should have a purpose. How customer data is processed falls under KVKK and may need a separate legal assessment, so we suggest asking your own legal adviser.

One thing to do today

Take a sheet of paper and write down the steps your last three won deals went through, from first contact to contract. The steps all three share are the first draft of your stage list; move on to choosing a tool after that.

Sources

This article is general information, not legal, financial or technical advice. Platforms, their rules and the law change over time, so some details may have changed since 11 November 2026 or contain small errors. Before you make a decision for your business, check the current official sources or write to us.

Tell us about
your project.

Fill in the form or write to us directly, and we will agree on a day to talk.

Your first meeting is with Deniz Sezer, founder of Detmore.

First meeting free · Reply within one working day · Written proposal in 2 to 3 days · NDA ready

What do you need? pick as many as you like

Name, email and phone are required.

Contact

We reply within one working day.