Ennui Blog

Welcome back!

Here’s a pretty cool and funny video from the folks over at HubSpot. They’re major proponement of a new type of marketing called inbound marketing. I’m sold on it and when these guys talk, I listen.

Check it out:

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.

I’m giving Squidoo a try after hearing a Webinar from Seth Godin today. I set up a page about how to choose a web hosting provider. We’ll see how it goes.

Check out How to Choose a Web Hosting Provider on Squidoo.

After a few days of set-up, I’m ready to announce my latest project: Sci-fi Conlist.info. Sci-fi Conlist will be a directory and calendar of every sci-fi, anime, comic book, fantasy and gaming convention I can find.

There isn’t really a good site out there listing all the sci-fi conventions going on in the USA. There’s one site that has the information, but it’s stuck in the 1990’s.

What differentiates Scificonlist.info from the competition is that there is an RSS feed, so you can be notified of the latest genre conventions when they’re added to the database.

Another excellent feature of the site is a calendar that gives you a month by month overview of the conventions happening at all times. You can also view conventions broken down by state or type.

It’s a great little tool. The database isn’t very full right now as I’m still adding conventions to it. But like WebinarCentral.net, there is a submission form that allows anyone to submit their genre convention for free.

Stop by and let me know what you think.

I’ve been developing another site for the past few weeks and it’s now ready to go live. I present the Essay Outliner.

Free Essay Outliner is a simple tool that will help anyone outline a standard five paragraph essay. All you need to do is input the data in the form such as: main thesis, idea 1, idea 2… etc and then a script will compile the data and present sentence by sentence instructions on how to write your essay.

This is a very simple, yet invaluable tool that I wish I had while going through cool. It’s perfect for young students whom are still trying to understand how to structure an essay or for seasoned college students who don’t have time to do the legwork. This could conceivably help you outline blog articles as well. The possibilities are endless.

I hope to develop more sophisticated tools based on this concept (such as a term paper outliner) in the future, but for now, this tool does the job simply: outline an essay.

Check out the Free Essay Outline Tool Today!