Visit_count_visits not starting at 1

Support & Bugs
1

Hi,

In our matomo 4.15 database, we have visitors for which first visit does not exist.

The following query yields results :

select 
	idsite,
	idvisitor,
    min(visitor_count_visits)
from
	matomo_log_visit
group by
	idsite, idvisitor
having 
	min(visitor_count_visits)>1

Does anybody have the same behaviour or is it a problem with confiig/install of our instance ?

This is preventing us from easily identifying the “first click” of visitors.

2

Hi @fredleroy
Do you still have all raw data from the beginning of the tracking? Maybe some raw data have been deleted:

3

Hi, yes we started using matomo not so long ago, we still have all data since begining

4

Hi @fredleroy
Do you track the user ID?

5

No we don’t, we don’t need them for our analysis and think it is better for privacy

6

Hi @fredleroy
I am sorry, the only reason I see is the deletion of data thanks to the old raw data deletion task.
Maybe @innocraft could see another reason?