If you have everything on paper, start entering them according to the ideas suggested below. If you already have them in an electronic format, you have to import them. A common question is if you should clean them up in the old database first, or clean them up in the new one. By cleaning up, we mean getting rid of contacts when we do not know who they are, or filling in a last name on contacts that have none, etc. One difference that may affect that decision is that if you do it in the new one, you are learning the new one, so maybe that’s the better way to go. If you do it that way, but the existing database is such a mess that it creates problems with the import, then you have your answer. Just delete the trial import and clean it up before you import.
As soon as you get the new database in and cleaned up – BACKUP immediately, twice!
As you are adding your contacts, click around in the menus. Try right clicking everywhere and see if anything happens. Experiment! That is part of getting a new CRM. The more time you spend with it up front, the sooner you will feel comfortable and more efficient with it, and the more you will use it.
Add everyone – If you have to call, e-mail, or write to someone once, put them in your database. You never know when you may need it again. Text takes virtually no space on a computer. Taking up too much space is not a factor. Many people have the concern that they did not want to clutter up their database. Some agents want only the names of the people to whom they want to mail in their database. That thinking is probably a throwback to when we had all our names and addresses on a piece of paper that we used to copy onto a sheet of labels to do our mailings.
People will often say they do not want to have to sort through names they do not need. What sorting? You start keying the name of the person you want in the search box, and it comes up. If you have 50 names or 5,000, it is the exact same procedure and result.
After you use a CRM for a few years, if you put everybody in there, you will be amazed at how often you will not have to look someone up because they are already in there. In many markets there are hundreds of ancillary service companies. Title companies, loan originators, termite inspectors, home inspectors, etc. After a few years and a number of transactions, a great many of them will be in your database. When you add a new transaction, many times, many of the parties to the transaction will already be in there. If you need to call or e-mail someone, you will have his or her contact info already. It gets to be a tremendous time saver.
A little advice about what to put in some of the fields. Much of this may seem very basic, but you might surprised how often it is not done.
First name – Only put the first name of one person in the first name field. Do not put Bob and Karen. Karen goes into another field, which exists specifically for that person. Do not put Mr. or Mrs. or anything else in the first name field either. Always include a first name. If you do not have a first name, use the last name as both first and last until you get the first name. Why? Because sooner or later when you are creating a report or doing some kind of look-up, it will matter. And if you ever create an a template e-mail or letter and decide to use “Dear first_name” as an opening merge field, it will be blank. It’s better to have their last name there than a blank.
Middle name – Only use the middle initial, but always use it if you have it. It helps with duplicate names. It would be great to always have one of course, but a full middle name can be problematic. More databases than not do not have room for a full middle name. Most only allow for the middle initial, and sometimes two or three letters. So if you are using a CRM that does have a field for the full middle name, but then you export that data to move to one that allows for only two letters, then you can have a mess to clean up.
Last name – Always put a name in the last name field. If you only have the first name, put the first name in both the First name and the Last name fields until you get the last name. Another option is to put TBD (to be determined) in the last name field. Then, on occasion, you can easily call up everyone with TBD in the last name field, and work on getting those last names. Without going into great detail, not having a name in every field can cause problems when doing searches, ordering names in a list, and other things you may end up doing.
E-mail address or phone number – A name in a database without an e-mail address or phone number or at the very least an address, is probably not worth having unless you are certain one of them is forthcoming. And if it is, create a task to remind you to make sure you got it. Always have at least one of them.
Address – Whenever possible get a postal address regardless of what kind of contact it is. If the City field has an auto fill feature, use it. Auto fill is where you can key in the name of the city and it will remember it and retain a list. In the future, as you start to key in that city, it will complete it for you after the first few letters. It sounds trivial, but saving a few thousand key strokes over a years time adds up.
Company – If the person works for a company, take the time to put the company name in the company field. If it has auto fill, definitely use it. This is more important the city field. The reason is that it is very easy and common to key in a company name differently from one time to the next. You might key in RE-ACT for one person, and RE-ACT, LLC. for the next person. The problem then becomes that if you do a search for everyone in your database who works for a given company, the results can be wrong.
Category – Always put a contact in a category such as Buyer Prospect, Seller Prospect, Appraiser, etc. and always put some kind of note in there on them if possible. The goal is to always have something in the contact record that will jog your memory about them. You would be surprised at how little it takes to remember someone you have spoken with, even years later, if you have them categorized and have a sentence or two about your conversation with good keywords.
Different CRMs call them different things. Categories, Contact Types, Classifications, or maybe Groups. It is a field that identifies what that person is to you. Buyer-Past, Seller-Active, Gold Partner, Title Rep, Mortgage Processor, etc. For you to truly interact with your database in an expedient and accurate and profitable manner, being able to categorize your contacts is at the core of what you are trying to accomplish. The versatility here is critical. You should require that you at least have the ability to add as many categories as you choose, and that a contact can be included in as many categories as you need. Keep in mind though that you want to have an organized rational approach to adding categories. Think it out first before you start adding them haphazardly. If you are working in a team, there should be one person who is designated the Category Cop. That person is the only one permitted to add or delete categories, either on their own, or by committee review/agreement.
To get started, consider the following core categories:
- Buyer Past
- Buyer Active
- Buyer Pending
- Buyer Prospect
- Seller Past
- Seller Pending
- Seller Active
- Seller Prospect
- Settled 20XX (XX = year /closed/settled).
Referral – Always put in the name of the person who referred this contact to you if that was the case. A good CRM can show you a referral tree of who referred whom. A really nice feature of a CRM is when it tracks a commission dollar value to each referee. Then you can see not only who that person referred to you, but how much money they made you by giving you those referrals.
Source – If it was not a referral then you need to record the source from which they came. Such as Homes and Land ad call (note that you should not just say ad call). Be specific because in a good CRM you can generate a report to show you where your business came from. This is the kind of thing people are talking about when they say that you need to run your business like a business.
If you know exactly where your business is coming from, it allows you to identify your strengths and weaknesses, and where to continue to spend money, and where to stop. Business people have an annual budget. You should generate a report that shows you how many transactions can be directly related to specific types of advertising. Now you can see that you spent $3,000 on Homes Magazine ads last year, but only earned $2,500 on one commission from a lead from it. The argument can be made that the $500 net cost to be in that magazine is a reasonable amount to maintain a presence in that magazine. But the fact is that you are now making that decision based on ROI and tangible information.
Mail Preference – When you meet someone and get their contact information, you should try to determine with which mode of communication they are most comfortable. When getting their e-mail address, do not ask them if they check it often or daily etc. Ask them how often they check it. Their answer will tell you if e-mail or postal mail is better. If your CRM tracks it, you should note their mail preference. In some CRMs, that can automatically determine whether or not they get an e-mail or a printed letter when something is sent to them in their follow-up campaign.
Date of initial communication – Whatever CRM you pick, make sure that it both date and time stamps your notes when you key them in. This comes in handy for many things including risk management down the road. Copious and accurate notes frequently stave off hours of wasted time and unnecessary finger pointing and posturing. It is absolutely amazing how quickly someone will defer to you when they become aware that you have an accurate point by point record of date and time stamped phone calls, notes, e-mails, and letters all at your fingertips. In the future if you have another transaction with them, they will remember. What will happen is that eventually you will get a reputation for being accurate and organized, and other agents will sometimes recommend your offer over others because they are confident that their transaction with you will go smoothly.
Follow-up reminder – If this new contact is a lead of any kind, you should have a reminder either to call or e-mail them at some point in the future. You should also have everyone in your sphere of influence receiving something on at least a monthly basis. There is no doubt that sending something that is clearly valuable information is the best thing to do. That said, if ti is taking too long to come up with that perfect follow-up piece, do something in the interim. If you stay in touch regularly with you SOI, you are one of a small percentage of agents who do, and you reap the rewards.
In summary, every effort should be made to insure every contact has information in the following fields:
- First name
- Middle initial
- Last name
- Postal address
- E-mail address
- Phone number
- Web site address
- Note about initial conversation or communication with the date of that communication if other than e-mail
- Referral person or source
- E-mail or postal mail preference
- Calendar item for next contact – at least one if not a plan
People often ask “What does a CRM do?” This article covers one aspect of the answer to that question. There are many others. If used correctly, eventually your CRM will be the hub of your business, and it will be a much more efficient and organized business.
Remember, not everyone thinks they need a CRM. But if you want to grow your business, while having more of a life, with less stress, with less mistakes, with better service, with less staff, with more compliments, with more referrals, then you do.