lesson
35 min

Build a Dashboard, Make a Decision

Use Looker Studio to put your channel results on one page, then write a decision you can explain.

What you will learn

You will plan a one-page dashboard in Looker Studio. Then you will write one decision based on it, in plain words.

What a dashboard is for

A dashboard is one page that shows your most important numbers together. It is not for showing off. It is for answering one question: what should we do next?

Looker Studio is a free Google tool for building dashboards. It can connect to GA4 and to a Google Sheet. That means you can show website results next to numbers GA4 cannot see, like sign-ups that came in by phone.

Keep it to one page

A good campaign dashboard has only a few parts:

  1. The goal number. Total sign-ups this campaign, big, at the top.
  2. Results by channel. A table or bar chart of visits, sign-ups, and rate.
  3. Over time. A line chart of sign-ups by week.
  4. Offline results. Phone and walk-in sign-ups from a Google Sheet.
  5. A notes box. What you think the numbers mean.

If a chart does not help you decide something, remove it.

Build it

To start, sign in to Looker Studio with a Google account, create a blank report, and add GA4 as a data source. Google's Looker Studio help pages have step-by-step guides. Menus change, so follow their current steps.

If a team member does not have a computer, a printed weekly summary from the dashboard works too.

From numbers to a decision

Every review ends with a written decision. Use this pattern:

We saw:      Text had the highest sign-up rate for three weeks in a row.
We think:    Families who opted in to text are ready to act.
We will:     Send one more text reminder before the deadline.
We will not: Text anyone who did not opt in.
We will check: Sign-ups and opt-outs from text next week.

The "we will not" line is where judgment lives. Data can push you toward more messages, more tracking, and more pressure. Your job is to decide where the line is.

Privacy and dashboards

  • Show totals by channel, not lists of people.
  • Never put names, phone numbers, or emails on a shared dashboard.
  • Be extra careful with programs for minors. Report on groups, never individuals.
  • Share edit access only with people who need it.

Reflection

Private. Saved only in this browser. No one else can see it.

Bring it to The Cook Up

Go deeper: Business Intelligence for Real Operators: Turning CRM & ERP Data into Decisions

Ask. Answer. Build together.