No. of outlinks are different between database and UI


#1

I inner join the table piwik_log_link_visit_action and piwik_log_action with type =2.
However some outlinks appeared in the database record but not shown in the UI.
I have already expanded the no. of rows thus the entries are not in the “Others” row.

I have also checked the IP are not in my configured excluded list. Not sure did Piwik has a IP excluded list by default.
Just want to know why those database entries with type=2 are not counted.

Any suggestions are appreciated.
Thanks.


(Matthieu Aubry) #2

Hi there,

So you do not see any “Others” row, and are you also looking for the whole date range?

See FAQ: After the top 500 or top 1000 rows, Piwik automatically groups pages, keywords, websites, etc. under the label "Others"; How do I force Piwik to not limit the data? - Analytics Platform - Matomo

Technically you see all records since if the IP was excluded it wouldn’t be recorded in the database at all.


#3

Hi Matt,

The data shown in the UI is missing the record I found in the database.
I have expanded the page to show all the records.

The database query I used is simply inner join the table piwik_log_link_visit_action and piwik_log_action with type =2.

Thanks.