Key takeaways
- Referral and affiliate software is usually its own monthly bill. Ours isn't software at all, it's a handful of files and the CRM we were already running.
- Anyone can apply. I approve an applicant into an active affiliate by hand, which assigns them a unique link and a commission rate.
- A referred lead stays attributed to the person who sent them for 90 days across the entire site, not just the first page they land on.
- A weekly task checks for closed deals tied to an affiliate link and flags what's owed. It never pays anyone automatically. I still write the check.
- The whole thing runs on local records and a CRM we already pay for, so there's no new recurring cost to run a referral program at all.
Every referral program I looked at before building this one wanted a monthly fee just to exist, on top of whatever we were already paying for the CRM doing the actual work of tracking leads. That felt backwards. A referral program should be cheap to run, since its entire premise is that someone else is doing free marketing for you.
How someone actually gets in
Someone applies at a simple page on the site. I review it and make the call by hand: is this someone whose referral is worth crediting long term. Once approved, they get flipped from applicant to active affiliate, which assigns them a unique link carrying a short referral code, and sets their commission rate. Ten percent is the default, though nothing forces that number to stay fixed for every case.
That approval step matters more than it sounds like it should. An automatic approval would eventually let anyone spam a link with no relationship to the business at all. A human glance at who's asking keeps the program pointed at people who'll actually vouch for us to someone real.
Why 90 days and why the whole site
A referred lead doesn't always convert on the first visit. Someone might click a friend's link, look around, leave, then come back two weeks later ready to actually fill out a form. If attribution only counted the first page loaded from that link, most of the real credit would evaporate before it ever mattered. So the attribution window runs 90 days, and it follows the visitor across the whole site, not just one landing page, because the actual decision to become a customer rarely happens on the first click.
The commission step stays a flag, not a switch
Once a deal closes and it's tied to an affiliate's referral, a task runs weekly to check for exactly that: closed business connected to a live referral code. It calculates what would be owed at that affiliate's rate and creates a task on their record so I see it. It does not send money. It never touches a payment rail at all. I look at the flagged amount, confirm the deal actually closed the way the record says it did, and I'm the one who pays it out.
That's a deliberate choice, not a limitation we're waiting to remove. A payout is real money leaving the business over a program that's still fairly new. Keeping a human in that specific loop, while automating everything upstream of it, means the parts that are tedious and repetitive get automated, and the one part with real financial weight doesn't.
Why local files instead of a platform
The unique codes, the commission rates, the attribution windows, all of it lives in plain records this system already reads and writes, tied to fields already sitting in the CRM we run every other part of the business through. There's no separate dashboard to log into, no separate monthly charge, and no second source of truth that could quietly drift out of sync with what the CRM already knows about a contact. One system, one bill, one place attribution actually lives.
Why this matters for Bay Area and San Jose businesses
A lot of small businesses assume a referral program means signing up for another piece of software with its own login and its own monthly line item. It doesn't have to. If you're already running a CRM that can hold a custom field and a task, most of what a dedicated affiliate platform charges for is stuff you can build once and never pay rent on again.
Practical steps
- Decide who's actually allowed to refer people before you build anything. An open program with no approval step gets gamed faster than you'd expect.
- Set an attribution window long enough to match how your customers actually decide, not how fast you wish they decided.
- Automate the tracking and the flagging. Keep the actual money movement as a human decision until the program has a track record.
- Check what your CRM can already hold before paying for a separate tool to hold the exact same information.
We build systems like this at On Point Tech Solutions in Los Gatos, serving San Jose and the whole Bay Area. Every one, you own outright, done for you or taught with a full SOP. If a referral program sounds like something you've been putting off because of the software cost, that cost might not be real. Start at optechsol.llc.