Ennui Blog

Welcome back!

Last spring, I was in the planning stages of starting a website that would become a database of all the immigration policies of every country in the world. It was a daunting task (it still is!). I knew that I wouldn’t be able to set up the site overnight but I wanted to get the framework of the site going to that it would start building traffic for carefully targeted key phrases. I needed to create a ’stub page’ or a placeholder for each country, targeted for key phrases. These pages would build traffic and rankings until I would be able to actually write the content.

How could I do that when I had no content and no time to write it?

Welcome to the world of unique content generation.

Basically you use mad-libs (remember those?) to create this ’stub’ content quickly.

There are many programs out there that purport to do this, but they charge and arm and a leg. Anyone can do this themselves for free, as long as you have a little knowhow in MS Office and some data.

So, how do you generate web content from a template using MS Word Mail Merge, mad-lib style?

First, you need to think about what the pages will be about. For example, I wanted to create a stub page for every country that would basically target key phrases such as: immigration to comoros, immigrating to comoros, comoros citizenship, etc. There are two elements to creating these pages, a database and a template.

The database was simple. I needed a list of every country of the world. Then I used Mail Merge in MS Word to insert that country into the template, 300 times.

So, the first step was to get a list of every country in the world (thanks Wikipedia) and create an Excel database.

The next step was to write a country page template. I wrote six paragraphs of generic content using a template tag in place of each country like {country}. Then I put the template into MS word and opened the mail merge function. Once you load the Excel data, you need to replace your template tag with MS Word’s template tag. Once you’ve done all that, all you need to do is run the mail merge and have it open the results in a new document.

I ended up with 300 automatically generated pages. All I had to do at that point was cut and paste each new page into my Drupal CMS. There are solutions for importing multiple pages into most CMS’s with .csv files, but I was never able to get it to work correctly.

You can also write your templates with HTML, so you can add text bolding and hyperlinks. MS Word doesn’t care. It just looks for it’s tag to replace. Then you can insert this code into your CMS and it will show up as a page.

So, what was the result? I did all of this 8 months ago and the site has been very successful. I rank highly for many of the key phrases I targeted and have several hundred pages generating a ton of adsense revenue. About 40% of my Google Adsense revenue comes from Global Citizen Wiki.

Unfortunately, I was unable to roll out full country pages as quickly as I’d hoped. Doesn’t matter though, the site still has increasing traffic and rankings, despite the pages having no actual content on them.

Duplicate Content Concerns

I don’t really have to worry about duplicate content because each page is different. And the trick is to use your template tags in order break up any repetitive writing. This will ensure that each page appears to be unique content, which, in the end, it is.

After several days of testing and working out the bugs, my latest web project, Webinar Central has gone live today.

Webinar Central will become the web’s best destination to find out about the latest free webinars taking place anywhere on the web. It’s the ultimate webinar directory. At Webinar Central, you can view the latest free webinars, submit your own for inclusion and comment on past webinars. We’re harnessing the power of social media to spread the word on the latest educational webinar opportunities.

Key Features of Webinar Central:

• Submit Your Own Webinar
• See Upcoming Webinars for Current Week
• View Month by Month Calender
• Subscribe to RSS Feed of Latest Webinars
• View Webinars by Category
• Comment on Webinars
• Updated Daily
• Ongoing Blog About Webinar Tips and Tricks

Why did I start Webinar Central?

I love to learn and the advent of webinars has revolutionized the way knowledge can be disseminated over the internet. I’ve learned so much from these wonderful tools that I want to make sure that anyone has the knowledge and abilitiy to learn via this medium. There hasn’t really been a central location for all the webinars taking place on the web. There is so much going on, that if you don’t have a way to find out about it, you’ll miss out on valuable learning opportunities. So using some tools that I’ve set up, I’ll be able to monitor for future webinars all across the web and let you know about them here first. Don’t see your webinar in the database? Then you can add it for free by filling out the submission form.

The media was filled positive PR about a new search engine that is seeking to challenge Google called, Cuil (pronounced ‘cool’).

As a search professional, I’m not impressed.

In fact, the only thing that impressed me was their PR campaign. They managed to get into every major media outlet in the world. They were even featured on the front page of Drudgereport as well as Digg and all the other major social networking websites.

While their PR campaign was impressive, it was also their own undoing. Their new site could not handle the server load and it did not work for most of the day. Way to impress us guys.

What kind of company announces their ‘Google Killer’ to the world and doesn’t plan for the inevitable traffic from people wanting to try it out?

Well, eventually I was able to try it out and I was not impressed at all. The search results weren’t very relevant. I couldn’t even find some of my own websites. Hell, if you search for ‘Cuil,’ it returns nothing.

The layout of the search results also doesn’t really work from a perspective of trying to find what you’re looking for quickly. They claim they’ve indexed 192 billion webpages. But that is irrelevant unless they have the relevancy to match.

I also fail to see a business model, I don’t see ads anywhere or any way to monetize their search results. I’m glad to see someone step up and take on Google but these guys have a lot more work ahead of them before they can truly compete.