← All insights
Share

Where should your customer data actually live?

Short answer

Customer data should live in one system the whole team trusts, usually a CRM, with every signup feeding into it automatically. When every signup takes a different path, you can't serve customers in the moment or nudge them toward what's next.

Every owner has a version of the same awkward moment. A parent is standing in front of you at the grocery store, they mention their kid and a camp from last summer, and you realize you have no idea what they're talking about. You smile, you nod, and you hope the conversation wraps up before the idiocracy shows.

Scattered customer data does that. It never announces itself. It just quietly takes away answers you're supposed to have.

I know this, because I watched an owner live it.

A while back I worked with a youth volleyball organization: after-school programs, spring-break camps, competitive training and summer camps. They were good at all of it, and growing fast. That was exactly the problem.

Parents could sign up by paper form. Or through the website. Sometimes both, for the same kid. None of it fed into anything central: no database, no CRM, no single list of who was registered for what. Every answer lived in an inbox, a binder or somebody's memory.

The owner told me his biggest struggle had nothing to do with volleyball. He'd run into parents around town and have no way to pull up, on his phone, which programs their kids were in. Some days he couldn't even recall a kid's name. When your whole business is community, that doesn't feel right.

What does messy customer data actually look like?

It doesn't look like a disaster. It looks like a busy, growing business where every signup takes a different path and no two records match.

One family fills out a paper form at the gym. Another submits the web form late at night. A third just emails and hopes. Somebody copies the details into a spreadsheet, or means to and doesn't. Six months later you have 4 versions of the same kid, spelled 3 different ways, and no reliable way to answer a question as basic as "what did this family sign up for last?"

The mess usually isn't laziness. It's success. The paper system that worked for 40 kids quietly breaks at 140, and everyone is too busy coaching to notice until they're the one in the grocery store aisle without an answer.

Why does scattered data cost you money?

Two ways. The first is the one the owner felt directly: you can't serve customers in the moment. Someone asks about their kid's schedule and you need 3 tools and a bit of luck to answer. Multiply that by every interaction and it slowly drains the confidence out of running the place.

The second is quieter and more expensive. You can't see what a customer should do next.

This organization ran its programs as a progression. Finish level 1, and level 2 is the natural next step. But nothing tracked who had finished what, so nothing could nudge anyone. A kid would wrap a fall session and, as far as any system knew, never exist again.

The family didn't leave. They just never got asked back at the right moment.

Call it silent churn. Marketing to those families meant one generic announcement for everybody, because there was no way to know who was ready for level 2 and who had never touched level 1.

Where should customer data live instead?

One system the whole team trusts. In practice that usually means a CRM, with everything else feeding into it.

Here's the principle before the tool: information gets entered once, by whoever collects it first, and it flows everywhere else on its own. The CRM is simply the home base that makes the rule real.

For this club, we set up a CRM as the single home for family information, connected it to their marketing platform, and built custom fields that track which programs each kid has registered for. A paper signup and a web signup now land in the same place, as the same kind of record. When the owner runs into a parent around town, he pulls up the family on his phone and sees exactly what their kids are in.

That order of operations matters more than any specific tool, and it's the same thinking behind our approach to technology decisions: understand the process first, then pick the software that supports it. Software chosen before the process just gives you a new place to copy and paste.

How do you get there without a big project?

You don't need a six-month migration. Start with 20 minutes and a notepad.

The 20-minute data audit:

  1. List every place customer information lands: paper, web forms, email, spreadsheets, point-of-sale.
  2. Pick ONE system to be the single home. If you already pay for something that could do the job, start there.
  3. For each place on your list, decide how it feeds the home: direct integration, one-time import, or retirement.
  4. Add 2 or 3 fields you actually want answers about. For the club it was "which programs has this kid done?"
  5. Set 1 automated nudge. Someone finishes level 1, they hear about level 2.

Step 5 is where the money shows up. Once records know what a customer has done, communication stops being a megaphone and starts being a conversation. The club can now see who finished level 1 in the fall and invite them straight into level 2, instead of hoping they check the website. The owner reports more signups and higher average revenue per family since the change.

Peace of mind is harder to measure but easier to spot. He can answer any question about any family from his phone, anywhere.

Isn't a CRM overkill for a small team?

Reasonable question, and I'd ask it too. If you're 4 part-time coaches and a binder, enterprise software is the wrong answer. "One source of truth" is a different idea, and a much cheaper one.

Pick the home, wire up 1 form, add 1 nudge. That's the whole starter kit. If it's not for you, no problem: the audit alone will show you where your gaps are. But data only ever gets messier on its own. It never gets neater by accident.

Frequently asked questions

What's the best CRM for a small business?

The one your team will actually use, and that connects to what you already run: your forms, your email marketing, your payments. Pick from your tech stack, not a top-10 list.

Is a spreadsheet really a problem if only one person manages it?

It works until that person is away, or two people update it at once. The bigger issue is that nothing else in the business can see it, so nothing can automate off it.

How long does a cleanup like this take?

A simple setup, one CRM, one form integration and a handful of custom fields, is usually days of work, not months. Merging old records and deciding what a household looks like is often the slow part.

Alex Wingert
Alex Wingert

Co-founder of Goodwing Solutions. Alex helps small and mid-sized businesses in Canada build the operations, people systems and technology they need to grow without the owner doing everything.

Connect on LinkedIn