Your leads are dying in a spreadsheet

Every studio I've talked to has the same shape of problem with new-family inquiries. Someone calls. Someone DMs Instagram. Someone fills out a contact form. Someone walks in off the street. The front desk writes the name on a sticky note, in a notebook, in a Google Sheet, or in their head — and intends to call them back.

Some of those families turn into enrollments. Most don't. And the studio has no idea why, because there's no record.

The reason this matters is that new-family acquisition is the slowest, most expensive part of running a studio. The cost-per-lead of a paid ad is real money. The cost of the recital where prospective families saw your work was real money. And the cost of the front desk hour that's about to be spent trying to remember which lead you owe a callback to is real money.

If you're going to spend money attracting prospects, the worst thing you can do is lose them in the handoff between "they're interested" and "they're enrolled."

What's actually happening when a lead "goes cold"

When people say a lead went cold, what they usually mean is one of four things:

1. The studio didn't reply fast enough. Prospective families are usually shopping. They're comparing two or three studios. Whoever replies first, and with the most specific information, almost always wins. If your front desk takes 24 hours to get back to a Tuesday-afternoon inquiry, that family has already booked a tour somewhere else by Wednesday morning.

2. The studio replied but couldn't pin down a time. "Let's set up a tour — what works for you?" "How about Tuesday?" "Tuesday I'm not in, how about Thursday?" "Thursday works in the morning." "We're closed Thursday mornings." Three emails in, the family loses momentum.

3. The tour happened but no one followed up. The family came in, met the staff, watched a class, and then nothing. No follow-up text, no email two days later, no "ready to enroll?" prompt. The momentum dies because the front desk got busy with the existing customers in front of them.

4. The family said "let me think about it" and was never heard from again. Sometimes this means no. More often it means "I forgot." A nudge after a week or two recovers a significant fraction of these. Nobody nudges.

Notice that none of these failures are about the studio itself. They're all about operational handoff. The studio could be excellent and still lose the family to a worse studio that happens to have a better intake process.

The first fix: let prospects book themselves

The single biggest improvement most studios can make is to remove the front desk from the first booking. Stop trying to schedule tours by email or phone.

Instead: publish a public booking page. One URL. The prospect picks a date and time that genuinely works for the studio (because availability is built into the page, not in someone's head), enters their contact info, and is confirmed. Done. They get a confirmation email, the studio gets a notification, and the appointment is on the calendar before any human has touched the request.

The change in lead quality from this one shift is bigger than people expect. A family that books themselves at 9pm on a Sunday is a substantially more committed prospect than one who fills out a contact form and waits. They've already taken an action. They've already put it on their calendar. The conversion rate from "self-booked tour" to "enrolled family" is typically 2-3x the rate from "contact form submission."

The second fix: every lead in one place

The spreadsheet approach to leads has a specific failure mode: once a lead is in the spreadsheet, no one looks at it again.

The minimum a lead record needs:

• Contact info (name, email, phone)
• What they're interested in (age of student, style, time of day, anything they told you)
• How they got to you (Instagram ad, recital, friend's recommendation, walk-in)
• Current status — booked, completed tour, cancelled, no-show, converted to family, lost
• The next action — call them back, send a follow-up, mark cold

The first four are data. The fifth is what makes the lead list useful: it converts a passive log into a worklist. "Here are the 14 leads that took a tour but haven't enrolled yet. Who's calling them?" That's a productive conversation. "Here's the Google Sheet" is not.

The third fix: the conversion step itself

This one is undersold. When a lead decides to enroll, what happens next?

At most studios, the front desk asks them to fill out a new-family form. They re-enter their name, their student's name, their address, their phone number — all of which they already entered when they booked the tour. Then a different system gets a "new family" record, separate from the lead, and the lead history is now disconnected from the family.

This is administratively wasteful and it loses you the attribution data. Six months later when you're trying to figure out which marketing channels are working, you can't trace this family back to "Instagram ad → tour booking → enrolled" because the lead and the family are two unrelated rows in two unrelated tables.

The fix: convert the lead directly into the family record. One button. The lead's contact info becomes the family's contact info. The lead status flips to "converted" and points at the new family. The history is preserved. The data flows.

You can also email a converted lead to send them an automatic welcome message, payment-method setup link, or class-recommendation list. Nothing fancy — just acknowledging the transition. This is where a lot of studios drop the ball: the family enrolls and then doesn't hear anything until their first class. Two weeks of silence after a financial commitment is the worst possible thing to do.

The follow-up cadence that actually works

Once you have leads in one place with status, you can do the simple thing that the spreadsheet approach prevents: nudge them at the right times.

A cadence I'd recommend for most studios:

• Immediately after booking the tour: confirmation email with the date/time and a note about where to park.
• Day before the tour: reminder text. Reduces no-shows by 30-50% on its own.
• Day after the tour: a short "great to meet you" follow-up with a link to enroll. Conversion is highest in the 24-48 hours after the tour.
• One week later if still pending: a softer nudge. "Just checking in — any questions about [specific class you discussed]?"
• One month later if still pending: final touch. After this, mark cold and stop. Continuing past this is harassment, not nurturing.

The whole cadence runs on auto-pilot if your software lets you target an email audience by lead status. "All leads who booked a tour, completed it, but haven't converted to a family in the last 7 days" should be a saveable, sendable group.

What to track and what not to track

A trap I've seen studios fall into is over-tracking. They try to build a full CRM with notes, custom fields, deal stages, win/loss reasons. After three weeks the data stops getting updated, and the system rots.

Track only what you'll actually use:

Worth tracking: source (where they came from), status, conversion date, the class or program they were interested in. These let you measure marketing channel effectiveness and forecast enrollment.

Skip: probability percentages, deal stages with five sub-statuses, custom notes fields, sentiment ratings. These feel professional and are almost never useful for a small studio. The front desk doesn't have time to maintain them.

If you're tempted to build out a more elaborate system, ask: what would I do differently with this data that I wouldn't do without it? If the answer is unclear, don't collect it.

The unsexy honest version

Most studios that struggle with new-family acquisition don't have a marketing problem. They have an operational problem. The leads are coming in. The leads are just dying somewhere between "interested" and "enrolled" because nobody owns the handoff and nobody can find them on Wednesday.

You can solve most of this with three things:

1. A public booking page so prospects can book themselves.
2. A single list of every active lead with their status and next action.
3. A one-click path from lead to family that preserves attribution.

That's it. The studios that do these three things see their conversion rate from inquiry to enrollment double or triple compared to studios running the spreadsheet system. Not because the studio got better — but because they stopped losing the prospects they were already attracting.

---

James runs a dance studio with his wife and built Presently because nothing else fit the way studios actually work. Presently includes a built-in Sales Appointments module with public booking pages, lead tracking with status and source, and one-click conversion from lead to family. See how it works or start a free trial.