Sweet! I was storing the full URL mainly because that's how web servers
generally do it and I was copying them.
But... you're totally right, I'm going to separate out the the
fuseaction, the path_info, and the variables. It'll make for far less
parsing during report time.
This is going to be wicked. Let me get a good version of this and I'll
post it to the fusebox.org site as long as people help me improve on
it.
deal?
Steve
Dan Haley wrote:
>
> What you will need to add also is the ability to add "actions" that can be
> captured. If you are using any type of state maintenance, be it session
> variables or roll-your-own database solutions, your URL may never hold all
> of the information needed to determine what the user is really doing. Our
> version of this that we are designing right now has the "page hit"
> functionality to it to review clickstream, browser, operating system,
> referers, etc., but will also have "actions" that the user takes. These are
> what we are really looking for . . . and we don't want to have to look
> through their clickstream to see if they did it. An example is a
> configurator . . . with "actions" you can grab how many people started the
> configurator and how many people actually finished a configuration. If the
> ratio isn't high enough, then start reviewing the clickstream.
>
> Great idea Steve . . . it's nice to have someone like yourself validate that
> we aren't on a lonely path!
>
> Dan
>
> -----Original Message-----
> From: Steve Nelson [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, August 30, 2000 8:01 AM
> To: [EMAIL PROTECTED]
> Subject: Re: CF based web stats
>
> I'm pretty sure, you still wouldn't have to wait....
>
> Every hit is thrown into an application query, that application query is
> dumped to a file, which is then bulk inserted into the database every X
> minutes. Then to view the stats for that page it's just a matter of
> running the appropriate query.
>
> Sure, it may be a little slow for that many hits, but that all depends
> on the database you're using. I'd be very interested to see how well it
> does work for this many hits.... i honestly have no idea.
>
> btw, I built it so you could drill down to view stats, it starts out by
> listing hits/month, then you choose a month, it shows hits per/day in
> that month, then you click a day and it shows hits/hour in that day.
>
> Steve
>
> Chris Chambers wrote:
> >
> > hehe you won't have to wait for hours to run the report until you start
> > getting 1M+ hits a day...
> >
> > __________________________________________
> >
> > Chris Chambers
> >
> > ICQ: 40311211
> > MSN: webdood
> > AIM: CTC HOME
> >
> > Vox: 757-896-6393
> > Fax: 757-896-0774
> > __________________________________________
> >
> > -----Original Message-----
> > From: Steve Nelson [mailto:[EMAIL PROTECTED]]
> > Sent: Wednesday, August 30, 2000 9:41 AM
> > To: [EMAIL PROTECTED]
> > Subject: Re: CF based web stats
> >
> > i've started experimenting with bypassing webserver logs and just
> > logging every hit myself into the database. By doing this I can see a
> > dynamic log reports on every page (for properly secured people). So, no
> > more waiting for hours for a log report tool to give you crappy reports.
> >
> > But the truly cool thing is that instead of running reports based on IP
> > address, I can run reports based on the #client.user_id# or
> > #client.cfid#/#client.cftoken# So it's designed to give incredibly
> > powerful reports.
> >
> > It's still in the very beginning stages, i've only put about 3-4 hours
> > into it, if any of you that are coming to conference want a
> > demonstration, let me know.
> >
> > I demonstrated this to my dad and he said: "Is there a billion dollar
> > company that does this same thing?" haha
> >
> > Steve
> >
> > Todd Hartle wrote:
> > >
> > > Any know of a CF based web server log analyzer?
> > >
> _________________________________________________________________________
> > > Get Your Private, Free E-mail from MSN Hotmail at
> http://www.hotmail.com.
> > >
> > > Share information about yourself, create your own public profile at
> > > http://profiles.msn.com.
> > >
> > >
> --------------------------------------------------------------------------
> > ----
> > > To Unsubscribe visit
> > http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/fusebox or
> > send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> > the body.
> >
> ----------------------------------------------------------------------------
> > --
> > To Unsubscribe visit
> > http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/fusebox or
> > send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> > the body.
> >
> >
> ----------------------------------------------------------------------------
> --
> > To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/fusebox or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.
> ----------------------------------------------------------------------------
> --
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/fusebox or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.
> ------------------------------------------------------------------------------
> To Unsubscribe visit
>http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/fusebox or send a
>message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
------------------------------------------------------------------------------
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/fusebox or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
