Usage statistics and reports

[hardymeg]

Hey - I want to know which of our Metabase reports are being used and how often. I have read on some other threads that this data is in the Metabase database. But how do you connect to the Metabase database itself to view usage statistics? Thank you!

[AndrewMBaines]

Metabase Metadata SQL

Metabase is lacking in some of the management information I’d like to see. Hopefully the queries below will help a few others build up a management dashboard too. In summary: List of Dashboards List of Questions List of Questions in each Dashboard List of Questions not in any Dashboard List of Users LIst of Users who have never logged in List of Dashboards viewed by each user and count of views Pretty much anything else you can dream up /* All dashboards */ SELECT rd.id, rd.name, rd.descript…

[hardymeg]

Hey thanks Andrew! This is super useful Please can you share how to connect to the Metabase database so I can run these scripts?

[AndrewMBaines]

Depends upon the database you’re using. If you’re still on the default H2, you need to change to MySQL or Postgress as it’s single user.
Go through the documentation for how to migrate.