Skip to content

Booking, CRM and Follow-Up

Turning Callers Into Contacts: A Clean CRM Habit

Contact management for small businesses: one key per customer, plus naming, duplicate and notes rules that keep a contact list useful after year one.

AssistCall research teamPublished Reviewed by Faruque Amin, VP of Sales and Marketing8 min read

On this page
  1. Why contact lists rot
  2. One key per person: the phone number
  3. Naming rules everyone follows
  4. Find and merge duplicates every week
  5. Notes that still make sense in two years
  6. Tags: a short, fixed list
  7. Give the list one owner
  8. Let calls create the record, people correct it
  9. Frequently asked questions
  10. References
Booking, CRM and Follow-Up: Turning Callers Into Contacts: A Clean CRM Habit35 million: US phone numbers are disconnected and made available for reassignment each yearBOOKING, CRM AND FOLLOW-UPTurning Callers IntoContacts: A Clean CRM Habit35 millionUS phone numbers are disconnected and madeavailable for reassignment each yearAssistCallInsightsBooking, CRM and Follow-Up: Turning Callers Into Contacts: A Clean CRM Habit35 million: US phone numbers are disconnected and made available for reassignment each yearBOOKING, CRM AND FOLLOW-UPTurning Callers IntoContacts: A Clean CRMHabit35 millionUS phone numbers are disconnected andmade available for reassignment eachyearAssistCall
Figure source: Federal Communications Commission, 2018[1]

Key takeaways

  • Contact lists decay on their own: people move, numbers get reassigned and staff type the same person two ways.
  • Use the phone number, stored in one format, as the key for each caller; names are too common to match on.
  • Write down naming, duplicate and notes rules on one page and review duplicates for ten minutes a week.
  • Notes should be dated, initialled facts a customer could read; payment data and ID numbers never go in.
  • Let each call create or update the record automatically, so staff spend their time correcting, not typing.

Why contact lists rot

A contact list starts decaying the day you stop tending it. Customers move, change numbers and take new surnames. Two people at the front desk type the same caller two different ways. None of it shows in the first six months. By the second year, a search for Moreno returns three records, two of them with numbers that ring someone else.

The numbers behind that decay are large. The FCC estimates that about 35 million phone numbers are disconnected and made available for reassignment to new consumers each year, after a minimum aging period of 45 days[1]. A number in your list that has not been used in two years may now belong to a stranger who will not thank you for the reminder call.

Addresses drift too, if more slowly than they used to. In the Census Bureau's survey data, 7.8% of US residents had moved in the past year in 2023, about 25.6 million people, and that was the lowest rate in a series going back to 1948[2]. For a trade that keeps service addresses on file, roughly one customer in thirteen moves in a typical year.

Share of US residents who moved in the past yearCurrent Population Survey (CPS ASEC), residents aged 1 and over; selected survey years.
Share of US residents who moved in the past yearLine chart. 2013: 11.7%; 2015: 11.6%; 2017: 11%; 2019: 9.8%; 2021: 8.4%; 2022: 8.7%; 2023: 7.8%.6%8%10%12%20132015201720192021202220232013: 11.7%2015: 11.6%2017: 11%2019: 9.8%2021: 8.4%2022: 8.7%2023: 7.8%7.8%11.7%Share of US residents who moved in the past yearLine chart. 2013: 11.7%; 2015: 11.6%; 2017: 11%; 2019: 9.8%; 2021: 8.4%; 2022: 8.7%; 2023: 7.8%.6%8%10%12%20132017202120232013: 11.7%2015: 11.6%2017: 11%2019: 9.8%2021: 8.4%2022: 8.7%2023: 7.8%7.8%11.7%

Source: U.S. Census Bureau, 2024[2]

Show the data
PeriodValue
201311.7%
201511.6%
201711%
20199.8%
20218.4%
20228.7%
20237.8%

Software does not stop any of this. What stops it is a small set of habits, written on one page and followed by everyone who touches the list. The rest of this guide is that page.

One key per person: the phone number

Every contact list needs one field that identifies a person, so a second call updates the first record instead of creating another. For businesses whose customers arrive by phone, that field is the phone number. Most adults now carry their own: 78.0% of US adults lived in wireless-only households with their own cellphone in the second half of 2024[3]. A mobile number usually belongs to one person, which is exactly what a key needs.

Names make poor keys. In the 2010 Census, 2,442,977 people had the surname Smith and 1,932,812 had Johnson[4]. Two John Smiths in a mid-size town is not a coincidence, it is arithmetic. Match on the number first, use the name to confirm, and never merge two records on the name alone.

Store every number in one format. US numbers are ten digits, a three-digit area code and a seven-digit local number, and country code 1 is shared by 20 North American countries, including Canada and much of the Caribbean[5]. The safest stored form is +1 followed by the ten digits, with no spaces or brackets: +13125550142. Display it however you like on screen, but store it one way, so (312) 555-0142 and 312.555.0142 cannot become two contacts.

Two exceptions need a rule. A shared number, such as a family landline or an office main line, can belong to several people: keep one contact per person and note the shared line on each. A business customer whose staff all call from a switchboard gets one contact per caller with the company name in its own field, so the record still says who rang.

Naming rules everyone follows

Most duplicates are typing habits, not software faults. Agree the rules below, pin them next to the screen, and fix old records as you meet them rather than in one heroic weekend.

Naming rules for a small business contact list, with examples
SituationWrite it asNot as
A personMaria Lopezmaria, Mrs L, MARIA LOPEZ, Lopez Maria
Name not known yetLeave the name blankCustomer, Unknown, ???, New lead
Someone calling for a businessDev Patel, with the company name in its own fieldPatel Plumbing Supply (Dev)
Two people at one addressTwo contacts, each with its own numberSam and Alex Rivera
Landlord or property manager calling about a tenant's unitThe manager as the contact; the unit address in the notesThe tenant's name with the manager's number
A customer changes surnameUpdate the name; note formerly Chen with the dateA second record under the new name

The blank-name rule surprises people. A blank field is honest and easy to filter: show me every contact with no name, and ask for it next time they call. A placeholder like Customer looks like data, sorts into the middle of the list and never gets fixed. When the caller's name is captured on a later call, the blank fills in and nothing needs merging.

Find and merge duplicates every week

  1. Sort by phone number

    Any two records with the same stored number are almost certainly one person. If your list mixes formats, normalize the numbers first or the sort will hide pairs.

  2. Then sort by name

    Look for the same name with two different numbers. These are often a landline and a mobile, or an old and a new number. Confirm on the next call before merging.

  3. Keep the record with the most history

    Move notes, tags and appointments from the newer record to the older one, then delete or archive the empty duplicate.

  4. Never merge on a name alone

    Two Maria Lopezes with different numbers and different addresses are two customers until a call proves otherwise.

  5. Log what you merged

    One line in the surviving record: merged with duplicate, date, initials. If a merge was wrong, someone can trace it.

Ten minutes a week keeps a list of a few thousand contacts clean. Leave it a year and the same job takes a weekend, plus the cost of everything that went wrong in between: the reminder sent twice, the quote sent to the wrong Maria, the regular who was greeted as a new customer.

Notes that still make sense in two years

Notes are where contact lists become useful or useless. The test for every note is whether a colleague who has never met the customer could act on it in two years, and whether the customer could read it without complaint.

Example: a note that rots and a note that lasts
Note that rotsNote that lasts
WhenNo date2026-03-04
Who wrote itUnknownJR
What happenedCalled, wants a quote, nice guyAsked for quote to replace 40-gal water heater in basement
Promise madeWill get back to himQuote by email by Fri 3/6
PreferenceHard to reachBest after 5 pm on mobile

Example notes for a fictional plumbing customer. Date, initials and facts first.

  • Start every note with the date and the writer's initials.
  • Write facts and promises, not opinions about the customer.
  • One note per interaction; never edit an old note to say something new.
  • Put the next step in its own field with a due date, not buried in the note text.
  • Leave out payment card numbers and Social Security numbers. The FTC advises against keeping card data without a business need and against using Social Security numbers as customer identifiers[6].

Accuracy is the whole point of a note. Receptionists themselves rate it highly: 75% call being exact or highly accurate very or extremely important to the job[7]. A repeat-back on the phone, reading the number and the promise to the caller, catches most errors before they reach the record.

Tags: a short, fixed list

Tags let you pull a group of contacts in seconds, but only if everyone uses the same ones. Agree a list of no more than fifteen or twenty, in three families, and add new tags only when someone needs a list the current ones can't produce.

  • Source: where the customer found you, such as google, referral, yard sign or repeat.
  • Service: what they buy, such as drain, water heater, maintenance plan.
  • Status: anything that changes how you treat them, such as VIP, do-not-call or account on hold.

Keep tags lower case, singular and free of punctuation. That matters more than it sounds: when contacts leave one system for another, tags often travel as a single field joined by commas or semicolons, and a tag that contains either character splits in two. The guide to exporting contacts to CSV covers that move in detail.

Give the list one owner

Rules without an owner fade within a month. Name one person, usually the office manager, who owns the contact list: they keep the one-page rules current, run the weekly duplicate check and decide disputed merges. Everyone else may add and edit records, but only the owner deletes them or changes the tag list.

Teach the rules on a new hire's first day, before they take a call. Five minutes is enough: the number format, the blank-name rule, the note format and the tag list. Then have them search for three existing customers and fix whatever they find wrong. It teaches the habit and cleans three records at the same time.

Example: a fictional four-person cleaning company with about 1,900 contacts runs its first weekly check and finds 64 pairs with the same number, 40 records named Customer and a tag list that has grown to 37 tags, including both residential and resi. The owner merges the pairs over two weeks, blanks the placeholder names, and cuts the tags to twelve. From then on, the weekly check finds three or four new duplicates, almost all from a single staff member who had never seen the rules.

Let calls create the record, people correct it

The cleanest contact lists are the ones staff do not have to type. When an SI Employee answers your phone, each caller's number creates a contact, a second call from the same number updates that record instead of making a new one, and the call summary, recording and transcript sit on it. The habit then shifts from typing to reviewing: fix a spelling, add a tag, set the next step. The call summary examples show what a reviewer is looking at.

Once a quarter, run a cleanup that the weekly review misses. Pull contacts with no call in eighteen months and decide whether they still belong. Before any reminder or seasonal campaign, check old numbers rather than trusting them, for the reassignment reason above. And follow the FTC's pitch-it principle: delete what you no longer have a reason to keep[6].

For the earlier stages of the same habit, start with the call log template and the new customer intake questions that decide what a record holds in the first place. What an SI Employee is covers the wider job. The salon and spa bookings example shows why clean records matter most where the same clients call every few weeks, and the home services guide to CRM data cleanup applies the same rules to a trade's job history.

Frequently asked questions

What is the best unique identifier for a customer in a small business?

For businesses whose customers mostly call, the mobile number, stored in one format. Email works for online businesses, but many callers never give one. Names are too common to rely on.

How often should I clean my contact list?

Ten minutes a week for duplicates and blank names, and a longer review each quarter for contacts with no activity in eighteen months. Little and often beats an annual purge.

Should I delete old contacts?

Keep customers you may serve again and records you need for warranties or tax. Delete people you have no reason to contact, especially if the record holds personal details you no longer need.

What if two family members share one phone number?

Create a contact for each person, note the shared line on both, and add a mobile number for each when you get one. Never merge them into one record.

Can I import my old spreadsheet into a new contact list?

Yes, but clean it first: one number format, duplicates merged, and records older than you can justify left behind. Import a few rows as a test before the full file.

References

  1. Federal Communications Commission (2018). Advanced Methods to Target and Eliminate Unlawful Robocalls, Second Report and Order (FCC 18-177) (opens in a new tab) ↑

  2. U.S. Census Bureau (2024). Table A-1. Annual Geographic Mobility Rates, By Type of Movement: 1948-2023 (opens in a new tab) ↑

  3. CDC National Center for Health Statistics (2025). Wireless Substitution: Early Release of Estimates From the National Health Interview Survey, July-December 2024 (opens in a new tab) ↑

  4. U.S. Census Bureau (2016). Frequently Occurring Surnames from the 2010 Census (opens in a new tab) ↑

  5. North American Numbering Plan Administrator (NANPA) (2026). About the North American Numbering Plan (opens in a new tab) ↑

  6. Federal Trade Commission (2016). Protecting Personal Information: A Guide for Business (opens in a new tab) ↑

  7. O*NET OnLine (U.S. Department of Labor, Employment and Training Administration) (2025). 43-4171.00 - Receptionists and Information Clerks (opens in a new tab) ↑

Book a demo

Meet your SI Employee.

Book a short demo. We walk through calls like yours and show what your SI Employee would answer, book and follow up.

Book a demo