mipapage - 11:14 pm on Dec 4, 2003 (gmt 0)

cfx211,

What a golden post! Thanks for sharing your efforts.

I'm working on a DIY tracking system that fits in nicely with the CMS that we use in-house. The ideas that you have shared have saved my tired brain a lot of thinking!

The one thing that it didn't allow me to do was path analysis which I thought was next to impossible with SQL

I guess you mean sophisticated path analysis like:

create[ing] a table of pages viewed immediately after an account was created and look at paths from there.

Could this be done by storing an action (account creation in this case) that refers to a session -> Then query for that action, get the sessions and concatenate the urls to make a path?