Set up referral tracking in any CRM in 20 minutes

Most agencies tell me referrals are their #1 channel, and most of them have ZERO data on which clients send the most. Here's the 20 minute setup that fixes that.

I'm not exaggerating about the percentage either. Almost every client I've ever closed has come through a referral or someone seeing me post in a Facebook group. I get 3-4 inbound leads a month minimum on autopilot. And for about a year and a half, I had no clue who was actually responsible for any of it.

I'd close a deal, ask "how'd you hear about me?", they'd say "oh, Mike sent me," I'd say "cool thanks Mike," and that data point would die in my inbox. Mike got nothing. I had no idea Mike had sent me four other people that year. My CRM was a graveyard of "referred by" notes nobody ever queried.

So let me walk you through the exact thing I built. It's three fields, one report, one automation. That's it.

The three fields you actually need

Every CRM I've ever touched, whether it's the one I'm building or the big subscription ones, lets you add custom fields to a contact or a deal. Most people add 47 of them and never look at any. For referral tracking you need three.

Field 1: Referred By. A relationship field on the contact record that links to another contact in your CRM. Not a text field. Not a dropdown. An actual link to another record. This matters because in 20 minutes when you want to ask "how many deals has Mike sent me?", you want to click Mike's profile and see a list, not run a fuzzy text search on a free-form field where you spelled his name three different ways.

If your CRM only supports a text field for this, that's your first warning sign. Write it down. We'll come back to it.

Field 2: Referral Source Deal. On the new deal record, a link back to the deal (or contact) the referral came from. So when I close a $5K project from someone Mike sent me, that $5K deal record points at Mike. Now I can stack them.

Field 3: Referral LTV. This one is a rollup or calculated field on the original referrer's contact. It sums up every deal value where "Referred By" equals that person. It updates automatically every time a referred deal closes.

That third field is the whole point. Without it you have data. With it you have a ranking. And the ranking is what changes how you behave.

Setting it up (the 20 minute part)

Open your CRM. Go to settings, custom fields, contacts. Add "Referred By" as a relationship/lookup field pointing back to the contact object itself. Save.

Go to custom fields, deals. Add "Referral Source" as a relationship field pointing to the contact object. Save.

Now the rollup. This is where CRMs split. The good ones let you create a calculated field on a contact that aggregates from related deals. Sum of deal value where referral source equals this contact. Set the filter to "won" deals only so pipeline tire-kickers don't inflate your numbers.

If your CRM can't do a rollup, you fake it with an automation. Every time a deal moves to "won," trigger a workflow that adds that deal's value to a number field on the referrer's contact. Same outcome, slightly clunkier.

That's the setup. Maybe 15 minutes if you're slow.

The one report that changes your business

Now build a contact view. Filter: "Referral LTV is greater than 0." Sort: descending by Referral LTV. Columns: name, email, phone, number of referrals sent, total LTV, last referral date.

Save it. Pin it to your dashboard. Name it something obvious like "Top Referrers" so future you doesn't forget it exists.

The first time I ran this view on my own pipeline I was genuinely shocked. The person I'd assumed was my top referrer was number four. The actual number one was a guy I'd done a small project for in 2024 who I hadn't talked to in eight months. He'd quietly sent me five people. I'd never thanked him properly. Not once.

I sent him a handwritten card and a gift card that afternoon. He sent me two more leads in the next 60 days. Coincidence, maybe. But also, not really.

Automating the attribution

The setup catches new referrals going forward. But it only works if the data actually gets into the fields. And here's where most people's process falls apart.

You ask "how'd you hear about us?" on the contact form. Someone types "Mike." You stare at the word "Mike" with no idea which Mike. You do nothing. Field stays blank. Six months later you have 200 blank "Referred By" fields and you've learned nothing.

The fix is two things. First, the intake form needs a dropdown of existing contacts, not a free text field. Or at minimum, a follow-up step in your onboarding workflow where you, the human, link the new contact to the referrer manually. It takes 10 seconds. Build it into your "new lead" checklist.

Second, automate the loop back. When a deal closes, fire a notification to whoever referred them. A simple email: "Hey, just wanted to let you know that referral you sent over signed up today. Means a lot. Coffee on me next time." That email does two jobs. It thanks them. And it trains them that referring you is a thing that produces a visible reward, which makes them do it again.

I had a client a while back who came to me through a referral. He already had decent offline authority but Google didn't know who he was. We connected the dots with some PR and content work. In about half a year they had almost doubled their revenue. Now, the part that's relevant here: every new lead that came through that growth, I tagged with referral source. By the time we wrapped, I had a clear map of which press placements drove which deals and which client introductions snowballed into the biggest accounts. That map is the reason I knew where to spend the next quarter's effort.

You can't make those decisions without the data. And you don't get the data without the three fields.

What I learned running this on my own book

A few things I didn't expect.

The 80/20 is real, but in referrals it's more like 90/5. About 5% of my past clients have sent me 90% of my referrals. Most clients send zero. A small handful send a steady drip. Two or three are absolute machines. Before I tracked it I treated all past clients roughly the same. Now I treat the machines very, very differently.

Referrals compound on a delay. The deals that send you the most referrals are usually not the deals that closed last month. They're the ones from 12 to 24 months ago, where the work has had time to produce results the client can brag about. This is why a brand new agency feels like a ghost town for referrals and a 3-year-old agency suddenly feels like it can't keep up. Patience, but also: track from day one so you can see it coming.

Most people don't know they're a "top referrer." When I tell mine, they're surprised, then proud, then they refer more. Visibility of the score changes the behavior. This is annoyingly basic psychology and it works every time.

The common mistakes

A few traps I've watched people walk into, including me.

Using a free text "Referred By" field. You will not query it. You will spell names inconsistently. You will give up.

Tracking referrals only on closed deals. Track at the lead stage too. A referrer who sends you 10 unqualified leads is telling you something important about how they describe your service, and that's worth fixing before you lose the relationship.

Forgetting to backfill. When you set this up, spend an extra 30 minutes going back through your last 50 closed deals and filling in the field. Without history, you have no rankings. With even a partial history, your top referrer view starts working immediately.

Not closing the loop. If you don't thank the referrer, you've built a tracking system for your own ego. The whole point of knowing who your top referrers are is to do something about it.

Building this in a CRM that fights you. And this is the contrarian bit. If you've just read this and thought "my CRM can't do relationship fields" or "I can't build a rollup" or "I'd need to pay $200 more a month per seat to unlock custom fields," that's not a tracking problem. That's a tooling problem. The whole reason I started building my own CRM is that every subscription tool I tried either crippled the data layer to upsell me into a higher tier, or made simple things like this take a developer to configure.

Referral tracking is, no exaggeration, the single highest-leverage thing a service business can put in their CRM. If your CRM doesn't make this easy, it might be the wrong CRM.

20 minutes. Three fields. One report. One automation. Go set it up. Then in 90 days come back and tell me who your actual top referrer is. I'm betting it's not who you think.

I talk about this kind of stuff regularly on my YouTube channel if you want the video version.