Welcome to WebmasterWorld Guest from 54.234.104.173

Forum Moderators: werty

Message Too Old, No Replies

# a good formula for "median bid"?

#### httpwebwitch

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

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?

#### werty

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

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.

#### httpwebwitch

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

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:

abyss
accommondation
action divers
acuc
air fills
aj morford
akumal
albatros
aliwal
alk diving
alk maritime
[snip]

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
nitrox
certification
fins
diving tours
accomodation