NOOOOOOOOOOOOOOOOOOOOOOOOO! WHY WHY WHY! This will cause INSTABILITY IN THE INTERNET! NO! Why did someone let this list out! NO! Well Im 100% sure that my earnings from affiliates will drop now Thanks for sharing this information anyways ..
bandwidth is the least of his worries, it's computing power that counts. My pc has been smoking on this data for hours and I'm not doing anything complex, just selecting cases where search strings contain my keyword. I got 1gb ram in my home pc and I'm getting "Out of memory" errors from SPSS, and SPSS is not a crappy program. I won't even think about creating a frequency table before I go to sleep.
are you sure you want to omit those dupes? if one user searches something 10 times a month that doesn't mean the search string gets only 1 hit each month...
1EightT, just out of curiousity, are you basing the dedupe on an MD5 hash or some other relevant factor? Or are you performing a near-dedupe?
What would you consider a duplicate? There almost always seem to be different timestamps on the rows, so it just seems like people are doing the same query over again. I'm not sure this should be considered a duplicate.
1eightt i agree with peach Maybe it is best that the data is left intact I cannot wait for link!!!! Thanks Dr N
I agree; if the dupes have different timestamps, then they are very valuable in determining the search frequency and popularity of particular keywords.
Someone on another thread said that the following are top paying keywords and it would be nice to run them against the list and see results: - drug tests - Golf - Call center - email marketing - bpm - financing - pos software - clean rooms - caviar - psychic advice - dog doors - window blinds Dr N
Sorry! The following list is also meant to be high paying.I would just love to see how many people actually search for these: mesothelioma $84.08 mesothelioma attorneys $80.93 mesothelioma lawyers $69.04 malignant pleural mesothelioma $55.95 Asbestos Cancer $54.17 mesothelioma symptoms $53.66 peritoneal mesothelioma $52.27 trans union $51.91 lung cancer $43.12 search engine optimization $30.19 mesothelioma diagnosis $28.70 home equity loans $20.06 Baines and Ernst $18.47 consolidate loans $17.74 Lexington law $17.68 Lexington law firm $16.81 debt problems $16.28 register domain $15.74 home equity line of credit $15.61 affiliate programs $14.33 refinance $14.21 video conferencing $13.63 payday loans $13.21 credit counseling $13.02 asbestos $12.79 debt solutions $12.64 cash loans $12.13 refinancing $12.09 broadband phone $12.08 debt management $11.86 fast loans $11.81 credit card processing $11.75 credit reports $11.59 making money on the internet $11.58 merchant account $11.46 line of credit $11.42 money magazine $11.27 Adsense $11.13 credit counselors $11.02 identity theft $11.00 make money at home $10.84 free credit $10.76 cash advance $10.64 consumer credit counseling $10.63 freecreditreport $10.61 make money from home $10.35 free credit reports $10.26 make extra money $10.21 domain registration $10.19 adwords $10.08 citifinancial $10.06 my fico score $10.01 web hosting $09.88 American express credit $09.71 airlines credit card $09.52 credit report $09.52 earn money $09.51 hard drive recovery $09.49 hard money lenders $09.44 credit counseling service $09.44 consolidate $09.41 claims $09.20 debt consolidation $09.10 poor credit $09.09 low interest $08.89 web host $08.64 student credit cards $08.63 secured $08.60 merchant account application $08.59 loans $08.57 send money to India $08.43 discover credit $08.40 merchant accounts $08.39 hosting $08.35 money on the internet $08.34 credit loans $08.33 consumer credit $08.32 money making ideas $08.26 credit card applications $08.23 money lenders $08.10 discover credit card $08.09 money loans $08.08 dept help $08.01 credit card services $08.01 consolidation $07.94 ways to make money $07.84 student credit $07.73 online credit report $07.66 how to make money $07.51 accept credit $07.47 accept credit cards $07.43 student loan $07.43 internet money $07.39 credit repair $07.32 free credit check $07.28 bad credit $07.26 money making $07.21 SEO $07.18 University Degrees Online $07.16 credit card application $07.05 consolidating $07.05 people with bad credit $07.05 car loans $07.05 money fast $07.03 money now $06.88 household automotive $06.76 personal credit $06.73 money at home $06.72 bad debt $06.69 lenders $06.68 auto loans $06.63 making money online $06.61 Point of sale software $06.55 interest credit cards $06.53 credit history $06.53 lending $06.39 business credit $06.32 money to India $06.31 debt $06.17 online credit $06.15 student credit card $06.14 hard money $06.10 webhosting $06.06 credit cards $06.04 make money $05.97 credit application $05.96 online credit card $05.96 chase credit $05.90 interest credit $05.89 Equifax credit $05.89 video conference $05.88 credit card offers $05.88 American credit $05.86 credit card fraud $05.82 best credit card $05.82 no credit check $05.79 credit card $05.75 bankruptcy $05.64 best credit $05.59 money market account $05.55 mbna credit $05.54 for credit $05.48 webhost $05.48 pengar $05.47 college credit $05.44 money market accounts $05.43 best credit cards $05.40 credit reporting agency $05.39 credit card debt $05.36 credit checks $05.36 visa credit $05.36 credit check $05.29 secured credit cards $05.26 one credit card $05.25 Credit report $05.24 i need money $05.16 low interest credit $05.15 credit services $05.08 credit reporting $05.06 preapproved $05.04 online approval $05.04 credit card rates $05.02 credit score $05.00
For "mesothelioma" I got roughly 214 searches out of the 20,000,000. But I'm sure at least some of that are people doing keyword research
Don't forget that this data is only for 0.0005% of total internet users. 500,000 out of 1 billion isn't much of a sampling