Double records due to unneeded replay log import. How to repair?

Dear all,

After migration we did an ‘ --replay-tracking’ on the running site on the period we thought Matomo missed, but after running ‘console core:archive’ it was clear this was unneeded and now we have double the real number of visitors for that period.

How can we repair this? does not seem to have a ‘remove’ option…
Btw. I am not afraid of running sql queries if needed…

Much obliged,


The only thing coming to my mind right now is to use How do I delete old visitors statistics for a given website and/or date? - Analytics Platform - Matomo to completely remove all data from the given period and afterwards reimport it via replay.

Afterwards you would need to reprocess the reports that had the wrong data.

Thanks for the tip :slight_smile:
For consistence in quality of the tracking, I would prefer to just delete the imported log data if I could select it in a reliable way (not familiar with the database). It is several days of logging…