Your sphere of influence database is the most important asset you’ll build in real estate. Agents who use a CRM to manage their database report gross commission income 40% higher than those who don’t. But a database only delivers if it’s set up right — proper fields, consistent tags, smart segmentation. This guide walks the complete SOI database setup, field by field, tag by tag.

Why Database Setup Determines Your Income

The data is stark:

  • 46% of agents name personal connections and past-client referrals as their single best lead source
  • 82% of real estate transactions come from referrals
  • Agents using a CRM report 40% higher GCI than those who don’t

Your SOI database is where all of that lives. A well-built database makes nurture systematic, makes nothing fall through the cracks, and turns relationships into a predictable business. A poorly-built database — missing fields, inconsistent tags, no segmentation — produces the opposite: missed follow-ups, generic mass emails, and referral business left on the table.

The setup is a one-time investment that pays for decades.

Choosing Your CRM

Before structure, pick the tool. The 2026 options for real estate agents:

Real estate-native CRMs:
– Follow Up Boss — strong all-around, popular with solo agents and teams
– Wise Agent — robust, good automation, reasonable price
– kvCORE / BoldTrail — comprehensive, team-oriented
– LionDesk — budget-friendly, good for newer agents
– RealOffice360 — SOI-focused, simpler
– BoomTown / Sierra Interactive — lead-gen heavy, team-oriented

Starting point if you have nothing: even a well-built spreadsheet works for a database under 100 contacts. But move to a real CRM before you hit 150 — manual tracking breaks down past that point.

Pick one and commit. Switching CRMs is painful; choose deliberately and stay.

The Core Fields

Every contact in your database should have these fields. Set the field structure up before you import anything.

Contact Basics

  • First name
  • Last name
  • Spouse/partner name
  • Email (primary, verified)
  • Phone (mobile preferred)
  • Mailing address
  • Preferred contact method (text / email / call)

Relationship Information

  • How you know them (source / origin)
  • Relationship type (friend, family, past client, vendor, neighbor, met-at-event)
  • Tier (A / B / C — covered below)
  • Date added to database

Transaction History (for past clients)

  • Property address(es) bought/sold with you
  • Transaction date(s)
  • Transaction type (buyer / seller / both)
  • Sale price
  • Closing anniversary date

Life Stage Indicators

  • Birthday
  • Family members (kids’ names, ages)
  • Profession / employer
  • Life events (recently married, new baby, divorce, retirement, job change)

Communication Log

  • Last contact date
  • Last contact type
  • Next scheduled follow-up
  • Notes from recent conversations

Future Plans

  • Likely next transaction timeline
  • Stated interest (downsizing, upgrading, investing, none)
  • Neighborhood interests

Not every field will be filled for every contact. Fill what you know; complete more over time as you have natural touchpoints.

The Three-Tier Segmentation (A / B / C)

The foundational segmentation: every contact is an A, B, or C contact.

A Contacts (25–50 people).
Your closest relationships and highest referral potential. Recent past clients who refer. Close friends and family. Top vendor partners. The people who’d show up to your major life events.
– Contact frequency: personal touch at least quarterly, ideally more
– Touches per year: 36+

B Contacts (75–150 people).
Warm relationships, regular but less intensive contact. Past clients (not necessarily active referrers). Acquaintances you see semi-regularly. Vendors you work with periodically.
– Contact frequency: personal touch every 4–6 months
– Touches per year: 24–36

C Contacts (everyone else).
People who know you but with less regular contact. Older past clients. Casual acquaintances. Newsletter subscribers.
– Contact frequency: a few personal touches per year via market updates and community content
– Touches per year: 12–18

The tier drives the cadence. Set the tier field for every contact during setup.

The Functional Tags

Beyond tier, tags capture specifics that let you pull targeted lists. The 2026 best practice: 12 consistent, well-defined tags beat 60 inconsistent ones. Review and prune tags quarterly.

The recommended tag set for a real estate SOI database:

Relationship tags:
– past-client
– sphere
– vendor-partner
– referral-source

Intent tags:
– buyer-interest
– seller-interest
– investor

Timeline tags:
– active-pipeline (transacting in the near term)
– nurture-3-18mo (interested but not imminent)
– long-term (no near-term plans)

Neighborhood tags:
– One tag per priority neighborhood (e.g., stapleton, park-hill)

Special tags:
– do-not-email (for contacts who only want personal touches)
– vip-event-list (for client appreciation event invites)

That’s roughly 12–18 tags, all clearly defined. Resist the urge to create a new tag for every minor distinction — tag sprawl makes the database harder to use, not easier.

The Segmentation Layer

Tier + tags together produce segments you can act on. The functional segments every real estate database should support:

Past Clients. Your highest-value long-term contacts. Monthly touchpoints plus birthday and closing-anniversary outreach — 12–14 touches/year minimum.

Active Pipeline. People actively buying or selling now. High-touch, high-frequency — weekly or more.

Nurture / Long-Term. People 3–18 months out or with vague future interest. Lower frequency but still regular — 1–2 emails/month.

Sphere of Influence. Personal contacts — friends, family, colleagues, neighbors. Relationship-maintenance cadence, not a sales sequence.

The principle: a past client who closed two years ago and a buyer who requested a showing today should never get the same email. Segmentation makes that possible.

Data Collection Standards

The database is only as good as the data going into it. Set collection standards before you start:

Standard format for every field:
– Phone: one consistent format (e.g., (303) 555-0100)
– Name: First and Last in separate fields, properly capitalized
– Address: consistent abbreviation choices
– Dates: consistent format

Capture standard for new contacts:
When you add a contact, capture at minimum: full name, phone, email, how you met, and where they are in their real estate timeline. The “how you met” and “timeline” fields are the ones agents skip — and they’re the most useful for personalization later.

The weekly add habit:
Add 2–5 new contacts per week, immediately tagged and tiered. Over a year, that’s 100–250 new SOI members. Set a recurring Friday calendar block.

Automation Setup

Once fields, tiers, and tags are in place, set up automation:

Time-based automations:
– Closing anniversary email (triggers on the anniversary date field)
– Birthday email (triggers on the birthday field)
– Monthly newsletter to the full active database
– Overdue-touch alert (flags when an A contact hasn’t been touched in 60+ days)

Activity-based triggers (the 2026 standard):
The most effective 2026 CRM workflows combine time-based check-ins with activity-based triggers that fire when a contact:
– Visits your website
– Fills out a form
– Engages with a social post
– Opens/clicks emails repeatedly

When a nurture-3-18mo contact suddenly visits your home valuation page three times in a week, an activity trigger should flag them for personal outreach — they may have moved from “long-term” to “active.”

The Import Process

If you’re migrating an existing database (covered in depth in the Database Audit spoke):

  1. Export from all sources (old CRM, phone, email, spreadsheets)
  2. Consolidate into one file
  3. Deduplicate
  4. Verify emails (NeverBounce, ZeroBounce, Bouncer)
  5. Clean and standardize formatting
  6. Add tier and tags
  7. Map every column to your CRM’s fields
  8. Test import on 10–20 records first
  9. Run the full import
  10. Spot-check 10 records to confirm everything mapped correctly

Maintenance Cadence

A database is a living asset. The maintenance rhythm:

Weekly (15 min):
– Add 2–5 new contacts
– Tag and tier new additions
– Log any field updates from the week’s interactions

Monthly (30 min):
– Review contacts with no recent contact
– Update tags as contacts’ situations change
– Verify recently-added emails

Quarterly (60 min):
– Tag audit — prune unused tags, fix inconsistent ones
– Tier review — should anyone move up or down?
– Full email verification on the quarter’s additions
– Review automation performance

Annually:
– Full database audit (the deep clean)
– Re-segmentation review
– Archive truly dead contacts

Common Database Setup Mistakes

Mistake 1: No CRM. Spreadsheets break down past 100–150 contacts. Use a real CRM.

Mistake 2: Inconsistent data formats. Phone numbers in five formats, names in mixed case. Set standards before importing.

Mistake 3: No tiering. Treating all contacts the same means over-investing in C contacts and under-investing in A contacts.

Mistake 4: Tag sprawl. 60 inconsistent tags is worse than 12 consistent ones. Discipline.

Mistake 5: Missing the useful fields. Skipping “how you met,” “timeline,” “life events” — these are exactly what makes personalization possible.

Mistake 6: No automation. Manual everything fails because life gets busy. Automate anniversaries, birthdays, and overdue-touch alerts.

Mistake 7: Set-and-forget. Databases drift. Without the maintenance cadence, your database degrades over time.

Your Setup Plan

Week 1:
– Choose your CRM
– Set up the field structure
– Define your 12–18 tags
– Define A/B/C tier criteria

Week 2:
– Run the database audit / import process
– Tag and tier every contact
– Standardize data formats

Week 3:
– Set up time-based automations (anniversary, birthday, newsletter, overdue-touch)
– Set up activity-based triggers
– Test all automations

Week 4:
– Establish the weekly add habit
– Set up the maintenance cadence on your calendar
– First full month of operation

After 30 days you have a properly structured SOI database. From there, the Sphere of Influence pillar and the Build SOI From Zero spoke cover the nurture cadence that turns the database into business.

For the database audit and cleanup process, see the Database Audit spoke.

Jon Smith is a 20+ year SEO veteran specializing in real estate agent database and referral systems. He has set up SOI databases for hundreds of agents across North America.

Sources: