@AlJE87 opened this Issue on February 21st 2019

I have this query :

select_ date(server_time) as _Date, count(distinct(idvisit)) as unique_pageviews_Page  
from  matomo_log_link_visit_action 
where idaction_url = (select idaction from matomo_log_action where name = 'Page')
and server_time between '2019-02-11' and '2019-02-20'
group by _Date;

and I am getting theses results:

+------------+-------------------------+
| _Date      | unique_pageviews_Page |
+------------+-------------------------+
| 2019-02-11 |                   21725 |
| 2019-02-12 |                   19410 |
| 2019-02-13 |                   16708 |
| 2019-02-14 |                   20465 |
| 2019-02-15 |                   20563 |
| 2019-02-16 |                   24996 |
| 2019-02-17 |                   19678 |
| 2019-02-18 |                   23404 |
| 2019-02-19 |                   21228 |
+------------+-------------------------+

While Matomo's report is giving the following :

Date       | Label | Unique Pageviews
2019-02-11 | label | 30724
2019-02-12 | label | 29071
2019-02-13 | label | 25824
2019-02-14 | label | 29173
2019-02-15 | label | 29688
2019-02-16 | label | 34864
2019-02-17 | label | 29452
2019-02-18 | label | 33334

Can you please give me an explanation?

Powered by GitHub Issue Mirror