I’m currently playing around a bit with Matomo and like the option to delete a User with the provided GDPR-Tools.
Anyhow, I realized that this deletion will remove the visit / user by VISITID or User ID but any Conversion or Goal is not affected in Matomo UI.
Following questions appeared:
Once I delete a user via GDPR-Tool can anyone confirm this user and all attributed actions / data is deleted from the RAW-Database tables?
Do I have to reprocess all Matomo Reports with historical data if I would like to remove the user data and interactions also from the Matomo UI?
I think so because I can’t find the User but I still see related Goals.
If I delete my raw data regularly. How can I adjust (if required) the aggregated data?
As I guess this will still show what the Matomo UI has processed by the date the data was first recorded.
As my SQL-Knowledge is a bit rusty (I had some experience a few years ago when I was on University)
Is there a option to delete any raw data fro a certain userid / visitorid via SQL-Query?
If so some pseudo-code would be great.