What I Learned By Tracking My Blog Topics for One Month

Real Estate Agent with Long & Foster Real Estate, Inc.

Pie-Chart - Blog Topics

Have you ever tracked your blog topics?

As January came to an end, I decided to create a table listing my 42 Activerain posts for the month and categorizing them by topic.  I used an Excel spreadsheet to do this, thinking I might someday wish to sort them by topics with the mere click of a finger, or create a graph like the one you see here, using the Excel Chart Wizard.  You could track them in a table on MS Word, however, or even by hand in a notebook.

Reblogs (8) and original content (34) were tracked and categorized by topic.  Most of the re-blogs fell into the Q&A category (5), since there have been so many wonderful Q&A posts written for Bob Stewart's "Never Answer the Same Question Twice Challenge".  The other reblogs were Military (1) and Networking (2) posts. 

By the way, "networking" is the category I used for all posts written for Activerain members, my number one source for referrals.


The real wake-up call was this: Only ONE post for my #1 target market, relocating military families - and that was a re-blog of a video by my friend Cindy Jones in Northern Virginia.  I really dropped the ball in January, when it came to relocating military families!

I could probably argue that two of the local posts were military because they featured photos taken at the U.S. Naval Academy, but they weren't written to the specific needs of relocating home buyers or sellers. And no doubt the Local posts will be of interest to anyone relocating to the area and local residents, as well.

Another blown opportunity was the new listing I never blogged about.  Yikes!  I guess it's not too late to do that in February.

Activerain tracks our comments, clicks and views, and that data could probably be added to my chart.  Maybe next year... 

In 2011, I just want to have a system in place which encourages me to keep blog posts on target.  Tracking them like this will hold me accountable.


Posted by

This infoMargaret Wodarmation was provided to you by Margaret Woda, an Associate Broker with Long & Foster Real Estate in Crofton Maryland. Contact Margaret today for general real estate information or to learn how she can help you buy or sell a home in Annapolis, Bowie, Crofton, Davidsonville, Gambrills, and Odenton. 

Crofton real estate

HOME SEARCH          HOME BUYERS          HOME SELLERS          



Re-Blogged 1 time:

Re-Blogged By Re-Blogged At
  1. Praful Thakkar 02/02/2018 09:43 PM
ActiveRain Community
Active Rain Newbies
The Lounge at Active Rain
Long & Foster Agent Lounge
Diary of a Realtor
Valentine Bloggers
blog topics
activerain networking

Spam prevention
Show All Comments
Leticia Sanders

Margaret, what an out of the box idea. Will definitely keep this in mind!

Feb 08, 2011 01:13 PM #93
Georgie Hunter R(S) 58089
Hawai'i Life Real Estate Brokers - Haiku, HI
Maui Real Estate sales and lifestyle info

Very interesting idea, and good job with the pie chart!  There's just so much to blog about, it's hard to fit it all in isn't it?  I hope your next few days go well and you'll be back here refreshed.  No need to respond to this comment!

Feb 08, 2011 02:55 PM #94
Jeff Belonger
Social Media - Infinity Home Mortgage Company, Inc - Cherry Hill, NJ
The FHA Expert - FHA Loans - FHA mortgages - USDA loans - VA Loans

Margaret.. late to the party... I saw this earlier, but just now getting to it... in any case, great idea and I like the graph. I need to see how to do this per your instructions in what you stated above. I might be calling you.. thanks for sharing this...

jeff belonger

Feb 08, 2011 03:25 PM #95
Diane M. Phillips Realtor 443-286-4365
Frankly Real Estate Inc. - Manchester, MD
Specializing in Carroll Co., MD

Margret ~ I hope everything works out the best for you. Thanks for the wonderful idea. I’ve been pondering ways to improve content and increase exposure.

Feb 08, 2011 03:34 PM #96
Nancy Hankin
RE/MAX Real Estate Consultants - Palm Springs, CA
Margaret: I Blog weekly and have been doing so for many years. Last year I asked my Virtual Assistant to help me keep track on what I am blogging about. She did as you did and created an Excel Spreedsheet. Now I can sort by topic, date, etc. It has really helped me stay on tract. Great Share!
Feb 08, 2011 04:18 PM #97
Lisa Wiseman
Intero Real Estate Services, San Jose, Silicon Valley - San Jose, CA

Wow, Margaret! Thank you so much for drawing attention to this. We have so little time left in the day, and spend so much time on social networking. This helps us all help eachother...

Feb 08, 2011 04:56 PM #98
DeeDee Riley
Lyon Real Estate - El Dorado Hills CA - El Dorado Hills, CA
Realtor - El Dorado Hills & the Surrounding Areas

Great idea Margaret!  I am struggling with the newest version of Excel. I could handle the 2003 version but now I'm lost.  This is a great thing though to do with it!!!!


Feb 08, 2011 05:30 PM #99
Sandy McAlpine
Search Lake Norman Homes For Sale - Lake Norman NC

Funny thing when I read these posts: I get determined to do more market reports and then I sit down to do it and it seems harder to start a blog post like that

Feb 09, 2011 01:22 AM #100
Steven Pahl
Keller Williams Tampa Properties - Tampa, FL
Real Estate Consultant Tampa, FL 813-319-6423

Never thought to track my blog posts, thanks for the idea!  I agree with DeeDee #99, I am about two versions behind in MS Office products.

Feb 09, 2011 01:59 AM #101
Bob Sweazy
Prudential A. S. de Movellan Real Estate - Lexington, KY

Good idea. Thanks.

Feb 09, 2011 04:11 AM #102
Lora "Leah" Stern 914-772-4528
Coldwell Banker, 170 N Main Street, New City NY 10956 - New City, NY
Real Estate Salesperson

Margaret, I do whatch my stats but have never tracked by topic.  Most of my posts are on localism.  I've started including more real estate topics and the reblogs, like yours are mostly the question answer or real estate topic ones.  Love your idea of doing regular tracking.

Feb 09, 2011 09:24 AM #103
Billi Evans
Murney Associates - Springfield, MO

I to find myself more determined after reading your post to: stay on track, keep focused, and keep moving forward!

Feb 09, 2011 02:49 PM #104
Brenda, Ron, Lee Cunningham & Tara Keator
West USA Realty - Phoenix, AZ
Realtors, Homes for Sale - Phoenix Metro

Thanks you provided me with great motivation and some very good ideas!

Feb 09, 2011 02:58 PM #105
John Whittinghill
Keller Williams Realty First Atlanta - Marietta, GA
Marietta, GA Real Estate Agent


Thanks for the great reminders, and very great idea on tracking blog topics on an excel spreadsheet!

Feb 10, 2011 05:41 AM #107
Virginia Madden
Virginia Madden, Buyer's Choice Realty, LLC (Prattville, AL) - Prattville, AL

I never thought to track by topic.  What a great idea!  That way I can stay mindful of the whole reason I'm blogging in the first place - to give buyers information they want and need!  Great post!

Feb 10, 2011 01:07 PM #108
Beverly of Bev & Bob Meaux
Keller Williams Suburban Realty - West Orange, NJ
Where Buying & Selling Works

What a great way to take a quarterly look back and see what you've accomplished. Then track which ones got the most clicks and which one you got the  most leads/business from. I've been debating the courage to go back and read from the beginning to see what "me" exist online and if I like what I "see" and if the online "me" has changed and grown for the better.

Feb 12, 2011 09:59 AM #109
Margaret Woda
Long & Foster Real Estate, Inc. - Crofton, MD
Maryland Real Estate & Military Relocation

Thank you all for your comments.  When I got behind in acknowledging each of you, I set out to comment on YOUR own blogs.  If I haven't been there yet, I should be before this week is over.

Still dealing with a medical matter that requires my attention, so I hope you'll give me a pass this time.

Feb 13, 2011 11:51 PM #110
Mark Peek
Roseville Rocklin Real Estate - Keller Williams - Roseville, CA
Peek Real Estate Group - Roseville CA Real Estate

Great idea.  I never really thought of doiing this with my blog posts.  I will certainly implement it.  Thanks!

Feb 15, 2011 03:56 PM #111
Margaret Woda
Long & Foster Real Estate, Inc. - Crofton, MD
Maryland Real Estate & Military Relocation

Mark - I don't find it easy to do as I go through the month, as I had planned for February, but it was a one-evening project to do the entire month of January while I was watching TV.

Feb 15, 2011 08:57 PM #112
June Piper-Brandon
Remax New Beginnings ---------- and ------------- Ashland Auction Group - Baltimore, MD
Piecing Dreams One Home at a Time

This is interesting reading.  I have been away for a while side tracked by some personal stuff I saw this reblogged by Praful and would have missed it otherwise.  I am trying to get back to blogging with some encouragement from friends and topics like t his will help me really target my audience and hopefully drive sales. 

Feb 03, 2018 08:58 AM #113
Show All Comments

What's the reason you're reporting this blog entry?

Are you sure you want to report this blog entry as spam?


Margaret Woda

Maryland Real Estate & Military Relocation
Ask me a question
Spam prevention

Additional Information