homepage Welcome to WebmasterWorld Guest from 54.166.148.189
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Become a Pro Member
Visit PubCon.com
Home / Forums Index / Yahoo / Yahoo Search Marketing Pay Per Click Advertising
Forum Library, Charter, Moderators: werty

Yahoo Search Marketing Pay Per Click Advertising Forum

    
a good formula for "median bid"?
httpwebwitch




msg:3865096
 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




msg:3866000
 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




msg:3866013
 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
advanced diver
advanced nitrox
adventure divers
adventure diving
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
masks
cruises
[etc]

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

Global Options:
 top home search open messages active posts  
 

Home / Forums Index / Yahoo / Yahoo Search Marketing Pay Per Click Advertising
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Home ¦ Free Tools ¦ Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About ¦ Library ¦ Newsletter
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved