Hi,
I get surprizing results from the following query in our Matomo 4.15 database :
select
idsite,
idvisit,
count(distinct idvisitor)
from
matomo_log_conversion
group by
idsite, idvisit
having
count(distinct idvisitor)>1;
It appears that there can be more than one idvisitor in conversions for a given visit !?
This prevents us from easily counting unique visitors for a given goal (without joining the visit table).
Are we the only ones experiencing this behaviour ?
We have similar issue on the link_visit_action table, thus preventing counting unique visitors on an event (unless we join the visit table again)