Hello!
What I need to do if I want to cleanup my database but keep the following:
1.) Totals of unique visitors without pageviews for past years (e.g. 2006 = 1000) and without any statistics for every month or every day in 2006 - just pure yearly data.
2.) Totals of unique visitors without pageviews for present year (e.g. 2007 = 750), with statistics for every month in 2007 (unique visitors without pageviews, e.g. Jan = 10, Feb = 15, etc.), but without daily statistics for the past months except only this one (e.g. Nov > 1 = 2; 2 = 4; etc.).
Many thanks in advance.
What I need to do if I want to cleanup my database but keep the following:
1.) Totals of unique visitors without pageviews for past years (e.g. 2006 = 1000) and without any statistics for every month or every day in 2006 - just pure yearly data.
2.) Totals of unique visitors without pageviews for present year (e.g. 2007 = 750), with statistics for every month in 2007 (unique visitors without pageviews, e.g. Jan = 10, Feb = 15, etc.), but without daily statistics for the past months except only this one (e.g. Nov > 1 = 2; 2 = 4; etc.).
Many thanks in advance.
SiteStats - How to cleanup tables?