How to check the user view count of questions?

[kim]

Hi, I know we can track the user view count of dashboards by writing SQL, now I wonder is there any way we can track the user view count of questions. We need to know which question is popular rather than the dashboard.

Hope someone could introduce a method , thanks.

[flamber]

Hi @kim
That is builtin to the Audit functionality in the Pro/Enterprise edition.
https://www.metabase.com/docs/latest/enterprise-guide/audit.html
But otherwise you'll need to look in the query_execution table - see more examples here: Metabase Metadata SQL

[kim]

Hi@flamber,

thanks for your quick reply.

Now I am using free open source, I checked the Metabase Metadata SQL , but did not find the query could fit the requirement, could you kindly share with me the query?
Thanks a lot!

[flamber]

@kim Did you look in the comments? Which query are you using to see the dashboard activity?

[kim]

yes, I use /* which dashboards has a user viewed */ this query to see the dashboard activity, and I also want to see the question activity, but I could not find suitable query.

[flamber]

@kim Did you try this?

Metabase Metadata SQL

Most viewed questions in the last 3 months /* Most viewed questions in the last 3 months */ SELECT rc.name AS CardName , COUNT(vl.user_id) AS viewCount , rc.description AS CardDescription FROM view_log vl INNER JOIN report_card rc ON rc.id = vl.model_id WHERE vl.model='card' -- last 3 months AND str_to_date(concat(date_format(vl.timestamp, '%Y-%m'), '-01'), '%Y-%m-%d') BETWEEN str_to_date(concat(date_format(date_add(now(6), INTERVAL -3 month), '%Y-%m'), '-01'), '%Y-%m-%d') AND str_to…

[kim]

Thanks, flamber, this is exactly what I am looking for!

[gchev]

@flamber
Is there a way to access Metabase Metadata why on Cloud but not pro/Enterprise edition ?

[flamber]

@gchev No: https://www.metabase.com/cloud/docs/limitations#no-access-to-application-database