Avoid Arguments By Using Google Docs

The first partnership in a website I entered into had quite a few problems. It didn’t end particularly badly or anything like that (in fact I am having a beer with my old partner on Monday), but there was always a bit of tension regarding the site and the business surrounding it. This is a real risk for online business collaborations where partners don’t necessarily meet face to face or talk with each other all that often (and sometimes never at all).

The main reason for the tension in that first partnership was that our communication system wasn’t all that good. Sure we had spreadsheets and email and phone, but we never really got a system settled for how we recorded business decisions, marketing decisions or design and content decisions. It was all a bit ad hoc with us emailing and saving over each other’s documents (sometimes unintentionally). It was not a great setup.

Recently, I have started another online project with a partner and it is quite the opposite. Everything is going startlingly smoothly and there have been no tensions, no fights, no disagreements or really anything like that.

The single greatest reason for this is Google Documents.

Now, I am sure you have heard of Google Spreadsheets (which was formerly iRows). It is basically a collaborative spreadsheet that saves in real time so one person or twenty can be working on the same document.

We have a single spreadsheet document that has a bunch of different worksheets. One for keeping track of finances, another for keeping track of the publishing schedule. Another for keeping track of advertising and marketing campaigns, another for keeping track of other blogs and sites that we want to be mentioned on. There’s really no limit there.

But the main point is that we are on the same page! (sorry - bad pun).

We also keep a another document that has the template of the format that we use to post content to our blog. That way we can both refer to that document for our own purposes and we can also share it with contractors who we hire to write content for us. This seems to be working quite well so far.

Once again, the central idea is open communication.

Google’s online documents allow collaborative abilities that simply weren’t widely available (let alone free) all that long ago.

The thing is that these tools are a great arrow in the quiver of good business communications for online partnerships and projects.

With the imminent release of Google Gears, which will allow users to take Google Docs offline, one can only hope that the aids to successful online collaborations will get even better.

Technorati Tags: , ,

Continue reading » · Rating: · Written on: 05-31-07 · 5 Comments »

How to Select the Best Keywords for SEO and PPC

Choosing the wrong keywords will destroy your online marketing efforts. I don’t mean to be melodramatic, but I can tell you from experience that spending weeks and months SEOing a page for the incorrect keywords can really take the wind out of your sails. So can dumping a bunch of cash on some PPC and not getting any sales conversions.

In fact, a few years ago, after SEOing a site  for the singular of a keyword and later discovering (by the complete and abject failure of that site) that the plural was where both the traffic and conversions were, I decided to make sure I always did my keyword research well.

But what makes a good keyword when you are trying to convert some type of affiliate offer?

There are several ways to judge a keyword, but it basically comes down to two main factors.

Traffic volume and conversion rate.

Traffic volume kind of speaks for itself. The more people searching for a specific keyword term, the more traffic you will get. Use a tool like Overture or the Wordtracker Tool to estimate traffic for certain keywords. ‘Nuff said.

But how do you know which keyword searches will translate into sales?

Basically, you need to seperate keywords into three categories:

  • browse
  • compare
  • buy

For the purpose of this post, let’s use a few examples from the auto industry.

Browse Keywords

A browse keyword is a word that is searched for when the searcher doesn’t really know what they are looking for. “Cars” would be an example of a browse keyword and I guarantee that you would have a very hard time getting people to convert into sales or leads if what they typed into Google was “cars”.

Browse keywords are the enemy of the affiliate marketer. We need to get more specific than that.

Compare Keywords

Compare keywords are words and phrases that people type into search engines, usually when they are researching a specific product that they are considering buying.

This can be a good time to get them, offer them the information that they desire and convert them into a sale via an affiliate program. Product comparison sites are good for this.

An example of a compare keyword within the auto industry would be “compare car insurance.” In fact, if you could rank well for that term naturally, your site would be doing very well.

Buy Keywords

Buy keywords are words and phrases that a searcher will type into search engines at the very end of the buying cycle. At this point the searcher knows exactly what they want and will be very specific in their search.

An example in the auto industry would be something like “cheap 1999 Toyota Landcruiser roof rack.”

Note that the keyword is very specific. If you can put exactly what the searcher is looking for infront of their face at this point, then you will have a very good chance of making a sales conversion.

Free Tip: Branded products with model numbers are great keywords and convert very highly.

Show me the money!

The problem of course is that most “buy keywords” with high traffic are very competitive to rank for with PPC and natural SEO.

For an affiliate or a blogger on a limited budget, your easiest course of attack will be to go after the long tail “buy keywords” and going after lots of them. “Compare keywords” also offer a lot of opportunities. Just be sure to track which keywords are turning into conversions (there’s great tutorial on using PHP for conversion tracking at Jeremy Palmer’s blog).

But whatever you do, don’t neglect the keyword research stage of your site building or PPC efforts.

Technorati Tags: , , ,

Continue reading » · Rating: · Written on: 05-15-07 · 6 Comments »