Skip to content
Blog

Dental CRM or a spreadsheet? 6 lead statuses to track

Maciej Odrobina, founder of Helpify

Maciej OdrobinaFounder of Helpify

LinkedIn profile

Published

In short

A spreadsheet is enough to start, as long as each lead from your ads has one of six statuses in it and one person marks them the same day. Your practice management software knows a patient only once an appointment is on the schedule. A lead starts earlier, when someone leaves a phone number. A dental CRM helps once leads pile up or once you want reminders to go out on their own. If nobody keeps the statuses current, a spreadsheet won't help, and neither will new software.

Who this is for

This is for you if you own or manage a private dental practice and you advertise services where you have open chair time. Leads from your ads land in an inbox, in a spreadsheet from your agency, or on a sticky note by the front desk phone. Someone told you to buy a CRM. You already have practice management software, and you don't want a second system.

Start with a quick test. Take the phone number of someone who left a lead last week and ask your team what happened to that person. If nobody can answer right away, this article is for you.

If each lead at your practice already has a status and a person who owns it, use the table below as a checklist. If your schedule is full for months, this article won't help you. You couldn't offer a person from an ad an appointment soon anyway.

We wrote this at Helpify. Helpify brings patients to dental practices and follows up so they make it to the chair. You can read more about us on the About Helpify page.

Six statuses for a lead from your ads

A lead is a person who saw your ad and then left a number in a form or called the practice. From that moment until a visit, or until they drop out, the lead has exactly one status at any time. The status tells you what happened last and what the front desk does next.

Status When you set it What the front desk does next
New lead When the lead goes into the spreadsheet, before anyone calls. Calls the person and changes the status after the call.
Call back When the person didn't answer or asked for a call on another day. Writes down the date of the next attempt. After the last attempt, closes the lead.
Appointment booked When the patient has an appointment in your practice management software. Sends a confirmation with the date, time, and address, and a reminder before the visit.
Showed up On the day of the visit, when the patient came in. Nothing more here. You track this patient's next visits in your practice management software.
No-show On the day of the visit, when the patient didn't come in and didn't cancel. Offers a new time. If the patient reschedules, the status goes back to "Appointment booked".
Closed When the person isn't interested, asks not to be contacted, or doesn't answer after the last attempt. Stops calling and writes the reason in the notes.

For "Call back", set a limit ahead of time, for example three contact attempts. Stick to it with each person.

A person marks every status. A spreadsheet doesn't know that the front desk called or that a patient didn't show up until someone types it in. If you're looking at software, ask the vendor whether it knows these things on its own.

How a lead differs from an appointment in your practice management software

Practice management software is built around the schedule. A patient appears in it when the front desk books them for a specific day and time.

A lead from an ad starts earlier. The person left a name and a number. They have no appointment and may not have a chart at your practice yet. Getting them on the schedule can take a few days and a few calls. Some people never book.

Check whether your software has a place for a person without an appointment. If it doesn't, the front desk keeps those people in their heads, in an inbox, or on sticky notes. There, a lead has no status and no owner. When someone at the front desk goes on vacation, nobody knows who needs a second call.

The six statuses cover this stretch, from a phone number to the first visit. You don't need to buy new software for it right away.

A spreadsheet to start: columns, who fills it in, and when

One row is one lead. Your front desk fills in the spreadsheet between calls, so keep it simple. These columns are enough:

  • Date of the lead.
  • Name and phone number.
  • The service the person asked about.
  • Where the lead came from: a form or a phone call.
  • Status, picked from a list of the six, so nobody types their own word.
  • Number of contact attempts and the date of the last one.
  • Next step and its date, for example "call Thursday morning".
  • Date of the booked appointment.
  • Who last changed the row.
  • Notes, including the reason a lead was closed.

One person at the front desk keeps the spreadsheet. We write about that person below. They add a new lead the same day it comes in. They change the status right after each call or missed attempt, the same day, while they still remember what happened.

If leads come into an inbox or a spreadsheet from your agency, decide who moves them into your spreadsheet and at what time of day. You can also ask the agency to use the same columns in its spreadsheet. Then your front desk works in one place.

One person and one time of day

Ask your team who owns new patients from ads. If you hear two names or none, the spreadsheet has several authors and no owner. Everyone assumes someone else will make the entry.

Pick one person to handle leads from ads and a second person as backup. Tell the whole team. When someone else takes a call from a lead, they hand it to the owner.

Set a fixed time of day, too, for example an hour before you close. At that time, the owner goes through every row marked "New lead" or "Call back" and checks that the next step has a date. Then they mark today's appointments as "Showed up" or "No-show".

Without that person and that time of day, any spreadsheet or software soon stops showing what really happened. The statuses stop changing. The front desk goes back to sticky notes, and nobody opens the spreadsheet anymore.

Once a week, you or your office manager count the rows in each status. Then you know how many people are waiting for a call and how many didn't show up.

We describe the stages from the lead to the consultation, and who owns each one, in implant leads not showing up? 5 stages from lead to chair.

When a spreadsheet stops being enough

The first sign is the number of leads. There may be so many that the person at the front desk forgets the second call to someone who left a number a few days ago. The spreadsheet won't remind them. It shows the date of the next step only to whoever opens it.

The second sign is messages to patients. If you want the confirmation and the reminder before the visit to go out on their own, a spreadsheet can't do that. Your front desk has to send each message by hand.

We won't give you a cutoff, because it depends on your front desk and how much else they handle. Check it at your practice. Count the rows where the next-step date has passed and the status hasn't changed. If those rows grow week after week, even with a fixed review time, it's time to look at software.

We explain how to count the people from ads who move from one stage to the next in how to get more dental patients.

Questions to ask before you buy software

Before you sign up for new software, ask the vendor about your front desk's day-to-day work.

  1. Who marks the statuses? Does the software know on its own that the front desk called or that a patient didn't show up, or does someone have to click it?
  2. What does the software do on its own? Does it send the patient a confirmation and a reminder? Does it remind the front desk about the next call attempt?
  3. How does a lead from a form or a phone call get into it? Does someone have to copy it over?
  4. Will your front desk work in two programs? Who moves a booked appointment into your practice management software?
  5. What will you see as the owner? Can you see the number of leads in each status without asking the front desk for a summary?

Compare the answers with your spreadsheet. If the software does the same things the spreadsheet does, your front desk just gets one more place to type. If an agency handles your leads, ask it questions 1, 3, and 5 as well.

How we do it

Helpify brings patients to dental practices and follows up so they make it to the chair. In your Helpify dashboard, each lead has one of six statuses: New lead, Call back, Appointment booked, Showed up, No-show, and Closed.

We run Facebook and Instagram ads with videos filmed at the practice, and we build a service page with a form. After every lead, the patient gets a confirmation and the front desk gets reminders to call and book. We remind patients about appointments, and after a no-show we help the front desk reschedule. The dashboard shows leads, booked appointments, patients who showed up, and ad spend.

You pay once for the campaign build: the service page, the ad videos, and front desk training. After that, you pay a flat monthly fee for campaign management, and it doesn't start until the day your ads go live. You pay your ad budget separately, straight to Meta. I'll show you the numbers along with a plan for your practice.

Helpify's fee doesn't depend on the size of the practice's ad budget.

Helpify is based in Poland. We work remotely and take on dental practices in Poland and the United States.

You can read about the whole process on the Helpify System page. Book a free 30-minute call. It's online, with Maciej Odrobina, the founder of Helpify. Book a call.

Questions and answers

Does a dental practice need a CRM?

Not on day one. It needs a place where each lead from your ads has one of six statuses, and a person who marks them the same day. A spreadsheet is enough for that at the start. A CRM makes sense when your front desk can't keep track of the next calls, or when you want messages to patients to go out on their own.

How is a CRM different from practice management software?

Practice management software tracks a patient from the booked appointment on. A CRM, in the sense we use here, tracks the person earlier: from the number they left to the first visit, or until they drop out. Check whether your software has a place for a person without an appointment. If it doesn't, track that stretch in a spreadsheet or in separate software.

Is a spreadsheet of leads safe?

We can't decide that for you, because it depends on how your practice keeps the spreadsheet. Ask the person who handles compliance at your practice how patient data should be stored. Do it before your front desk enters the first lead.