The second part of Bill Gates' famous quote from Business at the Speed of Thought deals with the subject of reporting and managing the information you've gathered. The unfortunate reality is that many people have databases full of useful information, but they simply don't use the information effectively. Many people think of a database as an electronic Rolodex®, when it is really so much more than that. A database is a living, breathing, proactive platform that can generate predictable results and keep bringing in new business for you.

The only way to turn your data into useful information is through reporting. The more you know about your customers, the more you will be able to market to their relevant needs. In Part II of this series (Gathering Information), you were provided with a list of questions to ask your client.

Let's look at the question of "What are your hobbies?" and see how we could use that information to create a better relationship with our clients. Wouldn't it be terrific if you had notes on all of your clients, and knew if they were fans of the Atlanta Braves, Tampa Bay Buccaneers, or Cleveland Cavaliers? If you knew that information and could run a report listing all the people who fall into those categories, you could send those groups of people a congratulatory email whenever their team wins big, and connect with them on their level.

If you knew the timeline up front when a client stated they were expecting an increase or decrease in pay, or any expected change in their financial situation, you could run reports on that information and proactively be ready to service them. Wouldn't this constitute terrific service? Don't fall prey to the never-ending cycle of gathering information over and over again and doing nothing with it. Remember, stagnant data does nothing to help you build your business. You need to be able to compile intelligent reports and use them effectively.

I like to use drop-down menus in my database management software because, for reporting purposes, it is extremely important that the data you input is consistent. If you list some of your clients as "Bucks Fans," some of them as "Buccaneers Fans," and the rest as "Tampa Bay Fans," then your statistics would not be correct if you ran a report on how many "Buccaneers Fans" you had in your database. But, if you use a drop-down menu that allows you to select one option that is consistent (e.g., "Tampa Bay Buccaneers Fan") then you will have consistent results as you run your reports. This is called normalizing your database, and it solves a lot of these problems.

 
Post is included in group: Realtors®
Post is included in group: Optimizers
Post is included in group: Dedicated Bloggers
Post is included in group: Coweta County Real Estate

7 Comments on The Art of Database Management: Reporting and Managing Information

OCT
16
Outside Blog

Very helpful post Darrell.  We're trying to move our dBase to the next level and this gives me some food for thought.

7:37am • #1

Hi Darrell,

I have thought about updating my database using this type of information.  It freaks me out.  I've been afraid to move forward.  However, I think this is the push I need......

7:39am • #2
1 Featured Post Outside Blog Hit Router

Darrell, what database software are you using?  I am currently searching for a new one, and can't decide.

7:44am • #3
115,580 Points 1 Featured Post

Syreeta, 

I hope this helps. I've been writing Friday blog posts on database management for the past few weeks. Check them out.

Cindy, 

I'm glad I could help. I once had a client that was a Pirates fan (really no joke) and I gave him a Pirates hat at closing. He loved it a gave me more referrals.

Lina,

I've been using Outlook Business Contact Manager but have recently started to migrate to ACT. They have programs for mortgage databases and I think they have them for Realtors also.

8:08am • #4
OCT
17
521,351 Points 52 Featured Posts Localism Sponsor Outside Blog

That is a really good idea!  I try to remember all the little details in my crainial database but sometimes it just doesn't work when I need it :)

11:32am • #5
OCT
24

You can be a database guru.  Stagnate data does nothing to help you build your business.

7:00pm • #6
OCT
26
115,580 Points 1 Featured Post

Mike, 

Thanks. My business is primarily referral based and having an accurate, quality database has been a big key.

10:04am • #7

Leave a response…



(optional)
What does the graphic say?
 
Walterswedding-392 Rainmaker_large

Darrell Walters

Newnan, GA

More about me…

Integrity Mortgage Funding

Address: 395 Millard Farmer Ind Blvd, Suite A, Newnan, GA, 30263

Office Phone: (678) 648-5626

Cell Phone: (678) 326-0417

Email Me



Links

Archives

RSS 2.0 Feed for this blog

Find GA real estate agents and Newnan real estate on ActiveRain.