Hi

My current assignment is to develop a tracking system which would
later be integrated into an affiliate system. We would also need to
track the country of origin.

I would currently like to get your thoughts on the database design. A
sample to what I need would be Google Analytics (www.google.com/
analytics)

Thanks
Pankaj

"Pankaj" <panahuja [at] gmail.com> wrote in message
news:1176114545.400148.312500 [at] b75g2000hsg.googlegroups.com.. .
| Hi
|
| My current assignment is to develop a tracking system which would
| later be integrated into an affiliate system. We would also need to
| track the country of origin.
|
| I would currently like to get your thoughts on the database design. A
| sample to what I need would be Google Analytics (www.google.com/
| analytics)
|
| Thanks
| Pankaj
|

what, exactly, are you tracking...the only requirement you've stated is
'country of origin'. no karnacks here.

I am tracking IP Address, Browser, OS, Start Time of Access, End time
of Access, Referred By. I wish to track all the pages that the user
has visited and if possible the exit page. I want to use Pixel
Tracking.

Thanks

On Apr 9, 6:13 pm, "Steve" <no.... [at] example.com> wrote:
> "Pankaj" <panah... [at] gmail.com> wrote in message
>
> news:1176114545.400148.312500 [at] b75g2000hsg.googlegroups.com.. .
> | Hi
> |
> | My current assignment is to develop a tracking system which would
> | later be integrated into an affiliate system. We would also need to
> | track the country of origin.
> |
> | I would currently like to get your thoughts on the database design. A
> | sample to what I need would be Google Analytics (www.google.com/
> | analytics)
> |
> | Thanks
> | Pankaj
> |
>
> what, exactly, are you tracking...the only requirement you've stated is
> 'country of origin'. no karnacks here.

there's no need to pixel track. the manual also has plenty of examples of
collecting all the information you require. since it does, i'm not going to
waste my time when you should be spending yours rtfm.

sorry if that's too abrupt for you.


"Pankaj" <panahuja [at] gmail.com> wrote in message
news:1176187022.781015.215300 [at] e65g2000hsc.googlegroups.com.. .
|I am tracking IP Address, Browser, OS, Start Time of Access, End time
| of Access, Referred By. I wish to track all the pages that the user
| has visited and if possible the exit page. I want to use Pixel
| Tracking.
|
| Thanks
|
| On Apr 9, 6:13 pm, "Steve" <no.... [at] example.com> wrote:
| > "Pankaj" <panah... [at] gmail.com> wrote in message
| >
| > news:1176114545.400148.312500 [at] b75g2000hsg.googlegroups.com.. .
| > | Hi
| > |
| > | My current assignment is to develop a tracking system which would
| > | later be integrated into an affiliate system. We would also need to
| > | track the country of origin.
| > |
| > | I would currently like to get your thoughts on the database design. A
| > | sample to what I need would be Google Analytics (www.google.com/
| > | analytics)
| > |
| > | Thanks
| > | Pankaj
| > |
| >
| > what, exactly, are you tracking...the only requirement you've stated is
| > 'country of origin'. no karnacks here.
|
|

On Apr 10, 7:05 pm, "Steve" <no.... [at] example.com> wrote:
> there's no need to pixel track. the manual also has plenty of examples of
> collecting all the information you require. since it does, i'm not going to
> waste my time when you should be spending yours rtfm.
>
> sorry if that's too abrupt for you.
>


I am not asking how to track. I was just seeking suggestions on what
should be the DB design. Thanks any ways

"Pankaj" <panahuja [at] gmail.com> wrote in message
news:1176365650.734375.285210 [at] o5g2000hsb.googlegroups.com...
| On Apr 10, 7:05 pm, "Steve" <no.... [at] example.com> wrote:
| > there's no need to pixel track. the manual also has plenty of examples
of
| > collecting all the information you require. since it does, i'm not going
to
| > waste my time when you should be spending yours rtfm.
| >
| > sorry if that's too abrupt for you.
| >
|
|
| I am not asking how to track. I was just seeking suggestions on what
| should be the DB design. Thanks any ways

what's the big deal? make a table having the columns for the data you want
to collect. hell, put an index on it if you want to get fancy and optimize
it. without any more specifics than what you've stated, that's the best
answer you'll get.