Build your first marketing dashboard in Looker Studio

#01What "done" looks like for page one

If leadership only ever screenshots page one, that page must stand alone.

#02Step-by-step build (GA4)

1. Data source. Home > Create > Data source > Google Analytics. Pick the GA4 property. Connect. Set credentials to owner's. Leave freshness at 12 hours unless you have a reason. Name it GA4 — Brand Prod (owner).
2. Report. Create report, add that data source.
3. Canvas. Set size to a landscape screen size your team actually uses. Add a text title.
4. Date control. Insert > Date range control. Place top right. Set default to last 28 days.
5. Scorecards. Insert four scorecards: Sessions, Engaged sessions, Key events, Session key event rate (or your primary conversion metric).
6. Time series. Dimension Date, metric Sessions. Optionally add Key events as a second metric.
7. Table. Dimension Landing page + query string (or Session campaign). Metrics Sessions, Key events. Sort by Key events desc. Limit rows to 10.
8. Bar chart. Dimension Session default channel group, metric Sessions.
9. Footer text. "GA4 via Data Studio. Owner credentials. Freshness 12 hours. Compared with the GA4 UI, expect small timing differences."
10. Share. Share > restrict to your domain or named users > Viewer.

Detailed GA4 field choices and quota hygiene continue in lesson 9 and the existing GA4 Looker Studio reporting page.

#03Sheets alternative (15 minutes)

If GA4 access is blocked today:

1. Put Date, Channel, Sessions, Leads in a Sheet.
2. Connect Sheets, owner's credentials, freshness 15 minutes or 1 hour.
3. Build the same layout.
4. Replace Sheets with GA4 later without redesigning the page.

#04Naming and versioning

Copy a report when you experiment. Never experiment on the link leadership already bookmarked.

#05Share settings that avoid pain

• Viewers by default.
• Editors only for people who change charts.
• Avoid "anyone with the link" for anything with customer or revenue detail unless legal signed off.
• If you embed in Notion or an intranet, watch GA4 quota (lesson 17).

#06Worked example: Ledgerline

Ledgerline is a fictional accounts-payable software company. Details are illustrative.

Walkthrough

1. Ops created the reusable GA4 source before the report.
2. Page one answered "are we getting leads, and from which channels?"
3. They refused to add a second page on day one.
4. CEO opened the view link on Monday; one chart was slow. They removed two vanity scorecards.
5. The same report became the parent for Ads and AI pages in later lessons.

#07Exact first-build checklist (print this)

1. Create folder in Drive or Team Drive for Data Studio — Brand.
2. Create reusable GA4 data source named GA4 — Brand Prod (owner).
3. Set owner's credentials; freshness 12 hours.
4. Blank report → rename Brand — Marketing Overview v1.
5. Add date control default last 28 days.
6. Four scorecards: Sessions, Engaged sessions, Key events, Engagement rate.
7. Time series: Sessions + Key events.
8. Table: Session default channel group.
9. Footer text with freshness + owner email.
10. Share view to marketing group; keep edit for ops only.
11. Open token usage once on a cold load.
12. Copy to MASTER only after a week of stability.

#08Scorecard formatting tips

• Use compact numbers for large session counts.
• Show comparison to previous period only if stakeholders already understand it.
• Conditional formatting on engagement rate can wait until targets exist in Sheets.
• Do not put seven decimal places on rates.

#09How this pairs with Academy tracks

After the first dashboard loads cleanly, layer:

• GA4 marketing dashboard lesson for AI Assistant.
• Google Ads dashboard for spend.
• Search Console dashboard for queries.
• AI visibility dashboard for the three-lane board.

Jumping straight to a 12-page blend is how first projects stall.

#10First-week QA script

If Day 0 fails, stop decorating charts and fix the data source selection (property ID, credentials).

#11Common mistakes

• Starting from a public template and never checking field names.
• Twenty charts on page one and a quota error by 09:10.
• Sharing edit access to the whole company.
• No date control, so every screenshot is a different range.
• Untitled Report living in someone's Drive forever.

#12Try it yourself

Build a one-page report from GA4 or Sheets with a date control, four scorecards, one time series and one table. Share it to yourself as viewer in an incognito window and confirm it loads.

#13Quick quiz

1. Why create the data source from the home page?

Answer: So it is reusable across reports instead of trapped as an embedded one-off.

2. What credentials mode should a shared marketing dashboard use?

Answer: Owner's credentials.

3. Roughly how many charts belong on page one?

Answer: About 6 to 10 for speed and quota.

#14What should you check before the next lesson?

• One shared one-page report exists.
• Footer states freshness and owner.
• You can open it as a viewer.

Previous: Looker Studio connectors: Google, partner and costs. Next: Calculated fields, CASE, groups and bins in Looker Studio. Or return to the Looker Studio for Marketers track. Related: GA4 for Marketers, GA4 Looker Studio reporting, GTM for Marketers.

#15Common questions

How long should a first marketing dashboard take? Most marketers can ship a one-page GA4 or Sheets dashboard in under an hour if the data source already exists. Plan a morning if you are connecting GA4 for the first time.

How many charts should page one have? Aim for 6 to 10. More charts mean more queries, slower loads and higher GA4 token use.

Should I start from a template? Templates are fine for layout ideas. Rebuild field names against your own data source so you do not inherit someone else's broken metrics.