I have 38.000+ records from visits with 1600x1600px resolution which I expect are spam visits. Can I simply delete these records and will history be updated automatically? If not, what is the best way to approach this issue?
I would not delete all 38,000 records based only on the 1600×1600 resolution. First confirm they’re spam by checking IPs, user agents, referrers and visit patterns.
If they are confirmed spam, delete/exclude them and then check whether your analytics system automatically recalculates historical reports. The exact process depends on the software you’re using.
Hello @vespino Could you please let me know how are you deleting the data every hour? I’m a bit worried that legit data are being deleted too. if you can share some screenshot, on you are deleting it, that would be great.
I wouldn’t delete the records directly from the database. First confirm they’re actually spam, then use Matomo’s built-in privacy/GDPR tools to remove the affected visits. Matomo should update the related reports after deletion.
I delete all rows from the matomo_log_visit table where config_resolution matches square resolutions (1600x1600 most of the time) and afterwards I delete the rows from the matomo_log_link_visit_action table where idvisit not in SELECT idvisit FROM matomo_log_visit.