A dashboard you can trust
Not another chart, but a report where you know where every number came from.
On request
Three departments, three dashboards, three numbers all called “revenue”. And nobody knows which one is right.
A dashboard is only as reliable as the definition underneath it. If that definition differs in three places, a prettier chart will not fix it.
So the logic lives in BigQuery and Dataform, in version control, with tests — not in the reporting tool. The dashboard only reads. Which tool sits on top is a separate choice after that.
Loading dashboard…
Loaded live from Metabase on insights.groendata.nl
What this dashboard shows
Three tabs, each with one question above it. The numbers come from GA4 and Google Search Console, run through BigQuery and Dataform, and are shown in a self-hosted Metabase. Every card can be downloaded.
Overview: how much traffic comes in, and where from?
Sessions, search clicks, impressions and search CTR as single figures, with sessions per day and sessions per channel below. At the bottom of the tab sits coverage: how many rows there actually are and up to which date the data runs.
Search performance: how are we doing in Google Search, and on which pages?
Impressions, clicks, CTR and average position, clicks and impressions per day, and two tables: which pages appear in Google Search and on which queries. Coverage of the search data is shown here too.
Site quality: is the site fast enough by Google's standard?
The p75 of LCP, INP and CLS, judged against the thresholds Google uses: LCP up to 2500 ms, INP up to 200 ms, CLS up to 0.1. Below that, per metric, how many measurements there are, what share is good, and the trend per day.
Why coverage is shown
A dashboard that only shows a number hides whether that number rests on three measurements or three thousand. Every tab above states how much was measured and up to when. That is not tidiness for show: it is the difference between a figure you can act on and one that happened to come out that way.
Explore a larger example dashboard (fictional data)
The dashboard above runs on this site's real, modest numbers. To see how a dashboard reads with more volume in it, open the Metabase example dashboard with fictional data: made-up products and customers from Metabase's own sample database. It sits on the same instance and shows the layout and the interaction, not work done for a client and no Groen Data data.
Open the Metabase example dashboard (fictional data, opens in a new tab)
A reporting layer like this for your own marketing data?
What you see above runs on groendata.nl's own data: real sessions, real Search Console figures, a site with little traffic. Not a template every client gets by default.
The setup is always the same though: the logic lives in BigQuery and Dataform, and the dashboard only reads from it. Which BI tool sits on top, Metabase, Power BI or Data Studio, is a separate choice.