PHP/MySQL – track impressions and click through rate for products?

Question by Fortune P: PHP/MySQL – track impressions and click through rate for products?
Hi,

I run a book selling website and have around 1000 books listed in the database. I want to display certain “books special offers” in boxes around the website but I want to be able to track the impressions and clicks for each book displayed, as would happen on google adwords. An example would be a box with 5 book offers, which would rotate based on certain criteria in the PHP script. I would want to be able to view the impressions and click through rate. This dynamic offer box would be on several pages.

Best answer:

Answer by r_ranjith
The php code for “Special Offers” box should have a counter variable which increment the number of impressions in the database. If you want to make it more sophisticated that you want to track unique visitors, then you may have to set a cookie in the users browser and increment the impressions only if the cookie is has already expired.

What do you think? Answer below!