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

(AJ) #1

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,


(Fabian Dellwing) #2

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.

(AJ) #3

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…