Need to understand about the uniqueness of idvisitor column in the database.
By running the below query, against one idvisitor, multiple devices can be seen in some scenarios, sometimes on the same date. What is the logic behind this? As it is my understanding that one device/person will have a unique idvisitor value
select idvisitor,
count(distinct(config_device_model))
from matomo_log_visit mlv
group by idvisitor
having count(distinct(config_device_model))>1
Do you use cookie?
Maybe with shared “browser desktop” (I know Firefox allow such behavior) the cookie may be shared across several devices? (I know that password manager can be shared, but no idea on the cookies…)