Originally Posted by Vi5

Thanks but is there anywhere I can get say 1m for excel or access?

Alos those URL searches - remember AOL will be the error page for AOL users and maybe it's like the MSN error page.

I might export some records to excel tomorrow,
but how much records can excel handle?

Originally Posted by SEO Portal

I might export some records to excel tomorrow,
but how much records can excel handle?

Unlimited I believe, however it may have a limit (especially if it is importing data as a CSV).

Originally Posted by SEO Portal

I might export some records to excel tomorrow,
but how much records can excel handle?

Each worksheet can have just a tad over 65k rows

I got 65,536 rows

Thanks SEO Portal!

I crap out at about 6500 rows as well.

Originally Posted by august

How small are you talking? what would you be able to deduce with such small data?

Thanks but don't worry about what I'll deduce with it. That's my problem. I'm fairly good with Excel. I'm sure I'll manage the data quite well if I can just open it.

For all of you that are good with databases like SEO Portal...
Here are several mirror sites where you can download the files.
http://www.gregsadetsky.com/aol-data/

If you do create Excel friendly files... I know someone who will host them for you. Just PM me and I'll send you the info.

Aloha,
Dave.

i;m exporting the data 64k records at a time right now.
Just tell my how many you want and where I can upload the files. (they are 4MB / file)

I added a posting to my analysis serie;
AOL Data Analysis - IV. Where do People Search For?

You can get the Tab delimited txt for the top 2500 searches as well..

Originally Posted by mattd

Maybe that says more about AOL users than anything.

It says something about newbies in general, NOT about AOL users. Many newbies don't know the difference between inserting something in a search box and in the browser's address bar. If you don't believe me, read Jakob Nielsen's new book.

If anyone wants the files in smaller chunks just use "split -l 60000 aol_01_" from the command line.

If you want it as CSV just use "tr '\t' ','" - no need to mess around with databases - just use the unix command line for what it was designed for

just for fun:

Top searched Women by AOL Users

Oprah is the top searched woman....... lol

Does anynone know how sponsored links are measured in de AOL file? I am not to familiar with AOL since I live in Holland, but I would imagine a lot of clicks are on sponsored links.

Originally Posted by Bram

Does anynone know how sponsored links are measured in de AOL file? I am not to familiar with AOL since I live in Holland, but I would imagine a lot of clicks are on sponsored links.

The data shows only clickthroughs to the organic results. However 46% of the searches show no clickthroughs at all and it is highly likely that the majority of these were clickthroughs to the sponsored results.

- Michael

Bram brings up a good point, it would be nice to know if those 46% that don't show clicks, clicked anywhere else on the page, such as sponsored links or other ads.

OK, I'm a little late to the party here. Just found this thread. This AOL data is very interesting, but does anyone else find it odd that only 54% of searches result clicks???

When I search for something I almost always click something. And I usually click several search results either by opening a site in a new tab/window or by clicking the back button after I've looked at a site so I can check out another site in the search results.

Is this 54% number really legit?

Is AOL still widely used? I thought it was obsolete

AOL's marketshare is ~1.7% According to Hitslink and I think Nielsen Netrankings is reporting 1-2% as well.

But even though it only covers a few percent of internet users for 3 months, the AOL data is still useful. It's size is comparable to Overture's and you can download it and process it locally. Plus you can find all the users that searched for a term you're looking at, and see what other searches they made and when they made them.

Originally Posted by pdstein

OK, I'm a little late to the party here. Just found this thread. This AOL data is very interesting, but does anyone else find it odd that only 54% of searches result clicks???

When I search for something I almost always click something. And I usually click several search results either by opening a site in a new tab/window or by clicking the back button after I've looked at a site so I can check out another site in the search results.

Is this 54% number really legit?

I'm usually not one to quote myself, but I would really be interested in hearing other people's opinions on this question. Do you all believe AOL is only getting a 54% click rate on searches???

Originally Posted by pdstein

OK, I'm a little late to the party here. Just found this thread. This AOL data is very interesting, but does anyone else find it odd that only 54% of searches result clicks???

When I search for something I almost always click something. And I usually click several search results either by opening a site in a new tab/window or by clicking the back button after I've looked at a site so I can check out another site in the search results.

Is this 54% number really legit?

Anyone?

Originally Posted by pdstein

Anyone?

this was mentioned before, but it could be that some of the 46% could be clicks on sponsored links.
Furthermore we have to keep in mind the people refining their searches...

Originally Posted by SEO Portal

this was mentioned before, but it could be that some of the 46% could be clicks on sponsored links.
Furthermore we have to keep in mind the people refining their searches...

Sorry, I read the entire thread. I must have missed it. I suppose sponsored clicks would account for a considerable %, but 46%? That seems awfully high to me. Is there anything to support that theory? Is everyone else accepting that theory, or are there others who like me are skeptical of the 54% number?