detailed statistics on how many times buyers visit one product page?

searain

To do the marketing statisticis, I need to know the detailed statistics about how many times a product was visited daily, weekly, monthly ...?

If it is a static html page such as

http://www.myshop.com/products/product1.php, http://www.myshop.com/products/product2.php

...

etc. The current statistics tools can do the job.

But if the product page is created from the database such as

http://www.myshop.com/products/product.php?id=1
http://www.myshop.com/products/product.php?id=2

...

Then what is the best way to handle it, are there any scripts available.

I am thinking about every time people visit http://www.myshop.com/products/product.php?id=###

I will grab the id and save this visit as a record in a database with date information etc. Later on, I will create statistics report from the visit records I save.

But it will be too huge, say if in one year, there might be 100,000 times visit of the products in total.

It is still a good idea to use the database table to handle it? The statistics tools handle the static html page visiting records in text logs. That will be even better or less efficiency comparing with my database approach?

I am familiar in using database than in the text logs.

Thanks!

sarahk

http://webanalyse.sourceforge.net/

I use webanalyse to do most of what you need. It stores the files in text files. Some of the stats would need reworking at year end. I've just posted a mod at http://property.digitalrice.com/tutorial/ to collect the first passed variable in the stats.

I wouldn't worry about a database handling 100,000 records. Should be able to do that easily. Simpler for running custom queries too. I'd go with a database if you can.

dustbuster

Maybe...

For your database make a table

product_stats

product_id
date
viewcount

On the product.php page make a function to do
1) Update the product_stats table
a) if no entry for that date for that product exists add one
b) else update with the product_id, the date, and viewcount++

Weekly/Monthly/Yearly are just date functions from there.
If you wanted you could get really detailed using the NOW() function which would create a new record in the database so it would be:

product_stats

product_id
time

HTH