tables

I've installed the software and testing.

but there isn't
gstats_ads_click

in db install

I'm asking how big will be the mysql database, if it tracks every click.

But it's an interesting solution.
Perhaps you can filter clicks only on adsense clicks, that's the most interesting feature for me.

Great job and good work.
Spataro

Sorry. I've forgotten.

Here is the SQL code, I will include in 4 hours or more in the code.

CREATE TABLE `gstats_ads_click` (
`userId` int(11) NOT NULL,
`visitor` int(11) NOT NULL,
`page` varchar(250) NOT NULL,
`ads` varchar(50) NOT NULL,
`size` varchar(10) NOT NULL,
`dtime` datetime NOT NULL
);

If you track every click the DB is not so big, I implement two days ago into my blog. My blog recieve 500 unique visitors and 700 hits and it has 100kb per day. Not so much, and it brings useful information like Where users go (out links) and from where they come.

And you can modify the class and comment the insert to every click.

I will start tomorrow to offer a new useful way to do more personalized way to track what you want.

Thanks for download my class.

I've installed the missing table, and now is again on line for testing.

I have 50.000 pages a day, but i've installed just in one of my sites. I'll tell you my stats.

At the moment the only litte bug I verify is some errors of duplicate entries in the mysql log.

Did you verify if it is ok with adsense rules ?

Spataro

That is not an error, that is duplicated when the same user open the same page, so the DB ignore the entry

That is not a bug.

Hi Cesar,

Do you have a utility to view the stats on nicely formatted page?

That would be great.

-Thanks,
Bablooji

Not yet! And that is a good idea, i usually see my stats in a mysqlclient prompt, but that is not so nice, I will build one and share.

And if anyone can do, that will be cool too ;-)

hi,

i suggest that you correct the very first line of the file "db_install.sql".
it says: "DROP TABLE IF EXISTS `gstats_out_clicks`;"
while it should be: "DROP TABLE IF EXISTS `gstats_ads_click`;"

no offense dude! :)