Hey there !
At my company, we’re heavily relying on Matomo to discover how users are interacting with our SaaS platform.
As we use a side software for visualization (Metabase), we would like to sync data with an outside database like MySQL or Postgres. However, when doing so, we fell on the fact that the Matomo database scheme is really blurry, with tables like blob_january_2022
, whereas we thought from the UI we could have a visit
table, a pageviews
table etc.
Does somebody know where I could find the SQL requests to build these tables back from the database ?