Welcome to WebmasterWorld Guest from 35.171.45.91

Forum Moderators: open

Message Too Old, No Replies

Excel and other Keyword Creation Tools

Sharing your tools to help others...

     
5:31 pm on Dec 30, 2003 (gmt 0)

New User

10+ Year Member

joined:Dec 30, 2003
posts:4
votes: 0


Ok, I am fairly new at keyword creation, but I was hoping that some of you might have tools (i.e. excel spreadsheets), short cuts, etc. you have created that you would be willing to share with the rest of us. Not commercial products, but perhaps you advanced Excel users could help some of us out. Maybe this is already covered in this forum, but I couldn't find anything specific

I have created a sheet that combines and capitlizes rows to create OV titles. I would be happy to share it with those who share.

Thanks...

Cj

1:54 am on Dec 31, 2003 (gmt 0)

Preferred Member

10+ Year Member

joined:Apr 4, 2002
posts:418
votes: 0


I typically just use excel spread sheets and the search and replace function in my favorite text editor.
4:52 pm on Dec 31, 2003 (gmt 0)

Junior Member

10+ Year Member

joined:Nov 15, 2000
posts:77
votes: 0


This is a good idea jornada. I'm fairly new at this too and have been trying to come up with a way to get all the keywords I'm interested in using on one spreadsheet and then organizing it from there.

I've created an excel file that has the following colums:

Keyword phrase,Overture price/click top 3, Overture search counts, MYSITES Google position, Total Amount of google advertisers, total referring searches this past month to MYSITE.

Those seem to be the essential elements I need to get to the main keywords from there. After I've identified a keyword that seems like it will be a good fit I look around for broader terms based on that word and plug them in to another file.

It works for me.
B

5:18 pm on Dec 31, 2003 (gmt 0)

New User

10+ Year Member

joined:Dec 30, 2003
posts:4
votes: 0


So, how do use use this info? Determining your bid?

I use gotoast for bid management and they allow me to submit excel spreadsheets of keywords to OV and Google (which I don't believe allow you to submit a spreadsheet of words ...well OV gives you a one time deal).

Anyway...I use the standard ov suggest tool, google sandbox and my brain (going to wordtracker next) to generate KW

I have built an excel sheets that allow me to create KWs, KW variations, ad titles, and unique links (although gotoast creates these to track). It allows me to add words before and afer the keyword.

Anyone with a tool for generating custom ad copy?