The answer is quite simple.
You can identify the most popular reports from Looker Studio directly in the BigQuery console.
This insight comes from Tim Hiebenthal.
Getting the report ID from Looker Studio is straightforward – a standard query from the Job's Table in the information schema.
This way, you can track which reports generate the most queries, and more importantly, stay informed about new reports and visit them.
Enjoy!
If you work with GA4 to BigQuery exports, be sure to check out my SQL cheat sheet.
Want all my best GA4-BQ queries in one place? I turned them into a Chrome extension — top SQL queries you can search and copy in seconds.
Go here to install it for FREE.
Prefer the web version? It's here.
