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

date posted 28th January 2002 14:45

Hi Paul,

Sounds easy enough. Few things to consider; you cannot use Javascript to
talk to the database you'll need to use a db language like ASP, Perl, PHP or
DSql.

As for database structure, off the top of my head I would go for about 4
tables:

SESSION
=============================
ID|DNSID|START DATE/TIME|END DATE/TIME|OSID|MONITORID|BROWSERID|PAGE

DNS
==================
DNSID|Customer Account#|DNSName

OS
============
OSID|OSName

MONITOR
===========
MONITORID|MonitorName

I'd have the DNS table because even though if your customer has three
domains they may want to see stats for them all combined or individually,
this schema would allow you to do both.

The session table will get very large very quickly so you may want to
consider whether exact pages are necessary to be stored or if a particular
subset of pages would be sufficient.

If it is straightforward I would have said around £750 - £1,500.

All said and done though is there no way you can use the application server
log files instead? They should contain all of this information already...

Good luck
Michelle


-----Original Message-----
From: [EMAIL REMOVED]
[EMAIL REMOVED] Behalf Of Paul Fisher
Sent: 28 January 2002 10:14
To: [EMAIL REMOVED]
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]