SQL Query on Matomo Database to Calculate the Number of Visits to Each Page

Useful WebsitesI’ve been using for just short of four years now and have been pretty happy with it.

I generally consume the data it holds via the eweb portal, but I was wanting to extract some data to manipulate recently, in a way that the web portal didn’t allow, so I did a little poking around the database to work out the syntax needed to query the database directly in mySQL.

The below query returns all…

Continue Reading Ian Grieve’s Article on their blog

SQL Query on Matomo Database to Calculate the Number of Visits to Each Page

I’ve been using for just short of four years now and have been pretty happy with it. I generally consume the data it holds via the eweb portal, but I was wanting to extract some data to manipulat‎…

Blog Syndicated with Ian Grieve’s Permission

Author: Ian Grieve

Share This Post On
Share via
Copy link
Powered by Social Snap