Real Estate Blog - The Easy Peezy Way to Build a Database of your Active Rain Blog Posts

Home : Blogs : Jackie - MortgageVirtualAssistant.com : Mortgage Virtual Assistant Blog

The Easy Peezy Way to Build a Database of your Active Rain Blog Posts

By JC Kadii, Virtual Assistance & Online Marketing for Mortgage Professionals

I have content strewn all over the Internet. It occurred to me that it's probably a good idea to do a better job of organizing all of my written material, so that I can put it to use by re-purposing it.

After putting together my database of 6 years worth of email newsletters, it was time to tackle my Active Rain posts.

Imagine my delight when I found a way to get it done in 10 minutes instead of hours?

Here's how you do it.

Log into your account.
Click the My Home button, on the upper right hand corner of your screen.
Click the Statistics link. It's on the left side menu, towards the bottom.
This will take you to your Statistics page(s). And there you have it. Every single post you've written, along with the number of times people have clicked through.
Simply copy this information into Excel, and now you have a list of all of your blog posts. As an added bonus, the titles are hyper-linked. So, if you click on a blog post's title in your Excel list, you will be taken to that blog post.
How cool is that? Don't you just love technology when it saves you time?

Don't miss the next post - Subscribe to this blog and get updates in your email.

http://www.twitter.com/mortgageva

JC Kadii, Mortgage Virtual Assistance and Online Marketing Services . 770-469-7385. Are you reaching out to the 70% of new buyers who start their search online? Our team provides results-driven mortgage internet marketing services. Visit our website and sign up for the More Closings email newsletter to receive the report 6 Steps to More Referrals.

Posted by Jackie - MortgageVirtualAssistant.com on 06/11/2009 11:52 PM

Comments (16)

Active Rain Community Support in the ActiveRain Channel

mortgage technology tips, i heart technology, time savers

Post is included in group: Active Rain Newbies
Post is included in group: Virtual Office - Work from Home Office
Post is included in group: Time Management
Post is included in group: Tech Corner

16 Comments on The Easy Peezy Way to Build a Database of your Active Rain Blog Posts

JUN

OK, first I was let down a little... I thought you were going to tell me how to build a db of all of my content... not just the titles. But then I started to think about how nice it would be to have access to all of those titles...

Thanks for pointing that out.

I love the easy button.

Cool.

They do make it easy for us. Now what about organizing all that other stuff out there?

A virtual assistant:

Assisting with virtue?

Assisting with virts?

Assisting with virtually everything?

Nearly an assistant?

Somebody who improves your efficiency?

Yes. That's it.

Lane - especially when you 1 click on the title will take you directly to the blog post. Thanks for commenting.

Ralph - me too. There's a little dance I do when I learn a new tech tip that saves me time and/or money. Thanks for commenting.

Richard - Exactly. In a future blog posts, I'll be asking all of you for help in organizing all of my content. It's proving to be a little tough, especially since I haven't done it in years. Thanks for commenting.

Jim - How creative you are!!! Thanks for commenting.

Great tip that adds value - like Lane, I became very, very excited when I realized the copied titles would be live. Perfect way to organize by title and then link! Thanks!

Debbie - thanks for commenting. I am glad I was able to provide information of value, especially to someone as savvy as you.

JUN

Oh Jackie.,....yes, yes, yes - this is VERY cool. I knew all the posts were there, but saving them with links - I LIKE IT :-)

Gail - Thanks for commenting; I am glad you are able to use this.

JUN

Writing a blog? Important

An organized system to find it? PRICELESS

Thanks Jackie! This is why I loved the Rain. Glad to be back.

Tara - great to see you back, and thanks for your comment.

JUN

I'm very disorganized, so this is helpful. Thanks for sharing.

Thanks, I have bookmarked and I will use this.

JUN

Hi Kathryn and Yolanda - Thanks for commenting, and I am glad you can put this tip to use. I was thrilled when I stumbled upon it!

http://www.twitter.com/mortgageva

JUL

Yep, that's the easy way. I think it was Bob Stewart that pointed this tip out to me about six months ago when I needed an easy way to find a post and the link to the post to send to someone. Having them all in Excel means that I can sort on them, too. And each time I do a new post, I can simply add it to my Excel database, with the link, very easily so that the database is always up to date.

JUL

Thanks for commenting, Russel. I missed Bob's tip, and ended up stumbling on this solution quite by accident.

This blog does not allow anonymous comments