Re: ECommerce Customer Tracking

Well, I do not log something on every page, but I do know that MySQL will easially handly over 1000 Queries/Sec on a decent box. I cannot see a much faster way to do it. I do not experience any performance problems on www.pulseaday.com. Well, let me know how it goes. -Jason Garber IonZoft.com At 10:39 AM 10/12/2001 +0100, Girish Nath wrote:

Hi I'll take a look at that. Have you experienced any performance issues with this, it seems like it would generate quite some overhead doing inserts on every page. Thanks Girish ----- Original Message ----- From: "Jason G." <blair@nb.net> To: "Girish Nath" <girishn@btinternet.com>; <php-general@lists.php.net> Sent: Friday, October 12, 2001 9:42 AM Subject: Re: [PHP] ECommerce Customer Tracking I Have. Basically, I have a user_id available on each script (from a logged in user) that comes from session management. I have a MySQL table that has the following columns: table stat_log: stat_id - int unsigned not null auto_increment primary key user_id - int unsigned not null (indexed) action_type_id - tinyint unsigned not null (indexed) cpudate - int unsigned not null (indexed) for use with UNIX_TIMESTAMP() additional_data - varchar(127) not null you have a definition of stat types such as 1 = logged in 2 = executed search 3 = visited page 4 = ... Have a function for recording a stat: function RecordStat($nUserID, $nStatID, $sAdditionalData = '') just insert a record into the stat_log table that has the user_id, stat_id, unix_timestamp(), and if they visited a page, put the page name in additional_data, if they did a search, put the search string in the additional_data... you get the point. From this table, you can quickly determine alot about a user's actions. BTW, this table grows pretty fast, but - who cares - disk space is cheap now. Besides, your average record length will maybe be 4+4+1+? = 20 bytes or so, depending on how much additional_data you put in... mysql> select count(*) from stat_log; +----------+ | count(*) | +----------+

|    32320 |

+----------+ 1 row in set (0.02 sec) Hope it helps! -Jason Garber IonZoft.com At 09:05 AM 10/12/2001 +0100, Girish Nath wrote:

Hi As part of a shopping site project, i've been asked by my client about "customer tracking". Things like keeping a log of specific customer's actions once they've

logged

in, which pages they went to, what search keywords they used, if it

resulted

in a purchase etc. Ideally, i'd like to output all of that info in a report for their marketing/sales department to use. Has anyone implemented/experience of this ? Any ideas are welcome :) Thanks Girish -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net For additional commands, e-mail: php-general-help@lists.php.net To contact the list administrators, e-mail: php-list-admin@lists.php.net

-- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net For additional commands, e-mail: php-general-help@lists.php.net To contact the list administrators, e-mail: php-list-admin@lists.php.net -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net For additional commands, e-mail: php-general-help@lists.php.net To contact the list administrators, e-mail: php-list-admin@lists.php.net