W’ve been migrating a large e-commerce site from Piwik to GA using the google2piwik.py script. I know its no longer supported as of a few weeks ago but there is currently no other tool and the business requires this historical data. We’re importing 5 years of data and so far we’ve had many issues with the script hanging on days with a high spike in traffic (i.e. 500k visits) and other general bugs however we’re slowly progressing by importing the data one month at a time and then verifying everything.
However our most recent import for Dec-2012 has the number of visits doubled in Piwik. We’re not sure how that happened but we need to delete the data from the database and re-import it. We’ve looked at the tables but are not sure exactly how to delete this data. Can anyone give us a sql statement to delete a specific month’s data?