How to track coaching inquiries without a CRM

How do you track coaching inquiries without a CRM?

Put every interested person in one list with six columns: name, source, status, next step, follow-up date and outcome. Add each person the day they reach out, review the list for 15 minutes once a week, and after 30 days you will see where people stop moving toward a conversation instead of guessing. A free spreadsheet is enough. The habit matters more than the tool.

What I see with coaches who feel stuck is rarely weak coaching. More often the conversations are spread across Instagram DMs, WhatsApp, email and a note on the phone, and nobody, the coach included, can say what happened to each person. This post shows you how to fix that with a simple sheet you can set up tonight.

Why does losing track of inquiries cost you clients?

When interested people are not in one place, follow-ups slip and you end up judging your business by memory, which keeps the loud conversations and forgets the quiet ones.

In practice it looks like this:

• You remember someone asked about coaching a few weeks ago, but you cannot find the chat.
• You only follow up with people who message you again first.
• You cannot say how many people asked about coaching last month, or where they found you.
• You feel busy with messages all week, yet new clients arrive in random bursts.
• You promised someone "I'll send you the details tomorrow" and tomorrow became two weeks.

Speed matters too. Research published in Harvard Business Review on online sales inquiries found that most companies respond far too slowly, and that a fast reply makes a real difference to whether a conversation goes anywhere. You cannot reply fast to people you have forgotten about.

Tracking is one of six places where online coaching growth usually stalls, and the overview of why your online coaching is not growing covers the other five. If you are not sure tracking is really your weak spot, you can find which area it is in under 3 minutes with the free CoachScan. It asks 8 short questions, gives no score, and shows which part of your path to new online coaching clients needs attention first and what to do first. It was built by Advencio, Trainera's growth partner for coaches who want more online clients.

What are the six columns every inquiry tracker needs?

Six columns are enough, because each one answers a question you would otherwise have to answer from memory later.

Keep the status list fixed. If you let yourself write "maybe", "warm", "interested?" and "follow up" as statuses, the column stops meaning anything. A dropdown helps, and in Google Sheets you can sort and filter your data so everyone due for a follow-up today sits at the top.

If you want a seventh column, make it a short notes field for one line of context, like "wants to train at home, works night shifts". Anything longer belongs in the conversation itself.

How do you add people without it becoming a chore?

Add a row the moment someone shows real interest, not at the end of the week when half the details are gone.

Real interest means they asked about price, asked how your coaching works, or said they want help with a goal. A like, a fire reaction to a story or a "nice!" comment is not an inquiry yet.

1. Keep the sheet one tap away on your phone, next to the apps where people message you.
2. Add the row before you reply. It takes less than a minute.
3. Before you close the chat, fill in the next step and the follow-up date.
4. When something changes, such as a booked call or a clear no, update the status the same day.

Your replies can set the next step for you. A few sentences you can send as they are:

• "Thanks for reaching out. Can I ask two quick questions so I can tell you honestly if my coaching fits? What is your main goal for the next three months, and what has gotten in the way so far?"
• "Sounds like we should talk. Does Tuesday or Wednesday evening work for a short call? Pick one and I'll send the link."
• "I said I'd check back today. Are you still thinking about starting this month, or is now not the right time? Either answer is completely fine."

The qualifying questions you ask in that first reply matter a lot, and how to qualify coaching leads goes deeper on which ones to use. If people go quiet right after your first answer, read why prospects stop replying before the call.

What does a 15-minute weekly review look like?

Once a week, sort by follow-up date, deal with everyone who is due or overdue, and write down one thing you noticed.

1. Filter out rows with the status client or no, then sort by follow-up date.
2. Anyone overdue: send the follow-up now, or close them as "no reply" with today's date.
3. Anyone with an empty next step: give them one, even if it is "last check-in on the 20th".
4. Count the new rows from this week and note where they came from.
5. Read the outcome column for the reasons people gave for not starting.
6. Write one sentence at the top of the sheet: "This week I noticed..."

Put the review in your calendar like a client session. Sunday evening or Monday morning is a good slot because it sets up the week. If your follow-ups keep piling up even with a review, some of the reminders can be automated, and lead follow-up automation for personal trainers shows what to automate and what to keep personal.

What will 30 days of logging show you?

After a month the sheet stops being a to-do list and becomes evidence: it shows where interested people stop moving toward a conversation or a decision.

Look at plain counts, not ratios: how many people got in touch, how many fit, how many booked a call, how many showed up and how many became clients. Then match what you see to the pattern below.

If calls are where things stall, what to do when a prospect says "I'll think about it" covers the conversation and the follow-up. If you want to go further with numbers, what to track from first inquiry to client explains each count and how to read it over time. And if many people are not a fit, the problem may sit in how your online coaching offer is structured.

Spreadsheet or coaching software: which should you use?

For people who are only interested, a spreadsheet is usually enough. Coaching software earns its place once people become clients.

A sheet is free, works on your phone, and you can share it with an assistant later. It starts to strain when several people answer your messages, or when you need reminders that do not depend on you opening the file.

If you coach with Trainera, everything after someone says yes can live in one account: training and nutrition plans, check-ins, chat and payments, and intake questionnaires are included on every plan, Free included. A simple setup is to keep the inquiry sheet for people who are interested and move a person into Trainera on the day they start.

Whatever tool you use, you are holding other people's contact details. The FTC's guide Protecting Personal Information comes down to knowing what you hold, keeping only what you need and protecting it. For an inquiry sheet that means no health details, a strong password on the account and sharing only with people who need it.

Common mistakes that make the sheet useless

• Too many columns. Age, weight, goals and diet belong in your intake questions, not in an inquiry list you need to scan in seconds.
• Logging only promising people. The ones who said no or went quiet teach you the most.
• "Later" instead of a date. Every open row needs a real follow-up date.
• Deleting rows. Close a row with an outcome instead. Someone who said "not now" in spring may be ready in autumn.
• Reviewing only when things are slow. The review is most useful in busy weeks, when people slip through.
• Changing the columns every month. Keep the same structure for at least 30 days so you can compare.

Set up your inquiry tracker in one evening

Open a new sheet and add the six columns. Then go back through your DMs, WhatsApp and email from the last two to three months and add every person who asked about coaching, with an honest outcome for each one. If you cannot fill in what happened with several of them, that is your answer about tracking, and the weekly review starts this Sunday.

Not sure tracking is your biggest gap? Take the free CoachScan: 8 questions, under 3 minutes, and it shows which area of your path to new online clients needs attention first.