The Latest Articles:

I took two of my blogs and merged them into one.  Tucson Real Estate In the News merged with Tucson Real Estate to form a single entity.  The story of the process is documented in Combining Two Blogs in to One A Geeks Holiday Weekend.

I’m not sure when or who but there was a comment asking me to get back on the results of combining these two into a single entity.  Some have asked me if I would do it again.  Here is an update on how it is going and where we are at 55 days later.

Deindexing Reindexing Three Minutes of Radio Silence

Remember the movie Apollo 13.  There was the three minute blackout period during reentry when there was no communication with the capsule and everyone was on pins and needles till the blackout period was over and communications reestablished.  I wish it only took 3 minutes.

This is what it is like to merge two of your blogs into a single entity.  Over 300 post on the News Blog, all indexed in Google had to be moved and reindexed to show up at the new site.

It wasn’t easy watching my traffic drop for both blogs to almost non existent during those early weeks of the merger.  Yes there was a redirect 301 in place, but it didn’t eliminate the confusion Google had with the merger.  Google suddenly saw more than 300 pages of content on the one blog’s sitemap.xml file and 300 fewer pages on the other one.  I thought the sitemap submitted to Google would be the key to Google quickly grasping what was going on.  It did turn out to be the key but not the way I thought it would.

Enter a conversation with Eric Blackwell

Eric and I had a catchup conference call one day to talk about the state of the RENet and RE-Blogosphere.  It was during that conversation I mentioned to Eric the frustration I was having over getting my combined sites pages to be indexed.  It wasn’t just the new pages that were effected by the merger, the existing pages were being deindexed as well.  I had over 300 pages indexed on the one and almost 200 pages indexed on the other.  A week after the merger I had a combined 101 pages indexed.  I was adding new content daily and submitting the sitemap by hand as well as hand pinging.  Nothing helped.  This is when Eric suggested I turn into the slide.

Huh?  You know how counter intuitive it seems when your car is skidding on ice to turn into the slide and not away from it.  That is what happend with the merger of the two blogs

Delete The Sitemap

Eric said, “Delete your sitemap.xml file submitted to Google and make the bots crawl the pages themselves”  I’ll tell you that was one solution that never crossed my mind nor would it have.  But I trust Eric to know what he is talking about (I also felt l didn’t have anything to loose at this point  : )

I deleted the sitemap.xml and within 24 hours I had 300 pages indexed.  It continued to climb.  Without me guiding the bots and Google with the sitemap they started crawling and finding lots of content to index.  It climbed to 1200 pages then to 1460, to 1600 and is currently 1820 pages indexed.

The bots on their own started indexing tags as well as categories, achive pages, pdf files.  Name it if it could be seen as a page the bots were indexing it.

Traffic Increased

The Hittail traffic for the combined site gradually picked up.  It is now more than what the two sites were before.

I ran random searches for main posts I knew were indexed on the old site to see if they were coming up under the old URL or the new.  Two weeks after deleting the sitemap it appeared all the posts were reindexed under the new site.  (I was having a similar issue with another blog of mine from errors being generated in the sitemap.xml by the Google sitemap plugin.  There was an error in the code (since fixed) wihch left the category out of the post URL on a blog using a custom permalink structure.

Moving UP in the Organics

The combined site is now moving up in the organics.  It is #1 for quite a few targeted keywords from the News blog merged into the TAZ blog.  The move for the most desired keywords has been gradual.  It is hard to compete for some of these especially when there are long standing sites already in those positions.  (Some have age on their side, some have deceptive practices, some both)  Not easy to make a move on a search term with real estate in it, unless it is a long tail term.

It has only been a couple of weeks since getting the sitemap deleted and the majority of pages indexed.  I hope to get a bigger boost in the organics in less than a month.

Would I do it over again?

Yes I would.  It is easier to manage a single site.  But there has been a diluting of the message of the news blog and integrating the content changes to “Voice” of both.  It will take a little while for it to find a combined audience.  I keep tweaking the content and sidebars to provide a good experience for both sets of readers and those finding the blog through search engines.

Continuing to add quality content is one of the most significant things you can do to increase both readership and lines in the water for those searching for information you provide about your community and market.

There is no substitute for good planning and layout of your blog.  But, there are few bloggers that have the knowledge and experience to “get it right” from the beginning.  It is great to know that it is possible and profitable to take two existing blogs and merge them into a single entity.

  • Share/Bookmark

It all started out as an early morning experiment that went horribly wrong and I learned more than I ever wanted to know about patience and URL resets.  I’ll try and keep this short and break it into section.  Yeah, I learned a lot today.

Combining Two Blogs into One

The experiment that went wild.  I have decided after a lot of hesitation and hair pulling (which is getting thin) I wanted to combine the Tucson Real Estate in The News blog with the Tucson AZ Real Estate Blog.  I write a lot of blog posts in the course of a month.

There has been less of a need to post to the news blog. At this point everyone knows there isn’t much good news or new in real estate and I want to post daily and fight depression doing it.

My issues.

  1. How to bring over to the Tucson AZ Real Estate blog all the posts/pages/ and comments from the Tucson News blog.
  2. How do I create an htaccess file with the 301 redirect code that will be needed so these posts can be found by the search engines.
  3. How to notify everyone that has linked to the Tucson News blog it was going dormant and if they are willing shift their link to the Tucson AZ blog.

The first step was to create a new test database to try and integrate the two blogs.  I initially thought I could use the MYSQL database upgrade routine to accomplish this but soon found out the files were to large.  I decided to use the Export function under the Manage tab in 2.6.1.  It exported all posts/pages/comments/ etc to a new file.  I did this for both blogs.  I set up the new blog and imported both sets of files.  It took almost no time and I had both blogs integrated.  Step one was a huge success.

Then the lab rat (that would be me) took it one step further.  I thought it would be nice to attach the Tucson AZ blog to the newly created Database containing both sets of files. It went downhill fast from that point.

I realize soon the internal url structure for that database pointed to the location of the test blog.  I couldn’t just point to it in the config file like I could when I did it from the server using the MYSQL routine I described before.  Since I had set up a blog the url was inside that database file different than using the other method.  It didn’t like that and I switched it back.

I had the database, I knew it could be done experiment over.  I deleted the test directory using my FTP program and just like that all the blogs on that hosting site disappeared.  I couldn’t get to the admin panel, I couldn’t get anywhere.  In the past if this happened (YES IT HAS HAPPENED BEFORE)  I just renamed the htaccess file so it couldn’t be found and waited a few minutes for things to reset.  This time they didn’t.

I called GoDaddy support which has helped me through similar issues a couple of times over the years which usually resulted in renaming the htaccess file.  This time they said it might have been something in the directory I had deleted, but the server was fine,  They could point to the welcome.html and it would come up, it was just those dynamic php files that were the issue and according to “Scott” that was “My Problem”.  Yeah.

I learned I can combine two blogs into one.  I haven’t addressed how to handle the 301 redirect from the old News blog to those integrated posts in the Tucson AZ blog.  Anyone with this kind of experience, I”m all ears.  I know I can do each of the 255 posts in 14 categories by hand, but “PLEASE Somebody Help The Boy”.

Tomorrow, I’ll tell you the rest of the story.  All the blogs are back up live, all the blogs have been upgraded to WordPress 2.6.1 and functioning nicely (Fingers Crossed)  Here is a hint at what else I learned while trying to figure out how to recover from this.

I learned how to move a blog url from one hosting site to another and bring it back up live.  That is good to know how to do.

I learned not to upgrade a blog living in a folder as a sub directory to a higher version of WordPress than the version on the root drive.

Oh Yeah, I was a big time Lab Rat today.  More on this Rats adventure tomorrow.  I hope you sleep well tonight, I’m at least going to be able to sleep.

  • Share/Bookmark