How to Build a Real Estate Sphere of Influence (SOI) Database
Building a real estate sphere of influence starts with listing every person who already knows and trusts you, putting those names into one database, recording how you know each contact, sorting people into tiers by relationship strength, and staying in touch on a schedule you can actually keep. The list is the easy part. The system is what pays.
Every new Ontario agent hears "work your sphere" during their first week at a brokerage, and almost nobody shows them what that means in practice. This guide covers who belongs in the database, how to build it in an afternoon, what to record about each person, and how to stay in touch for years without feeling like a pest.
What is a sphere of influence in real estate?
A sphere of influence (SOI) in real estate is the full circle of people who know you by name: family, friends, neighbours past and present, former coworkers, the parents on your kid's soccer team, your dentist, your barber, your accountant. An SOI database is that circle written down and organized, with each person's contact details, a note on how you know them, and whatever you know about their housing situation. It matters because people tend to hire a realtor they already know, or one a trusted friend recommends, long before they respond to a stranger's ad. For a solo agent in Ontario with more time than marketing budget, the sphere is the one lead source that is already built, costs almost nothing to work, and compounds every year you maintain it.
If you are brand new, this is also where deal number one is hiding. Your first listing as a new Ontario agent will almost certainly come from someone on this list or someone they know, not from a stranger who found you online.
Who belongs in your SOI database?
The honest answer is almost everyone you know by name. New agents tend to write down thirty obvious contacts and stop, and the list you actually want is usually several times bigger. Work through these groups:
- Family and close friends, including the cousins you only see at weddings
- Neighbours, current and past, including the street group chat and the condo board
- Former coworkers from your pre-real-estate career, especially anyone you would happily meet for lunch
- Parents from your kids' school, daycare, teams, and activities
- The people you pay: stylist or barber, dentist, mechanic, accountant, trainer, family lawyer
- Your faith community, volunteer groups, service clubs, and rec leagues
- Local business owners who know your face and your coffee order
- Classmates from school and from your registration courses
- Agents in other cities and provinces who need a trusted contact in your market
Two warnings. First, do not prejudge anyone. The quiet former coworker you assume rents might own two investment properties in Barrie. The friend who "just bought" knows three other people who are about to. You are not deciding who will transact; you are deciding who knows your name. Second, the database is permission to keep in touch, not an obligation. If there is someone you genuinely would not want to work with, leave them off and feel no guilt about it.
One group deliberately not on this list: internet leads who do not know you yet. They are real, but they are a different animal with a different playbook, covered in our guide to nurturing cold real estate leads. Mixing strangers into your sphere muddies both systems.
How do you build the list without missing anyone?
Set aside one honest afternoon and work through these seven steps in order. Each one surfaces names the previous step missed.
- Export your phone contacts. This is your richest single source, so start here rather than trying to recall names from memory.
- Mine your email accounts. Search your personal inbox, and any old work account you can still access, for people you corresponded with more than once.
- Walk your social lists. Facebook friends, Instagram followers you actually know, and every LinkedIn connection. Scroll the full list; do not trust your memory.
- Raid old paper and digital lists: wedding guest list, holiday card list, kids' team rosters, alumni directories, old phone backups.
- Add the people you pay and the people who pay you: service providers, clients from a former career, tenants, landlords.
- Run a memory-jogger pass. Go through occupations alphabetically (accountant, barber, chiropractor...), then every neighbourhood you have lived in, every job you have held, every team or club you have joined.
- Merge everything into one home and remove the duplicates.
Expect the result to feel a little awkward. There will be names you have not spoken to in five years. That is normal, and it is not a problem to solve today. Reconnection is a gentle, months-long play, not a batch email announcing that you sell real estate now.
What should you record about each contact?
A name and a phone number is a contact. The fields below are what turn a contact into a relationship you can maintain. You will not have every field for every person on day one, and that is fine; the database fills in as you use it.
| What to record | Example | Why it matters |
|---|---|---|
| How you know them | Former coworker, Vaughan office | Personalizes every future message |
| Contact channels | Mobile, email, mailing address | Calls, notes, and cards need different details |
| Housing situation | Owns a semi in Hamilton, bought a few years ago | Tells you which updates are relevant to them |
| Household notes | Partner's name, kids, dog, job, interests | Fuel for genuine conversation |
| Consent | Agreed to the monthly newsletter in March | Keeps your email and texts legal |
| Last touch and next touch | Coffee in June; check in this fall | Turns a list into a system |
The consent field deserves special attention. Canada's anti-spam legislation applies to commercial email and text messages, and it requires consent before you send them, as outlined by Innovation, Science and Economic Development Canada. So when a friend says "sure, add me to your newsletter," record the date and how they agreed. It takes five seconds and protects you later. The full picture is worth understanding before your first mass email; our plain-English guide to CASL compliance for realtors covers it.
How should you organize your sphere into tiers?
Not every relationship carries the same weight, and pretending otherwise is how agents end up sending their mother and a distant LinkedIn connection the identical newsletter and nothing else. Sort every contact into one of three tiers based on relationship strength, not on how likely you think they are to move.
| Tier | Who fits | A realistic rhythm |
|---|---|---|
| A: Advocates | Past clients, close friends, anyone who has already sent you business | A personal touch every month or so, plus your regular updates |
| B: Supporters | People who know you well and would happily take your call | A personal touch every two or three months, plus updates |
| C: Acquaintances | People who know your name and face, but not much more | Newsletter and market updates, plus a personal note once or twice a year |
Relationship strength and readiness to transact are different things. A C-tier acquaintance can list their house next month; the tier only decides how much personal energy you invest between now and then, because your hours are finite and your A tier earns most of them.
You can run all of this in a spreadsheet at first, and a spreadsheet you actually use beats software you ignore. The reason solo agents eventually move to a CRM is that the database and the follow-up belong together: CloseFlow, for example, keeps each contact's email and text history in one thread, logs CASL consent on the record, and runs gentle automated follow-up plans, so a B-tier supporter never accidentally goes eight quiet months without hearing from you.
How do you stay in touch without being annoying?
One rule sits above all the tactics: every touch should be either useful or genuinely personal. "Just checking in, let me know if you hear of anyone looking to buy or sell" is neither, and a database worked that way trains people to dread your name. Build your rhythm in layers instead.
- A steady base layer for everyone: a short monthly email with a genuinely local market note, one useful homeowner tip, and zero pressure. Neighbourhood-level beats national headlines every time.
- A personal layer on top: birthday messages, home anniversaries, congratulations on new jobs and new babies, and the occasional "saw this and thought of you." For your A tier, actual phone calls and coffees.
- Show your work. When you solve a problem for a client, tell the story (with their permission) in your newsletter or on social. People refer what they can picture.
- Comment and reply on social media. These micro-touches keep you familiar, but they supplement direct contact; they do not replace it.
- Ask rarely, and ask well. If every message ends with a plea for business, none of them land. There is a right way to ask past clients for referrals without making it weird, and it starts with having been useful all year first.
What are the most common SOI database mistakes?
- Building the list once, feeling productive, and never opening it again
- Blasting every tier with identical messages and calling that staying in touch
- Going silent for a year and reappearing only when you need business
- Prejudging who can buy, sell, or refer, and quietly deleting the "unlikely" ones
- Splitting the sphere across your phone, three inboxes, and a drawer of sticky notes
- Waiting until the list is complete and perfectly organized before contacting anyone
Every one of these has the same root cause: treating the database as a project instead of a habit. The project version gets finished and forgotten. The habit version gets a little better every single week.
Start with twenty names this week
Do not wait until the database is polished. Pick twenty A and B tier people today and send each one a short, personal message that has nothing to do with real estate: a question about their summer, a memory, a congratulations you owe them. Log each reply, note one detail you learned, and set the next touch date. Next week, pick twenty more.
That is the whole engine. The agents whose spheres send them steady business are not smoother or better connected than you; they simply wrote the circle down, kept it in one place, and never let the conversation go cold.
Frequently asked questions
How many contacts should a new agent's SOI database have?
There is no magic number. Most agents who work through their phone, email, social accounts, and old lists like wedding guests and team rosters end up with far more names than they expected. Size matters less than coverage: the goal is that everyone who already knows you is written down somewhere you will actually look. A smaller list you touch consistently beats a huge list you ignore.
What is the difference between an SOI database and a lead database?
Your SOI is people who already know you personally: friends, family, neighbours, former coworkers, past clients. Leads are strangers who raised their hand online or at an open house. They need different treatment. Your sphere gets personal, relationship-first contact. Cold leads need a slower, value-first nurture track, because they have no reason to trust you yet.
Should other real estate agents be in my SOI database?
Yes, as long as they work a different market. An agent in Ottawa, Calgary, or Halifax cannot serve a client moving to your area, so they refer the file to someone they trust. Course classmates, conference contacts, and agents you meet online can become a steady referral channel if you stay in touch like you would with any other relationship.
Do I need permission to email my sphere in Canada?
For commercial email and text messages, yes. Canada's anti-spam legislation (CASL) requires consent before you send commercial electronic messages, so ask before adding anyone to a newsletter or automated sequence and record when and how they agreed. Personal one-to-one notes are a different matter, but anything that looks like marketing should ride on documented consent.
How often should I update my SOI database?
Treat it like brushing your teeth: small and constant beats occasional deep cleans. Add or update a record right after every conversation, while the details are fresh. A weekly ten-minute review catches anything you missed. Databases die when updating them becomes a quarterly project instead of a daily habit.
Sources
- Innovation, Science and Economic Development Canada - Canada's Anti-Spam Legislation (accessed July 2026)