Welcome to WebmasterWorld Guest from

Forum Moderators: werty

Message Too Old, No Replies

a good formula for "median bid"?



3:38 pm on Mar 7, 2009 (gmt 0)

WebmasterWorld Administrator httpwebwitch is a WebmasterWorld Top Contributor of All Time 10+ Year Member

I've acquired some bid data from Yahoo (indirectly), a few thousand keywords and anonymous bid data for them; the top 10 advertisers' bids, showing what the keyword is "worth".

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.

sample data:

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
subtract $0.10

is there an industry-accepted formula for giving a keyword a "score" like this?


2:09 am on Mar 9, 2009 (gmt 0)

WebmasterWorld Administrator 10+ Year Member

What is your goal with the data?

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.


3:32 am on Mar 9, 2009 (gmt 0)

WebmasterWorld Administrator httpwebwitch is a WebmasterWorld Top Contributor of All Time 10+ Year Member

ok, here's a concrete example

say I'm showing SERPs for "scuba"

I have a list of words that are *related* to it, like these:

action divers
advanced diver
advanced nitrox
adventure divers
adventure diving
air fills
aj morford
alk diving
alk maritime

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:

diving tours

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


Featured Threads

Hot Threads This Week

Hot Threads This Month