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.

Hi katakombe,

Sorry - haven't been reading the forum for a while so didn't see this.

The first thing is that you can clean up SSSite easily without losing this data - just use the cleanup feature in the plugin and click on the button 'Delete old data from SSSite'. This data is not used in the plugin and you can set this up to clean up every day if you click on 'Edit' next to the plugin name in the plugin manager. Just set Clear Daily to 'Yes'.

In the SSSiteMonthly table the pageviews and unique users are kept in the same row so there is no advantage to removing one and not the other.

Hope that is clear.

Laura.
The UK High Street

Hello Laura!

Many thanks