JonnyQ Special: Adwords Keyword Spreadsheet

I contacted my author and she said she'd be ready for the next project next week. That will take care of sites #4 and 8. I will start doing the prep work for #7 as far as the header and Universal Template go. Once that is finished, I will write its content while she is writing for the other sites. If things work out properly, all 3 will be up at the same time.

Nikki asked how I was putting in 500 keywords to my Adwords campaign in a night. She also said that I was the "King of Efficiency". Not yet, but one day I will hold that title. Anyway, I'm a believer in front loading work, i.e. Universal Template, spreadsheets. It's all about streamlining where I can. For this, I created a spreadsheet with three columns. The first column is an adjective column, the middle is the keyword column, and the third is whatever I need it to be. Each row would be a root keyword. I go down the first and third columns, creating phrases. For example, (and I can't guarantee Blogger will like the format but here goes) lets say my ads are for home renovation...

, home, renovation
, home, remodeling
cheap, home, renovation
cheap, home, remodeling

The first and third columns are static; the middle, dynamic. Now I shift gears and get more specific....

, bathroom, renovation
, bathroom, remodeling
cheap, bathroom, renovation
cheap, bathroom, renovation

By creating the spreadsheet in Excel, I can type in "bathroom" and either drag fill down the sheet or have the rest of the middle cells automatically copy the first middle cell (B1) by putting "=$B$1" in each.

, Where I type (B1), renovation
, =$B$1, remodeling
cheap, =$B$1, renovation
cheap, =$B$1, remodeling

From there I can drag and copy the three columns. I paste it into Mike's Adwords Wrapper. I only use the phrase and exact match, never broad. This essentially doubles the keywords instantaneously. This has taken me a while to develop (didn't reach this level of refinement until this week) but now that I have it down, I can quickly create keywords.

I am considering outsourcing my link building. I am tired of having to choose between expansion and link building. Link building diverts my attention from making new sites and developing new content. At the same time, my sites have not reached the levels I want because I do not have enough inbound links to break into Yahoo and Google. I haven't figured out how to safely conduct this outsourcing but major cerebral resources are being devoted to it.

I'm coordinating a war on several fronts...