Online Marketing

Alexa 1 Million Top-Sites CSV (worth 2500$) download for free

Alexa seriously tries do defend Google’s recent data publishing attack (releasing Trends for Websites and Insights for Search) and stumbled across this ad on alexa.com:

The linked download is quite impressive. Not only the Top 500 (or country-based Top 100), but the top 1 million trafficked sites by Alexa ranking is now available for download (top-1m.csv.zip 9,5 MB Zipfile, ausgepackt 21,4 MB) and it appears to be recent data too (November 24th says the file-timestamp). This list would set you back 2500 US$ via Amazon’s Web Services and unlucky you are only if you recently bought it or you work with MS Excel 2003 where you’re limited to the first 65536 Entries…

Some observations about the content: Subdomains from wordpress.com, blogspot.com, blog.br, blogs.com and others are now counted seperately. While this might be old news to some I just observed it today as well as the fact that they do also seperately track it when your folder-structure contains a ~username (old UNIX standard used at some universities) or my.domain.tld/user/name. This also causes some errors, assome Domains using Feedburner MyBrand appear in the stats with their feeds.domain.tld/~r/ redirect URLs.

Beside these minor flaws just a sincere Thank You to the Alexa Team for this early christmas present 🙂

Also see my original german post about this christmas present from Alexa.

6 comments Alexa 1 Million Top-Sites CSV (worth 2500$) download for free

[…] read my english translation on randolf.jorberg.com […]

Barry says:

Thanks for making everyone aware of this! I learned about your post today via DomainNameNews.com.

I just finished writing an browser based tool to help me search the data (since my version of Excel was only able to open the first 65,000 records). Instead of manually reviewing the list, I can now enter in a keyword phrase to show all sites in the
Alexa top million which contain this phrase.

The data is very interesting. In addition to checking on competitors,
it’s possible to get a list of top trafficked domains by domain extension
or country code.

For example, I found…

565,805 .com sites
70,640 .net sites
48,810 .org sites
54,309 .de sites
3,599 .za sites

If you would like to try the tool out, it’s located at
http://www.popularity.info and can search the entire list in about 5-10 seconds.

hey Barry – THIS IS COOL! Thanks for that tool…

[…] 10k…, while Alexa charged a whopping $2500k for pretty much the same data. Today I saw over a Randolph’s blog, that Alexa just opened up their database and offered the Alexa top million websites for free. […]

Recently Alexa added new features in their Top http://www.alexa.com/data/details/main?url=www.fortunehotels.in Sites Lists. These features have come to be extremeley well recieved by the web professionals.

kanka says:

thank you..

Leave a Reply

Your email address will not be published. Required fields are marked *