Such tool exist?

[Raymond]

I have been using a decent stats analyser provided by my host for 2 years. It's not great, but it does its jobs ok.
I have been wanting to trace EACH IP to see how and where they click on my site. Not just a general statistics of paths and exits pages.

Is there a stat program, or even a script out there that I can use that provides this function?

[larryn]

Raymond,

If you have access to your raw logs, you can use a spreadsheet for the basics.

Larry

[Raymond]

Actually I have been downloading my logs everyday. But my log file can go as big as 40 megs per day, and the 65536 limit in excel just can't cut it.

Is there an existing product that have this function?

I am also considering writing this script myself. I just need to know if such software exist. I would gladly pay for it instead of spending weeks to write the script.

[nmattheij]

I've been doing this with Hitlist in the past. Hitlist converts log-files into a huge SQL Server database, and then created reports based on this database. Once you know the structure of this raw-database, and if you're a pro in SQL, you can exctract pretty much anything you want in the way you want it. I used the query analyzer to trace visitors by IP and agent.

Hitlist is made for normal reporting, but I've been double checking a lot of reports this way. So it kind of does the job, but it takes patience and a load of SQL-knowledge.

You should probably be able to convert log-files into a database with a much simpler program.