Article
Set up referral tracking in any CRM in 20 minutes
seedly-crm.ghost.io
Quoted on this wiki
Every place a page here uses this source, in the order the words come in it.
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.” So let me walk you through the exact thing I built. It's three fields, one report, one automation. That's 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. “It's three fields, one report, one automation. That's it.” The three fields you actually need
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. “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 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. “They're the ones from 12 to 24 months ago, where the work has had time to produce results the client can brag about.” 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.
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. “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.
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.” 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.
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. “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.
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. “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.
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. “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.
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. “They're the ones from 12 to 24 months ago, where the work has had time to produce results the client can brag about.” 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 three fields you actually need “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.
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.” 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.
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.” 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.
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. “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.
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. “Visibility of the score changes the behavior.” The common mistakes