Welcome to WebmasterWorld Guest from 22.214.171.124
Forum Moderators: werty
I acknowledge that the data is pretty old and of no use to someone doing SEM marketing... It's probably from some time last summer. But honestly for what I'm doing it's perfect.
kitchen+stove 1.12 0.90 0.89 0.82 0.68 0.65 0.46 0.20 0.20 0.20
I just made those numbers up. you get the idea.
I just want to sort some words by average or median bid price. I want to use bid prices to sift through a motley list of millions of keywords. when sorted by median bid price, good English Nouns and competitive common phrases will come to the top. Words with typos, foreign slang, obscure nouns will fall to the bottom.
What I need is a way to distill bid data
One formula that I once heard was:
take the average of the 3rd, 4th, and 5h advertiser's bids
is there an industry-accepted formula for giving a keyword a "score" like this?
If you are looking to bid on these terms then you would have a different formula than if you are going to profit from them (from a Yahoo! Feed)
I would actually probably play with the data quite a bit, and slap some new columns on it.
1. Take an average of the entire bids they are showing per keyword.
2. Add up all the bids for a keywords and divide by 10. )not a true average since some KWs will not have 10 bidders, but this will give those with less bidders less average value.
3. Sort the 10th bid from greatest to least. This would show you the most competitive keywords on the top. They have lots of bidders, and they are paying lots of money.
4. Repeat 3 but for all the other bids and see what rises to the top.
That last formula you mentioned does not really seem to make sense to me.
say I'm showing SERPs for "scuba"
I have a list of words that are *related* to it, like these:
actually, that list is 500+ words long.
When I do a similar query for any common english noun, I get the same kind of thesaurus barf. The keyword list includes misspellings, foreign spellings, and questionable phrases...
What I'd like is to show a list more like this:
It's not *crucial* that the highest bidded terms be at the top. But it would be nice to take say the top 15 keywords sorted by bid price, so all the chaff is discarded.
#2 sounds like a great candidate for this kind of weeding
#3 is appealing too