Change "days since last ..." dimensions to save second duration instead of days and compute in PHP #14094
Labels
c: Platform
For Matomo platform changes that aren't impacting any of our APIs but improve the core itself.
Milestone
Saving days means cutting off the time of day, which makes the information less accurate. This prevents using, eg, visitor_days_since_first to find the exact time of a visitor's first visit.
Changing this would mean updating every row in the log table so we should likely do it in Matomo 4.
When changing this we can also get rid of the
_idts
query parameter in the tracker. It is possible to compute this in PHP without ever having to issue a SQL query.After we search for an existing visitor we would:
This would allow computing this value for every type of tracking.
Refs #14125
The text was updated successfully, but these errors were encountered: