Delete wrong Visits after import



I’ve used the Google Analytics Import to move data to Piwik. Unfortunately I run the script twice for a number of days. My idea was to delete the data (I deleted the entries from piwik_archive_blob_2011_XX, piwik_archive_numeric_2011_XX and piwik_log_link_visit_action for this siteid and date range) and rerun the script. After I deleted the rows, the UI view was empty as expected, but after the import run again, the number of visitors was “added” to the old values. How could I delete “all” data for these days?

Thank you very much, Micha

(Matthieu Aubry) #2

Delete all data from piwik_log_* tables


Hi matt,

how can I delete data from piwik_log_action and piwik_log_visit only for one site / a specific time range?

Thank you, Micha


I have deleted all data from piwik_log_visit with visit_first_action_time and visit_last_action_time in this range and seems to work. I leave piwik_log_action untouched, so maybe I’ll have some “wrong” entries but as i reimported the same period again i think there should be no ones.