It is possible to keep all the websites information (names, defined goals, etc.) and only delete the stored analytics data. There is not currently a tool available to delete all data automatically, but you can manually delete all data for a specific website directly within the database server.

Connect to your Mysql database storing your Piwik data with your favorite database client (for example phpMyadmin) and do the following:

  • Remove completely the tables with a name starting with piwik_archive_

    DROP TABLE piwik_archive_numeric_2011_01, piwik_archive_numeric_XX;

They will automatically be re-created from the Visitor logs when Piwik processes your reports.

  • Execute the following query:

    DELETE FROM piwik_log_visit WHERE idsite = X;
    DELETE FROM piwik_log_link_visit_action WHERE idsite = X; 
    DELETE FROM piwik_log_conversion WHERE idsite = X; 
    DELETE FROM piwik_log_conversion_item WHERE idsite = X;

with X replaced by the website ID you wish to reset.

The alternative solution is to use the Delete old reports and Delete old tracking data features, click to see the FAQ.