Thanks for the replies everyone. All good suggestions! <!----------------//------ andy matthews web developer ICGLink, Inc. [EMAIL PROTECTED] 615.370.1530 x737 --------------//--------->
-----Original Message----- From: Andy Matthews [mailto:[EMAIL PROTECTED] Sent: Monday, March 20, 2006 11:07 AM To: CF-Talk Subject: Stats tracking logic question I'm building a site for a real-estate company and they'd like to track several aspects of an individual listing as follows: - Each time a listing is displayed in a search - Each time an actual listing page is viewed - Each time someone clicks the "view map" button - Each time someone clicks the "print page" button - Each time someone clicks the realtor website link - Each time someone clicks the "listen to voice-over" button My first inclination would be to store each of these as columns in the listings table. This would def make it easy to keep track of the totals. Then I started wondering if it might be best to create a new table strictly for tracking these stats. Each time someone does one of those things, it gets it's own row in the db. The second would be more cumbersome but gives me more options as then I could record the date as well for each individual click. What might some of you suggest? <!----------------//------ andy matthews web developer ICGLink, Inc. [EMAIL PROTECTED] 615.370.1530 x737 --------------//---------> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:235801 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
