lesson
35 min

Build a One-Page Looker Studio Report

Turn GA4 data and offline counts into a simple report your partner can read in two minutes.

What you will be able to do

By the end of this lesson you can build a one-page Looker Studio report and write a short "so what" for your partner.

What Looker Studio does

Looker Studio is a Google tool that turns data into charts and tables on one page. It can connect straight to GA4. It can also pull in a Google Sheet, which is where your offline counts go.

Your partner does not want to learn GA4. They want one page that answers: did it work, and what do we do next?

Build it step by step

  1. Go to Looker Studio and sign in with your Google account.
  2. Create a blank report. Add Google Analytics as a data source and choose your partner's GA4 property.
  3. Add a date range control at the top. Set it to your campaign weeks.
  4. Add scorecards (big single numbers) for your action metrics, like key events and sessions to the volunteer page.
  5. Add a table with Session source / medium and Key events. This shows which channel worked.
  6. Add a time series chart of sessions by day. Spikes show which posts landed.
  7. Add a Google Sheet data source with your offline counts, like lunch specials redeemed or "how did you hear about us" tallies.
  8. Add one text box at the top with your summary in plain words.

Keep it to one page. Label every chart in words. Do not rely on color alone to show meaning.

Write the "so what"

Numbers do not make decisions. People do. End your report with three short parts:

  • What happened. "The volunteer page got 212 visits. 14 people signed up."
  • What it means. "The barber's video sent 9 of the 14 sign-ups. Our own Instagram posts sent 2."
  • What we do next. "Ask two more community voices to share their shifts. Post less on our own feed and more in neighborhood groups."

Judgment check

  • Share reports with care. Share with Viewer access only, and only with people who need it.
  • No personal data on the page. Totals only. No names, emails, or phone numbers.
  • Be honest about weak results. A campaign that did not work still teaches something. Say what you would change.
  • Do not cherry-pick. Show the whole campaign window, not only the best day.

Draft your so what

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

Module 6 check

Quiz: Module 6 Quiz: Decide With Data

  1. 01What is a key event in GA4?

    Choose one.

  2. 02Where in GA4 do you see which campaign and channel sent visitors?

    Choose one.

  3. 03What should every Looker Studio report end with?

    Choose one.

  4. 04How can you include offline results like lunch specials redeemed?

    Choose one.

  5. 05Your campaign had weak results. What should the report do?

    Choose one.

  6. 06Which belongs in a shared report? Choose all that apply.

    Choose all that apply.

Go deeper: The Power of Web & Business Analytics: Turning Data Into Decisions