How can I get the exact pageviews when execute sql query? #10299
Labels
answered
For when a question was asked and we referred to forum or answered it.
Comments
|
have you seen our Mysql guide: http://developer.piwik.org/guides/persistence-and-the-mysql-backend For example this page lists all the action types which is maybe what you need: http://developer.piwik.org/guides/persistence-and-the-mysql-backend#action-types please note we recommend to use the Reporting APIs instead of direct SQL access: http://developer.piwik.org/api-reference/reporting-api If you have further Piwik DB SQL queries feel free to ask in our forums: http://forum.piwik.org/ |
mattab
added
the
answered
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Piwik is a great app, wo do like it.
According to the
API Response: Metric Definitionsnb_actions - Number of actions (page views, outlinks and downloads)And I execute query like below on table
piwik_log_visitselect sum(visit_total_actions) from piwik_log_visit where idsite=5 and date_add(visit_last_action_time, interval 8 hour)>="2016-07-01 00:00:00" and date_add(visit_last_action_time, interval 8 hour)<"2016-07-02 00:00:00"But the query result
1236greater than1219which showed on the dashboard.Because
visit_total_actionscontains pageviews, downloads and outlinks, so how can I get the exact pageviews when execute sql query.The text was updated successfully, but these errors were encountered: