Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Query results consistency between matomo's reports and query made on matomo's mysql raw data #14122

Closed
AlJE87 opened this issue Feb 21, 2019 · 1 comment
Closed

Query results consistency between matomo's reports and query made on matomo's mysql raw data #14122

AlJE87 opened this issue Feb 21, 2019 · 1 comment
Labels
answered For when a question was asked and we referred to forum or answered it.

Comments

@AlJE87
Copy link

AlJE87 commented Feb 21, 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?
@mattab
Copy link
Member

mattab commented Jan 21, 2020

Thanks for reaching out. Unfortunately we cannot provide support to this particular issue by email, however can you please ask in our forums here: https://forum.matomo.org/ - Someone might be able to assist you there.

@mattab mattab closed this as completed Jan 21, 2020
@mattab mattab added the answered For when a question was asked and we referred to forum or answered it. label Jan 21, 2020
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
answered For when a question was asked and we referred to forum or answered it.
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
2 participants
@mattab @AlJE87