Hello everybody,
I'm writing a banner rotation script. I wish to have a simple statistics feature in it.
It will not be doing much. It will just count the number of times each banner has been displayed. Also, i'd like to present the data datewise.
That is, if i choose, "Today", i'd like to see how many times each of the banners has been shown on that day. If i choose "Last Month", i'd like the corresponding data to be showed.
Since, i've not worked with stats, i'd need the advice on someone in how to structure the database.
What i planned is : For every time the banner is displayed, a new record would be created in a table along with the timestamp and the banner's ID. Then, i'll use this data to display data the way i wanted. But, is this the best way to do it ?
Or, are there better ways ?
Please help me
Thanks,