Top 50,000 paying Adsense keywords (purchased from a shady looking website)

https://docs.google.com/leaf?id=0B2QExXr67OcTZjNlNDYwMTktNmE4YS00MTYyLTg1NGUtMmJhMzg0YmIzZjBi&hl=en

by iamelgringo • 16 years ago

105 38 16 years ago

docs.google.com

iamelgringo5• 16 years ago

So, last March, after two startup ideas bombed, I was doing some research on where online advertising revenue was being spent. I figured that if I was going to even partially monetize with ad revenue, it made sense to figure out what topics and niches were paying.

As part of that research, I ended up purchasing a list of the top 50k paying keywords off a shady looking website. The site only took PayPal, and they were only charging 50 bucks, so I figured it was worth it, and I wasn't risking too much aside from exposing my PayPal account, so I bought it.

I was pretty skeptical of the data at first, but I randomly spot checked around 50 search terms, with my Adsense account, and they seemed to correlate pretty closely.

I then wrote a script to cross reference how much people were paying for each set of keywords with how many results were returned for those keywords. That gave me a ratio of High cost keywords::number of results, which was enlightening.

Mind you, this data is suspect. Google doesn't charge a fixed rate for their advertising rates, from what I understand, each time an ad is served, the price essentially depends on an auction and the price varies accordingly. Also, I bought this data off a shady looking website during a really low point in one of the worst economies in decades. Caveat Emptor

That being said, I thought you might find it interesting.

nixy• 16 years ago

Do you have the rights to re-distribute this data?

iamelgringo5• 16 years ago

There was no guidance whatsoever on the website I bought it from as to whether or not I could or couldn't redistribute. I agreed to nothing, I didn't click "next" on any licensing terms. The site I got if from was really pretty sketchy. The site was only 3 or 4 pages. A description of the product, a price list, a "buy now" page and a download page. I clicked the buy now button, paid $50 and downloaded a CSV. No license, no agreements. Nothing.

Also, it was a March '09 that I did this, not March '10. Sorry about that.

I'm really not trying to be shady at all with this, and I really had no idea that people would be uncomfortable with something like this or think it's wrong.

If people have serious moral qualms about this being here, I'm happy to take it down. I just thought it was an interesting hack so I thought I'd share it.

btmorex• 16 years ago

Facts can't be copyrighted. There's no problem with redistributing the data.

vincentchan• 16 years ago

Since when Hacker News has become Private Bay?

josefresco• 16 years ago

Vincent has a point, I don't feel comfortable looking at this even if the source was shady.

harshpotatoes• 16 years ago

So somebody spent the time to figure this data out, is selling it, and you're now giving away their product for free? Is there more to this story?

laxk• 16 years ago

It's forbidden right now, is there any other url?

iamelgringo5• 16 years ago

http://ran.dom.crap.s3.amazonaws.com/Top%20Google%20Key%20Wo...

iamelgringo5• 16 years ago

I throw myself on the court of community opinion. Please feel free to flag this post if you think it's unethical or wrong. And, the mods and/or the HN algorithm will mark it dead.

I'm really not trying to be a ass. I thought it was interesting, and the recent post where the author was driving traffic to his blog by posting the top 50 keywords reminded me of it. I did this project over a year ago in March of '09. I don't think I'm giving away any trade secrets at this point.

I thought I'd share the whole list I'm sure he bought in the spirit of openness. But, as I said, it's really no skin off my nose. Feel free to flag this if you think it's inappropriate. I'm really not up for getting flamed or arguing.

ohashi• 16 years ago

Very kind of you to share, I've seen a lot of data like this in the past, it looks pretty familiar in terms of the type of stuff on there.

keefe• 16 years ago

Well, you certainly convinced me to download with this comment :]

agbell• 16 years ago

Likely this data comes from google's keyword tool, which has a paid API.

semisland.com/semrush.com has alot of good data of this type. Also, they scrape the ads and organic rankings for a ton of keywords.

tszming• 16 years ago

10 Big Myths about copyright explained http://www.templetons.com/brad/copymyths.html

invisible• 16 years ago

And the relevant tidbit: "Facts and ideas can't be copyrighted, but their expression and structure can. You can always write the facts in your own words though."

kwyjibo• 16 years ago

It's not a fact, it's a database and databases are protected by law.

ashbrahma• 16 years ago

Has anyone downloaded this yet?

DanielBMarkham• 16 years ago

I'm flagging you. I was one of the people paying 50 bucks for it, and this just starts some kind of stupid DRM battle. The guys did the work to accumulate the data, they're not asking for your firstborn. Giving it away is just screwing over somebody else's business model simply because you can.

wdewind2• 16 years ago

Has anyone actually looked at these? Most of them have typos (ie: ameratrade instead of ameritrade).

I don't think this is the top 50k search terms, maybe it's the top 50k when there was a google suggest or something?

I refuse to believe "visaa" ranks higher than "visa" and that "ameratrade" was #1.

drm237• 16 years ago

It's not a list of search volume, it's a list of the top keywords ordered by cpc price in adsense. Some (most?) likely have little to no search volume at all.

wdewind2• 16 years ago

Ah my mistake, thanks. Makes sense then that one offs are the most valuable (lowest competition, latches on to a real one)

rmc• 16 years ago

A lot of trademarked terms (e.g. "visa") might not be available as adsense words. So people bid on the misspellings.

patio11• 16 years ago

These surface on the SEO underground every once in a while. I personally don't think the data is that valuable except for getting less-than-savvy folks to pay scads of money for a CSV file (present company excepted, most folks who buy this are going to be the DigitalPoint "How do I make $1 a day with AdSense!?" crowd that buy most Make Money Online products).

That said, the existence of lists like this always makes me shoot a baleful glare in the general direction of Google's "transparency." They are very happy to give away all the rest of the world's information, but anything Big G thinks is commercially sensitive for Google is guarded like Fort Knox. (Did you know AdSense users can't even tell you the CPC rates they get without violating the TOS?)

iamelgringo5• 16 years ago

You've hit the nail on the head. I didn't really want to bring up that issue, but I'm glad that you did. Google also makes it against their TOS to automatically crawl their search content: http://www.google.com/support/webmasters/bin/answer.py?answe...

IMHO, that's patently absurd considering the business they are in.

re: transparency:

In what other business would it be remotely okay to not talk about the purchase price, or the sales price of an item? That's just patently silly.

And, the transparency really only gets worse the closer you get to Google headquarters. I can't tell you how many Googlers that I end up having brief chat's with, that can't talk about what they do or what they are working on in more than very vague terms. It's creepy.

re: I personally don't think the data is that valuable except for getting less-than-savvy folks to pay scads of money for a CSV file

You're absolutely correct. The list is really not that valuable, but you see where people take that information and run with it putting out hundreds of cheap SEO sites that target mesothelioma. Where I did find value in it, was in categorizing sectors where people pay a log of money for customer lead generation. That's Legal and Financial.

So, I mulled that idea around for a while, and I decided I would try and focus my startup, http://Newsley.com on the Ecnomic and Financial News space. One quarter of all online ad spend is devoted to Financial services marketing. It's a 3.5 Billion a year industry. And, I dont' really see that many financial services ad that much, so they must be paying a lot.

I've been taking Newsley in a different direction now that I'm part way into the business, I'm talking to a lot of people that manage large sums of money for a living, and I'm picking their brains about their news finding and filtering problems. It's been really valuable. My current business has really nothing to with the original list, but it at least pointed me in a certain direction, and I'm quite happy I did it.

steveplace• 16 years ago

For those that don't want to download, I'll give you a major theme in this after a quick perusal.

1. It's very hard to bid on trademarked names. For example "Disney" may take issue with your "Orlando on $20 a day" clickbank ebook ad.

2. It's a little less competitive if you use misspells. So bidding on "Dinsey" could provide higher CR. This is a fairly well-known theme.

Do note, my example was not included in the file.

pbhjpbhj3• 16 years ago

Caveat: a trademark protects the owner from you attempting to confuse the public into buying your product because they think it comes from the trademark owner. Using typos is attempting confusion. Thus simply relabelling things as "dinsey" doesn't avoid a potential trademark suit.

Top 50,000 paying Adsense keywords (purchased from a shady looking website)

Related Stories