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
- Go to Looker Studio and sign in with your Google account.
- Create a blank report. Add Google Analytics as a data source and choose your partner's GA4 property.
- Add a date range control at the top. Set it to your campaign weeks.
- Add scorecards (big single numbers) for your action metrics, like key events and sessions to the volunteer page.
- Add a table with Session source / medium and Key events. This shows which channel worked.
- Add a time series chart of sessions by day. Spikes show which posts landed.
- Add a Google Sheet data source with your offline counts, like lunch specials redeemed or "how did you hear about us" tallies.
- 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
Module 6 check
Quiz: Module 6 Quiz: Decide With Data
Go deeper: The Power of Web & Business Analytics: Turning Data Into Decisions