[ic] User tracking

Jamie Neil jamie at versado.net
Thu Oct 21 12:22:19 EDT 2004

Stefan Hornburg wrote:
> Jamie Neil <jamie at versado.net> wrote:
>>I've found the usertrack file very useful for both troubleshooting and 
>>generating accurate ROI stats etc. However when you're serving 500K 
>>pages per month it quickly grows unmanagable, so I've been rotating it 
>>once a month and compressing and archiving the old logs.
>>This works ok but means that only the current months stats are easily 
>>available to me for producing reports. What I'd like to do is log the 
>>same kind of information to an SQL database which will (hopefully) be 
>>more scalable and faster/easier when generating reports.
>>Has anyone done this and if so could they give me some tips? I was 
>>thinking about putting a block of perl in an Autoload, but I'm not sure 
>>whether this is the best approach.
> Presumably we can extend Interchange's usertracking easily to log into
> a SQL database. I'll look into that soon if you like. How do you
> generate statistics from the usertracking information ? I'm sure that
> other users will be interested in your experiences.

At the moment I'm doing some analysis by hand (a combination of grep and 
Excel), and some using the traffic report module from IC 5.0 (which 
seems to be missing/disabled in 5.2). We track all our paid advertising 
(PPC and banners etc.) by setting mv_pc in the query string so they are 
treated by IC as "affiliates".

The stats produced by the traffic report are very useful, but could be 
much better if the data was in a database so more complex queries were 
possible. Once I get this working I'm looking at extending the traffic 
report module to take advantage of it and I'd be happy to feedback the 
results to the group.


Jamie Neil | <jamie at versado.net> | 0870 7777 454
Versado I.T. Services Ltd. | http://versado.net/ | 0845 450 1254

More information about the interchange-users mailing list