Lesson 03 · 13 min read
Your CRM and Data Hygiene
Set up a commercial CRM around owners, entities, properties, and deals, keep the data clean, and use it to never drop a follow-up.
A commercial contact list is not a list of people. One owner may control three LLCs, each holding a different building, and one deal may involve a seller, a buyer, a tenant, a lender, two attorneys, a title agent and a qualified intermediary (QI), the neutral party who holds funds in a 1031 tax-deferred exchange. A customer relationship manager (CRM) built for simple one-name, one-deal sales will blur all of that together.
This lesson shows how to structure your CRM so it matches how commercial deals work, how to keep it clean, and how to use it every day so no follow-up depends on memory.
Builds on. Pipeline Tracking and Your First 90 Days in Course 23 gives you the nine pipeline stages and the weekly scorecard. We do not repeat them here. Time, Calendar, and Focus gives you the protected blocks where CRM work happens.
Education, not legal advice. Confirm legal and tax points with your broker of record, a Florida attorney and a CPA. Your brokerage's policies come first.
Why commercial records differ
Think in six record types. Each one has one job, and links do the rest.
| Record | What it holds | Links to |
|---|---|---|
| Contact | One person: name, role, phone, email | An entity, notes, tasks |
| Entity | The LLC, trust or corporation that holds title | Its contacts and its properties |
| Property | One parcel: address, parcel ID, asset class, size | One owner entity, any deals |
| Deal | One engagement on one side (listing, tenant rep, buyer rep) | A property, an entity, contacts with roles |
| Task | A dated next step | Any record above |
| Note | A dated log of one touch | A contact or deal |
Two rules follow. First, type the owner once. If the same entity later buys a second building, you add a link, not a new record. Second, give each party a role on each deal, such as seller, buyer, landlord, tenant, lender, attorney, title agent or QI. The same person can be seller on one deal and buyer on the next, so the role belongs to the deal link, not to the contact.
Choosing a CRM as a rookie
Ask your broker of record first. Many brokerages provide a system, and some restrict what you may use for client data. Also ask who owns the data and what you can take with you if you leave. Do not build a two-year database in a tool you cannot export.
If you choose your own, use this table.
| Criterion | What to look for | Why it matters |
|---|---|---|
| Tags | Several per record | Farm, tier, asset class, source |
| Custom fields | Text, number, date, and dropdown types | Clear height, parcel ID, lease expiration |
| Tasks and reminders | Due dates, recurring tasks, a daily list | Follow-up without memory |
| Email logging | Sent and received mail attach to the record | Fewer manual notes |
| Import and export | Clean spreadsheet in, full spreadsheet out | Your data stays yours |
| Mobile | Log a call between stops, never while driving | Notes within minutes of a touch |
| Cost | Total per year, including add-ons | Fits your first-year budget |
Free and low-cost tiers often cap records, users or custom fields. Paid tiers add automation and reporting. Check current pricing with each provider. A spreadsheet is acceptable for your first 100 owners, as Course 23 notes, if every row has a stage and a dated next step. Test any tool by exporting everything before you commit.
Design your fields
Fewer fields, filled in every time, beat forty fields half empty. Start with these.
| Record | Field | Notes |
|---|---|---|
| Contact | Decision-maker | Yes, no or unknown |
| Contact | Role | Owner, manager, CFO, attorney, CPA |
| Contact | Phone and email | One format, verified |
| Contact | Do-not-contact flag | Yes or no, with date |
| Contact | Source and date | County records, referral, event |
| Entity | Legal name | Exactly as on Sunbiz |
| Entity | Sunbiz status | Active or inactive, with check date |
| Entity | Manager or registered agent | Person who signs |
Sunbiz is Florida's online corporate records database. Your farm is the set of owners you work on a repeating cycle, and tier A, B or C ranks them by priority. Recheck status before any meeting where the owner will discuss signing. Researching the Property and the Owner in Course 22 covers signing authority.
| Record | Field | Notes |
|---|---|---|
| Property | Address and parcel ID | Parcel ID is the county's number for one parcel, and it is your match key |
| Property | Asset class | The property type: industrial, NNN, retail, medical office, land. NNN (triple net) means the tenant pays taxes, insurance and maintenance |
| Property | Building SF and land size | Verify, since appraiser SF is a lead |
| Property | Farm and tier | A, B or C from your farm plan |
| Industrial | Clear height, bays, dock and grade doors, power, yard acreage | Clear height is floor to the lowest ceiling obstruction. Yard matters for industrial outdoor storage (IOS) |
| NNN | Tenant, lease expiration, options, rent bumps | Bumps are scheduled rent increases. Note whether the guaranty (who backs the lease) is corporate or franchisee |
| NNN | Annual rent and net operating income (NOI) | Owner-stated until you verify |
| Deal | Stage, side, price, fee | Fee stays blank until an agreement is signed |
| Deal | Key dates | Appointment, listing expiration, contract dates |
Course 23 Choosing Your Farm explains tiers. For what the asset fields mean, see Flex and Small-Bay Industrial in Course 17 and Reading the NNN Lease in Course 13.
Import and clean your lists
Most rookies import a county records list, then discover it is really a list of parcels. Clean it before you dial. Building the Owner List from Public Records in Course 23 shows how to build the list. This is how to load it.
| Step | What to do | Done when |
|---|---|---|
| 1. Back up | Save the raw file untouched | Original stored in a dated folder |
| 2. Group by owner | Match on owner name and mailing address | One row per owner, parcels attached |
| 3. Normalize entities | One spelling of each LLC suffix and name | Every entity matches its Sunbiz record |
| 4. Verify contacts | Confirm each phone and email by a real touch | Unverified numbers flagged, not trusted |
| 5. Tag source | Add source and date to every row | No record without a source |
| 6. Search first | Look for the owner before creating a record | Duplicates stopped at entry |
| 7. Merge, not delete | Combine duplicates and keep the history | One record holds all notes |
Here is why step 2 matters (illustrative numbers). A list has 300 parcel rows but 220 unique owners. Your effort follows owners, not parcels. At 6 minutes per touch, 300 x 6 = 1,800 minutes, or 30 hours, for a full pass. By owner it is 220 x 6 = 1,320 minutes, or 22 hours. You save 1,800 - 1,320 = 480 minutes, which is 8 hours. And 300 - 220 = 80 rows collapsed, or 80 ÷ 300 = 26.67 percent of the list.
For ongoing cleanup, schedule one 30-minute monthly block. In a 400-contact database with a 6 percent duplicate rate (illustrative, not a benchmark), 400 x 0.06 = 24 duplicates to merge.
Daily use
The system only works if every touch leaves a trace. Follow one rule: no touch is logged without a dated next step.
The one-page daily CRM routine (about 20 minutes a day, plus the few minutes it takes to log each touch):
- Start of day, 10 minutes. Open the Today view, then Overdue. Pick your three most important follow-ups. Clear or reschedule everything overdue.
- After every touch, within 5 minutes. Log who, what was said, and a next step with a date.
- End of day, 10 minutes. Check that every record you touched has a dated task. Update stages. Add any new owners you met.
- Friday, 30 minutes. Run your reports (see below) and set next week's top follow-ups.
That is 20 minutes x 5 days = 100 minutes, plus 30 for Friday, or 130 minutes a week (2 hours 10 minutes).
Set up four saved views and open them daily:
- Today. Tasks due today or earlier.
- Overdue. Tasks past due, oldest first.
- Tier A. Owners in your top tier, sorted by last touch date.
- Appointments this week. Deals at the appointment set stage with a date in the next seven days.
Save three templates. First, a log note that you paste after every call.
(a) Situation: You just finished a call with an owner.
[Date] call with [Name], [role] at [entity]. Spoke with decision-maker: [yes/no]. Topic: [property, timing, price talk]. Objection: [what they said]. Next step: [action] by [date]. Do-not-contact requested: [no/yes].
Second, a follow-up email to send the same day.
(b) Situation: You want to confirm a conversation and the next step.
Subject: Following up on [property]
Hi [Name], thanks for the time today. As discussed, I will [action] by [date]. If anything changes on your end, reply here or call me at [phone].
[Your name], Sales Associate | MaxLife Commercial, a division of MaxLife Realty LLC | [phone] | [email]
Third, keep your letter templates in the same place, one per farm segment, and log each mailing as a touch on every owner who received it. Pull the mailing list from a saved view so opted-out owners are never included.
Florida advertising rules call for the licensed brokerage name in real estate advertising (Fla. Admin. Code 61J2-10.025). Your broker of record decides exactly how that applies to email signatures and templates, so confirm the format before you send.
Compliance in the CRM
Your CRM is also a compliance record. Treat these fields as required.
| Item | What to record | Watch for |
|---|---|---|
| Do-not-call and opt-out | A flag with the date and channel | Honor it in every list you export |
| Consent notes | What the person agreed to, and when | Do not assume consent from one call |
| Recording | Whether a call was recorded and whether all parties agreed | Florida generally requires every party's consent to record (F.S. 934.03), and your broker may bar recording altogether |
| Confidentiality | Mark seller and buyer information by deal | Never share one client's data with another |
| Data ownership | Whose data it is under your brokerage agreement | Deal files generally stay with the broker, and your agreement decides the rest, so ask before you leave a firm |
| Retention | How long records are kept and where | Your broker sets the schedule |
| Sensitive data | Store only what you need | No Social Security numbers, bank details or wire instructions |
For calling rules and opt-out handling, see Cold Calling Commercial Owners in Course 23 and Advertising, Prospecting, and Communication Rules in Course 27. For records, see Money, Escrow, and Records.
Under F.S. 475.5015, a broker must keep brokerage records for at least five years, measured from when money is received or an agreement is signed, and longer when litigation is involved. Lesson 4 has the retention dates and worked arithmetic. Your deal correspondence is part of the broker's record. Keep it in the brokerage's system, not only in personal email or on your phone, and keep seller documents in the approved deal folder rather than pasted into notes. Ask your broker of record how long CRM notes are kept and who can see them.
Reports that matter
Run these on Friday. Each one should lead to an action.
| Report | Question it answers | Action |
|---|---|---|
| Overdue follow-ups | What did I drop? | Clear or reschedule before anything else |
| Pipeline by stage | Where is the pile-up? | Fix the leak (see Course 23) |
| Activity | Did I do the planned dials and touches? | Protect the blocks that slipped |
| Source of business | Which channel produces conversations? | Do more of what works, after enough data |
| Referral tracking | Who sent me leads, and did I thank them? | Send a note within a week |
Do not judge a channel on a handful of touches. Course 23 suggests waiting until you have at least 100 dials or 5 appointments before calling anything a leak.
Common mistakes and fixes
| Mistake | Cause | Fix |
|---|---|---|
| Too many fields | Wanting to capture everything | Keep the fields above, delete the rest |
| Logging skipped | Notes feel like paperwork | Log within 5 minutes, use the template |
| Duplicate records | Multiple imports, no search first | Search before creating, merge monthly |
| Data in personal email | Convenience | Forward or log to the CRM the same day |
| No next step | Ending on "call later" | Refuse to save a note without a date |
| One record per parcel | List came from parcel data | Group by owner, link parcels to the entity |
A worked example (illustrative records, invented names and numbers)
Assumptions (invented, not market data and not MaxLife results): You are a newer sales associate working a Seminole County industrial farm and a Polk County NNN farm, like Jordan in Lessons 1 and 2. Names, parcel details and dollar figures are made up. Dates assume a starting point of Wednesday, September 30, 2026.
| Record | Industrial owner | NNN owner |
|---|---|---|
| Entity | Harbor Row Industrial LLC, Sunbiz active, checked Sep 30 | Palm Lane Holdings LLC, Sunbiz active, checked Sep 30 |
| Contact | Marcus Bell, manager, decision-maker yes, source county records Sep 14 | Elena Ortiz, manager, decision-maker yes, source referral Sep 28 |
| Second contact | None yet | Priya Nair, CPA, who referred Elena. Thank-you task due Monday, October 5, 2026 |
| Property A | Small-bay flex, 12,000 SF, 18 ft clear | Single-tenant quick-service restaurant pad, 3,200 SF |
| Property B | Small-bay flex, 9,000 SF, 16 ft clear | None |
| Asset detail | Two parcels, one entity | Franchisee guaranty, lease expires Aug 31, 2031, two 5-year options |
| Numbers | Owner's hope $3,150,000 | NOI $180,000, owner's hope $3,000,000 |
| Deal | Listing prospect, stage Appointment set | Listing prospect, stage Conversation |
| Next step | Meet Thursday, October 8, 2026 | Send NNN cap-rate letter Thursday, October 15, 2026 |
Check the arithmetic:
- Industrial size: 12,000 + 9,000 = 21,000 SF.
- Industrial price per SF (illustrative): 3,150,000 ÷ 21,000 = $150.00 per SF.
- NNN cap rate at the owner's hope (illustrative): 180,000 ÷ 3,000,000 = 6.00%.
- NNN price per SF (illustrative): 3,000,000 ÷ 3,200 = $937.50 per SF.
Notice the links. Marcus is one contact with one entity holding two properties, so you made one owner record instead of two. Priya's referral is logged on Elena's record, so a thank-you task exists within the week you promised yourself. If Palm Lane later needs a replacement property, you add a buyer-side deal to the same entity. Nothing is retyped and every touch has a date.
Key takeaways
- Model commercial data as contacts, entities, properties, deals, tasks and notes, and link them.
- Enter each owner once. Group parcel lists by owner before you dial.
- Choose a CRM that exports everything, and ask your broker of record about firm systems and data ownership first.
- Keep fields few and filled in. Add asset-specific fields for industrial and NNN only where you will use them.
- Log every touch within 5 minutes with a dated next step, and work from Today and Overdue views.
- Record opt-outs, recording notes and confidentiality. Never store data you do not need.
- Run five reports every Friday, and merge duplicates monthly.
Next: Lesson 4 covers transaction management and deal files.