Looker Usage Data
Looker Usage in Euno
Euno tracks usage activity across dashboards, looks, explores, views, tiles, and even individual fields. This rich usage history enables teams to make informed decisions about what is actively used, what may be deprecated, and how resources are accessed across the organization.
Utilize Looker Usage Data To:
Identify underused resources to clean up dashboards, looks, or models that are no longer actively referenced.
Highlight heavily used content to prioritize optimization, refactoring, or access reviews.
Understand adoption and ownership by analyzing who queries what, from where, and how frequently.
Understanding the Types of Usage Data Captured in Euno
Euno collects and organizes Looker usage data into a few distinct signals, drawing from Looker’s System Activity API and enhancing it for deeper insights:
1. Query History
For all Looker resources—including views, explores, looks, tiles, dashboards, and fields—Euno tracks:
Total Queries: The number of queries executed over 14-, 30-, and 60-day windows.
Distinct Users: The number of unique users issuing those queries.
Source Attribution: The context in which the query originated (e.g., from a dashboard tile or an explore).
User List: A list of all users who have queried the resource.
Note: Euno includes both cached and non-cached queries. Cached queries are not filtered out, providing a more complete picture of usage—but potentially overestimating warehouse activity when cache hits are high.
Important: Euno not only collects total queries for dashboard tiles and other visualizations, but also propagates those queries back upstream to the associated explores, views, and fields. This means field-level and explore-level resources inherit accurate query activity metrics, even when they are not queried directly but are involved in dashboard or look execution. This propagation ensures a comprehensive view of actual field and model usage, helping teams make better-informed decisions during refactors or cleanups.
total_queries_14d total_queries_30d total_queries_60d
The number of queries the resource is found within over the last 14/30/60 days, taken from the Looker API (not from a db connection) Note: This number is for all queries including cached.
View, Explore, Dashboard, Look, Tile, Dimension, Measure
distinct_users_14d distinct_users_30d distinct_users_60d
The number of distinct users querying the resource is found within over the last 14/30/60 days, taken from the Looker API (not from a db connection) Note: This number is for all queries including cached.
View, Explore, Dashboard, Look, Tile, Dimension, Measure
2. View Activity
For visual content such as dashboards and looks, Euno captures UI-level interactions (impressions):
Views: last_30d_views.
Timeframes: View counts are tracked over 7- and 30-day windows.
These events represent frontend engagement with visual assets—even when no new queries are issued due to caching.
last_7d_views,
last_30d_views
The total number of impressions over the last 7 (30) days
Look, Dashboard
last_viewed_at
The last impression time of the resource
Look, Dashboard
3. PDT Build Activity
For Persistent Derived Tables (PDTs) defined in looker_view files and marked as persistent:
Total PDT Builds: The number of materialization events in the past 30 days.
Total Build Time: The cumulative time spent building PDTs—useful for identifying slow or resource-intensive transformations.
pdt_builds_last_30d
Total number of PDT builds in the last 30 days.
View
pdt_total_build_time_30d
Cumulative build time for PDTs in the last 30 days.
View
Choosing the Right Signal for Your Use Case
Use Query Activity when evaluating:
Warehouse cost
Query frequency
Backend performance
Data model usage across explores and fields (thanks to query propagation)
Use View Activity when assessing:
Dashboard and look engagement
User adoption and content popularity
Organizational awareness and usage trends
Use PDT Build Activity when evaluating:
Model performance and efficiency
Resource load from persistent transformations
Maintenance and freshness of derived data
Why Do Query and View Data Sometimes Differ?
Differences between query and view counts are normal and often reflect Looker's caching and backend mechanics:
When a dashboard loads from cache, Euno records a view event, but no new query is sent to the database.
Conversely, when a PDT refreshes or a model is recompiled, queries may be triggered without user interaction, resulting in query counts without corresponding views.
Understanding this difference helps you interpret usage signals more accurately, especially when balancing adoption metrics against infrastructure and cost considerations.
Last updated