Wednesday, June 30, 2010

The Saga So Far

Well, I've been a busy little bee, or beaver, or interneter  <<<--- is that a word? Ack, don't care.

Have setup the Hub as a WIP (work-in-progress) in Word, on my hard drive, so it doesn't even exist in Hublandia yet. Still searching and looking at keywords and keeping track of what I am finding in an Excel spreadsheet, I have the niche I am targeting just not the final keywords, etc that I want ot nail down. Still love this app, it is one of the best items of software that Microsoft has created, but I digress...

The benefit I am finding is double, I can play around with certain keywords, long tails, and find whats the best ranking to date, competition, so on and so forth (all that fun keyword research). The other benefit I am finding is that I can tailor change my long tails and certain other words around as I can link specific words in Excel, to those I have in my WIP Hub in Word.

How does this benefit? Well if I change a keyword in Excel, they change and update in my Word document, so all I am required to do then is check the Word doc for grammar and spelling corrections as required. Yep I still need to type for mistakes, spelling, grammar etc, but saves flicking between two applications and a high amount of copy-switch app-paste.

The final aspect I like with Excel is that I can provide graphs on my data, this will give me snapshots on various tables highlighting data in certain ways to see trends, volumes, searches, competition keywords, etc. So at a glance I can also quickly see some results that may need further investigation.

No comments:

Post a Comment