Why We Are Lucky to be SEOs
Yes, Keyword Ranking Reports are Still Valuable

Download Alexa Top 1,000,000 Websites for Free

Quantcast was the first web traffic analytics company that allowed users to download their top 1,000,000 websites. Recently Alexa followed suit, giving away a daily updated index of their top 1,000,000 websites.

Such lists should be taken with a grain of salt, but at free one can't complain about the price. As time passes free and good enough is going to force those selling tools and information to offer something that has a sustainable advantage over free.

At the same time...

  • the sea of information will become increasingly hard to navigate, increasing the value of filters (particularly those built around a shared perspective or bias)
  • hyped up salesmen will be able to build many business models out of selling such recycled information to the uninitiated, forcing others who sell information to add even more differentiators between themselves and the competition

Thanks to Jamey for the Alexa tip. :)

Published: December 28, 2008 by Aaron Wall in seo tools
Why We Are Lucky to be SEOs
Yes, Keyword Ranking Reports are Still Valuable

Comments

garethjax
December 28, 2008 - 12:45pm
reply
1 million of rows!

I'm wondering which software we can use to read this file without clogging the operating system :)

Aaron Wall
December 28, 2008 - 1:31pm
reply
I am using excel 2007 and it

I am using excel 2007 and it is working (even searchable!), while playing web videos, having multiple browsers open (with 2 dozen tabs), using dreamweaver, etc.

longhand
December 28, 2008 - 2:25pm
reply
You can try uniCSVed ->

You can try uniCSVed -> http://csved.sjfrancke.nl/index.html

Add new comment

(If you're a human, don't change the following field)
Your first name.
(If you're a human, don't change the following field)
Your first name.
(If you're a human, don't change the following field)
Your first name.

Gain a Competitive Advantage Today

Your top competitors have been investing into their marketing strategy for years.

Now you can know exactly where they rank, pick off their best keywords, and track new opportunities as they emerge.

Explore the ranking profile of your competitors in Google and Bing today using SEMrush.

Enter a competing URL below to quickly gain access to their organic & paid search performance history - for free.

See where they rank & beat them!

  • Comprehensive competitive data: research performance across organic search, AdWords, Bing ads, video, display ads, and more.
  • Compare Across Channels: use someone's AdWords strategy to drive your SEO growth, or use their SEO strategy to invest in paid search.
  • Global footprint: Tracks Google results for 120+ million keywords in many languages across 28 markets
  • Historical data: since 2009, before Panda and Penguin existed, so you can look for historical penalties and other potential ranking issues.
  • Risk-free: Free trial & low price.
Your competitors, are researching your site

Find New Opportunities Today