I’m looking into an issue which seems to have been occurring for a while. Partly due to our website links not following a convention.
However how can I amend all previous logs to ensure they are all the same? Is there any tables which I could look at and replace the URLs manually to lower case?
My understanding is the old logs are archived and the URL is stored in the ‘value’ column of the matomo_archive_blob_2022_05 table for example? I don’t think I can change this easily, is there any query which to force all the previous URLS to lower?
Thanks in advance,