Managing Site Visits In Database

[eluser]Jay Logan[/eluser]
There is no telling how far we may need to go back. The thing is, we have a big network of web sites that act as lead farms in different markets. And when a customer fills out a form it creates a record for that customer that joins to all of their records in the PAGE HITS table which tells us what pages the user has visited and when. I've recently noticed customers who have filled out forms in 2007 and then again this year. So if we had PAGE HIT data from 2007, it would be nice to show it. And sometimes, it's fun to query how much traffic we've gotten the past month or for the whole year.

Right now, as you probably can tell, the system is pretty custom. So releasing it in the WiKi would take some downsizing. I'm thinking about releasing the entire lead farm CMS though. It's more of a Franchise management system.