My owner is a home inspector in San Diego.When I first came to San Diego and got a job, I interviewed with a company that had lost hundreds of documents from a computer hard drive crash. They expected me to spend about two weeks retyping all those documents. After typing the first document and starting on the second, I noticed that the first paragraph was identical to what I had just typed.

Typing the same thing over and over and over again is not my idea of a good time. As I looked through the stacks of papers that they had given me, I noticed that the file number and a couple of paragraphs in each document were the only things that were different, so I created a template and then just changed the wording in the appropriate paragraphs. What they thought would take a couple of weeks took me eight hours.

I bring that up to reinforce the fact that I just don't like to do the same thing over and over and over again, and when I got my first computer in 1978, I discovered that I didn't have to. The computer allowed me to save things on these huge floppy disks that looked like old vinyl LP records.

In today's world, computers allow me not only to save my previous work but to do various searches on it to find what I want virtually immediately. While the ActiveRain tags are quite useful, they don't provide me as much flexibility in finding what I want very quickly because they don't have a search function associated with them. So whenever I do a blog post, the title of the blog and keywords get entered into an Excel spreadsheet:

ActiveRain blog database in Excel

Notice that each title is a link, which takes me directly to the post in my ActiveRain blog.

Once I have my titles and my keywords entered, I can do a simple search for what I'm looking for:

A search for the word electricity in the titles and keywords

If I want to send that link to a past Client who has a question, or a prospective Client who wants to determine what I know about my profession, I can either go directly to my blog and copy the shortcut, or I can copy the shortcut directly from my Excel database.

Since I also like to have backup copies of my work, I have copied all of the text and pictures from my ActiveRain blog into Word files:

ActiveRain blogs entered into Word

Each file is labeled for the month the posts were entered into my ActiveRain blog.

ActiveRain blog posts folder

Word files containing ActiveRain blog posts

This way, if I want to search on something even more specific than my titles or keywords in Excel, I can use the Word search function.

Searching for specific words in Word

The first time you set such a system up, it might take you a little while to create your own system. However, once it is set up, adding to it each time you do a blog post is very easy, and whenever a Client or prospect needs information, you can find it within minutes, if not seconds, and send the link their way. I've even been known to send my complete Excel spreadsheet to prospects and let them click on the links to my ActiveRain blog posts. I don't send my Word files because I don't make the posts in Word look all pretty and everything like I do my ActiveRain blog posts.

 

Links to more posts are below

Twenty most recent posts

  1. San Diego home inspection FAQs: Do you recommend a gas or electric home?
  2. Mornings with Mother and Father Nature: Remember your prom?
  3. Gotta love those helpful Clients!
  4. Mornings with Mother and Father Nature: Johnny jumps up
  5. Speechless Sunday at the San Diego Zoo: A little bigger than Zoey the Cool Cat
  6. Mornings with Mother and Father Nature: PLEASE STAND STILL!
  7. San Diego home inspection FAQs: Should I have my home tested for radon?
  8. You can do home maintenannce and party at the same time!
  9. Mornings with Mother and Father Nature: I went to see a beautiful sunset and got this!
  10. Mornings with Mother and Father Nature: Not from Georgetown University
  11. It's easy to make presumptions. It's a little more difficult to take action.
  12. CAUTION: Beware of how you use your pre-May 1, 2009, blog posts
  13. Mornings with Mother and Father Nature: Not your average doggie in the window
  14. Mornings with Mother and Father Nature: A purple prickly pear?!!!!
  15. Speechless Sunday: How can you not love these little guys?
  16. !@#$%^&* is a four-letter word
  17. Mornings with Mother and Father Nature: How blue are YOU?
  18. How to keep that pesky home inspector at bay....
  19. Mornings with Mother and Father Nature: How realistic is YOUR boat ornament?
  20. Mornings with Mother and Father Nature: Alfred Hitchcock

Please join me in these special ActiveRain groups:

  1. Out and About - Share specific events, places, and things to do with your target audience.
  2. NAR 2009 Convention San Diego - Coming to the Convention in November? Check in here.
  3. Guerrilla Marketing Tactics - Marketing that requires mostly ingenuity, creativity, time, and energy.
  4. Inspired By Nature - Where you can come to relax among Mother and Father Nature's fauna and flora.
  5. Classical Music - Share classical music events with your target audience.
  6. ActiveRain Book Club - A great place to find information on books of all genres.

 
Post is included in group: Cosmic Cow Pie
Post is included in group: Be The Best In Your Field
Post is included in group: BananaTude
Post is included in group: Addicted to Active Rain
Post is included in group: Active Rain Block Party

48 Comments on Creating a blog database for you and your Clients

OCT
29
Outside Blog

Wow, that is a great post and it has a ton of information, I think I might have to re-read this one.

3:18pm • #1

It really is a great post I will definitely use it. Bookmarked!

3:25pm • #2
181,603 Points 8 Featured Posts Localism Sponsor Outside Blog

Russel, great information. I become frustrated and put my posts in an Excel spreadsheet, however I did it from AR's lists of my posts, not the best but it worked! I should update it all the time instead of waiting to update it after a page more of posts.

I am not as good with this as I should be. My database lacks teeth, and I need to get moving on it. Thank you!

3:35pm • #3
Outside Blog Hit Router

Wow!  I am hugely overwhelmed, but in a good way.  Bookmarked, filed, printed, posted on my bulettin board, yellow sticky attached with exclamation points.  And, on my "to do" list.  Thanks!

3:45pm • #4

Russel--Great tips.  Thanks. I am just starting out on AR but every tidbit of advice is very useful.

Kathy Stankard
3:52pm • #7

For those who are not proficient or familiar with Excel, a similar "database" of links could also be created in MSWord, OpenOffice Writer or similar word processor and use the search function to find titles and tags as you would in Excel.  While it doesn't have the sorting possibilities of Excel, it WILL keep a list of blog titles with their underlying link.

4:00pm • #8

Wow Russel, great tip. It will save me a ton of time and help when wanting to follow up with someone

Ty

Ty Lacroix
4:02pm • #9
Outside Blog

Russel, I am so glad to have this information now, especially at the beginning of my blogging career. Won't take me too long to set it up. I am a detail person, but unfortunately not a methodical person. This is a huge boon. Thanks.

4:18pm • #10

It sounds so simple and rational when you say it! I get a little panicky when I work with Excel....

4:27pm • #11
102,259 Points 3 Featured Posts Localism Sponsor Outside Blog

This is such a straight-forward and easy idea to use!  I wish I had an "excel-spreadsheet" based organization process in my mind too!  I'm jealous!  Thanks for the tip!

4:39pm • #12
Outside Blog

Wow, this is really organzied. Is there some benefit to doing this on Google Docs OR can it be done?

4:58pm • #13

Excellent idea. I do somewhat of the same thing not just for blog posts but for many of other things. The best thing I also use is Google Desktop, the best tool to find things on your computer ever!

5:07pm • #14
Outside Blog

That is a really great tip to share.  I save all my posts in a folder on my computer.  I like the Excel version.  It would be beneficial to save my posts as you do in you example, and also posts from others that I like to keep.  Usually I just book mark them, but the Excel sheet would be a great way to back it up.  Thanks!

5:31pm • #15
673,971 Points 145 Featured Posts Localism Sponsor Outside Blog Hit Router

Russel - that's an impressive and organized system you have. Much more so than me. I keep all mine in one doc file on word and use the search function to look for keywords (in the title or the article). The thought of being more organized with this intriques me. It s=certainly works better than trying to find something on AR!

Jeff

5:39pm • #16
Outside Blog

Very organized I admire that.

5:46pm • #17
121,817 Points 3 Featured Posts Localism Sponsor

Hi Russel - You must never sleep!  You are so organized and so busy - I'm impressed.  I am pretty organized, but I don't have systems like yours.  I guess I'll have to rethink mine.

6:02pm • #18
537,535 Points 10 Featured Posts Outside Blog

Hey, Folks! I do a blog post, go do a little condo inspection, and come back to find a Featured Post. So glad that I could reach out to a lot of new people - other than my regular readers -- and help them, too.

If you look back at John's comment, #8, I don't know about Open Office because I've been a World fan ever since Word 1.0 for DOS (don't laugh!) when all my friends were using WordPerfect and Wordstar. Since the days of Word for Windows 3.11, Word has been extremely powerful with its autocorrect function, outline organizer, hidden text, and links. It is possible to put the date and link as a title in an outline and put the actual post as hidden text under the title. Once you do that, you can hide all the hidden text and just have the titles and links of your blog posts. When you need to do a more extensive search, you simply unhide the hidden text and there is all your text to search on.

Also, if you're running Windows Vista, which is a superb operating system if you'll ignore all the naysayers and actually use it, you can do a search on a complete file folder for any text, so using the examples in my post here, if I were to do a search on my ActiveRain blog posts folder, I could also find the specific files that had Enron in them and then open them up and do a search to find the specific post. That little tip will become even more useful when I'm into my twentieth year here at ActiveRain.

Hmmmm. Maybe this comment needs to be a post of its own with examples.

6:26pm • #19
Outside Blog

Russel,

What an exquisite filing system you have created...undoubtedly saving you tremendous amounts of time for just a few seconds a day! Excellent.

6:47pm • #20
1 Featured Post Outside Blog Hit Router

Great thinking Russel. Can you tell us in your next blog how to (step by step) set up this ExCell (sp?) spread sheet? I would really appreciate it Russel.

7:32pm • #21
352,888 Points 38 Featured Posts Localism Sponsor Outside Blog

Russel, Now that is one of the most impressive organizational posts ever! This is definitely one to bookmark! I am sending you my entire computer...just set it up so I can find everything real easy!!

8:20pm • #22
436,393 Points 10 Featured Posts Outside Blog

Great tips for all of us.  It is a great idea.  Thanks for sharing.  Have a great night.

8:28pm • #23
179,621 Points 1 Featured Post Outside Blog

Master Russel, little grasshopper here; you are a very patient soul.  I will do my very best to follow along and learn.....step by step.  Congratulations once again on your very helpful featured post.   On an appointment tonight we were talking to a very camera savvy gentleman and thought oh Master Russel would enjoy this conversation! 

8:48pm • #24
Outside Blog

Hi Russel,

What a great informative & helpful post!  You are so organized!  What a wonderful system that you set up.  I will definitely bookmark this!  Thank you for sharing! 

Chris

 

9:51pm • #25
156,087 Points 1 Featured Post Outside Blog

Russel, Wow! It sounds like a great way to organize. When I'm looking for post, I just google it. I haven't even considered doing all that filing. You've given me something else to think about.

10:05pm • #26
1 Featured Post Outside Blog

Russel:

Wow!  I wish I could be so organized.  I remember those nasty 5.25 floppy disks.  That goes way back!!!   Your kitty is so cute!  Can I steal him for a few hugs? 

10:31pm • #27
138,022 Points 7 Featured Posts Outside Blog

Russel my man, you are WAY too clever.  My tired brain must book mark this for further review. 

thanks.

10:43pm • #28
Outside Blog

Russell, this is very good info. I was wondering how to do such a thing.  Thanks.

10:46pm • #29

After having head crashes on other computers and the pain of losing data I appreciate this post.  I've bookmarked it.  Thanks!

11:25pm • #30
2 Featured Posts Localism Sponsor Outside Blog Hit Router

Russell, such an informative post and organization!  I need to do some organizations in many areas and Excel seems like a great idea for these items.  Good to see your post was FEATURED!

11:26pm • #31

I am sooooooo bookmarking!!! & I truly appreciate the effort that you put into it!! Thanks a million!!  All the Best!!

11:37pm • #32
OCT
30
341,770 Points Outside Blog

All I can say is wow!-- this is a slick and efficient idea to keep things organized.

12:27am • #33

Russel,

 This is AWESOME!! I have it bookmarked now for reference.  I will be showing your systems to many others

Thank you for sharing!

PG

4:38am • #34

Russel - Your post is a fantastic way to start organizing ActiveRain posts and can be applied to other blogs as well.

5:47am • #35
5 Featured Posts Outside Blog Hit Router

Russell:

That is a very impressive system you have devised. You make it look so easy...

 

8:09am • #36
189,423 Points 2 Featured Posts Outside Blog

Russel, thanks for sharing your info as you are soooo good at keeping tabs and categorizing your posts.  I asked others for an easier way over the last week or so and yours seems to be the most thorough.  I tried the 'tags' method just yesterday and it wasn't bad but not easy either.  Did I mention I hate Excel and it hates me?  I will have my husband teach me AGAIN and get these in order once and for all.  It was really Zoey's idea right?

9:12am • #37
Localism Sponsor Outside Blog

Russel - You've done it again!  Outstanding organizational skills.  I am going to put your system into place for our team.  That would make it so much easier than just saving the word files.  I see what I'll be doing this weekend.  That and saving lizards from my cat Tiger's mouth.  :)

9:46am • #38

Russel - This is a great post and as someone who does their best to stay organized and work most efficiently, I appreciate it.  I'm always looking for new ways to implement technology into my business.

11:39am • #39
3 Featured Posts Outside Blog

Russel,

You have such brilliant ideas! I haven't been very good about saving my blogs, let alone organizing them. You've inspired me to something about it! Life would be so much easier if I could find exactly what I was looking for the second I need it. And having posts saved that could help other people would be great. Thanks for sharing your great system.

 

12:28pm • #40
1 Featured Post Outside Blog

Excellent idea, Russel! It's just what I needed as I'm just into Week 7 of blogging on ActiveRain...I only have 88 blog posts to input. :)

Leilani

2:46pm • #41

wow thanks for your CBT (computer based training) course!  Lots of information.  I bookmarked it!

oh, one more thing, hopefully your cat brings you more business, I spotted your cat on a lot of your blogs.

Good luck!

-Nelson

3:46pm • #42
4 Featured Posts

Russel, Thank you for the insight.  I will have to go back and try to catch up on this and put it into use.  Have a great weekend!  :-)

6:32pm • #43
113,200 Points 3 Featured Posts Localism Sponsor

Russel, Your post shows me how much more organized I need to be! Thanks for the information and I will bookmark this one too! Thank you!

10:09pm • #44
412,883 Points 17 Featured Posts Outside Blog

This is so cool! I'm a tech geek but unfortunately I suck with Excel =(   And this really rocks! (we're not worthy) lol

11:53pm • #45
OCT
31
196,058 Points 2 Featured Posts

You are brilliant.  I need to take an Excel class.  Why didn't I think of this????

12:26am • #46
NOV
05

I love it when I see a great database and someone who is actually using it.

9:40pm • #47
NOV
06
Localism Sponsor Outside Blog

Russel, Thanks for sending me here - I missed this when it was featured the other day.  Now I just have to wait for my kids to get home from school and teach me how to use Excel!

11:14am • #48
NOV
07
Outside Blog

Thanks for the great information. Wow are you ever organized. One of these days I am going to get this stuff together.

8:53am • #49
NOV
11

Leave a response…



(optional)
What does the graphic say?
 
Img_9340 Ambassador_large

Russel Ray, San Diego home inspector

San Diego, CA

More about me…

Russel Ray, Property Consultant

Address: 7000-31 Saranac Street, La Mesa, CA, 91941-3315

Office Phone: (619) 341-0173

Cell Phone: (619) 341-0173

Email Me



Links

Archives

RSS 2.0 Feed for this blog

Find CA real estate agents and San Diego real estate on ActiveRain.