Build a GA4 Dashboard in Plain English (No SQL, No Looker)

You can build a useful GA4 dashboard by starting from the questions you actually have, not from GA4’s menu of metrics. Five questions cover most of it, and each is answerable from live data in plain English, no SQL, no Looker, no data team. The trick is to ask in business terms and let the tool handle the query.

GA4 makes this harder than it should be. It replaced Universal Analytics on July 1, 2023 with an event-based model that’s more capable and much less intuitive, and its exploration reports assume time you don’t have. Starting from your real questions is how you skip most of that.

Start from the question, not the metric

A dashboard built from "which metrics exist" becomes a wall of numbers nobody reads. A dashboard built from "what do I need to decide this week" stays short and gets opened. Write your questions first; let the metrics follow.

The five questions a founder actually asks

1. Where is my traffic coming from? Channels and sources, and which are growing.
2. What actually converts? Which sources and pages produce signups or sales, not just visits.
3. Which pages leak? Where people drop out of the funnel before converting.
4. Is my ad spend paying off? Ads cost read against the conversions in GA4, together.
5. Is search working? Search Console queries and rankings tied to the traffic they drive.

Answer each without SQL

Each of those is a plain-English request, not a query language. Ask for "signups by channel this month" or "the top pages losing checkout traffic," and the view gets built from live GA4 data. The skill you need is knowing the question, not the syntax.

Why GA4 makes this hard, and the way around it

GA4’s event model is genuinely powerful once configured, but its defaults and exploration UI are where most people give up. The durable workaround isn’t learning every report; it’s asking in business terms and letting the tool translate, so the analytics serve the decision instead of becoming another thing to maintain.

For why live beats exported in the first place, read first-party data beats screenshots, and for the full loop, the first-party analytics playbook. Or see dashboards built on your live data in a demo.