http://simplifiedsec.com/KeywordDigger.html Here it is guys, the full 18 million query 2GB database from AOL/Google in a searchable format. It's somewhat slow as we are indexing the tables at the moment, but we have a query cache in place that should speed things up as we go.
Thanks for the link, just playing around with it looks realllly cool...(while i wait for the files to download)
Thats a good opiton, but what i found from the results is that this data is all crap, Try with the keywords which you usually search and u will know it
We would have to parse the data and do a count of each unique search term. Possible, but it would take some time given the amount of data present. Rank and clicked url. The clicked url is the url the person clicked in the SERPS after doing their search. The rank is the position of that url in the serps. 0 means the search engine took them straight to the page (as if you put google.com in the search engine and it takes you straight to google). 1 would mean they clicked on the first result, and so on.
We are changing the index type to FULLTEXT on the data so search will be quite fast. No idea how long that will take though. I'm guessing a few hours.
I've got a tool that works a little better. This site only returns 50 rows.. and it's limited.. dontdelete.com It does an Overture-like result set.. I think it's a better layout... let me know..
Nice dude, real nice... although it's not very helpful from what I can tell. It shows what looks to be the last 50 queries with the search term, but it's not sorted in any valuable way. If I search for the term "widget", I'd like to see it return the most frequently searched for terms with "widget" in them, like Wordtracker & Overture.
Interesting...alot easier to use...definitley the best one out there! dontdelete.com - really has all of the info - not limited and is actually pretty fast considering all of the info thats there
Assuming you're talking about DontDelete.com.. It actually does. Quick hint: though a "%" sign in the beginning and you'll get everything. For instance "%widget". The results returned are as follows.. # distinct users searched # times and clicked to # sites for the give keyword that matches "%widget". Then you can click through no search terms and see the sites that were visited AND their average page rank for that term. It shows the top 1000 results.. if there are few by nature of the term.. fewer will show. Let me know if you have other questions or suggested enhancemenets.
We added a FULLTEXT index to the search, and now searches are returning in under a second for most queries. Give it a shot. http://simplifiedsec.com/KeywordDigger.html Give us feedback on what you would like to see added feature wise.
we are sorting the data based on user feedback, so it may appear slow for a moment. Just try back if it is. It's definitely the fastest i've seen of anyones on the net.
there are a php sql error did you configure well the config file ??? are you sure the password is YES ???