How to get the first visit time of a unique visitor?

Support & Bugs
#1

I use matomo on-premise, And recently I found a problem. There are some visitor that do not have their first visit data in table matomo_log_vist. all of their visit data show that visitor_returning = 1.
I want to know what’s the reason,and how to fix it?
Here is the example:

image
image2504×1000 205 KB

#2

Hi @wenjuan_xie
Didn’t you delete some hits, thanks to GDPR tool or with raw log auto cleaning?

GDPR tool

Raw log auto cleaning

#3

Hi @heurteph-ei
I confirm that I have not deleted any historical Matomo data and didn’t make any change with GDPR tool.
Are there any other possible reasons for this result?

#4

Can you check if the visitor has a user ID, and if so, can you check this user ID is not associated with another visitor?
On your last request screenshot, can you include also the visitor_count_visit column?

#5

I never set User ID, just use visitorid

image
image1920×757 64.7 KB

#6

Very strange indeed: the first visit of 00074ebec9063ee1 doesn’t appear…
It has been deleted, and I don’t see other reason than:

  • Manual deletion in the DB
  • Manual deletion through GDPR tool
  • Manual / auto deletion via Matomo DB cleaning
#7

Here are the settings of my matomo.

image
image2584×1288 271 KB

#8

image
image2720×1490 241 KB

is there other settings that will lead to data deletion?