Tutorial · Looker · 12 min

    Looker Studio Dashboards That Actually Get Used

    How to scope a one-page dashboard the exec team will open daily.

    1. Step 01

      Pick three numbers

      If your dashboard has more than three top-line numbers, no one will read any of them. Force a ranking.

    2. Step 02

      Anchor every chart to one of them

      If a chart doesn't trace to a top-line number, cut it. "Interesting" is not a reason to include a chart.

    3. Step 03

      Refresh on a schedule, not on click

      Schedule extract refreshes (15-min or hourly) so the page is always fast to open. Live queries against BigQuery on every load will make execs close the tab.

    4. Step 04

      One-page rule

      If the page scrolls, split it into two dashboards: an exec page (3 numbers + trend) and an operating page (the deep-dive). Link between them.

    5. Step 05

      Annotate the anomalies

      Use Looker's annotation feature to mark launches, outages and pricing changes on the time-series. A 40% spike with no explanation is a meeting; a 40% spike with a "launched referral" annotation is a story.

    6. Step 06

      Permissions and ownership

      Every dashboard has one owner and a "last reviewed" date in the footer. Quarterly review: cut anything no one has opened.