Re: FN-FORUM Site traffic analysis running on SQL Server

date posted 28th January 2002 14:58

You do know that IIS supports odbc logging ?

So you could make IIS just log directly to the SQL Server,
and then use triggers to do any processing of the raw data.

I don't understand, then, what you mean by "cross-platform",
nor by "tracking script", especially since you say

> We will develop pages to generate reports from the SQLserver database
> separately -

What more is there to do, other than log the data,
and produce reports ?

If there is a lot of analysis to be done on the data,
it may be worth pre-calculating all the analysis,
and dumping it to a reporting table
(the data warehouse model)

But,
I imagine that the only calculations are a basic set of
SQL "Group By" and "Sum" commands.
(e.g how many AOL users visited the site today ?)

So, if you could explain what you mean by "cross-platform"
and what you mean by "tracking software"
(it's probably just me being thick :-) )
then i'd be more than happy to provide you with a price.

It couldn't be much more than a few hundred quid, though.

Hope this helps

Andy Freeman




----- Original Message -----
From: Paul Fisher [EMAIL REMOVED]
To: [EMAIL REMOVED]
Sent: Monday, January 28, 2002 10:13 AM
Subject: FN-FORUM Site traffic analysis running on SQL Server


> I'm looking into building a webstats tracking system for our clients.
We've
> used third party services in the past (e.g. stats4all.com etc) but really
> need to integrate some of our existing services with the reported stats.
>
> I need a quote for designing an SQLServer database and a tracker code, and
> just some general advice on what's involved.
>
> The tracker script must be compatible across platforms - probably
> JavaScript. It think it will probably need to work by account number - so
if
> a client has three different domains all stats are assigned to one
account.
> As well as basic number of impressions, IP visitors, operating system,
> monitor res etc. it needs to record the page name, so that we can track
> visitors through the site(s).
>
> We will develop pages to generate reports from the SQLserver database
> separately - all I need now is an idea of cost (and any
> ideas/thoughts/questions) as to the actual code and the database
structure.
>
> I think I have the server sorted, although any suggestions on this front
> might be helpful.
>
> Cheers,
>
> Paul
> [EMAIL REMOVED]
>
>
>
> ===============================================================
> = SAVE TIME *AND* MAKE MONEY! with Neutralize (**): =
> = Generate bespoke quotes for Online Marketing Services. =
> = Resellers info at http://www.neutralize.com & 01209 210 910 =
> ===============================================================
>
> **************************************************************
> *** Sponsor the forum for as little as £1 at: ***
> *** ***
> *** http://www.freelancers.net/cgi/sponsor.cgi?action=show ***
> **************************************************************
>
>
> Freelancers and Freelance Jobs:
> http://www.freelancers.net
>
> Forum FAQs:
> http://freelancers.netrickery.com
>
> To unsubscribe please email:
> [EMAIL REMOVED]
>
> If you have difficulties unsubscribing please email:
> [EMAIL REMOVED]
>