I’m trying to analyse my company’s Looker usage (~100 people), and the History explore has had a treasure trove of information. We don’t have an intense data-culture, so I’m just actually trying to find the few super-users, so I can reach out to them. In the meantime, I don’t expect very high usage-counts.
So when I see the “Query Run Count” hitting tens of thousands in the timespan of a few weeks, I’m kind of confused.
How is this measure counted?
Also, some people have query-counts at ridiculous hours of the day (e.g. 3am) that I imagine some automated processes are going on that are incrementing these counters?
No one uses embedded content though, or anything like that. Our Looker usage is pretty limited to making a couple dashboards, and maybe 4 or 5 people have scheduled some stuff.
Hey @Jamie_Friday, I had the same question and just got a few answers from the DCL that I think might be helpful for you!
The “Query Run Count” measure is aligned with description #3 - if someone opens a dashboard with multiple tiles, it increments for each tile that automatically loads. So a dashboard with 20 tiles on it would increment by 20 - or in the words of @kevin_dunn “a dashboard with 1 tile could be run 10x more than a dashboard with 20 tiles, but the dashboard with 20 would appear more popular.” Not super helpful when you just want to know how often someone is opening the dashboard.
A great workaround that Kevin gave me was to create a custom measure on the history explore based on the “Dashboard Session” dimension. Make it a “Count Distinct” and boom, you’ve got a count of each dashboard run.
For context - “A 'dashboard session' is one run of a dashboard. Every time a user opens a dash that runs automatically, that's one dashboard session. If they hit the run button, that's another. So what we can do is create a custom measure that's a count distinct of the dashboard session field, and each count will essentially be one dashboard run.”
There is supposed to be a new field in version 21 for the dashboard run count, but until then you can use this custom field workaround and get what you are looking for.
@bullsean great to hear, thanks for the tip :). I did not know that “Dashboard Session” dimension existed.
On my other points, I had actually reached out to Looker support directly; apologies for not having updated this post earlier.
Better late than never, for others in the future.
Regarding Query Run Count:
Is_Single_Query
flag to “Yes”. (Alternatively, you can filter exclusively for merged queries by setting that flag to “No”.)Results from cache
and Results from database
.Also, regarding Approximate Web Usage in Minutes (which is also related to user-usage):