Real ChatGPT answer · index seeddbGmH6x9m9McompleteB2B software · data and analytics platformscomparison
What tools or scripts do senior analytics engineers use for detecting orphaned Looker Looks and unused dashboard reports?
Download run
Fan-out diagram
The searches the AI actually ran for this prompt.
SEED QUERY
What tools or scripts do senior analytics engineers use for detecting orphaned Looker Looks and unused dashboard reports?
3 real searches · 1 real-search pass
Looker API content usage dashboard viewed query history unused Looks dashboards system activity API documentationGoogle ↗
OBSERVEDOther / navigational
Looker API endpoints looks dashboards content metadata content validation unused content auditGoogle ↗
OBSERVEDOther / navigational
Looker System Activity dashboard content usage query history scheduled plans Looker APIGoogle ↗
OBSERVEDOther / navigational
Badge and edge weight = share of passes that produced the query. Hover a query for its intent and routing format.
Query classes
Google's semantic query class for every sub-query: what kind of answer each search is after, simulated vs real.
ChatGPT real searches (3)
Classes come from the query-classifier (a local Laya model). 3 of 3 calls are low-confidence (under 50%) — hover a query in the table to see its confidence.
Searches and sources
ChatGPT3 real searches · gpt-6
Looker API content usage dashboard viewed query history unused Looks dashboards system activity API documentation Google ↗
Looker API endpoints looks dashboards content metadata content validation unused content audit Google ↗
Looker System Activity dashboard content usage query history scheduled plans Looker API Google ↗
- Admin settings - System Activity dashboards | Looker | Google Cloud Documentation · docs.cloud.google.com
- Monitoring Looker usage with System Activity Explores | Google Cloud Documentation · docs.cloud.google.com
- Validate Content | Looker | Google Cloud Documentation · docs.cloud.google.com
- Managing unused content | Looker | Google Cloud Documentation · docs.cloud.google.com
- Monitoring Looker usage with System Activity Explores | Google Cloud Documentation · docs.cloud.google.com
- Looker API 4.0 documentation · cloud.google.com
Queries
3 queries · click a column to sort
| Query / type | Search | Intent | Query class | Routing format | Cluster | Freq ↓ | Weight |
|---|---|---|---|---|---|---|---|
Looker API content usage dashboard viewed query history unused Looks dashboards system activity API documentation OBSERVED | Google ↗ AI Mode ↗ | — | Other / navigational | — | — | 1x of 1 | |
Looker API endpoints looks dashboards content metadata content validation unused content audit OBSERVED | Google ↗ AI Mode ↗ | — | Other / navigational | — | — | 1x of 1 | |
Looker System Activity dashboard content usage query history scheduled plans Looker API OBSERVED | Google ↗ AI Mode ↗ | — | Other / navigational | — | — | 1x of 1 |